Search results for query: *

Laughing - well that did not work I found recordcount and it did exactly what i wanted counted each record - so that nothing totaled in the crosstab column Now i am looking at something like this CrsNo Crs title City Bldg Shift F1223-2 FinancePlan ORPORTLAND Other...

Lb your help has been great - It has help me learn "Crystal crosstabs" is very limited in some ways in row one - instead of concatinating together the rows {table.crs_no}+" "+{table.crsTitle}+" "+{table.City}+" "+{table.Bldg} to create the unique "string" how about where row #1 is just an...

oops I meant (if isnull({room}) then "Other" else {Room}

thanks lb there is a section in the data that didn't work i think it has to do with null values in the room field I will try a formula (if isnull({room}) then "" else {Room} to see if that will help

LB sometimes pictures are easier :) here is the layout in CR Crosstab expert http://mysite.verizon.net/res19czn/index/images/CRexpert.jpg (next 2 pictures I had to mask out some data) here is a pic of the preview page http://mysite.verizon.net/res19czn/index/images/CRpreview.jpg Here is a...

LB, do you have an e-mail addy i can send a file too? I have 2 samples of the data i am using and the problem associated with this topic

I am concatenating the fields together. {table.City}+ ', '+{table.room}+', '+{table.crs.no}}+', '+{course title) What formula or character do I use, so when I export to excel the + ', '+ will force the export in excel to separate into separate columns instead as one column of text? when...

Lb, Sorry it took a long time to get back to you the data I was using is an example the real data is how many people are requesting training classes by shift by city, building SHIFT 1 2 3 City...

Problem is, I do need all of the row fields to be listed and not suppressed. Seems like what ever field I place into row 1, 2, 3, in the row field the text get suppressed and row 4 is not suppressed column 1 2 3 row1 row2 row3 row4 xxx...

in crystal reports version 9.2 I want the rows to repeat themselves How do I make the row data repeat (for exporst to excel) Currently I get this result: (count of people by shift, by state, city, zipcode) Employee Shift State City Zip 1 2...

oops thanks Eradic8or, but that won't control the number of rows retuned in the report. I would need the control to pagebreak at first 20 records and then at the supv name change I have a supervisor(s) with: Supv 1 @ 30 employees (would recieve 2 pages of 20 names, & 10 names) Supv 2 @ 15...

I have a report that must be printed on a pre-printed form. The grouping is by supervisor and the detail(s) are the employees. I need to have the report page break on a maximum number of records, Per Supervisor. Example: ________________ Supervisor(1) ________________ employee1...