Solved

Adding row count to crosstab

Posted on 2010-08-16
7
934 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 101

Expert Comment

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

mlmcc
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 

Author Comment

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

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 101

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

Enroll in July's Course of the Month

July's Course of the Month is now available! Enroll to learn HTML5 and prepare for certification. It's free for Premium Members, Team Accounts, and Qualified Experts.

Question has a verified solution.

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

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…

632 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