SQL Report Builder 3.0 - generate multiple reports between date range

I've done some research on this but I don't think I'm typing in the right thing to find what I am after.....

Basically I have a working report which displays the order information based on the OrderID (parameter).. so 1001, 1002 etc. What im now trying to do is group all of these together between a date range..

So for example I could have 50 unique Orders in a specified week. I want to now generate a 50 page document (PDF), displaying the full Order Report for each unique order. NOT IN A TABLE VIEW.

so my question is: is this even possible and if yes, could someone please point me in the right direction..... Thankyou for any help.

Answers


You can pass date range as parameters to query, bring bring back data to report, and use grouping controls to show those 50 reports on every page. Use can use 'List' for that purpose. Put existing report into a list and just pass complete data source to the list.

If you can pull single order data, say order number 1001, in a single row, then it's quite easy to build report. Otherwise you may have to use sub reports to show tabular data from each order.

Let me know if you have any difficulties doing this.


Need Your Help

PdfPTable Prefer SplitRows false

itextsharp itext

Using PdfPTable with ColumnText is it possible to prefer that a row not split, but if it doesn't fit then split? Here is an example of a table with a single row and column that won't fit on a singl...

Basic Comet in Python using just std lib

python comet

I'm developing a web interface for an already existing desktop application. I've been looking for a way to allow the server to push content to the browser and ended up reaching Comet.