Displaying data from multiple datasets in the same table

Discussion in 'microsoft.public.sqlserver.reportingsvcs' started by Marius Cristian CONSTANTIN, Oct 7, 2004.

  1. I have two datasets, the first one attached to a table, and I would like
    to display a field from the second dataset based on a criteria. Think as an
    analogy to joins, but for various reasons I cannot merge the queries to get
    a single dataset (data is coming from different databases). So, I have a
    common key and I want to lookup into the second dataset? How can I achieve
    that?
    Practical example: first dataset retrieves a list of people, with their
    address and a column the contains the country code. In a different DB I have
    a table that has associations for a country code a country name. How can I
    display a list of people and the country name? No join at query level is
    acceptable.

    Regards,
    Marius
     
    Marius Cristian CONSTANTIN, Oct 7, 2004
    #1
    1. Advertisements

  2. A data region can only be bound to one dataset. Why is a join in a query
    unacceptable? Can you create a view in your database with a join in it and
    create a dataset off of that view? Would that be an acceptable alternative?
     
    Ravi Mumulla \(Microsoft\), Oct 7, 2004
    #2
    1. Advertisements

  3. It's not acceptable because we are not using a database, but instead a
    custom data extensions that gets data from our business layer objects. In
    business layer we do complex calculations, so writing the reporting as pure
    SQL queries wouldn't be feasible. So we have business layer object that
    retrieves a list of persons, and a business layer that retrieves a table
    with mapping from country codes to names. We would prefer not to implement
    joins in our custom data extensions if it would be possible. Also, I guess
    that subreports would do it, but is seems to be that it would be an
    overkill, and would raise problems when going to numeric (orders with items,
    and items with prices in a different dataset), because for example we could
    have two different tables, and show the difference between two prices.

    Regards,
    Marius Cristian CONSTANTIN
     
    Marius Cristian CONSTANTIN, Oct 7, 2004
    #3
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.