Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Durango122
  • Order by date
  1. Durango122

    Multi Language Variable

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

    pulling data from 10 tables but joining 20 tables

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

    My Crystal acting up

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

    Help with Cross tab grand total

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

    Week of the month, day of the week problem

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

    Week of the month, day of the week problem

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

    Week of the month, day of the week problem

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

    Select Statement Not Recognizing a Zero

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

    Problem with sum plz help

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

    How to suppress main report based on subreport

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

    Problem with sum plz help

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

    Replace holiday formula from Ken

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

    Sales Daily YTD Avg

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

    Sales Daily YTD Avg

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

    Sales Daily YTD Avg

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

    Display Multiple Reports

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

    Sales Daily YTD Avg

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

    Sales Daily YTD Avg

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

    Division by zero but no 0 anywhere

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

    sub report problem need help plz

    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

Part and Inventory Search

Back
Top