sub report and group by

Skip Navigation LinksHome  /  Support  /  Forums  /  DynamicPDF CoreSuite for .NET (v6)  /  Re: sub report and group by

DynamicPDF CoreSuite for .NET (v6) Forum

 Aug 15 2012 10:29 AM
I am trying to group data using two sub reports. The query of the main report is event driven. For example, I want first to group by letters and, in that set, further group by numbers so as to have a report that looks like that:

a
  1
  1
  2
b
  1
  2
  2

I am using the designer.

When I set the query of the first sub report to group by letters and the query of the second sub report to group by numbers, it does not generate what I want. Could you help?
 Aug 15 2012 1:05 PM
Posted by a ceTe Software moderator
Hello,

Please send an email to support@cete.com referring to this forum post and include the following information so we can look into this further. 

1. Dplx or designer template file.
2. Output pdf
3. Code used.
 
Thanks,
ceTe Software Support Team.
 Aug 15 2012 1:32 PM
Thanks for the prompt reply. Actually, we figured it out: the data set must be pre formatted in order for a group by  to work in a sub report. To reuse the example, I simply appended "group by letter, number" to the query filling up the data set.

All times are US Eastern Standard time. The time now is 2:55 AM.