Post reply

Multiple datasets from one source

  • August 12, 2009 at 4:43 pm

    #208562

    Hi!

    Is it possible to have mutliple datasets from a single datasource in a report in RS2008??? I have two queries that I want to use in a single report because I need to perform calulatiaons based on both. I've been looking all day and I can't seem to find much information.

    Any help is greatly appreciated!

    Michelle :ermm:

  • August 13, 2009 at 12:00 am

    #1038474

    HI

    we can add any number of datasets/datasources for a report. from View -- report data browser you can add the datasets.

    Now to do calculations using both datasets in the same control.

    only one dataset can be selected for a control as its datasource. But u can get aggregate values of other datasets also into this control . The datasetname also has to be given in the aggregate field value like this

    =Fields!ItemID.Value.ToString() & " " & First(Fields!AccountNumber.Value, "DataSet2")

    not sure how much it could be of help

    Thanks

  • August 13, 2009 at 8:11 am

    #1038714

    Thanks thetodaisies! I found what I needed. 🙂

    Michelle

  • August 14, 2009 at 6:18 am

    #1039274

    Hi, mm.

    I think you can use RAQ Report[/url], because it can make reports with multiple datasets easily.

    RAQ Report: Web-based Excel-like Java reporting tool[/url]

Viewing 4 posts - 1 through 3 (of 3 total)

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