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

...portfolio @RorS Column: year month Summarize: sum of @Amount here is how it looks --------------------------------------------------------- Gr#1 *******************************2007 --------------------------jan-----feb----mar age base 0-3|Contribution|500-----500----300 age base...

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

...NumberVar Days; Local Numbervar Hol; DateVar Array Holidays; Weeks:= (Truncate (End - dayofWeek(End) + 1 - (Start - dayofWeek(Start) + 1)) /7 ) * 5; Days := DayOfWeek(End) - DayOfWeek(Start) + 1 + (if DayOfWeek(Start) = 1 then -1 else 0) + (if DayOfWeek(End) = 7 then -1 else 0)...

...Date (2007,12,25) ]; 0 they must change the date for each year. I found this table holiday that has these value table Holiday field: Holiday_id*******Holiday_Dt*******Description 1**********01/01/2007 12:00:00 AM**New Year's Day 2**********01/15/2007 12:00:00 AM**Martin Luther King...

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

...NumberVar Days; Local Numbervar Hol; DateVar Array Holidays; Weeks:= (Truncate (End - dayofWeek(End) + 1 - (Start - dayofWeek(Start) + 1)) /7 ) * 5; Days := DayOfWeek(End) - DayOfWeek(Start) + 1 + (if DayOfWeek(Start) = 1 then -1 else 0) + (if DayOfWeek(End) = 7 then -1 else 0)...

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