Post reply

how to assign two datasets

  • August 1, 2008 at 12:57 am

    #190332

    I want to fetch records from two different datasets on my report.I don't want use sub-report.If anybody know plz tell me

  • August 1, 2008 at 7:12 am

    #851851

    Any given control in your report can be tied to one or the other of those datasets. A table or matrix control is only going to be accessing one of the two. If your objective is to get data from both datasets into a single table, then I'm pretty sure you're going to need to find a way to write a query that would quite likely involve joining the two data sources in a single query, view, or stored procedure.

    Of course, you can always have multiple tables or matrices, but then the question becomes - does that work for what you wish to achieve? Given that you could, if you wanted, have a single table for each and every field, as presented across your page, then you might be able to get the desired result - albeit with a rather large quantity of additional work that would probably be far more effort than coming up with a single query, view, or sp that achieves the same goal but with a single dataset instead of two.

    Also, in the multiple table scenario, grouping might well be highly impractical if there would be anything the least bit fancy about it.

    Steve

    (aka smunson)

    :):):)

    Steve (aka sgmunson) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)

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

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