Home General
New Blog Posts: Merging Reports - Part 1 and Part 2

Multiple Report Generation

edited November 2005 in General
I want to give my users the ability to select multiple ID numbers in a
ListBox and, based on this selection, tell Report Builder to generate a
report for each ID and then send it automatically to the printer...

For example: In NorthWind database, the user wants to print Order 10248,
10279, 10281 and 10282. I would create a ListBox showing all available
Orders to print, and then the user selects which Orders he wants to print.
Then ReportBuilder would generate a report with the order details for each
Order and print it automatically, making a print queue.

Thanks!

Comments

  • edited November 2005
    pretty simple to do with DADE or not. How are you accessing your data? Did
    you have a specific question?

    Ed Dressel
    Team DM
  • edited November 2005
    Do you mean... Make an SELECT statement with WHERE ? OR? OR ? OR based on
    each ID?

    I will try that...

    But I would like to know if this is possible to do with Report Builder.

  • edited November 2005
    > But I would like to know if this is possible to do with Report Builder.

    sure it's possible but the implementation depends upon how you are accessing
    the data.

    Ed Dressel
    Team DM
  • edited November 2005
    Thanks Ed Dressel for your help...

    Well, I'm acessing my data through ADO components to a SQL 2000 Server.

    I have seen such a example with Fast Report, where you select ID's in a list
    box and
    generate reports based on each ID. I would like to do that with Report
    Builder!

    Thanks again!


  • edited November 2005
    If you are doing the data access outside of ReportBuilder then you need to
    create the user interface for it.

    If you are doing it inside RB via DADE, then you set it up there.

    --
    Ed Dressel
    Team DM
This discussion has been closed.