Search results for query: *

I am using a count of the reportid field. When I do a distinct count the number is not what I am expecting. When I do a count of the reportId field I get the same count as the PartNumber count field.

I am attempting to summarize a field {Parts.ReportId} I have summarized another field {Parts.Partnumber} works fine. But when I attempt to summarize the {Parts.ReportId} field I get the same value as the {Parts.Number} field. This is what I am looking for GH- Country Australia GH-CustNo...

I am using Visual Studio 2005 with crystal reports 2008 I want to know can you export a report only to excel? I know that when you turn on the HasExportButton it gives you all available options to export the report is there a way to turn them off?

@IdoMillet I am using the Crystal 2008 viewer

I have 6 fields that I want to contacinate if they are not null or empty. This is what I started off with. I am getting an error A string is required. Any help would be appreciated stringvar notes; notes = {qt_head.text_id_2}; if (not isnull({qt_head.text_id_3})) then notes =...

Thank You!!!

I created a formula called Quarter the contents are below: if val({vSerialNo.PeriodMonth}) < 4 then "First Quarter" else if val({vSerialNo.PeriodMonth})< 6 and val({vSerialNo.PeriodMonth}) > 3 then "Second Quarter" else if val({vSerialNo.PeriodMonth})< 10 and val({vSerialNo.PeriodMonth}) >...

I wanted to know how to do a page break by a group. Is this possible

I wanted to know if it was possible to create a parameter based on a formula

I have a report that is viewed by supervisors There are 3 parameters on this report. technician name - which is a dropdownlist start date - text field end date - text field the supervisor selects a techicians name from a dropdownlist and enters in a start and end date to view report. The...

yes expect for the fact that I always want to check for null or empty fields first.

I am trying to compare if the custNo and ItemNo in one table match the CustNo and ItemNo in another then I want to set the warrEnd1 to 12/31/1999 being out of warranty if isnull({vSerialNo.WarrEnd1}) or {vSerialNo.WarrEnd1} = date(0,0,0) or {vSerialNo.WarrEnd1} =DateTimeValue ("12/31/9999") or...

Thank You fisheromacse checking the isnull worked perfectly

I tried that it worked. Thank you. I tried the same thing with another blank field that I am not getting an data in this field if {UserView.rptid} ={vSerialNo.ReportId} then 0 else if isnull({UserView.rptid}) or trim(totext({UserView.rptid}))= "" then 1 else 1

I am trying to flag an empty date field and change the value to a default value this does not work if isnull({vserialNo.WarrEnd}) then datetimevalue("12/12/1999") else {vSerialNo.WarrEnd}

Thank You Ian this worked

if val({vSerialNo.Operation})< 0 then formula = 1 else formula = 0 end if My formula is not picking up special characters like '?' '!' etc its counting them as 0 when these are not valid and I am looking for it to return a 1 for these characters as well as numbers less than 0.

I am trying to summarized a nested if formula I am not getting the numbers that I am looking for. I believe that I am on the right track with this if {@outofWarranty} = 0 and {@DuplicateRep 2} = 0 and {@Hours } = 0 and {@visit} = 0 then 1 else 0 here are the contents of the following...

Try ShowGroupTreeButtons = false

LBass first issue resolved. Second issue This is how the data is displayed Summary Report Country- CANADA VisitClaim DupRpt InvalidHour Credit Cust No. :VIC004 14 90 2 0 85 Cust No. :VIC004 24 3 0 0 3 Cust No. :VIC004 3...