I am having an issue with SSRS reports where I am not getting the data in the correct format. Please see below screenshot. There is a table 1 inside which are two tables 2 and 3. Both the inside tables contain data from 2 datasets ds2 (fy12,fy13,fy14)and ds3(prod
desc,revenue). The ds3 will have multiple rows but ds2 will have just a single row. Hence when i run the report the values of the ds2 gets repeated which should not be the case.How can this be done where the data is not repeated???I cannot merge the queries
to get into a single dataset.Also, I have to show the data in this format only.If I do not take the parent table1 but two different tables besides each other then table of ds2 remains constant and ds3 increases which does not look good and is not required
Please advise
