Search results for query: *

Using CR XI I have created a parameter for the user to select either New or Used from the field {sales.newused}, easy enough. However the data field contains either "U" or "N" How can I change or replace the "U" or "N" with "Used" or "New", so the the user can type in New and get N or type...

Using Access 2003, we have a main table of peopledump, which has unique records, each with an idn in field idn. However each idn may be in several Lists, such as sales, service, other, etc. numbered 1 2 3 4 5 etc In order to see which lists each person idn is in I have created a query linking...

Using CR XI I have some stock numbers that I need to select. The ones I want start with a "P" and that's simple enough to select {sales.stockno} startswith "P" But some of those end in "A" or "AR" or "AW" or "BR" So want something like .... {sales.stockno} startswith "P" and...

Using CR XI pro, and I need to have different field headers or text object headers for a Group section vs. Detail section. The group data is generally totals, summaries, or formulas, and so sometimes I need what was the field header in PH to be a text object description, especially if I delete...

Using Crystal Reports 10, with data from Access or MySQL, The Report is a Zip Code report, with the zip field as the Group. The Data has the zip formated as a number. I have formated it in Crystal as -1123 (no comma and no decimals)This works fine in the body, except in the left drill down...

Report uses only one table "sales" Grouped on Zip Code (top 10 Etc) In a field named "newused" there is either an "N" or a "U" I simply want to count how many N's and how U's in each Group I was able to get answer but had to use 3 formulas Formula1=@Count New if {sales.newused}="N" Then 1...