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!

Recent content by thiagarr

  1. thiagarr

    Change Datasource in Running Total "Field to Summarixe

    Hi, I use CR XI R2 with DB2 database. I am trying to use a command object to replace the database fields in a report. The command object works fine and I was able to replace the database names with the command object name in the formulas by doing a find and replace option in Formula...
  2. thiagarr

    Numberic parameter entry - to display Names

    LB, I went the subreport route and got the details as required in my report. Thank you very much for your help and suggestions. DGILLZ, Thank you for your suggestions too. Thanks and regards, TR
  3. thiagarr

    Numberic parameter entry - to display Names

    LB, Thank you for the reason behind the single character display. DGILLZ, The formula is located in Report Header B. Thank you both for your help. Thanks and regards, TR
  4. thiagarr

    Numberic parameter entry - to display Names

    DGILLZ, My apologies to you and LB, When I copied the formula, I did not copy the last line which reads: join( x , ","); In effect, my whole formula reads as follows: StringVar Array x; ReDim x[Count({?Sales Person})]; stringvar sales_rep; NumberVar i := 1; While i <= Count({?Sales...
  5. thiagarr

    Numberic parameter entry - to display Names

    LB / DGILLZ, Thank you for both your responses and the suggestions. I will try them on Monday and post back here. Yes, we have lots of sales rep entries and I will have to use the sub report option, looks like. BTW, any idea why the display resulting from my formula brings only the first...
  6. thiagarr

    Numberic parameter entry - to display Names

    Hi, The display of the names is to be in Report Header (RHB). The report is grouped by the Region followed by Rep Nmae. Thanks and regards, TR
  7. thiagarr

    Numberic parameter entry - to display Names

    Hi, I use CR11 ith SQL server 2000. I have a report where the parameter accepts sales rep Number and the report currently displays the numbers separated by a comma. New requirement is to display the sales rep name instead of the number in the report. I have modified the formula to display...
  8. thiagarr

    Choosing the database at runtime using a parameter selection

    K, Thank you for the pointers. I will look at these options. In the meanwhile, I was searching the forums and found something similar to this using 'Setlogin' and other commands. They do not seem to be CR syntax commands. Are these VB commands? Can these be used in the Command option as you...
  9. thiagarr

    Choosing the database at runtime using a parameter selection

    Hi, I use CR 9.2 and Oracle 9i. I am looking at an option to select the database to be used for the report using a parameter while running the reports. For example, I would like to have one of the parameters for selection between 'TEST' and 'PROD' and depending on the selection the datasource...
  10. thiagarr

    calculations based on 2 largest volume and price in a table

    LB, That is great and worked as required. I also understand that this is sort of a workaround for a running total or summary (which was what I was trying to achieve) where for some reason, CR does not allow running totals or summary in some instances. I am sure this idea will be used by me in...
  11. thiagarr

    calculations based on 2 largest volume and price in a table

    Hi, My apologies. I use CR 9.2 with Oracle 9i database. Thank you. Thanks and regards, TR
  12. thiagarr

    calculations based on 2 largest volume and price in a table

    Hi all, Greetings. I have a subreport in a report with volume and price. I would like to get the total of the top 2 volume * price based on the usage. Sample data and required result is as follows: Period volume Price Rank vol*Price 1 100 7 6 2 200 8 5 3 400 9 2 3600 4 300 8 3 5...
  13. thiagarr

    Choice of Parameters depending on the previous parameter entry

    LB, Thank you very much for your suggestion. This looks like a very good suggestion and I will work on this tomorrow. :) Thanks and regards, TR
  14. thiagarr

    Date parameter from DateTime field in database

    Hi, I use CR 9.2 and Oracle 9i. I am also having the same issue - my parameter in my SPROC is defined as datatype DATE in Oracle and in CR the parameter prompts for date and time to be entered. Any idea this can be overcome and prompt to enter only date and NOT time part of it? ANy help /...
  15. thiagarr

    Choice of Parameters depending on the previous parameter entry

    Hi, I use CR 9.2 and Oracle 9i. I use a SPORC for the report. The SP sends back data for 2 different kinds of reports produced from one CR report file. The formats and contents of the reports are very similar and hence we try and use the same SPORC and report. But there are unique...

Part and Inventory Search

Back
Top