Search results for query: *

HI, We are using CR XIR2 / MS access database. In one of the requirement user needs the cross tab same as the following example: Row - Sales person name Column - Month- Year Summarize - sum (product sales) And they need one more column which need to give the difference between current year...

We are using CR XIR2 FP2.4 with AIX. Most of the reports are using DB2 database for reports. All the dynamic prompts created using the DB2 database are working ok. Issue: At the time of creating a dynamic prompt using ODBC it is working fine locally. But we change the prompt value to the LOV...

Hi All, Why we need to give the schema name at the time of writing a select in a subreport. Do we have any doc. available for that question. Please let me know if you need more infomration. Thanks, M

Hi All, If any one knows the def. for Cached Dynamic Cascading Prompts please let me know. Thanks, -M

HI, If you find any new functionality updated in Crystal Report XI R2 please share that information? Thanks, -M

Hi, We are using CR XI and DB2 database in Windows. Using JDBC we tried to pull a stored procedre into the report which contains 2 parameters. We got the following error: "Failed to retrive data from the database. Details:SQL Exception:[SQL State:]07005 [Error Message:] [IBM][CLI Driver]...

Is it possible to open a BOXI R2 reports in BOXI R1 Thanks, -RR

Is there is any possibility to add prompts in the BO Repository and use them in different reports? Please let me know if you need more information. Thanks, -R

Hi, I am using Crystal Reprot XI & DB2 database. The output of the report needs to be in row/column format. (Cross Tab). But if we use the running total calculation (ie runningtotal1 (minus) runningtotal2) there is no option to put this one in the cross tab. Is there is any way to solve this...

Hi, We are using Crystal Report 11 in client with J2EE(not publishing in BOXI) Data base - DB2 Question is: How to pass the link value as parameter to another report? Main report is "Manager info". and in the bottom we need to provide link for the list of "supervisor id's". By clicking the...

Hi, I am using Crystal XI and DB2 database. Q: How to do the drill down in XI? Example: There are two levels 1. Manager and 2. Emplyee Parameter for the report is ManagerID. Once select the manager ID, I have to provide the Manager detail and in the bottom of the report i need to provide the...

Hi All, I am using Crystal 9.0 and working on one report which needs the count by condtion. Example: Detail Col1 Col2 xxx 10 yyy 30 zzz 50 aaa 20 bbb 90 ddd 37 fff 40 Report Footer Count1 10-30 = 3 Count2 31-50 = 2 Count3 50+ = 2 Please help me writing a formula for the...

Hi everyone, We are in BOEXI and using DB2 database. Please help me on the following: Project needs Cascading inside the report. For example: CEO - Manager - Asst. Manager – Supervisor - etc. In the output, need to provide a monthly report as well as the Links (employees assigned to...

Hi All, We are using CR 9 and Text files. How to use the Text file as a back end and use/show the reports in CR9? Thanks MK

Hi, we are using CR 9.0 - CE 9.0 - SQL DB. I tried to insert a jpg picture inside the report (Its a logo). But after published in CE, the pic won't dispaly in the output. Pl. let me know what i am suppose to do Thanks MK

Any one please explain about ad-hoc Vs Canned Vs on-demand reports Thanks, MK

HI, we are using CR 9.0. Question is: How to add a new font in the font dropdown in CRYSTAL? For exp. If I want use the courier font in the report which is not available in the font dropdown, what i am suppose to do? Pl let me know if you need more information. Thanks MK

HI, We are using CR 9.0 and SQL server DB. I put the required field in the Detail section. At the time of running I saw couple of records are douplicated. Then I suppress the detail section by using the following formula (in the Selection Expert... suppress -formula) @EmpName =...

Hi, We updated from the version CR 8.5 to Ver 9.0. I got the following error when I ran the report (which was worked prefect in CR 8.5): 1. Filed to open a rowset. 2. Unkown Query Engine Error. I checked the Verify database too. I says database upto date. Note: Report contains 2...

Hi, We are using CR 8.5, SQL Server. I tried to list all the employee photos in a report. (BLOB datatype). It gives the following error. The instrucation at "0x00820dbb" referenced memory at "0x001b97f7". The memorey could not be "read". Please let me know if you need more information...