Click here to Skip to main content
15,899,604 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
I have table BookingRecordDeposit Table in SQL Server. Using this table i want to generate Deposit Receipt. In terms of the Deposit, Deposit can be more than one. so it means report also one or more. i have generate single deposit report but what about more than one. I think i have to use For Loop. can any one tell me that i have take right choice?

What I have tried:

this is first time that i have to create multiple Reports.

Can any one help me?
Posted
Comments
an0ther1 15-Jun-16 19:15pm    
I assume you are passing in a Deposit Id (or similar) when running the report?
If you were to pass in a Booking Id the Report would then print for each Deposit - if your report is setup so that each page contains a single Deposit then you would get 2 pages if there was 2 deposits, 3 pages for 3 deposits etc.
Using a loop to display multiple reports is not necessary unless there is an extremely good reason. Your code would need to show a Report Viewer, wait for it to be closed & then run the next Report - very messy.

Kind Regards

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900