Friday, March 23, 2012

Problem printing on two page

Hi again! Now that I have fix with your help, my layout problem, I got a new one. LOL!!!!

Now my problem is when data in a report need to go on two page. The printer's give me a header on one page and a body on a second page instead of a header with a part of the body and the rest on a second page with a repeating of the header.

Following me?

Now can you help me?

Thanks in advance.

Daniel

Yes, I follow. You can select "Repeat header" from report properties.|||Hi! I don't have this options in my report properties. I'm using SQL 2005.|||

Click in your report body to show the tabular report table (unless you chose matrix), then right-click on the upper left corner of the report table and select properties. On the table properties general tab, under the Header / Footer section, you can check the box to repeat header columns on each page.

|||

No! I'm not getting that. But I think it might be these properties set to true going like that:

Page Headers:

Print on first page = true

Print on last page = true

same for footer. Logically if it's on the first and the last, it's on each page.

|||

No, that property is for page headers. What you need to repeat are the table header rows. Which part of the instructions above did not work for you?

|||I understand most of what I'm reading in english. Maybe I'm not at the right place. I'm using for developping my report VSS 2005, not the http://<ServerName>/reports tool. Is this make a difference?|||

You are using the correct tool, Visual Studio 2005 (with Business Intelligence projects) or SQL Server Business Intelligence Development Studio which are very similar. If you can supply an e-mail address, I will send you some screen shots to go with the instructions above?

|||

Good idea! I was telling to my self why we can't post screenshot...

Write me at dlusignan@.fmoq.org

Thanks you very much.

|||

It would be nice, however, I'm sure it is do to space limiations. I just sent you a MS Word document with the explanation and screen shots. I hope this helps.

sql

No comments:

Post a Comment