Recent content by unknownly

I tired this logic and it works but I get the "a string can be almost 254 char long". Can I somehow restric it to collect only 2 or 3 values. the field type is varchar 255 and checked a max leng with trim it's 108 for a single message? Please advice. TIA, Sweetie

Is there any other way around to do this. Since I may have more than two. I won't be possible for me to show in multiple columns when more than 2. How can i do this if shown in the same column(one column) with the amounts getting double? Hope I clear with my Q. ex: when more than one error...

Using CR 8.5 I have a table called errors. fields: error-id, utility, point, error message,error month In some case there might be errors generated more than once with different error_id though the remaining fields are same. (sometimes rarely with a different error message) my user need to...

even my record select seems to not work for multiple selection if {?!invoiceStatus} = '*' then true else {inv.invstatus} = {?!invoiceStatus} please help me find what Iam doing wrong

even my record select seems to work for multiplr selection if {?!invoiceStatus} = '*' then true else {inv.invstatus} = {?!invoiceStatus} please help.

Don't know what I was thinking. But it didn't work for Multiple selection...when I select more than one value for the parameter Here is what Iam doing IF {?!invoiceStatus} = '*' THEN 'All Invoices' else if {?!invoiceStatus} = 'D' then 'Draft' else if {?!invoiceStatus} = 'F' then 'Final'...

Thanks, It worked. I tried Join in my formula but I didn't know how check it "like '*D*F'

Using CR 8.5 In a report I need to print the selected parameter. which is a '*' for all values, mutliple or single value. How can I print the parameter on the page header as the user selected. For example I need it to print as IF user select ?state = '*' then print 'All Values' if user...

Using Cr 10, Oracle 9i I need to create a report from 2 different datasource. DS1: Datasource 1 DS2: Datasource 2 I have a pre written SQL which is in use and need to use the sql to build the report. How can I use the data connection in order to use a command where both the data source are...

Thanks for the reply, I will try your idea again to double check. lbass, Greetings! I got this working. I have to use the @null logic for the a/c @a/c true if command.a/c = ?a/c then 1 else 0 some how the reguarl sum or count wasn't working... and create a #rtotal for count of a/c and check...

My user will enter a/c as a parameter. Which Iam not filtering in the report as a parameter instead checking it to see if the a/c from exists for any of the user enter a/c and change the color of the "Name" in the summary report( basically tell user to drill down on that "NAme" for more details...

lbass, Colour change for the following doesn't work... if {table.a/c} = {?A/CParm} then crGreen TIA, SWeetie

lbass, Thank you very much. I can't stop myself from blushing because of my stupidity. :) I have tired most the same thing as you. but I didn't do the sum({@null},{table.group#3field}) > 0 and instead checking @null > 0. So, gave a try for count but sum really didn't get into my mind... :)...

I have 3 groups in the report and Iam show summarized report on Group 3 footer. IT has drill down to show details. now I need to change the colour of the group 3 footer( name column on the summarized report) if in detail report if one of the field is null for example report looks like this...

Using Crystal reports version 10. When a user edits a command object in the report and the command has a parameter "date" set to a default value. When edit command it done and click ok. The parameter values gets reset. We have dowlanded the hotfix for CR 10 and I have read in the "READ me"...