if cross tab report goes beyond one page?

Hello friends,

I designed a report that shows sales of products datewise -

product 1/12 2/12 3/12 4/12 ...
------------------
abc 100 93 94 109 ...
xyz 7 100 56 98 ...
...
...

if i select 2 or 3 months then it shows 90 columns (per day one column) and i can view the report on screen in correct format. But when i send print, it prints product names and some 18 columns only on first page and on each consecutive pages it shows remaining date columns only (with data) and that is also in cut format (half column on previous page and half column on next page)

In a nut shell, is there any setting so that cross tab will work like EXCEL sheet of fixed row / fixed column facility so that on each new page it should print the fixed column.

Since title row is printing on each new page.

Pls advice.

Thanks in adv.
KSee if you find solution here
http://support.businessobjects.com/|||Hi kirankul,

If u found the solution please update this...

Thanks
Sanju|||Hi All,

I encounter the same problem and found the solution, I am not sure whetehr this solution is really suitable for your case, but I think it will.

You go to Cross-Tab expert by right click the cross tab that you have created then go to Customised style tab --> go to the grid option --> check the keep columns together and check the repeat row labels option

By choosing these options, the cross tab that you printed will have the row header name and column header names at every pages.

Cheers
CS

If body contains two tables, report preview breaks are getting upset

When there are two tables in the body, if page break is added for first table, second table always go to a new page in report preview. But print layout preview is working fine.

Keep your two tables side by side.

IE Refresh Problems with WebParts

I am noticing delays in the refresh of my webparts (Sharepoing 2003) page in conjunction with how the report looks in my Report Manager for SSRS 2005. I have my Cache set to refresh on every page visit and my cache set to the lowest at 1 mb in IE....but when I refresh in my Webpage in Sharepoint, sometimes I have to completely close IE out...and even doing that and reopening IE doesn't always refresh the changes reflected in Report Manager right away.

What is this, a bug?

Can you be a little more specific? What changes are you making in RM that you are expecting to show up in the report?

|||just simple changes to the report itself. I think the problem ended up being at least so far, the old IE nonsense where it's still caching even though you tell it to refresh on every page. You'd think by now MS would fix this after all these years for us delelopers!...I have to keep opening Opra or another browser to ensure that I'm not seeing things...and that it's completely a fresh page reload!

IE browser not printing multiple page reports

Hi,
We are currently running RS 2000, sp2. When the user prints a multiple paged
report from the IE browser, it is printing the current page only. Is this an
issue or is it just a setting of some sort?
Thanks for your help!It sounds to me like you are using the printing functionality from IE, not
the new print icon on the toolbar of Report Manager.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"clutch" <clutch@.discussions.microsoft.com> wrote in message
news:8C8E0E0A-FCF1-4803-B360-B3B95267B118@.microsoft.com...
> Hi,
> We are currently running RS 2000, sp2. When the user prints a multiple
> paged
> report from the IE browser, it is printing the current page only. Is this
> an
> issue or is it just a setting of some sort?
> Thanks for your help!