Group Heading text different on repeated headers

Is there any way to have the data displayed in a group header different on the first occurrence of the header from subsequent occurrences within that same group?

I have the Repeat Header option checked, so the header appears on every page. I want the pages where it is a continuation (has been repeated because the option is on) to look different, e.g., the group's name cell should be "<name> (cont.)", where on the first page it appears it should be just "<name>". I can use an expression in a cell in the header, but I don't see any convenient function or other way to detect whether this is the first, or a subsequent, instance of the header.

I thought of using the RowNumber function, scoped to the header grouping, but this seems to return the row number of the bottom-most (last) detail row of the group - that is, the number of rows in the group - so that doesn't seem to help.

Have you found any solution to the issue in your post? I would like to do the same on a grouped table report and cannot seem to find the key.

Group Heading text different on repeated headers

Is there any way to have the data displayed in a group header different on the first occurrence of the header from subsequent occurrences within that same group?

I have the Repeat Header option checked, so the header appears on every page. I want the pages where it is a continuation (has been repeated because the option is on) to look different, e.g., the group's name cell should be "<name> (cont.)", where on the first page it appears it should be just "<name>". I can use an expression in a cell in the header, but I don't see any convenient function or other way to detect whether this is the first, or a subsequent, instance of the header.

I thought of using the RowNumber function, scoped to the header grouping, but this seems to return the row number of the bottom-most (last) detail row of the group - that is, the number of rows in the group - so that doesn't seem to help.

Have you found any solution to the issue in your post? I would like to do the same on a grouped table report and cannot seem to find the key.

Group Headers Not Showing In Excel

Hi,
I have created some reports that I need to export to Excel. I have realised
that when they are exported, the group headers do not appear in Excel, just
the table header and footer, group footers and details group.
Does anyone know why the group headers are ommitted from the Excel files and
how I can get around this problem?
ThanksAre the group headers hidden, or are they missing completely?
"Tabby Cool via SQLMonster.com" wrote:
> Hi,
> I have created some reports that I need to export to Excel. I have realised
> that when they are exported, the group headers do not appear in Excel, just
> the table header and footer, group footers and details group.
> Does anyone know why the group headers are ommitted from the Excel files and
> how I can get around this problem?
> Thanks
>|||They are missing completely.
I hope they fix this in the 2005 version of RS!
daw wrote:
>Are the group headers hidden, or are they missing completely?
>> Hi,
>[quoted text clipped - 6 lines]
>> Thanks
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200509/1

Group Headers

Hi,
Is there a way to Drill down and not to show the Group header details.
Thanks
Prashtry suppressing the group header

Group header won't repeat

I have a report with a List with Group Headers i want to repeat on every
page, even if the group spans more than one page.
-In the Visual Studio preview the same group header won't repeat
on every page.
-In the Reporting services HTML preview the group header WILL
repeat on every page (even if the group is the same).
-Exporting the report to PDF format won't repeat the List's Group Header
on every page.
I have Reporting services and Visual Studio 2003.I ran Reporting services
SP2 on all machines.Hi there
U can use the TableRow Property: RepeatOnNewPage=True In the Layout section.
"FattoreK" wrote:
> I have a report with a List with Group Headers i want to repeat on every
> page, even if the group spans more than one page.
> -In the Visual Studio preview the same group header won't repeat
> on every page.
> -In the Reporting services HTML preview the group header WILL
> repeat on every page (even if the group is the same).
> -Exporting the report to PDF format won't repeat the List's Group Header
> on every page.
> I have Reporting services and Visual Studio 2003.I ran Reporting services
> SP2 on all machines.|||we don't use table, but "list".
the problem is that the group header repeats in preview and html mode,
but doesn't do it in pdf mode.
"ש×?×?×?" wrote:
> Hi there
> U can use the TableRow Property: RepeatOnNewPage=True In the Layout section.
> "FattoreK" wrote:
> > I have a report with a List with Group Headers i want to repeat on every
> > page, even if the group spans more than one page.
> >
> > -In the Visual Studio preview the same group header won't repeat
> > on every page.
> > -In the Reporting services HTML preview the group header WILL
> > repeat on every page (even if the group is the same).
> > -Exporting the report to PDF format won't repeat the List's Group Header
> > on every page.
> >
> > I have Reporting services and Visual Studio 2003.I ran Reporting services
> > SP2 on all machines.

group header visibility problem

I have table with two group headers.
I want my data to look something like this:
-Group1_master data - header1
-Group1_master data - some description - header2
-Details of group1.....
Now, i want to display this header2 only if descrpition contains data, that
is not null, and i wrote expression like this:
=Iif(Fields!Description.Value = Nothing, "True", "False")
.. and put it in the Hidden property of table row that is actualy ma header2
But that header2 is never hidden, i realy dont know is that a known problem
or im missing something.
tnx for any replaysTry changing "True" to true and "False" to false:
=iif(Fields!Description.Value = Nothing, true, false)
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"hypo vedran" <hypo vedran@.discussions.microsoft.com> wrote in message
news:1B43308B-2A2B-4571-8BAE-4031C6CEC62A@.microsoft.com...
> I have table with two group headers.
> I want my data to look something like this:
> -Group1_master data - header1
> -Group1_master data - some description - header2
> -Details of group1.....
> Now, i want to display this header2 only if descrpition contains data,
that
> is not null, and i wrote expression like this:
> =Iif(Fields!Description.Value = Nothing, "True", "False")
> .. and put it in the Hidden property of table row that is actualy ma
header2
> But that header2 is never hidden, i realy dont know is that a known
problem
> or im missing something.
> tnx for any replays

Group Header Alternating color

I am trying to get alternating colors on group headers.

The rownumber() doesn't work; that only seems to be the count of rows in the group.

Does anyone have any great ideas for this?

Thanks!

BobP

Have you tried CountDistinct(<group expression fields>)?|||

Yes, I get a "1" for each group header row.

I have also tried countrows.

BobP

|||I realize this was a year ago, but was wondering if anyone had figured out a solution. I am trying to alternate colors at the group level and am not having any luck...
|||

If I understand you correctly, this should give you the desired result:

Add this to your code window:

Code Snippet

Dim numFooterRow as Double

Function GetRowNumber() as Double
numFooterRow += 1
Return numFooterRow
End Function

Add a new column to the table and mark it as not visible. On the group header row (the invisible column), add this expression:

Code Snippet

=Code.GetRowNumber()

You will need the name of the textbox that you just entered the expression into for the final part. In the header row background color add the following expression:

Code Snippet

=iif(ReportItems!textbox18.Value Mod 2 = 0,"LightCoral","RosyBrown")

You now have alternating colors at the group header level.

Simone

|||Wow, thanks so much, Simone! I've been banging my head against the wall on this one for the last hour, trying to think up ways to do it in SQL, using the Previous() function, etc. This worked like a charm!
|||I am trying to do something where I say look through the row. When you come across the word "Start" color that box green and color all other boxes to the right in that row green as well until you come upon the word "stop". Is this possible? If I am not making sense just let me know and I will try to explain better. Thanks in advance for any help that I get.|||You might want to start a new thread, although somewhat similar, it seems to me its a different topic...|||Ok will do.

Group Header Alternating color

I am trying to get alternating colors on group headers.

The rownumber() doesn't work; that only seems to be the count of rows in the group.

Does anyone have any great ideas for this?

Thanks!

BobP

Have you tried CountDistinct(<group expression fields>)?|||

Yes, I get a "1" for each group header row.

I have also tried countrows.

BobP

|||I realize this was a year ago, but was wondering if anyone had figured out a solution. I am trying to alternate colors at the group level and am not having any luck...
|||

If I understand you correctly, this should give you the desired result:

Add this to your code window:

Code Snippet

Dim numFooterRow as Double

Function GetRowNumber() as Double
numFooterRow += 1
Return numFooterRow
End Function

Add a new column to the table and mark it as not visible. On the group header row (the invisible column), add this expression:

Code Snippet

=Code.GetRowNumber()

You will need the name of the textbox that you just entered the expression into for the final part. In the header row background color add the following expression:

Code Snippet

=iif(ReportItems!textbox18.Value Mod 2 = 0,"LightCoral","RosyBrown")

You now have alternating colors at the group header level.

Simone

|||Wow, thanks so much, Simone! I've been banging my head against the wall on this one for the last hour, trying to think up ways to do it in SQL, using the Previous() function, etc. This worked like a charm!
|||I am trying to do something where I say look through the row. When you come across the word "Start" color that box green and color all other boxes to the right in that row green as well until you come upon the word "stop". Is this possible? If I am not making sense just let me know and I will try to explain better. Thanks in advance for any help that I get.|||You might want to start a new thread, although somewhat similar, it seems to me its a different topic...|||Ok will do.

Group Header Alternating color

I am trying to get alternating colors on group headers.

The rownumber() doesn't work; that only seems to be the count of rows in the group.

Does anyone have any great ideas for this?

Thanks!

BobP

Have you tried CountDistinct(<group expression fields>)?|||

Yes, I get a "1" for each group header row.

I have also tried countrows.

BobP

|||I realize this was a year ago, but was wondering if anyone had figured out a solution. I am trying to alternate colors at the group level and am not having any luck...
|||

If I understand you correctly, this should give you the desired result:

Add this to your code window:

Code Snippet

Dim numFooterRow as Double

Function GetRowNumber() as Double
numFooterRow += 1
Return numFooterRow
End Function

Add a new column to the table and mark it as not visible. On the group header row (the invisible column), add this expression:

Code Snippet

=Code.GetRowNumber()

You will need the name of the textbox that you just entered the expression into for the final part. In the header row background color add the following expression:

Code Snippet

=iif(ReportItems!textbox18.Value Mod 2 = 0,"LightCoral","RosyBrown")

You now have alternating colors at the group header level.

Simone

|||Wow, thanks so much, Simone! I've been banging my head against the wall on this one for the last hour, trying to think up ways to do it in SQL, using the Previous() function, etc. This worked like a charm!
|||I am trying to do something where I say look through the row. When you come across the word "Start" color that box green and color all other boxes to the right in that row green as well until you come upon the word "stop". Is this possible? If I am not making sense just let me know and I will try to explain better. Thanks in advance for any help that I get.|||You might want to start a new thread, although somewhat similar, it seems to me its a different topic...|||Ok will do.