Post reply

Pass parameters between multiple data sources in one report?

  • June 12, 2008 at 4:51 pm

    #192420

    I have implemented this using a SubReport, but I read that Microsoft suggests using a Table/Matrix instead - but I cannot get it to work.

    Within the same report, is it possible to have multiple data sources and pass the result from one data source query in as an argument/filter for another data source query? How would I do so? I cannot find the right combination of settings under Report Parameters.

    My first data source query returns Treatment_ID from the Treatment table. I would then like to do another data source query on the joined Treatment_WeedSpecies (many-to-many) and WeedSpecies tables to return species information specific to this Treatment_ID.

    Thanks!

  • June 23, 2008 at 1:40 pm

    #833000

    I'm not sure I fully understand what you are aiming for here, but my first question would be, are you expecting to deal with more than one treatment id in the report? If the answer to this is yes then you probably should be looking at a single datasource or, prefereably, the way you have already implemented it with sub-reports.

    If you are only looking to report on one treatment id then the question is, how is the treatment id selected, is this going to be a parameter that the end user selects or enters when running the report.

    Give me a bit more info & I'll try to help out.

    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