Click here to Skip to main content
15,892,927 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
I'm trying to build a report that hits five joined tables. That's the easy part. The customer wants the results in four bands. The top band has three boxes with results from three of the tables (group header). The second band has detail information from one table, in three separate boxes. The third band has detail information from another table, in four separate boxes. The fourth band has additional results from one of the three tables in the first band (so a group footer?) So the report looks something like:

Information about         General information about          Information about
engine goes here          results go here, again,            fuel used goes here
one row in query          one row from query                 one row from query

-----------------------------------------------------------------------------------
Specific information      More specific information from fourth table,
from fourth table         multiple rows, goes here too.
goes here, six rows       Again, six rows per
per query                 query

Third group of information from fourth table goes here
and here,
and here, still from the six rows per query.

-----------------------------------------------------------------------------------
Specific information from fifth table     Specific information from fifth table
goes here, *SEVEN* rows per query         goes here, six rows per query

Specific information from fifth table     Specific information from fifth table
goes here, six rows per query             goes here, six rows per query

-----------------------------------------------------------------------------------
Final information, from the second 
table goes here, from one row in query.


Notice in the second detail band the first box has seven rows, for background values, but the others only have six.

Is this a feasible report to do with a rdlc report or Crystal reports? Is one easier to use for this than the other? Do I have this right that it's a group header band, two detail bands, and a group footer band?

Thanks!
Posted

1 solution

You should use dataset kind of functionality for reports.

If you use, RDLC report is better you can design your query or dataset. Even you can run query for specific columns value also, Check in code project also you will get aritcle for same.

thank you.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900