Notifications
Clear all
Topic starter
I have an old report that was written before my time.
It has a group by that no longer works.
Here is a screen shot:
Here is a screen shot of the code for the GroupBy:
Any suggestions as to what to check would be greatly appreciated.
Posted : September 2, 2014 2:50 am
Topic starter
In addition the G.XXX moves up and down the list when you move over the add and remove buttons.
Posted : September 2, 2014 3:04 am
I can't see either of your screen shots. Tried three different browsers.
Posted : September 4, 2014 5:00 am
Topic starter
Try 2 on the images.
Posted : September 4, 2014 5:32 am
Can you provide the report query?
Posted : September 5, 2014 10:16 am
Topic starter
ronmoses,
Sorry or the delay in response.
I PM'd you with the SQL code.
Posted : September 30, 2014 3:05 am
Okay, I have the code, so let's get into some specifics:
1. When you say the group no longer works, what exactly is happening?
2. "In addition the G.XXX moves up and down the list when you move over the add and remove buttons." I'm not sure I'm picturing what you mean. Can you provide some further detail on that behavior?
Posted : October 3, 2014 12:53 am
Topic starter
When you select one of the G.XXX codes, it moves to the bottom of the select list, but it does not show that you selected it.
Posted : October 3, 2014 1:02 am
jkratzer said:
When you select one of the G.XXX codes, it moves to the bottom of the select list, but it does not show that you selected it.
So you click on G.Doctor, and the list is reordered so that G.Doctor is at the bottom? Or are you clicking Add at some point in this process? I'm just a bit confused about the steps.
Posted : October 3, 2014 1:06 am
Topic starter
It moves down when you select add or double click it.
Posted : October 3, 2014 1:15 am
jkratzer said:
It moves down when you select add or double click it.
But it does not add to the right-hand list? Hmm, that's weird. The one thing that looks off here is the "G"s in the selection list. I'm not sure why they're there. Try this: In your control properties (the other dialog you posted), put curly brackets around the field names so it looks like this:
Doctor^{d.ListName}|Financial Class^{f.Description}|Department^{dp.Description}
See if that does anything.
Posted : October 3, 2014 1:36 am
