Post reply

Create reports from multiple datasets

  • December 7, 2005 at 2:34 pm

    #111415

    I am trying to create a report from two datasets. Both datasets have an ID. I need ID in dataset1 but not in dataset2 to be included. Since the two datasets come from different database, there is no way to use sql to solve the problem. Is there any way in reporting service to do that? Thanks.

  • December 7, 2005 at 3:17 pm

    #608283

    Yes you should be able to do it no problem.

    Are you trying to bind both datasets to the same Table? Because if you say yes, then you cannot do that.

    The fields are dataset dependent.

    you can only bind 1 dataset to as single table. Not exactly sure what U are trying to do.

     

     

  • December 7, 2005 at 5:59 pm

    #608308

    Dataset1 and dataset 2 have some data in common. The table I need to create only contains data in Dataset 1. But those also in Dataset 2 have to be excluded.

  • December 8, 2005 at 5:35 am

    #608377

    Are you trying to join the data from the two datasets?

  • December 8, 2005 at 7:35 am

    #608410

    Yes. I need to find a way either join them, or use one as a filter for the other.

  • December 8, 2005 at 10:08 am

    #608470

    create a view in one database to refer to the table in the other, e.g.

    select * from server.databasename.dbo.tablename

    then write query for your report to join the two.

  • December 8, 2005 at 10:37 am

    #608483

    I would think that you should be able to use 2 DataSets for the same table.  

    To use a field in the second DataSet, try:

     = (Fields!ID.Value, "DataSetName")

  • December 8, 2005 at 11:48 am

    #608503

    I know this technique, but it doesn't solve my problem, since I need to use dataset2 as a filter to dataset 1

  • December 8, 2005 at 11:49 am

    #608504

    This seams to be a solution. I will try it. Thanks a lot.

Viewing 9 posts - 1 through 8 (of 8 total)

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