I'm a crystal user who just made a transition to SQL Reporting. I have a report thats been causing some headache for a while...
here is the structure
the report in Report designer has two tables
Table 1 has a dataset "CellHeaderQuery" that lists some values (group totals) that is built out of a stored procedure.
Talbe 2 has a dataset "Dataset1" that lists more detail (group totals, etc.) that is built out of a different stored procedure.
Both stored procedures are different and get data from different tables. the only things common are the group names.
This table structure is an existing report, I have to modify it so that the first table (which has the same groups) gets data in an additional column from data in the 2nd table.
CELL ID COL1 COL2 COL3 COL4 COL5
12345 4 4 4 * *
1345 4 4 4 * *
145 4 4 4 * *
13345 4 4 4 * *
TABLE 2 (same groupings and vvalues for Cell ID)
CELL ID COL1 COL2 COL3
12345 4 4 4
1345 4 4 4
145 4 4 4
13345 4 4 4
what I need to do is to populate the cells marked with a * (for COL4) and COL5 with the values COL1 + COL2 in table 2 and (for COL5) the value of COL3 in table 2.
How can I do this?