Post reply

Multiple Reports out of one report based on parameter input - like in Crystal

  • March 20, 2008 at 9:52 am

    #185455

    Not sure how to phrase this so I'll just describe my issue.

    In Crystal you can have multiple items selected for a said parameter. Then in the body you add your info in the header and footer so when the report runs it will print one report for each parameter. Like printing a list of invoices for customers. You select multiple customers and run the report once but it prints one invoice for each customer.

    Is this functionality available in Reporting Services?

  • March 28, 2008 at 2:50 am

    #795011

    I think you should be able to achieve this by wrapping your invoice within a ListBox (from the toolbox in VS2005), the list box has it's own grouping property which you would point to your parameter and optionally add a page break at start for this.

    Of course your SQL would need to take care of the selection of appropriate data according to the value selected in your parameter.

    Good Luck.

    Nigel West
    UK

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply