Recent content by khan007

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