Solved

Adding row count to crosstab

Posted on 2010-08-16
7
924 Views
Last Modified: 2012-05-10
Using Cystal XI. Is there a way to add row numbers to a crosstab report through Crystal?

So that this:

Ptr A
Ptr B
Ptr C

Ends up like this:

1    Ptr A
2    Ptr B
3    Ptr C

I just need it to be the first column in the report, not a summary or anything.
0
Comment
Question by:DebB
  • 3
  • 2
  • 2
7 Comments
 
LVL 13

Accepted Solution

by:
PCIIain earned 250 total points
ID: 33452438
Not without building the crosstab manually. Then you can use a running total to store the number.

Crosstab formats are very limited. Whilst there may be a method of getting this counter in there in Crystal 2008, it still couldn't be the first column.

What is the nature of the columns of the crosstab? Could it be done manually instead?
0
 

Author Comment

by:DebB
ID: 33454572
It's for a customer who wants this in a very specific way. I've already had to convince them to change a lot because of limitations with the crosstabs and was hoping that I could at least get this. I will try doing it programatically and see how that goes.

Thanks,

Deb
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 33458039
It would be possible in CR2008

mlmcc
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 

Author Comment

by:DebB
ID: 33458110
Is the functionality for crosstabs and charts enhanced in CR2008?  
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 33458216
For cross tabs it is.  You can add your own calculated fields to it.

I don't know about charts.

mlmcc
0
 
LVL 13

Expert Comment

by:PCIIain
ID: 33462288
You still can't put the calculated field to the very left of the crosstab, you can only put it within the crosstab body.
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 33467074
Thanks PCIan.  I haven't used the feature or even read up on it much since I am still mainly using CR XI.

mlmcc
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).
Both in life and business – not all partnerships are created equal. As the demand for cloud services increases, so do the number of self-proclaimed cloud partners. Asking the right questions up front in the partnership, will enable both parties …

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now