Search results for query: *

KingfisherINC Could you please give me more detail? At this moment, my CE9 is down so I can't run the lauchpad. I am trying to debug it. What is the CMC? Thanks. HP

Thank you for the reply. Here is the detail of what I've done. 1/ I go into CCM, highlight the Crystal Input File Repository Server, click 'X' icon, confirm the message about "Are you sure you want to delet the specified servers?". Then the server is delete. I do the same for the "Crystal...

Hello all I have windows 2000 Advanced Server and I am trying to configure Crystal Enterprise 9. I am trying to re-create the Crystal Input and Output File Repository Servers. The creation is ok but it keeps creating new Crystal File Repository Server inside the "Enable/Disable Server under...

Hello all Please help me out for this. Here is the report that I wish to do: c1 c2 2/01/04 2 2 2/08/04 4 5 2/15/04 10 7 2/22/04 15 10 However, this is what I have right now. c1 c2 2/01/04 2 2...

Phil You are the best person in the whole world. Thank you so much for your advice. Here is my code right now: <CFSET datestring = #DateFormat('#FORM.birthFr#', &quot;yyyy,mm,dd&quot;)#> <CFREPORT REPORT=&quot;C:\Inetpub\wwwroot\report\Cust1.rpt&quot;> {cust.CustID} LIKE...

All Please help!!!! I am using CR 8.5, SQL Server 2000, Windows 2000 Server. Here is the script that I created to call my report: <CFOUTPUT>#FORM.custID#</cfoutput> <CFOUTPUT>#DateFormat('#FORM.birthFr#', &quot;mm/dd/yy&quot;)#</cfoutput> <CFSET datestring = createODBCdate('#FORM.birthFr#')>...

All I found out what is wrong with my report. The reason is I have created a same name parameter for the report. That causes the problem. I believe for this kind of operation (Coldfusion/Crystal Report), we have to apply a different rule such as: do not create any parameter for the report...

Hello all I am testing the Web report with Window 2000 server, Crystal report 8.5, SQL Server 2000. This is my first report using NorthWind instance. It works fine. <H1>This is the first report</H1 <CFREPORT REPORT=&quot;C:\Inetpub\wwwroot\report\Report1.rpt&quot;> </CFREPORT> Here is my...

Hello all I am trying to build some Crystal reports (ver 9) for our coldfusion (MX, win 2000) application. However, this is how the servers look like: sqlserver 2000 = server1 coldfusion server MX = server2 crystal report 9 dev version = my local workstation. The transactions between the...

Hi Carl Thank you so much for your advise. As I am the only one who is testing the application, I believe the cache level is set to high. For that reason, I can't see the new values right away. (I hope that is the case). Anyway, I make some changes in the code and use cachedwithin(0,0,0,0)...

Hi all I have SQL Server 2000 and Coldfusion Sever 6.0.0.48097. What happen is I have entered some new values into the lookup tables. However, the new values don't get populated when I call the page. I have tried to refresh the browser (IE 5) but it doesn't help. Plus, when entering the new...

Hello synapsevampire Thank you so much for your help. My report works great now. We have Oracle 8.1.7, Crystal Report 9 running on NT Server. I followed your advice to setup CR Oracle ODBC driver (I have Oracle ODBC before) and the problem is resolved. Thanks again. HP

Hello all I have a LONG type field in Oracle Database that I would like to display in my report. The problem I have is it only show the first 2 chars of the field. I try the Length() function and it return number 2. Obviously, I have more than 2 characters in the LONG type field and I need...

Thank you Virk0009 and Synapsevampire for your help. I decided to go with the option of creating a view to consolidate data instead of creating so many link to tables. The report works fine now. I don't know should we consider this as a bug for Version 9 or not? Usually, it should be a...

All I have developed a report using version 8.5 without any problem. Once the report runs on version 9, I get the error message &quot;Failed to open a rowset&quot; and &quot;ORA-01417: a table may be outer joined to at most one other table&quot;. I believe that I can handle the situation by...

Many thanks to Pg and Tom. You are really champions for helping me out. The problem is resolved. Thank you very very much. Take care. HP

Hello all, Please help! I have a report that will display the following data: ID TaskName FatherID 1 a1 f1 1a s1a 1 2a s2a 1 2 a2 f1 2c c2 2 2d d2 2 11 a11 f11 22 a22 f11 33 a3...

dgillz Thank you so much for your advice. Its works great! HP

synapsevampire or Pudge Can you please clarify the steps when creating the formula for header, detail, and footer sections? This seems to be the solution for my problem right now but I have a hard time to figure how to create those formulas. Please advice. Thanks. HP