I am trying to create a sub-report which consists of main query and sub-report queries and running couple of pages.problem is sub-report query data is repeating in other pages too.how can avoid that one ? Anyone can help me to figure it out.I am using Impromptu ver 6.0.
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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Impromptu sub-reports
- Thread starter bhas79
- Start date
CosmicNerd
Technical User
What sort of frame is the sub-report in?
If your sub-report is linked to your main report you are likely to get this sort of result. Can you explain why you think this should not be happening?
If your sub-report is linked to your main report you are likely to get this sort of result. Can you explain why you think this should not be happening?
- Thread starter
- #3
Cosmicnerd,
Thanks for your reply.In my report I have to compare main query total to a calculated value.I don't want this value to be repeated on every page.Now we modified our tables to get needed data into our main table and calculated the value. we can align this value to a particular column so that calculated value is not repeated on other pages at same location.
Thanks for your reply.In my report I have to compare main query total to a calculated value.I don't want this value to be repeated on every page.Now we modified our tables to get needed data into our main table and calculated the value. we can align this value to a particular column so that calculated value is not repeated on other pages at same location.
- Status
Similar threads
- Locked
- Question
- Locked
- Question