Search results for query: *

Thanks for your response. I created a manual corss tab. And it works ok. Thanks for your replay.

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

Thanks a lot for your information.

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

All Programms -->IBM DB2 --> Devlopment Tool --> Development Center. where we can check the SP. If I have access to view the SP through IBM DB2 then it looks like i have rights to work on reports using that SP. But I used the Tables. that works good. Only the SP making issues. Pl. let me...

I checked with ODBC and I got the following error: Database Connector Error: '42884:[IBM][CLI Driver][DB2] SQL0440N No authorized routine named "XXX.SP10" of type "" having compatible arguments was found. SQLSTATE=42884 [Database vendor Code:-440]' By the way, at the time of checking through...

Thanks for your information -k. I'll check and come back. -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

Thanks. That's what I did. I thought there may be some other way by using array. Thanks, RR

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

Thanks for your response -k. I will try to expain the problem in detail. Manager_Tbl ManID ManName ManAddress 1 Man1 xxx 2 Man2 yyy 3 Man3 zzz Superv_Tbl SupID ManID SupName SupAddress S10 1 Sup1 aaa S20 1 Sup2 bbb S30 2...

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

Yes. It's working using the Running Total. Thanks a lot.

FYI... The Footer is the needed result. If i am confusing please let me know.