Search results for query: *

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

hi in your home page create a table and drop each report in it's cell <Table> <tr> your first report <\tr> <tr> second report <\tr> <\table> Durango122 if it moves and should not used Duck Tape if does not move and should used WD-40

ops forgot all has to be from the {?End-date} paramter the user select Thanks 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 a report that has a {?End-date} that i used as my parameter. i need some help on how to calculated Sales Daily YTD Avg keeping in mind they want working days with are monday to friday and holidays. my date field is {Transaction_History.Posting_Date} to calculated...

hi All cr 9.0 ms sql i have this report that contains 2 subreports 1. i have these amount sub report 1YTD sub report 2 Rep_Count 1062875/5294 1019197/4397 556346/4080 1123620/3837 409887/2801 3211420/1916 523793/2512 410306/2956 264899/2051 395437/3988 70871/1790 68954/2511 i'm dividing YTD by...

hi Yes i did and found how to create a share var but i found that my branch id is a varchar so i cant sum only count Durango122 if it moves and should not used Duck Tape if does not move and should used WD-40