Grouping issue

Jennypi · Post by **Jennypi** » Mon Jun 11, 2012 5:48 am

Hi all,

I have a list like this:
1- A
2- R
3- C
4- A
5- C

I would like to group data by letter, but I would like to keep the initial sorting order of the list.
The result would be:
1- A
4- A
2- R
3- C
5- C

Can I do that? I tried to group on letter, but then I get:
1- A
4- A
3- C
5- C
2- R
which is not what I want. R should be after A, as it's #2.

Thanks!

Post by **Alex K.** » Tue Jun 12, 2012 9:34 am

Hello,

As a way, you can try to use the additional code.
We need some additional time for prepare the sample.

Thank you.

Jennypi · Post by **Jennypi** » Tue Jun 12, 2012 9:36 am

No problem, I'll wait

(I don't know how to add/write code!)

Thanks in advance.

Post by **Alex K.** » Thu Jun 14, 2012 8:20 am

Hello,

Please check the sample report in attachment.

Thank you.

Jennypi · Post by **Jennypi** » Tue Jun 19, 2012 4:58 am

Thanks for this example.

In my report, I have:
- defined the same 3 databands
- set the BeforePrint event of the first 2 ones after adapting it to my Datasource,
- set the PrintIfDetailEmpty property to True for the 2nd one,
- set the condition to the third one,
- copied/pasted the code to create tbl and ind

To me, my report is exactly like your example, still, it's not working! Blank page...
Can you please help me finding what's wrong?

You can download report + data on this link.

Many thanks

Post by **Alex K.** » Wed Jun 20, 2012 8:51 am

Hello,

Please try to set the EngineVersion property to EngineV2.

Thank you.

Jennypi · Post by **Jennypi** » Thu Jun 21, 2012 5:54 am

Hi
Thanks, it's indeed working better now.
But I am still getting an error message, "Object reference does not refers to reference of an object", something like this.
It seems that it's coming from the condition:

Code: Select all

labels.line_name != tbl[indx].ToString()

Variable indx is initialized by 0, it seems that it's a problem for the reference in the array.
Can you please help me?

Thanks

Post by **Alex K.** » Thu Jun 21, 2012 9:24 am

Hello,

Please clarify does this error occur always or with a specific data? If with data please sent them for analysis.

Thank you.

Jennypi · Post by **Jennypi** » Thu Jun 21, 2012 10:30 am

Hi,

This error occurs with all data from my datasource, which is a database.
Unfortunately, when I export to csv to send it to you, error doesn't occur, it works perfectly. So you wouldn't be able to reproduce error if I send you data.
Basically, I first display a form where user can choose on which data he wants to work with, and then I run the report on this data.
I am attaching the report to this post so you can see its structure. Maybe something is wrong with the code? Maybe the fact that I'm using a form changes something?

(Or is there a way to share my desktop with you?)

Thanks,
Jennifer.

Post by **Alex K.** » Fri Jun 22, 2012 8:00 am

Hello,

Please check the modified report in attachment and let us know about the result.

Thank you.