Group by “original order” causes looping in CR

Printable View

August 24th, 2013, 09:56 AM
Capson

Group by “original order” causes looping in CR

I have a report grouped by Themes-S >> Questions-S there are 8 themes and each theme has a between 17 and 5 questions in it.

The report has 16 pages.

I need to change the ordering from specific to original when I do I end up with 288 pages

Something is looping? I can not figure out how to fix this (using CR 11)

Thanks
August 24th, 2013, 11:04 AM
jggtz

Re: Group by “original order” causes looping in CR

If you change order from specific to original you are 'saying' to CR that your data is already ordered by themes and questions

IMO you should keep ordering = specific
This way CR will order your data accordingly to your groups and sorted fields
August 24th, 2013, 11:30 AM
Capson

Re: Group by “original order” causes looping in CR

jggtz, thanks for the response.

The reason I want to change to "Original" order is that if a question changes in the data source (i.e question is added or deleted or edited) I will have to re-do the "specific" ordering for the "Question" group which is a long and tedious process, is there a way around this?

Thanks
August 24th, 2013, 11:38 AM
jggtz

Re: Group by “original order” causes looping in CR

Please explain more about :

Quote:

if a question changes in the data source (i.e question is added or deleted or edited) I will have to re-do the "specific" ordering for the question which is a long and tedious process

...also post the design of your data (tables, fields and relationships)
...or is it a single table?
...do you re.do the ordering manually?
August 24th, 2013, 11:55 AM
Capson

Re: Group by “original order” causes looping in CR

Data table is a Excel file, which is a download of a LimeSurvey Survey, if a question is added, deleted, or edited in LimeSurvey then the the data being imported into CR has been altered-a question has been changed so that for the "Question" group ordering = specific is no longer valid and will need to be updated with the deleted, added or edited question.

The order that comes out of LimeSurvey is the order I want in the report this order is in the excel file, "Theme" has specific order and "Question" group is already grouped with respect to Theme and has a specific order.

Thanks
August 24th, 2013, 12:12 PM
jggtz

Re: Group by “original order” causes looping in CR

It would be helpful if you post a snapshot of the excel's worksheet
or even better, attach the excel file

Anyway..
Have you tried removing the groups in CR ?
If the data is already ordered then is no a good idea to Group By in CR

If you want to group & order the data in CR it is necesary that the data has 2 more columns, one for the Theme and one for the Question
Example

Code:

Theme Question 1 1 1 2 1 3 2 1 2 2 3 1 3 2

...and so on