Search results for query: *

Hi Can anyone tell me the syntax for passing a SF string to a report?? I need to send 4 parameters to a table in the web report in the following fashion: select a,b,c,d from table where (a,b,c,d) in (1,'xyz',1,1) I want to know how to pass such a combination of columns in the where clause...

I was trying to pass a combination of 4 fields as Selection Formula thro a hidden field to a webreport.I am getting this error. Error on File :"Operation not yet implemented on pageserver" [name] I have checked with the date being passed ,No mismatch in terms of data ie lower or...

Hi Ido Thanks for your response.My report is based on J2EE platform and also on Coldfusion.I infact use Javascript to design the parameter string to be submitted to the report. I am not sure whether the Report Designer Component Object Model works on these platforms. Is there any other way ...

Hi all I need to program a web report which has the following scenario. There are a set of rows in a page with a checkbox associated with each of the rows.The user has the option of checking one or more of the checkboxes.He can as well invoke "check all" in that page.Now, I need to...

Hi Rosemary ,many thanks. Your posting was helpful and you figured my problem perfectly.But unfortunately the utility is not working as I am using an older version of crpe32.dll in Crystal8. I am using Crystal version 8.0.1.0 and I think that utility works for versions beyond that. Thanks a...

Ken ,many thanks.I have gone through the document. Actually,I am getting this error becoz of the Dynamic change of the database(which the document says as one of the reasonds).That much is understood.The remedial action is taken by changing the VIEW definition to match the new database...

Ken,I new database I am NOW using is Oracle 9i ; The old database was oracle 8i

Hi All I have a problem related to Set Location and ODBC datasource.The following is the scenario. OLD: 1)I have a set of CR files configured to a particular database server through an ODBC datasource. 2)Each of the files under this ODBC source point to a view in that database. NOW: 1)The...

Hi! I would like to know how one can create a Group tree in the Preview pane on SCR Smart viewer.Earlier, whenever I placed a group in a report,I used to see the grouping Headers on the left side of the Report Preview pane automatically. In this particular case,even when there is a group...

Hi! I need to show a PDF format document(NOT export) in my report.I am using SCR V8.I was able to embed fields on a scanned Image in the report but when I am trying to Insert a Acrobat PDF document it as a OLE object I see only the Acrobat icon but not the document.I need to embed a few...

Hi I have this requirement,where in I need to embed a pdf file in the report as an Image.I need to place fields on this Image in the report.I tried to achieve this by Inserting the file as an OLE object.I am able to see only the Adobe Acrobat Icon but not the document.I even tried to edit it...

Hi I am struck with this problem for quite some time.I request help on this.I am runnning a SCR Web report and trying to export it to MS Excel format(Office 2000).The export from the Smart viewer works fine but there is a problem.I am not able to see the complete export of a particular...

Hi all I have a problem with a Subreport on a web CR.I pass the Userid and the password to the Main Report(view based)from a web page.While this report is getting loaded, it prompts for the Database userid and Password for the subreport(a different view).Once it is supplied the report gets...

Hello dgillz, Thanks for your speedy response. I was trying to implement the above 2 formulas suggested by you.I am getting an Message "Blob Field or Memo field cannot be used in a formula" Is it because The length of the "fieldname" is varchar2(2000) ??? In that case can't...

Hi I would like to know if there is a Export Restriction on column length while exporting to Excel format.I mean when I was trying to export a web report to a Microsoft Excel format,I am not able to export the full Column Length of a particular report. Eg: A column called "Comments&quot...

Hi All. I have been having this particular problem in my application. I call CR from Coldfusion side .I pass parameters at run time in the form of hidden varibles.These variables are being sent as a string.The report fires and when I browser back to the application,the cookie gets killed(by the...

Hi all I have been facing problems with subreports while executing a web report. I am passing oracle login information to the main report through hidden fields to the main report.The subreport is also prompting for logon information(login, password) and even after I supply the same, no data is...

Hi all! I would like to know if change of IP address of the remote m/c hosting web component server effects web reports ? This is because all the reports prior to the change of IP are working but not the later ones.(I checked the ODBC connnectivity vis-a-vis the new IP of the database server...