Search results for query: *

Same problem with CR8.5.0.217 and Excel2003 SP3. Downloaded and installed CR8.5 SP3. No more error. Thanks!

Subreport wraps to next line when exporting to Excel: I have tried every recommendation given by kenhamady and lbass (resizing and aligning fields, snap to grid, attach both left and right sides of fields and subs to gridlines, eliminate all space between fields, make the section as small as...

Here is what I did: To identify the Top 20 of THE FIRST DESIGNATION listed, I have placed this formula in the detail section: //@TopN Whileprintingrecords; stringvar Top1 := NthMostFrequent (1, {@desig1}); stringvar Top2 := NthMostFrequent (2, {@desig1}); stringvar Top3 := NthMostFrequent (3...

LB, It's a complicated data set. I don't have a problem with the individual designations. I just need to count them. Nevertheless, here are the formulas as requested. {@desig1}: if {@one desig} = "" then trim((Split ({Name.DESIGNATION}, {@field_sep}) [1]) ) //trim off any excess characters...

LB, Just saw your post. I am counting across all records in the db. the field {tablename.designation} would have the following data : record1: "CPA, CFA, QQ" record2: "CFA" record3: "CFA; QQ" So you see that it is quite random. I have created the follwing from this data with formulas: record1...

Thanks. But {tablename.designation} gets parsed to five different fields. I have determined a unique separator for record and created @desig1; @desig2; etc. Where "CPA" for ex. can exist in any of the "fields" @desig1, @desig2...depending on the order that the individual entered his/her...

Theoretically yes. This is a data entry field on our website over which we have no control.

I have a database field ({tablename.Designation}) that can have multiple values separated by a variety of separators (e.g. "CPA, CFA, CFP"; "CPA"; "CPA,QQ"). I need a TopN (up to 20) count of the number of times each unique designation occurs. I have been able to parse the data using...