Adding row number to crosstab in BIRT report

I'm not able to add row number to cross tab in my report. The corsstab I have for some rean it will not allow me to add any element to row definition side of the crosstab. I have already tried several examples from this forum but haven't been successful yet. I have attached a copy of my report design. Please help me.

Find more posts tagged with

Comments

VSafonov

Looks like you group your values by BeginDate. So there could be multiple rows groupped into 1 line of crosstab.
1. Which rownum would you want to show there?
2. Depending on the answer add rownum to summary fields in you cube with the max or min or last or first. Then it will be available.

ReportBirtUser

In the summary I'm trying to get output for all 24 hours in a day. So, basically I want to show a running count as 1 to 24 once to the far left of the output. I have attached the output. So, the output i want is somethingto be static for all 24 hours once.

VSafonov

I see potential problems with just adding "dumb" counts. What is there is no trading in some hour - you going to skip the row and shift the rest? I would try this: add another summary field to the cube based on the trade time that just operates on the Hour portion. this way the hour will be displayed accurately even if there is a "skip" in the operation.

ReportBirtUser

Thank you VSafonov. It worked this time.