Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 Reporting Services Development
 Headers

Author  Topic 

Vivaldi
Constraint Violating Yak Guru

298 Posts

Posted - 2005-10-19 : 13:03:10
Design issue:

In working on Crystal to RS conversion. I am having issues with the old headers. The first page of the reports have a nice header with images and titles. The second page has a very plain jane header with smaller title and less formatting. I have managed to setup headers, but not sure how I could have the header display on first page only, and then have this "secondary" header show up on subsequent pages.

Any pointers?

________________________________________________

SQL = Serious Quaffing of Liquor

jhermiz

3564 Posts

Posted - 2005-10-19 : 17:11:37
I'm trying to understand the issue that you are having but I think I get your jist. What you want to do is use a single table, for the headers on each page what you want to use is a group. Once you create the group create an additional row above this group row and there is a property for grouping headers to display on new page or not it is called "RepeatOnNewPage" and it is defaulted to "False". Make sure you change this value to true, so that this header repeats on each page.

As for your main first page, I am kind of puzzled as to how to do this, one way I would do it is place the image and text outside of this table so that it only prints once, and put a page break right under it. That way you get a new page right after this cover. The other way you can do this is place the image and the text inside of another table that is above your second table. Set the properties of that table to place a page break after each print out. That way you get your cover page, then you get a new page, then all the other pages have the heading you are looking for (the second part of your question). I wish I could create a demo for you, because I know what I said above is kind of confusing :).

But if you have more questions just ask.

Jon


Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]
Imperfection living for perfection --
[url]http://jhermiz.blogspot.com/[/url]
Go to Top of Page

Vivaldi
Constraint Violating Yak Guru

298 Posts

Posted - 2005-10-24 : 09:36:35
Well, I am still stuck on the repeating headers.

I have taken the header out of the report header area.
I have a "First page" header that has an image, etc. on all pages I want a "table header" to show up with the data below it (column labels). I have grouping in the report already based on location.

The headers are repeating based on the location grouping now. Not sure how I can get them to show up on the top of each page....

any ideas?

________________________________________________

SQL = Serious Quaffing of Liquor
Go to Top of Page
   

- Advertisement -