straight table using RowNO() having issue with sorting

[#1]

Hi Guys,

I need to do sorting in a straight table on a chosen column.

I am using RowNo() in this table so sorting is not working and it always sorts by the first column.

Is there any work around of it?

I am using RowNo() in the expression like this...

if(RowNo()<>0  and not IsNull(RowNo()),LinkedTxnType)

to hide ReceivePayment in bold text text from appearing on the Total line.

I also tried to avoid using Rowno() for this purpose and use "No Totals" as TotalMode on the Expression tab but that did not stop the ReceivePayment in bold text text from appearing on the Total line.

So my goal is to

• stop the ReceivePayment in bold text text from appearing on the Total line.
• do sorting on columns.

Any ideas?

Regards,

Saurabh

[sundarakumar]

Hi Ramya,

Please share a sample app or sample source to understand ur requirements.

1. I think the TOTAL showing in bold with bold Received Payment is data and not total(since they are having txn id) .Please share sample source to confirm.

2.Sorting can be done by any expression just go to sort tab and select the expression u want to sort in and give the condition.Please specify on what condition you want to sort. We can try to help you.

-Sundar

[khadeer]

Hi,

In sort tab u have interactive sort option. Check that option.

Regards,

Khadeer

[#4]

I read on this Sorting Problem for Straight Table that if we are using rowno() then sorting is disabled.

And I can confirm that ReceivePayment and TxnID shown on total line is not data.

I will share a sample app soon.

[#5]

Hi,

Chart Properties -> Expression -> Total Mode (No Totals)

Chart Properties -> Sort Tab -> Sort By

[whiteline]

Hi.

In the cases like "RowNo()<>0 and not IsNull(RowNo())" you can use Dimensionality() instead of RowNo().

So that the sorting should work.

[#7]

I can not use dimensionality() because users have options to remove and add more dimensions.

[whiteline]

Since you check for the grand total line there is no matter what function to use.

add:

Here the solution how to get row numbers without using rowno().

[#9]

My whole purpose of using RowNo() is to find the Total line and remove the text from there.

like this

if(RowNo()<>0  and not IsNull(RowNo()),LinkedTxnType)

is there any other way to detect the total line and achieve the same result?

[phaneendra_kunc]

Try this option...

Enable "Design Grid" -- Menu bar --> design grid.

and right click on the cell you are trying to "unBold" and click on "Custom Format cell"

you will notice "BOLD" is checked..remove that..

Now all Total rows will be unbolded...do it for expressions too..

Regards,

Phani