Report line spacing issue

There is a formatting issue that I have come across.
The report has three groups and these groups have headers. When the report is populated most of the time it prints the result properly as expected, but sometimes at different number result records of the query I see that the main group header consumes an entire page and then skips to the next page. But in the next page I get the main group header and the data as it should be printed. After adjusting a page header (not the group headers) the report behaved normally for the same set of data, but fails when the result is changed again.
Any idea what I have done wrong or need to set (maybe a line size or something ) ?Often times when I have that problem, it's due to the "Keep Group Together" option.

Right click on the group name, and choose, "Change Group." Uncheck the "Keep Group Together" box, if it's checked. That might not be the same issue, but it usually resolves the problem with me.

Good luck!|||There is no 'Keep Group Together' checked in this case. I had it earlier and removed it also thinking that may be the issue.
The problem mainly is even if I tweek it a bit and get it to work with one set of data if fails for another one later.
Thanks very much for looking at the issue.|||So all your group expert 'keep group together' and your section expert 'keep together' for groups are unchecked?|||I am terribly sorry. I was all this time unticking the 'Kepp Group Together' check box in the 'Selection Expert' window when RMB and select the 'format..' option.
As I unchecked the check box in the 'Change Group Options' window it worked.
Thank you very much for the help.
By the way do you know why is there two options of 'Keep Group Together' in these two windows ?|||The one in the section expert keeps the section together, e.g. your group header has 3 sections and this keeps these 3 sections together.
The one in the group expert tries to keep the whole group together, i.e. the entire group header, footer, details inbetween etc.

Report Headers vs Page Headers?

Is there such a thing as a Report Header, which only shows up at the
beginning of the report?
This is in contrast to a Page Header which shows up at the top of each page.
Thanks,
Daniel WilliamsYes, there is a report header. Type the text you want to be in the header in
the Body section before your data region. Similarly, you can type report
footer text below the data region.
Charles Kangai, MCT, MCDBA
"Daniel Williams" wrote:
>
> Is there such a thing as a Report Header, which only shows up at the
> beginning of the report?
> This is in contrast to a Page Header which shows up at the top of each page.
> Thanks,
> Daniel Williams
>
>

Report Headers vs Page Headers

Hi, this is probably a simple question but I just can't figure it out. I'm using SQL Server Reporting Services 2005 sp1.

I'm trying to design a report that displays a particular embedded image on the first page, and then a different one on every subsequent page. I.e full, fancy company logo on the first page, and a trimmed down version on every other. In Crystal, I would have simply used the Report Header and Page Header sections to achieve this - easy.

However, in SQL Reporting Services, there is only a Page Header section - therefore whatever I place in the Page Header shows on every page. Now, I know how to stop it displaying on the first page, but I don't know how to display the other image instead.

I read in a support forum that it is possible to do this by "placing report items above or below your data regions" but I can't get it to work.

Grateful for any assistance.

Matt

Hello Matt,

Here's what I did to accomplish this task.

In your 'Page Header' section, place your trimmed down image (you want to display on all pages but the first), and set the PrintOnFirstPage property to False. Then, in the 'Body' section, move everything down enough to place your fancy company image at the top. Now, your fancy logo will show on the first page and none after, and your trimmed image will display on all other pages.

Hope this helps.

Jarret

|||

Hello Jarret,

Thanks very much, that was helpful. I think I'm nearly there - one last Q though! Now that the Page Header is set not to print on the first page it leaves a white blank space where it will appear on the other pages. Therefore, the image placed in the 'Body' section appears about 1/3 of the way down the first page. Do you know any way to make it appear at the top - at the same level as the Page Header one?

Thanks again

Matt

|||

Here’s another way you could do this:

Remove all the images you created earlier

Change PrintOnFirstPage back to true for the Page Header

In the BackgroudImage.Value property of the Page Header, type this: =IIf(Globals!PageNumber = 1, "Link to image that should show on Page 1", "Link to image that should show on the rest of the pages")

Resize your Page Header section to fit the images.

Unless your fancy and trimmed images are the same height, there will be blank space below the shorter of the two.Since you can’t dynamically change the size of a section, I think that’s as good as you’re going to get.

Hope this helps.

Jarret

|||Thanks - I'll give that a try. SSRS is great, but there are some features which Crystal has had for years which it is sadly lacking |||I'm having the same issue. I've found questions about this dating back to July of 2004, but no answers. Is it simply impossible to make a Page Header not print (and not take up space) on the first page?

Report Headers vs Page Headers

Hi, this is probably a simple question but I just can't figure it out. I'm using SQL Server Reporting Services 2005 sp1.

I'm trying to design a report that displays a particular embedded image on the first page, and then a different one on every subsequent page. I.e full, fancy company logo on the first page, and a trimmed down version on every other. In Crystal, I would have simply used the Report Header and Page Header sections to achieve this - easy.

However, in SQL Reporting Services, there is only a Page Header section - therefore whatever I place in the Page Header shows on every page. Now, I know how to stop it displaying on the first page, but I don't know how to display the other image instead.

I read in a support forum that it is possible to do this by "placing report items above or below your data regions" but I can't get it to work.

Grateful for any assistance.

Matt

Hello Matt,

Here's what I did to accomplish this task.

In your 'Page Header' section, place your trimmed down image (you want to display on all pages but the first), and set the PrintOnFirstPage property to False. Then, in the 'Body' section, move everything down enough to place your fancy company image at the top. Now, your fancy logo will show on the first page and none after, and your trimmed image will display on all other pages.

Hope this helps.

Jarret

|||

Hello Jarret,

Thanks very much, that was helpful. I think I'm nearly there - one last Q though! Now that the Page Header is set not to print on the first page it leaves a white blank space where it will appear on the other pages. Therefore, the image placed in the 'Body' section appears about 1/3 of the way down the first page. Do you know any way to make it appear at the top - at the same level as the Page Header one?

Thanks again

Matt

|||

Here’s another way you could do this:

Remove all the images you created earlier

Change PrintOnFirstPage back to true for the Page Header

In the BackgroudImage.Value property of the Page Header, type this: =IIf(Globals!PageNumber = 1, "Link to image that should show on Page 1", "Link to image that should show on the rest of the pages")

Resize your Page Header section to fit the images.

Unless your fancy and trimmed images are the same height, there will be blank space below the shorter of the two.Since you can’t dynamically change the size of a section, I think that’s as good as you’re going to get.

Hope this helps.

Jarret

|||Thanks - I'll give that a try. SSRS is great, but there are some features which Crystal has had for years which it is sadly lacking |||I'm having the same issue. I've found questions about this dating back to July of 2004, but no answers. Is it simply impossible to make a Page Header not print (and not take up space) on the first page?

Report Headers showing on blank page

I hope someone will have time to answer a really basic RS question.

I have a simple report, the query will only return a few rows (16 - 20), my header is repeating on a 2nd blank page. I'm sure it's because I grouped on a column from the record set. I can not find where you delete the grouping.

Anyone have any good suggestions on RS books?

Thanks

Hey Marc,

There are a couple of places to check:

When you click on the table, are there rows that have little numbers on them (1,2, etc)? If so, you should be able to right-click on these and select Delete Groups.

Another place could be the Properties of the table (Select the table, right click on the Properties option). Select the Grouping tab. Delete any of the groups in there (usually named something like "details_group")

Good luck!

Jessica

Report Headers in Report Services

Is there a way to "freeze" the report headers in Report Services? I'd like to have it work like Excel does when you freeze panes. My users complain that when they scroll down the report page, they lose the column headers and lose track of which column is which.

In your Layout section for table settings properties. Set the FixedHeader setting to True to keep the headers visible as you scroll down

|||

So-called fixed headers are available starting with Reporting Services 2005.

They are supported for matrix (see: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=167377&SiteID=1) and table.

Matrix: you can either have it on the row groups or column groups.

Table:
a) you can have a fixed table header (select it in the table properties dialog)
b) or you can have left-most or right-most fixed table columns (select an entire table column, and look for the "FixedHeader" property in the VS properties window of report designer).

-- Robert

|||

HI Robert,

I want to create a report with SQL Server Reporting Service 2000 where I need to have a fixed header and one fixed coloumn containg names of row items. I tried to find "Fixed Header" property in table region of toolbox but could not locate it anywhere.Can you please kindly tell me where should i look for it?

Thank you in advance.

Bharat Gadhia.

Report Headers in Report Services

Is there a way to "freeze" the report headers in Report Services? I'd like to have it work like Excel does when you freeze panes. My users complain that when they scroll down the report page, they lose the column headers and lose track of which column is which.

In your Layout section for table settings properties. Set the FixedHeader setting to True to keep the headers visible as you scroll down

|||

So-called fixed headers are available starting with Reporting Services 2005.

They are supported for matrix (see: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=167377&SiteID=1) and table.

Matrix: you can either have it on the row groups or column groups.

Table:
a) you can have a fixed table header (select it in the table properties dialog)
b) or you can have left-most or right-most fixed table columns (select an entire table column, and look for the "FixedHeader" property in the VS properties window of report designer).

-- Robert

|||

HI Robert,

I want to create a report with SQL Server Reporting Service 2000 where I need to have a fixed header and one fixed coloumn containg names of row items. I tried to find "Fixed Header" property in table region of toolbox but could not locate it anywhere.Can you please kindly tell me where should i look for it?

Thank you in advance.

Bharat Gadhia.

|||In the Grouping and Sorting Properties pop-up window that you get to when you click on Edit Group, that is where you will find (under the General tab) the following check box:
"Group header should remain visible while scrolling."
Note that one of the entries said it is a property of the GROUP.|||HOWEVER, that is in Reporting Services 2005. Also, in a matrix I froze a header on a column group, and in the Preview it was of frozen (although it did not function very elegantly), but when it got over to EXCEL it was not frozen at all. So, does anyone know: can you freeze a column header or row header in a matrix in Reporting Services and have it still be frozen after you EXPORT the report to EXCEL?

Report Headers & Footers

I see the Page Header and Page footer, but what about Report Header and Report Footers? Doesn't look like ssrs has this ability, am I wrong?

I was able to accomplish what I want by following the suggestion in this post:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=377566&SiteID=1

IMO, this is lame. Come on, even Access has a Report Header & Report Footer, what were they thinking? Seems like to get simple stuff done in ssrs you have to basically find hacks and workarounds. Not impressed.

|||

Hello,

Would the table header/footer work for you?

Jarret

|||

Yes, I ended having to use the table header/footer like it is described in the link in my previous post. I still think this is kind of a hack and am wondering why ReportHeader & ReportFooter were left out.

|||

The link in your previous post takes me to another post by you for Parameter Validation Failed. Oh well, glad you got it working.

Maybe I am missing something, but I can't think of any reason why they wouldn't be considered synonymous. Can you give me an example of something a report header can do that a table header can't (or vice versa), just for my knowledge?

Jarret

|||Sorry about that! I have fixed the link to point to the correct article, thanks for pointing that out.

Report Headers

I'm new to Reporting Services, but am familiar with other reporting tools. My question is, is there really no way to reference a field in a page header? If so, I suppose you could repeat some header information on subsequent pages from the detail section of the report using a text box, but how is that done because when I check the property box "Repeat report item with data region on every page" nothing happens. What is the best way to repeat header information on every page that needs to contain field values/information?

Thanks for any help you can offer.

Referencing a field from page header/footer is not supported currently. When you set a textbox to repeat on each page, you need to pick a data region for the textbox to repeat with. Suppose you have a table that'd span multiple pages, set the data region to the table. Or you can select the table header/footer row, and set it to repeat on each page.|||

You can use a field in the report header. Drop a field in the report body and make it invisible, if you don’t need it in the report body. Then drop a textbox on a header and type =ReportItems!TextboxName.Value (The textboxname is where your field is in the body)

Regards

|||

Thanks, GNDSP, but this solution seems to be unsuitable when the data you need repeated on each page comes from a different data set.
What do you do if the data being shown in the report body comes from a different data set than the header text?

I hope the next version of RS fixes this limitation of repeating data on multiple pages, as well as introducing a better way of integrating reports with your own code... the current "Code" tab in the report properties dialog box only supports Visual Basic and is hardly a suitable code editing window... how about "Code Behind" for reports, that also supports C#?

Thanks

Graham

Report Headers

I'm new to Reporting Services, but am familiar with other reporting tools. My question is, is there really no way to reference a field in a page header? If so, I suppose you could repeat some header information on subsequent pages from the detail section of the report using a text box, but how is that done because when I check the property box "Repeat report item with data region on every page" nothing happens. What is the best way to repeat header information on every page that needs to contain field values/information?

Thanks for any help you can offer.

Referencing a field from page header/footer is not supported currently. When you set a textbox to repeat on each page, you need to pick a data region for the textbox to repeat with. Suppose you have a table that'd span multiple pages, set the data region to the table. Or you can select the table header/footer row, and set it to repeat on each page.|||

You can use a field in the report header. Drop a field in the report body and make it invisible, if you don’t need it in the report body. Then drop a textbox on a header and type =ReportItems!TextboxName.Value (The textboxname is where your field is in the body)

Regards

|||

Thanks, GNDSP, but this solution seems to be unsuitable when the data you need repeated on each page comes from a different data set.
What do you do if the data being shown in the report body comes from a different data set than the header text?

I hope the next version of RS fixes this limitation of repeating data on multiple pages, as well as introducing a better way of integrating reports with your own code... the current "Code" tab in the report properties dialog box only supports Visual Basic and is hardly a suitable code editing window... how about "Code Behind" for reports, that also supports C#?

Thanks

Graham

Report Headers

I'm using VS 2003 and SQL Server 2000 Reporting Services SP2.
I haven't found anything in Reporting Services that lets me create a report
header (a header that shows up only on the first page of a report) but am
wondering if there is some method of making the page header visible on the
first page and invisible on all others.
Thanks.
JonDon't use the header, but simply start the report with it
"Jon Limmer" wrote:
> I'm using VS 2003 and SQL Server 2000 Reporting Services SP2.
> I haven't found anything in Reporting Services that lets me create a report
> header (a header that shows up only on the first page of a report) but am
> wondering if there is some method of making the page header visible on the
> first page and invisible on all others.
> Thanks.
> Jon
>
>|||You're kidding! That easy!! Cool!
and thanks...
Jon
"Antoon" <Antoon@.discussions.microsoft.com> wrote in message
news:51F10004-77A6-4061-91B3-3F8E58347B9E@.microsoft.com...
> Don't use the header, but simply start the report with it
>