Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Hi, I did a bit more resaerch and found an answer in CR itself. When I selected the X-2 against Horizontal Alignment, the text editor box has Functions and Horizontal Alignment constants option available under Functions. This provides the various options that are available and my formula has...

Hi, I am using CR 9.2 and Oracle 9i. I would like to get some help on conditional horizontal alignment of text fields. I want to align the fileds Right justified except the first 3 fields which are to be centered and would like to know if there are constants available for this purpose...

K, Thank you for your help. It is a new calculated field based on the values of USAGE, BTM and EGSH for each period using the formula New field = USAGE * BTM / (1-EGSH) I would like to show this field to the right of the report as per my original post. Thanks and regards, TR

K, Thank you very much for the Running Total suggestion. That worked very well. Now, I have one more issue to resolve - how do I calculate the report column called "New Field" (the rightmost one) in my post? I am able to show the running total for the New Field using the relevant running...

Hi, I use CR 9 with Oracle 9i. The following is the output obtained from an SQL query with 3 UNION statements. The SQL output is as follows: PERIOD CODE USAGE 1 USAGE 12911 2 USAGE 14762 3 USAGE 13657 4 USAGE 10356 5 USAGE 6301 6 USAGE 1703 1 Mkt 8.14 2 Mkt 8.87 3 Mkt 8.95 4 Mkt 8.8 5 Mkt...