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!