Search results for query: *

Any comments? Anyone? [ponder]

Hello, I've created a report using CR 2016. I am using 2 stored procedures with the following fields: SP1: Date1 Activity Comments SP2: Date2 Inspection Comments In the main report, I am using SP1 and displaying the fields from above. In the subreport (located in Report Footer of the...

PAYMENTKEY CUSTOMERKEY DATE PAYMETHOD RESPONSE 01[tab] 1[tab] 11/01[tab] C[tab] A 02 [tab]1[tab] 01/03[tab] C[tab] A 03[tab] 1[tab] 01/05[tab] C[tab] D 04[tab] 1[tab] 03/06[tab] C[tab] A 05[tab] 1[tab] 03/07[tab] C[tab] A 21[tab] 2[tab] 01/03[tab] C [tab]A 25[tab] 2[tab] 03/02[tab] C[tab]...

Hello, I have following dataset and need assistance with query to meet the following requirements: PAYMENTKEY CUSTOMERKEY DATE PAYMETHOD RESPONSE 1 1 11/1 C A 2 1 1/3 C A 3 1 1/5 C D 4 1 3/6 C A 5 1 3/7 C A 21 2 1/3 C A 25 2...

Hello, I'm using CR2008. I am using a crosstab and I would like to know if there's a way to duplicate the same column to show count in one column and percentage in other. For example: Apple1 Peach1 Apple%1 10 20 50% Thanks.

I know this is possible with the use of sql command but I would like to avoid that option. Thanks.

I'm using CR2008 and Oracle database. I have a report using 3 linked tables in the dtabase expert (tableA, tableB, tableC). I have a formula as follows: if {tableA.value} > 5 then "Over 5" else "Under 5". I also would like to add a count summary in the group (e.g. Count of tableA.value). I...

I would like monitoring options to check the availability of BOE, mainly to be alerted when it's down. We are going to be upgrading to BI 4.0 next year as a note. Any ideas?

any thoughts?

I have a parameter setup in the sql command of the report as follows: select * from table where name in (?ParameterName) This parameter has more than one values. So I have values already setup in the parameter (e.g. John Smith, Bob Hope, Steve Johnson, etc.). I can add more names as I wish...

So what formulas would I need to determine the current group? Thanks.

is there any way to determine the current group level if there are multiple groups?

Hello, I'm using CR2008 and Oracle DB. I have a report with 3 groups. I would like to create a formula to suppress the groups based on a paramter. This is simple to do by going to section expert for each group and putting a formula under suppress with something like {?Suppress}="Suppress_A"...

Hello, I'm using CR2008 and Oracle database. I have a monthly recurring report in InfoView (Business Objects)with parameters setup to be used to filter saved data of the report. The problem is that when trying to filter the previous instance (month) of the report, it's blank. But if the report...

I'm using CR 2008 and Oracle database. From Oracle, it looks like if I'm concatenating a field with a string, it adds "" to the value in the report (e.g. ',,' || Field1 ). Just a field itself would not show double quotes but if I add two commas, it's showing up with double quotes. I would...

Hello, I'm using CR2008 and Oracle DB. I have a report using stored procedure as a datasource and has a date parameter. When I select a date from Crystal Reports and run the report, I get an error message as follows: ORA-01722: invalid number However, if I do not select a date and use NULL...

Hello, I'm using CR2008 going against stored procedure in Oracle. I have a report using saved data as well as formula in saved data selection area. The report is complicated and thus takes about 15 mins to refresh. Therefore, I am using a parameter to filter from saved data. This seem to work...

By the way, when hovering over the parameters in the report, it displays data-fetching parameter which is not what I want.

Hello, I'm using CR2008 going against stored procedure in Oracle. I have a report using saved data as well as formula in saved data selection area. The report is complicated and thus takes about 15 mins to refresh. Therefore, I am using a parameter to filter from saved data. This seem to work...

Hello, I'm using CR2008. I created a dynamic parameter and using it in record select expert. I would like to know how I can use this parameter where if noting is selected for this parameter then show everything (=TRUE) in record select expert. Right now, dynamic parameter is requiring a...