Ravi Dommaraju Posted October 5, 2021 Share Posted October 5, 2021 I need to print Grand total of the report in report Header with the right format. any suggestions I need to print total count of items sold on header of the report. right now if use cnt verb, it is printing only first line item. Link to comment Share on other sites More sharing options...
David Beagan Posted October 5, 2021 Share Posted October 5, 2021 I image there could be something simpler, but this works: SET PAGE=NOLEAD DEFINE FILE ggsales GTDOLLARS/P12M = DOLLARS; END TABLE FILE ggsales HEADING "The Grand Total of Dollar Sales: <GTDOLLARS" SUM GTDOLLARS NOPRINT SUM DOLLARS/P12M BY REGION BY ST BY CITY END image.png465519 42.1 KB Link to comment Share on other sites More sharing options...
David Beagan Posted October 6, 2021 Share Posted October 6, 2021 Here is an alternative. This can be accomplished without multi-verb, so it should be achievable in InfoAssist. DEFINE FILE ggsales GTDOLLARS/P12M = DOLLARS; END TABLE FILE ggsales HEADING "The Grand Total of Dollar Sales: <TOT.GTDOLLARS" SUM GTDOLLARS NOPRINT DOLLARS/P12M BY REGION BY ST BY CITY END Link to comment Share on other sites More sharing options...
Ravi Dommaraju Posted October 8, 2021 Author Share Posted October 8, 2021 Thanks David!. I can do the total they way you have mentioned above using TOT verb. but how I can do distinct count of products instead of total I want to display total count of distinct customer in the header. Link to comment Share on other sites More sharing options...
David Briars Posted October 8, 2021 Share Posted October 8, 2021 If Davids code is a good model for your focexec, then perhaps try something like this: image.png983716 114 KB Link to comment Share on other sites More sharing options...
Ravi Dommaraju Posted October 15, 2021 Author Share Posted October 15, 2021 Thanks you Very much David! This works, Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now