Serial number in Crosstab

[Former Member]

Hi guys,

I have a crosstab that shows sales by a Parent, Territory and Product.

I need to show a serial number that represents the rank of the sales, sales are sorted in descendent way.

How can I add that serial number in the crosstab?

I have tried functions like CurrentFieldValue and CurrentRowIndex but I get errors for both;

For CurrentFieldValue it seems like it does only work on formatting fields.

For CurrentRowIndex, I get "This function can be used only within the context of a value grid"

Any help would be appreciated!

[abhilash_kumar]

Hi Minerva,

Could you also attach a screenshot of the crosstab's structure from the Design page?

-Abhilash

[Former Member]

Sure!

[abhilash_kumar]

This is going to be very difficult due to the number of fields (used as the row) in the crosstab.

I'll keep you posted if I do make any progress.

-Abhilash

[Former Member]

I know, I've been struggling with that for some days

Thank you!

[former_member11696]

Hi Minerva,

As you've noticed our crosstab engine is/can be quite simple in it's abilities.

What you may want to do is create a manual Crosstab.

See this KBA on how to:

1212953 - How to create a custom cross-tab with percentage values

Manual Cross tab reports using SAP Crystal reports for enterprise

Patrick is going to attach a sample report to the first one and the second one is for CR for Enterprise so the UI is quite different than CR for Windows you are using but the process is the same and may help...

Don

[Former Member]

Thanks, Don!

Unfortunatelly my pivoted columns have to be dynamics. With a manual crosstab I can't achieve that, right?

[former_member11696]

Not sure what you mean by Dynamic? When you hit the refresh button it updates the data, otherwise it's not dynamic and neither is a Crosstab.

Don

[Former Member]

I need the table to show all existent product types for the criteria selected (which can vary), so, I cannot place fixed columns like ColumnProduct1, ColumnProduct2...etc, that's why I was using the crosstab which is grouping by ProductType.