working with multiple tables in report builder

  • i have developed a report model with mulitiple table, which are linked with master-child relationship...

    in report builder, when i select one table i cannot get data from another table...even though they have relationship between them.

  • masqazi (9/18/2010)


    i have developed a report model with mulitiple table, which are linked with master-child relationship...

    in report builder, when i select one table i cannot get data from another table...even though they have relationship between them.

    Inline queries are not considered as the best practices

    You may consider creating SQL Procedures

    Raunak J

  • can u explain a bit more about what you mean..

  • it looks like that is the only option you got

    unless you give primary key to your table.

    or to create a unique key you may create a named query having two columns cocatenated

    i guess this helps

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

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