Multiple values in sql report

[dotnetcsharpdev]

Hi, I have a table in my sql report which has repeated values for the repeated values of one column.. something like master table with multiple values and detail table with multiplw values. How can I implement it in sql report? as i cannot insert a table inside a table!!...

[David Mujica]

I'm not sure what you mean by "SQL Report". :confused: Are you using a report writer ? Using a report writer, you would create 3 groupings: 1 Master level 2 child level 3 grandchild level You can then place summary fields at each grouping footer and display headers for each group change. Maybe list the data you are trying to report on and we can give a more detailed solution.

[dotnetcsharpdev]

:omg:   sorry for the confusion, i   reworked the report, this is a sql report and am developing it using vs. I need to take sum of the values in a table column but there is no way i can do that as all i can access in a new textbox are globals, fields and table textboxes don't figure in globals!!! also master detail kind of display using the values from the stored procedure is unknown to me.

[David Mujica]

I don't think I can help you. I'm not experienced with SQL Report. I'm much better at Crystal Report in Visual Studio 2005 Professional.