Recent content by Durango122

hi try creating formula depending on language selection from the paramter ex: @French if {?Language} = 'French' then 'Bonjour' else 'Good morning' Durango122 if it moves and should not used Duck Tape if does not move and should used WD-40

hi would be better if you can create a view to limit the record return simply import in the view the record field you need for your report Durango122 if it moves and should not used Duck Tape if does not move and should used WD-40

Hi Try saving your report first then close it and close crystal report app then reopen it and see sometime crystal does not refresh the changes made on a report and will run older version try and see PS clear your temp folder on your local drive to remove old crw temp file before opening crystal...

Hi All cr 9.0 ms sql i have a cross tab i created a group base on trade_class and order by S and R and i need to get grand total at bottom of report footer i have a formula that breaks it down by trade_class here is my formula --------------------------- @RorS if...

got it gigure out used kens formila and modified it to work thanks Ken was worth the money to get your books Durango122 if it moves and should not used Duck Tape if does not move and should used WD-40

Nobody can help me :-( Durango122 if it moves and should not used Duck Tape if does not move and should used WD-40

Hi folks ms sql cr 9.0 I have these date and would like to pass them to my variable ------------------------------------------------------- New Year's Day Monday, January 1 this does not change ------------------------------------------------ Martin Luther King, Jr. Day Monday, January 15...

hi check the report option and check convert to null so null int is 0 string null is "" Durango122 if it moves and should not used Duck Tape if does not move and should used WD-40

got it fix Thanks anyway Durango122 if it moves and should not used Duck Tape if does not move and should used WD-40

Hi you can look at these thread for more help http://www.tek-tips.com/search.cfm?searchstring=suppress%20main%20report%20based%20on%20subreport&action=search&CFID=22774335&CFTOKEN=11398722 cheers Durango122 if it moves and should not used Duck Tape if does not move and should used WD-40

Hi All Cr 9.0 ms sql I have a formula that calculated the average here are my formula -------------------------------- @Daily_Red if {TRANSACTION_HISTORY.POSTING_DATE} <={?End_Date} and {TRANSACTION_HISTORY.TRADE_CLASS} = "R" then round({TRANSACTION_HISTORY.GROSS_AMOUNT}) else 0...

Hi All. cr 9.0 ms sql I used Ken formula for the Holiday here is what it looks like BeforeReadingRecords; DateVar Array Holidays := [ Date (2007,1,1), Date (2007,1,15), Date (2007,2,19), Date (2007,4,6), //changing Date (2007,5,28), //changing Date (2007,7,4), Date (2007,9,3), //changing Date...

Thanks to Ken formula Durango122 if it moves and should not used Duck Tape if does not move and should used WD-40

hi All Well i got it to works thanks Durango122 if it moves and should not used Duck Tape if does not move and should used WD-40

Hi All I check Ken formula and modified it not sure if this is right way. Mayby someone can check and see if i'm on the right track ----------------------------------------------------------- The number of "Work Days" between two dates: Calculating the number of calendar days between two dates...