Search results for query: *

It worked. Perfect Thanks LB.

So what would be the sequence?

Hello LB, I created following: //{@reset} whileprintingrecords; stringvar jobs; if not inrepeatedgroupheader then jobs := ""; //{@accum} whileprintingrecords; stringvar jobs := jobs + {table.jobID}+","; {@display} whileprintingrecords; stringvar jobs; if len(jobs)>1 then...

Thanks a lot LB. Let me repeat it, what I understand. First Create a group of Job ID. Then create three formulas. {@reset} -- to be placed in Job ID group header and suppressed {@accum} -- to be placed in the detail section and suppressed {@display} -- to be placed in the gorup footer Is...

Hello Gurus, I am facing a problem to keep "all values of one column as one string". Example: I have a column "JOB ID", which contains five rows. I want to keep all five rows as one string seperated by commas, like "10010,10011,10012,10013, 10014". If would appreciate that if anyone help me...

I have a quick question, please reply... I am using Crystal 2008. One of my report has 5 parameters. 1) Options (On Demand, Weekly, Monthly 3 static values) 2) Date From 3) Date To 4) Legal Value, 5) Exchange Rate When user want to run the report and select an "On demand" option in...

Any update, please

Im using CRXI, SQL 2008 database. I have a question related to parameters. Working on a report requires a single Parameter "Selection" Rather than creating two different parameters, I need only one parameter with a drop down of two options "City" and "Status". User will select only one, in...

Environment: Windows 2000; JSP UI; IE 6.0; SQL 2000 CRXI Java Reporting Components. No Enterprise server. I am facing a problem in printing reports from IE browser. I noticed that when we click the print button, it doesn't print but it exports to pdf instead. Most probably because my deault...

Thanks MJRBIM. I was able to figure out my JNDI (DSN NAme) under jdbc provider options on web sphere admin console and changed it to production and test databass on each servers respectively. Report worked fine on each environment. Thanks a lot Ian and MJR.

Thanks a lot Ian.

Thanks Ian... I was able to configure this part last night after debugging for hours & hours...Thanks for confirmation. Really appreciated. But I am still getting one error on JSP UI side related to CRXI. Report works fine on designer with different databases but throwing me error while...

I am using CRXI Designer to build reports. Web based JSP UI using CRXI for java components. SQL Server 2000. Windows 2000. My questions is, How can I use one CR XI report for two different databases under one database server with a same DSN. Here is the detail: Initially I set my DSN...

I am using: CRXI Designer. SQL Server 2000. Windows 2000. My questions is, How can I use one CR XI report for two different databases under one database server with a same DSN. Here is the detail: Initially I set my DSN "ReportsDSN " to Testdb and created a New connection by using ODBC...

The table name is correct, exactally the same. No i cannot use views. We have a web based application. I pass all my parameters from JSP UI in a url to CRXI reports (residing on our Lotus Notes application server) including the Dates parameters, then report call SP with all passing parameters...

Thanks Ian... There is a problem in CRXI...It's not like 8.5 where you just go and modifiy the name as needed. Here in Set DataSource Location Option there are two panes. The upper one is for current data source and lower one is for Replace with. Let Suppose my report id built on a DSN: ABC...

Hello I am using CRXI Designer. SQL Server 2000. Windows 2000 I have a question related to DataSource Location settings in CRXI. We have One database server with two different databases as Testdb and Proddb. One ODBC System DSN as ReportsDSN pointing to each database on respective application...

Hello I am using CRXI Designer. I have a question related to DataSource Location settings. Till last month we were in an environment where we had two different test and production database servers with same database nameshaving same structure but different data. 1) TEST_SERVER Database...

Thanks aks12 and chelseatech. It worked. Appreciated.

I have following environment and setup: BO XI R2, SQL 2k, JSP Report UI. We have 300 reports are all are based on Stored procedures. What I want to do is: User login to JSP report UI, enter values for all parameters and JSP UI create and passes a managed URL possessing all report related...