page breaks in reporting services 2008
Hi,I'm using sql server reporting services 2008. the problem is with the page breaks.i just use a simple query like select * from patient.using tabular form report to display values.have to add a pagebreak after every ten records.Grouped the patientname and tried using =Ceiling(RowNumber(Nothing)/10) .In 2008 reporting services For setting page breaks there is a checkbox "Between each instance of a Group".So if the patient name is different , only one record gets displayed on each page. Inspite of this without grouping how could i make 10 records display in each page without any criteriathanks for any help...
December 30th, 2008 5:02pm

OK I see, try this :1 Edit Group, Group onexpression =Fields!patientName.Value(your group field)2 Anotherexpression=Ceiling(RowNumber(Nothing)/10)3include group header & page break at end I have the same case, hope useful !
Free Windows Admin Tool Kit Click here and download it now
December 31st, 2008 6:45am

OK I see, try this :1 Edit Group, Group onexpression =Fields!patientName.Value(your group field)2 Anotherexpression=Ceiling(RowNumber(Nothing)/10)3include group header & page break at end I have the same case, hope useful !
December 31st, 2008 6:45am

Hi,Thanks for your suggestion but I could not fing the edit group option. I'm using SQL server 2008 reporting services express edition with advanced services. Could you please detail on this.This is the way i created agroup.1) Right click [patientName] textbox-->Add Group-->Row Group-->parent Group (group name table1_Details_Group)2) Right click [patientname]textbox-->RowGroup-->Group properties-->in pagebreaks tab-->Between each instance of a group-->in general tab -->Add-->=Ceiling(RowNumber(Nothing)/10).Is there anyother way .please suggestthanks
Free Windows Admin Tool Kit Click here and download it now
December 31st, 2008 7:55am

Hi,Thanks for your suggestion but I could not fing the edit group option. I'm using SQL server 2008 reporting services express edition with advanced services. Could you please detail on this.This is the way i created agroup.1) Right click [patientName] textbox-->Add Group-->Row Group-->parent Group (group name table1_Details_Group)2) Right click [patientname]textbox-->RowGroup-->Group properties-->in pagebreaks tab-->Between each instance of a group-->in general tab -->Add-->=Ceiling(RowNumber(Nothing)/10).Is there anyother way .please suggestthanks
December 31st, 2008 7:55am

Hello,Once Try this.Remove all the Groupings.Add a Fresh Group by following thsese steps.1. Select the Detail Row. Right Click.2. Click on Add Group --> Parent Group.3. In the Group By Expression Add =Ceiling(RowNumber(Nothing)/10), Click OK.4. Right Click on the Expression Text Box on the column added. 5. Go for Row Group --> Group Properties 6. Go for Sorting Properties, Remove the Sort Expression. 7. Go for Page Breaks and check the 'Between Each Instance of Group".8. Click OK.9. If you dont want the Newly added Column , Select The Total Column. Click on Delete.10. Select the 'Delete only columns' Radio Button.Hope this helpsShilpa (http://www.ggktech.com)
Free Windows Admin Tool Kit Click here and download it now
December 31st, 2008 9:21am

hi, Ramaprabha I think VS 2008 and VS2005 have the same operation, you can follow the steps as ShipaReddy told, just make sure: Firstly, Report will display OK use Group. Then try to control the recordnumber in one page as you want.Be patient with youroperation, good luck!
December 31st, 2008 10:05am

hi, Ramaprabha I think VS 2008 and VS2005 have the same operation, you can follow the steps as ShipaReddy told, just make sure: Firstly, Report will display OK use Group. Then try to control the recordnumber in one page as you want.Be patient with youroperation, good luck!
Free Windows Admin Tool Kit Click here and download it now
December 31st, 2008 10:05am

Thanks a lot Shilpa .It's working good.thanks..thanks a lot.i have another one issue.created a patientreport using report wizard and deployed it on the report server.iwant to render this report to the report viewer.It'sall working fine .Reportviewer is used in the server mode.the thing is I have createda parameter patient name through add parameters.pass this parameter programatically through the URL. I'm getting rsInvalidPathItem error.Is there any way to set the parameters tothe rport in the report server and make use of it in the report viewer
December 31st, 2008 11:36am

Thanks a lot Shilpa .It's working good.thanks..thanks a lot.i have another one issue.created a patientreport using report wizard and deployed it on the report server.iwant to render this report to the report viewer.It'sall working fine .Reportviewer is used in the server mode.the thing is I have createda parameter patient name through add parameters.pass this parameter programatically through the URL. I'm getting rsInvalidPathItem error.Is there any way to set the parameters tothe rport in the report server and make use of it in the report viewer
Free Windows Admin Tool Kit Click here and download it now
December 31st, 2008 11:36am

Hello,You deployed your report to a server eg: http://server/myfolder/reportYou have one report Parameter in the Report you deployed. so you need to pass that parameter to the ReportViewer Control. Is this what you are asking?There is no need of passing parameters seperately. report Viewer Automaticlaly takes the Parameter whichever given in the ReportServer.Just Follow the Below steps1. Deploy the Report to report Server2. Add a Report Viewer Control to your application.3. And Give as <ServerReport ReportServerUrl="http://yourservername/reportserver" ReportPath="/yourfolder/subFolder/Report" With this you will get the Report Parameters also in Report Viewer Hope this helpsShilpa (http://www.ggktech.com)
January 2nd, 2009 9:45am

Hello,You deployed your report to a server eg: http://server/myfolder/reportYou have one report Parameter in the Report you deployed. so you need to pass that parameter to the ReportViewer Control. Is this what you are asking?There is no need of passing parameters seperately. report Viewer Automaticlaly takes the Parameter whichever given in the ReportServer.Just Follow the Below steps1. Deploy the Report to report Server2. Add a Report Viewer Control to your application.3. And Give as <ServerReport ReportServerUrl="http://yourservername/reportserver" ReportPath="/yourfolder/subFolder/Report" With this you will get the Report Parameters also in Report Viewer Hope this helpsShilpa (http://www.ggktech.com)
Free Windows Admin Tool Kit Click here and download it now
January 2nd, 2009 9:45am

Thank you so much Shilpa , this code is very helpul for me
February 24th, 2011 7:17pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics