Report Designer using Sub-reports
Quote from CSSystems on January 25, 2021, 9:42 pmI am updating a report which I am using 3 sub-reports. The most complicated report I use.
If I put them on the same page, one overwrites the other.
Is there a way that the sub-reports will push the one below further down the page?
Do I need a separate page for each sub-report.
Do I use partitions ? How do I do this?
This is a report to report an individual record which draws on 3 tables (dues payments, Awards, Positions held.
Help would be appreciated? I suspect my original approach may not have been the best.
I am updating a report which I am using 3 sub-reports. The most complicated report I use.
If I put them on the same page, one overwrites the other.
Is there a way that the sub-reports will push the one below further down the page?
Do I need a separate page for each sub-report.
Do I use partitions ? How do I do this?
This is a report to report an individual record which draws on 3 tables (dues payments, Awards, Positions held.
Help would be appreciated? I suspect my original approach may not have been the best.
Quote from CSSystems on January 25, 2021, 11:32 pmThis has been embarrassing ! The report that I have been talking about has existed for years.
I guess I did pay attention so it. It was in my early day. In fact the app was developed since 2013.
I think I have a handle on it now using Partitions etc. and some experimenting.
So don't need help now.
Just appreciation this forum being her for me to ask questions.
This has been embarrassing ! The report that I have been talking about has existed for years.
I guess I did pay attention so it. It was in my early day. In fact the app was developed since 2013.
I think I have a handle on it now using Partitions etc. and some experimenting.
So don't need help now.
Just appreciation this forum being her for me to ask questions.
Quote from PaulJonestindall on January 26, 2021, 1:11 pm@cssystems
I really hate to say it but Report Designer is, shall we say, problematic at best. While it is functional I've found it to be very quirky at times and it does take a lot of trial and error, not to mention paper also. Just a few tips if you're not already aware, be sure to have a report file backup before you edit an existing report. I had one report that would print Group Header and Data Body together with each record seamless down the page. When it came time to update for new data I now have an unwanted gap between records that I just can't seem to rectify. It just seems so very odd. Also, be aware of margins especially with your subreports. On occasion I've had to shift the subreport object on the main page to the left beyond the margin in order to print correctly.
Hope this helps a little bit.
I really hate to say it but Report Designer is, shall we say, problematic at best. While it is functional I've found it to be very quirky at times and it does take a lot of trial and error, not to mention paper also. Just a few tips if you're not already aware, be sure to have a report file backup before you edit an existing report. I had one report that would print Group Header and Data Body together with each record seamless down the page. When it came time to update for new data I now have an unwanted gap between records that I just can't seem to rectify. It just seems so very odd. Also, be aware of margins especially with your subreports. On occasion I've had to shift the subreport object on the main page to the left beyond the margin in order to print correctly.
Hope this helps a little bit.