Search results for query: *

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

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

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

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

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

We are planning to switch from CR 8.5 to BO XI R2. While working and testing for new BO XI R2 environment,I am facing problems with creating a managed URL for BO XI R2. I used to have following environment and setup: Crystal Enterprise server, 8.5, Database is SQL 2k and Win2k operating...

I'm trying to find a reliable way to determine which Crystal Report designer version was used to create any specific report earlier. We have hundreds of reports and have been created by different CR version including CR 7.0, 8.5, 9.0, 10. XI. Now we are using CR XI. When we try to open any...

Hi, I have an urgent question. I am on CR 8.5. I have 2 groups in my report. I need to print my report with first record of Group2 in BOLD else regular. Group1 is Doctor group and Group 1 header will display Doctor Name. Group2 is Patient group and Group 2 header will display Patient records...

Hi, I have a question. I am on CR 8.5. I have 2 groups in my report. Group1 : Teacher Group2: Students I need to print my report with first record of Group2 in BOLD else regular. I used following code on each field's, font properties for group2, tried many logic with groups but unable to...

I am using Crystal Reports 8.5. Win 2k. Users are viewing the report over the web using the Active X viewer. Once report displayed on Viewer we have an EXport Report Option. If we click on that it opens Report View Export Window. Here you can save report by following choices in order as...

I need to format some reports that have long lists of information and it would make them a lot easier to read if I could format the background color to alternate on every other line like in templates. What would a sample formula for this look like? I have found this formula on previous...

Hi! I am on CR 8.5, WIN 2k, SQL 2k. I have following scenario. Report is based on a view which has two tables linked by ID. (Need all records from table B) Table A ID Amount Class 111 2000 A 222 1500 A 333 4000 A Table B ID UniqueID Charge Class 111 w1 1000 A 111 w2 100 A 111 w3 900 A...

Does Crystal XI support Crystal data dictionary. Would it come with the crystal XI package or that product has been phase out by BO. Please inform me

Here is the problem. Running CR 8.5 / Win 2k/ JSP. I am trying to pass UserID having a hyphen like USer-Id. The Crystal report viewer does not like or allow the hyphen (-) in ClientID. It's giving me an error windows saying: The sysntax of @logiduser is incorrect. Please tell me what do do...

I am on crystal Enterprise server, 8.5, using Active X Control for crystal viewer. Database is SQL 2k and Win2k operating system I am facing problem in viewing a report on crystal report viewer. It wasn't like that from the last three years, it just started two weeks ago, i don't know what...

Hi i am SQL 2k. I have a table Employee with a field department . Department is a string field possessing data seperated by comma. like PT, AUD, OT, STR, PBSTRA, XLP, SP, SB, EI The size of each value is not fixed. My question is i need to create a view to split this feild into seperate...