i want to get multiple table data show in horizotal and same level
hi, i want to show multiple table data in same level in horizontal axis . how could be possible let me know
October 8th, 2012 12:00am

Hi Lukesh, It seems that you are designing a chart report, right? Are there any common columns in those multiple tables? If there are some common columns, you can use JOIN keyword to join them when creating dataset, then you can show then in the same level in horizontal. Another way is using lookup function. SQL Server Reporting Services 2008 R2 came up with Lookup Functions which plays a very handy role in getting the things done in a very simple way. However, these functions cannot be taken as an alternate to JOINs. As their name suggests, they are just lookups helping us to retrieve values from a dataset that has name/value pairs and that is not bound to the data region. For more information about lookup function, please see: http://msdn.microsoft.com/en-us/library/ee210531.aspx If I have anything misunderstood, please let me know and provide more information about your issue so that we can make further analysis and help you out. Regards, Charlie Liao
Free Windows Admin Tool Kit Click here and download it now
October 9th, 2012 10:50pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics