March 14, 2011 at 11:30 am
Hi,
I am trying to develop a simple report that displays person info and their plan types and rates.
I am having trouble with grouping as my sub category is repeating instead of displaying once.
for example:
my plan_ type is HCC and it should display the person plans and information below it like:
HCC
single plan
p1, last name, first name, rate
p2, last name, first name, rate
p3, last name, first name, rate
retiree plan
p4, lastname, first name, rate
But my report is showing as
HCC
single plan
p1, last name, first name, rate
HCC
retiree plan
p4,lastname, first name, rate
single plan
p2, last name, first name, rate
p3, last name, first name, rate
The person1 is showing separately and HCC is repeating. I tried it in all possible ways but no luck. Any help will be highly appreciated.
Thanks in advance,
Neha
March 14, 2011 at 12:47 pm
Let me restate it to make sure I undersand your question:
Your General / Group On expression is [HCC], [Plan]
Your Sort / Order By expression is [HCC], [Plan]
And what is happening is that the [Plan] part of the sort expression doesn't seem to be working? Is this an accurate description of what you are encountering?
March 14, 2011 at 1:05 pm
Hi,
Thank you for your reply. The Group on [HCC] is correct and [plan] is also a group on but not a sort by.
There are several sub category plans in [HCC] and I need to print people information grouped by these Plans.
group on [HCC/ HDR/ CRV etc]
and then group on [Plan]
and details about the person pid, lname,fname etc...
Please let me know if this helps.
Thanks
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply