Recent content by herbsza

yes

Thank you for your response We tried both your suggestions but it is still not working in crystal. How can we reinstall the OLE DB provider ? Thanks

When we try to connect to a database using OLE DB (ADO) the following message appears in the crystal reports 10 Error Message Unknown Query Engine The machine has the following operating system on it : Microsoft Windows Servers 2003 service pack 1 We have tried to reinstall crystal 10 but...

Hallo sbrunswik, If the fields {table.month}/{table.year} are a string value then use the following in the record selection formula (tonumber({table.year}) = year({anothertable.startdate,(dd,mm,yyyy)}) or tonumber({table.year}) = year({anothertable.enddate,(dd,mm,yyyy)})) and...

Dadas Is the sub report necessary ? Would it not be better to link the the two tables in the main report and then test in the selection criteria for the empty stock. selection criteria isnull({id on stock}) or {id on stock} = 0

Try the following I have not tested this but it should work. In a formula do the following formula @test replace ({ref},'/',',') go to change subreport links select the formula @test deselect (Select data in subreport based on field) now use the parameter in the subreport where clause...

Sommererdbeere I have been on leave. Do you still need this problem solved ?

Sommererdbeere A posible problem might be. When selecting the parameters {?Work_Cen} do you select 'SCRAP'. If so avoid doing so as you have already hard coded it into your where clause. The where clause does the first part ({WORK_CEN}='SCRAP' and {coln.SAP} <> 0)) but if you select...

sommererdbeere replace the AND with a OR ({WORK_CEN}='SCRAP' and {coln.SAP} <> 0) OR ({WORK_CEN}) like uppercase(replace({?Work_Cen}, &quot;%&quot;, &quot;*&quot;)) try that

sommererdbeere I think what you want to do is suppress the value's of sap when they are zero. in other words work cen qty @reworkissued @reworkedsap su 30 0 0 su 20 5 0 hk 30 0...

sommererdbeere original data work cen qty issued sap su 0 3 0 su 30 4 15 su 20 5 0 hk 30 0 40 hk 30 2 0 Go to the record selection editor...

I have made the following assumptions regarding the querie. That there are no date enteries occurring on a weekend. Date entries from monday to friday // the variable test determines if there was a fisrtdayofweek (Sunday) between the two dates given// local numbervar test :=...

Try the following. Still group by Physician. Place the following three formula's in the detail section. Do a sum on each of the three formula's. Now you can do your ranking according to the sum of formula procedureC and still be able to show the other totals. formula procedureA if...

create again a calendar year. in the select expert try the following if {?January} <> 0 then year({CPCASE.DOFF}) = {?calendar year} + 1 and month({CPCASE.DOFF}) = 1 if {?february} <> 0 then year({CPCASE.DOFF}) = {?calendar year} + 1 and month({CPCASE.DOFF}) = 2 if {?March} <> 0...

I will give this a try. create a parameter {?Calendar year} select expert date({CPCASE.DOFF}) in cdate({?Calendar year},04,01) to cdate({?Calendar year}+ 1 ,03,31) This should then give you a years worth of data. create formulas for each field you need to show. if {?January} <> 0 then...