Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Records in Sub report, but not in Main report
- Thread starter GeneN24
- Start date
synapsevampire
Programmer
Ahhh, that is a bit of a sticky wicket...
If it's possible that your main report will not have any rows, then I would convert the main report to a subreport too, and create a container report which always returns at least one row.
I sometimes create views for this wherein the select is:
select top 1 * from gender
Then I suppress everything in the main report and just show the 2 subreports. Since you're currently not linking the main report to the subreport (elsewise you wouldn't have expected to get anything in the subreport), you can treat them both as separate subs I think.
-k
If it's possible that your main report will not have any rows, then I would convert the main report to a subreport too, and create a container report which always returns at least one row.
I sometimes create views for this wherein the select is:
select top 1 * from gender
Then I suppress everything in the main report and just show the 2 subreports. Since you're currently not linking the main report to the subreport (elsewise you wouldn't have expected to get anything in the subreport), you can treat them both as separate subs I think.
-k
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question