Search results for query: *

I have 4 string fields text1 , text2,text3,text4 ,Client ask me to create single Parameter that he can put any of text 1,2,3,4 to return value of field called purchase? One Parameter for 4 fields Please I need help. Thanks

is there anyway to rename sql command in crystal reports?

I have two fields Division and incidents Divison incidents northeast 20 southeast 30 (Blank) 10 what is the formula if Divison shows blank or null but there is incidents value .I want do not show the incidents value if...

is there any formula can show Grand Total on detail section?

Hello, I am trying to put the Month Name and year on a report using a text box formula. anybody knows the formula for Month name and Year Formula. Thanks in Advance.

I have this query in Command select (select name from mastlocationcode where type = 'DIST' and code = m.district) as "Division", count(incident_num) as "Incidents" from incident i, mastlocation m where m.recnum = i.locn_rec and to_date(reported_on) >= '01-jan-2011' and to_date(reported_on)...

I have a date parameter with range from - to , when I place the parameter in the report i see blank parameter.I need to show (for eaxmple (From 1/1/2007 to 12/31/2007)

I have 5 queries(Command) with 5 diffrenet datbase (data Source)what is the easiest way to connect 5 datasource in one single report?

I have formula Called "Dist" if{Command.District} = "NE" then "Northeast" else if {Command.District} = "AK" then "Alaska" else if {Command.District} = "SE" then "Southeast" else if {Command.District} = "SW" then "Southwest" else if {Command.District} = "NW" then "Northwest" I want to create...

is there is any way to create spread sheet inside crystal Reports?

I want to create parameter called Division sorted by Action date and Disposition date? can we craete drop-down parameter? Thanks

I have to create Parameter with First and last name , but some of names comes with middle intial.How to create the parameter without the user enter the middle initial. I mean we want just to enter First and last name. I have table named People with two fields First name and last name(separate...

I have field named (Lastname) contains Last name and company name and I have 2 texts called name in first text suppose show person's last name and second text supose show same persons' company name or his crew member's name but I only have I field called lastname? any idea how to solve this...

I have to create Parameter with (Firstname%Lastname),Do I have create two parameters First name and Last name? but I need to put % between First and last Name?

I have Three counts , each count contains diffrenet amounts .I want to run total for each count without adding up all three counts totals together? I need to show total for each count separately.

I have main report and four subreports , how can i make just one parameter for all reports? I mean when user open the main report that can have only one parameter to run the report?

How to avoid repeated pages in detail section ?after I joined all my tables left join, my report running slow .any idea to solve this problem?

I have Detail section A,B,C,D,E,F and when i run the report I am getting repeated records with too many pages , I tried suppress if duplicate it did not work .Please I need help.Thanks

I am trying to link tables by smart key link and I am getting this message (unable to smart link unliked tables,foreign key relationships may not to be present for the tables,or the database not support the retrieval of this information) and i do not want to smart link key by field names.Please...

I have Caseid table and Casecount table , each case number in Caseid table have multiple counts in Casecount table .I need a formula that show each case number with their counts? (Casecount.CNT)CNT = Case Count (caseid.CCN)CCN = Case Number My Parameter is {?Casenumber}