Search results for query: *

Sample Data Below Item Days ----+-----------------------------------+ A 2009-01-10, 2009-01-15, 2009-02-14 B C 2009-03-24, 2009-04-23 D 2009-05-20 As you can see, the Days column may not contain anything or may contain 3 Days or more. I would like to create an...

Data for a Group 1 ES_DATE ES_DATE_H CS_DATE CS_DATE_H +---------+---------+---------+---------+ 07/30/09 04/21/09 01/30/10 11/30/08 06/30/09 06/30/09 12/30/09 12/30/09 07/30/09 07/30/09 08/15/09 10/20/09 07/30/09 08/30/09 10/20/09 11/01/09 I would like to get the...

I have table as below and would like to create a column that displays the distinct count of all the date columns and reset on change of Customer and Product Customer Product Date1 Date2 --------+-------+----------+----------+ ABC 123 01/01/08 02/15/08 ABC 123...

I have a report grouped on Customers (1) and then Products (2) and used printTime formulas (ie. WhilePrintingRecords) to calculate some metrics. All metrics are placed in both GF1 and GF2. One of the requirement is to display GF1 on top of GF2. Underlaying GF2 to GF1 doesn't work. Any help is...

I have succeeded in concatenating a list of products for the same customer. Now I would like to change the color of those products where the sale date is greater than a specified date. Here's a mockup data. Customer Product Sale Date --------+---------+----------- 1 A...

I have a report that consists of group header and detail. I would like to print the group header on the next page if no detail is printed on the current page. Here's some sample data :- GH1 California D San Diego D Los Angeles D San Francisco GH1 Texas D San Antonio D...

Hi, I created a CRXIr2 crosstab report. In the customize style tab of the crosstab export, there is a Grandtotal option for the rows and columns. The metric I am using is an average, therefore, instead of summing up the metric in the "Grand Total" column, it should be "averaged". Any tip ...

Hi, I have created a link between Reports A and B using viewrpt.cwr I would like to retain the selected values when the parameter is passed from the URL, and from the prompt box. The values were retained when I use a dhtml viewer and not an actx viewer. For this report, we would require it to...

Hi, I have created a link between Reports A and B using viewrpt.cwr I would like to retain the selected values when the parameter is passed from the URL, and from the prompt box. The values were retained when I use a dhtml viewer and not an actx viewer. For this report, we would require it to...

Hi, I need to display a RunningMax Trendline in a chart for a four week interval. This report is grouped on weeks (report date). Here's how the data looks like :- Report Date Amount ------------+---------- 03/01/2008 2000 03/09/2008 50 03/16/2008 100 03/16/2008 200...

Hi, We have a Crystal Report A that opens Crystal Report B via opendocument with a few parameters passed. Once we are in Crystal Report B, we would like to refresh the report and change the parameters. Problem is the report doesn't display the prompt box anymore and looks like it just consumes...

I have 2 database columns, say Suppliers and Product, which I want to concatenate and use as a group. One supplier has the same name but one has a space at the end. When I try to concatenate this supplier with the same product, Crystal Reports seem to treat this record as the same as one...

Hi, I created a report using a BO universe as datasource and would like to build dynamic cascading prompts. When I created the parameter and set list of values to Dynamic, I noticed that the Value Field Drop down box didn't contain any of my database columns. So, does Crystal Reports...

Hi, I am getting a report linking error when I try to link a report to another Crytal Report using OpenDocument.jsp. I suspect that the error is due to the date prompts. I have tried to use all kinds of date function calls (ie, Date, DateValue, DateTimeValue, etc) but still experiencing this...

Hi, When creating groups in CR, a magnifying lens is automatically displayed when user hovers over the group indicating that it is available for drilldown. Is there a way to eliminate the lens so it appears that data is flat and not available for drilling ? Thanks XIR2 on Unix Solaris...

Hi, I have a table consisting of the below columns. I need to sum up all Qty Passed per Product. This is simple. I just need to create a group and Insert Group Summary on Qty Passed. Now comes the tricky part. I also need to sum up all Qty Failed for each TIS # that has the maximum timestamp...