Hello,
There are two phases in your work
1. Direct Table
2. Custom Stored Procedure.
If you have the data in the table as you want to show, then you can
use the table directly #1 and drag the fields on the report as needed.
(This case , as of my knowledge, no one stores the data like this.)
OR
2nd method is the best to create the Stored Procedure and create #table
or declare table datatype and add all fields as you need to show the data
on the report. Then using SQL queries get the data, change the data as needed
through SQL programming tech and insert them to temp table or table varible.
Loop to all records, that depends how you execute the SQL select statement
with the CURSOR.
Finally, refer this SP, in the report. And there you will see all those
fields that you declared in SP (#table or table datatype). Align the fields
as needed on report.
So you get the data as you wanted.
In such case of reports, its better to write SP and use them. I always prefer
SP rather than tables. This is my way. I am happy with the flow which i use.
Just give a try on this, might you get end with satisfaction of the output.
Hope this helps.
With Regards,
Raghavendra Mudugal
|
