Hi Experts,

I developed a SSRS Report which shows the data of three companies for the respective year.

When I export the report to Excel ..I make the separated worksheet for each company with the help of SSRS.

Now what I want is to add the data of three companies and show it on the last worksheet and the data that is shown should also inhibit the sorting.

Is it possible...???

Please find the attachment for the reference.

Please help me in this context....

Hi,

Yes, you can do it. BIDS allows you to edit the Baan reports. So, whatever you need you have to first do it in your baan report. You can create an additional layout in your baan report with the data you want and then generate the xml and edit it in BIDS environment.

The other way is you will need to write procedures in your BIDS to do the calculations but always prefer the first option unless and until you are script expert.

Thanx Bhushan.....I'll try that..

I have one more query regarding SSRS....that...Is there any way to use the page variable(Globals!PageNumber) in the body layout.

Hi,

Again, you can do that in your Baan Report. Baan report has a predefined report special field called "Page No". You can add it on your Baan report layout and just edit whichever way you want in BIDS.

Hi,

Yes I know this field but this can be used only in page header and footer.
If I am using it in body layout then it give me an error.
I searched a lot but didn't find any solution.

Hi,

Why can't you put Page Number in body layout? You can put that special field anywhere you want in your report layout. How are you trying to use it? I have tried it and it works fine. What error are you getting?

Hi,

I am putting (Globals!PageNumber) field in the body layout and when I deploy it,it failed.
What could be the reason for this.

Hi,

Thats because, BIDS is not able to map that field with the fields present in the xml design generated through LN during the deployment. You should add a field in your LN report and then place it in your SSRS wherever you like. This is a better way to manage your reports through BIDS. But, if you just want your page number on the report, I would suggest you to use Special Field provided by LN.

Using the LN page number is not a good idea. The page layout being created by SSRS is by no means related to the pages of the classic LN report.

See http://stackoverflow.com/questions/4758793/access-page-number-in-report-body-ssrs for a solution of your problem.

Hi Jaap,

Thanks. Was waiting for your response. :)

Yes, my mistake. Don't try to use LN page number. This way works perfectly.

Hi Jaap,

I tried the code to display the page number in body layout:

Page Number:
Function PageNumber() As String
Return Me.Report.Globals!PageNumber
End Function

Total Pages:
Function TotalPages() As String
Return Me.Report.Globals!TotalPages
End Function

Access it in the body via an expression:
=code.PageNumber & " of " & code.TotalPages

but this code return page 1 of 1 always even if i am on page 10.

Hi,

Try to calculate that based on the number of rows.

Follow this link:-

Link! (http://social.msdn.microsoft.com/Forums/sqlserver/en-US/c2047eee-41a8-4d79-ae58-dbf60f6e7554/page-number-records-number?forum=sqlreportingservices)