cancel
Showing results for 
Search instead for 
Did you mean: 

using Collapse level is a problem in Grid

Former Member
0 Kudos

Hi,

I am trying to display a report in the grid having set Colapse level = 2. The query that is fetching the records is bringing the data correctly with the group total shown as 'TOTAL' titled row in the last row of every group. But when it fills the grid then 'TOTAL' titled row is not coming at its expected position. Either it is coming in the mid of the rows or, as first row. Seldom it comes as last row of the group. If i remove the setted Collapse Level, then the grid results are fine.

Plz advice.

Thnx in advance,

HK

Accepted Solutions (1)

Accepted Solutions (1)

Trinidad
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi,

Which version are you working with?

It only happens with a specific query?

I never saw that before, usually the order of the columns is the order in the SQL query passed to the DataTable, independently of the Collapse level.

Maybe you can share with as your query.

If you are using 2005 SP01 version you can easily test it with the ScreenPainter.

Regards

Trinidad.

Former Member
0 Kudos

I am using SBO 2005 SP 01 PL 11. The query is quite OK and is as per the grid columns. The query is quite long and not feasible to post over here.

How can i see the query results in Screen Painter?

Thnx for the help,

HK

Trinidad
Product and Topic Expert
Product and Topic Expert
0 Kudos

Just create a form with a Grid item inside.

In the Collections tab create a DataTable and asign your query to it.

In the Grid select the DataTable you just created.

Press the preview button, the form will be shown with the grid filled.

If you have the same problem with ScreenPainter then post a message for support saying that you are able to reproduce the same problem with your code and with the ScreenPainter. They should then be able to easilty reproduce your problem if you give them a copy of your database.

Regards

Trinidad.

Answers (0)