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

When I right click on command only shows (Edit command - View command) I do not have rename option.

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...

Never mind . Thanks Ibass

But , it shows duplicate also when I check supress if duplicat it shows on the top of the field not on the bottom?

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.

After creating parameter in the sql command I am getting Error message (Sql command not properly ended)

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)...

{?DateRange} I am getting this message (This field can not be summerized)

totext(minimum({?DateRange}),"M/d/yyyy") + " to "+ totext(maximum({?DateRange}),"M/d/yyyy") I am getting this message (This field can not be summerized)

The report works only I am getting blank parameter

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 a parameter that the user can see the report by division or Action Date or Disposition Date (user option)

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

Yes , James I." and "Jim" appears in the first name field , the second section are DOB ,SSN fields already in the People table and what you are expected is correct First Name Field Last Name FieldBrian GriffinJoe T. SmithJerry...