Now can I say "Help!!!"?
I'm working in CR 9. I've taken the Seagate Advanced Report Design course and have some limited knowledge of code from long ago programming courses.
I am grouping a report and very similar subreport on three fields. They have the same selection formulas on an ODBC link to a SQL Server database. Three linked tables with normal joins are queried. The second group is using a formula field. The subreport is linked on this and the third group field, which is a database field.
Here is the formula for the second group's formula field:
[
Local StringVar FirstTwo:= Left({wjsmas.ELCNUM},2 );
If FirstTwo = "S-" then "Collections"
Else if FirstTwo = "W-" then "Water"
Else if FirstTwo in ["A1", "A2", "A3", "A4", "GV"]
then "Other"
]
The report is supposed to work so that the subreport is called and prints out the third group totals line by line, once for each of the three groups indicated above and as many iterations as the first group. What is happening is that it does output the "Collections" and "Water" groups correctly but will not output the "Other" group. A drill down in the report preview shows that it has found and totalled all the "Other" data correctly but leaves it blank on the report. There is a subreport section titled "Other" showing on the report but no data. Any clues as to how to fix this? My supervisor and I would both be very grateful for a solution.
I'm working in CR 9. I've taken the Seagate Advanced Report Design course and have some limited knowledge of code from long ago programming courses.
I am grouping a report and very similar subreport on three fields. They have the same selection formulas on an ODBC link to a SQL Server database. Three linked tables with normal joins are queried. The second group is using a formula field. The subreport is linked on this and the third group field, which is a database field.
Here is the formula for the second group's formula field:
[
Local StringVar FirstTwo:= Left({wjsmas.ELCNUM},2 );
If FirstTwo = "S-" then "Collections"
Else if FirstTwo = "W-" then "Water"
Else if FirstTwo in ["A1", "A2", "A3", "A4", "GV"]
then "Other"
]
The report is supposed to work so that the subreport is called and prints out the third group totals line by line, once for each of the three groups indicated above and as many iterations as the first group. What is happening is that it does output the "Collections" and "Water" groups correctly but will not output the "Other" group. A drill down in the report preview shows that it has found and totalled all the "Other" data correctly but leaves it blank on the report. There is a subreport section titled "Other" showing on the report but no data. Any clues as to how to fix this? My supervisor and I would both be very grateful for a solution.