Recent content by AdHoc

How about using the Replace function in your record selection formula on both your data field and your parameter to replace all occurences of the apostrophe with another character? For example: Replace({YourTable.CompanyName},"'","_") = Replace({?YourParameter},"'","_")

I have version 9 now but if I remember correctly, previous versions will not let you change the first part of what is in the Show SQL Query box. If you change anything before the first WHERE clause CR will change it back. What you could do is use CR to select the gchg."effective", gchg."id"...

Why not just use "Add Command" and type your SQL statement in there and base your report on the SQL command instead of directly using the tables? But if you don't want to use an SQL command here is another way: Add Table_1 and Table_2 to a new report and link them on REFERENCE#. Then change the...

Sorry chelseatech I've been away awhile and didn't see your question until today. As I recall, I put the CR9 merge modules into "C:\Program Files\InstallShield\Express\Modules\i386" only because that is where most of the modules the Install Shield listed happened to be. If I were to...

OK. I finally found the problem by deleting each field, formula and running total in the report, one by one, until the report would finally run in crviewer. It turns out the culprit was a conditionally suppressed running total that was no longer used in the report. The formula that conditioned...

Good suggestion. I verified the database (an Oracle stored procedure) but still got the same result. To make sure it really was verifying I changed the name of the procedure, added a dummy field to the procedure, did a set location for the report, saved it - everything I could think of to make...

When trying to view a report using VB6 and the crviewer.dll it lets the report prompt for parameters and then gets stuck with an error message box titled "Crystal Report Viewer" and the error is "This field name is not known." This happens only with a couple of my reports and...

Put quotes around the filename when you save it, for example "myquery.sql". This prevents Notepad from adding another extention to the filename.

I don't know how to prove this is impossible in plain SQL but if I had this task I would do it in Crystal Reports. If you don't have Crystal Reports, do you have MS-Access or some other reporting tool? If not, you can write a script in PL/SQL to make the report you need. You need a reporting...

I don't think using a DSN-less connection will allow you to have linked tables. You can open a recordset in VBA but I think you need a DSN on the client computer to link to ODBC tables in MS-Access. Maybe creating the necessary DSN programatically is the way to go. Go to MSDN and look up the...

Great![thumbsup] I just built an Install Shield setup and installed my application on a computer that doesn't have Crystal Reports, and did a quick test to export to PDF from a report. It worked fine. As you say, the trick is to do what the instructions from Install Shield and Crystal Decisions...

So far I've been developing and running all my Oracle reports in the stand alone Crystal reports, but I've been reading this document about using a Field Definitions File (.ttx) and passing a recordset in VB to the CR viewer component on a VB form. Have a look at this...

Yes, thanks, I had already downloaded that file but to make sure I have the latest copy I downloaded it again today. The only instructions I can find for using these modules(cr9rdcmergemodules.zip) is article Q106852 at the Install Shield Knowledge Base. Did you follow these instructions? They...

We have a VB 6 desktop application using RDC and the crviewer from CR version 8.0, which I want to replace with components from CR version 9.0 so the users can export their reports as .pdf files. (We upgraded from 8.0 to 9.0 so I never had a chance to try 8.5). I modified and compiled the...

The standard where I work calls for stand-alone Crystal Reports against our Oracle Databases so my experience is limited to that. However if you are using Visual Basic or any other front end that can create a recordset there should be no problem doing it that way. I don't think it matters...