Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Bertrum

    Blank report using ASP

    Hi I have a C# asp page which is used to view reports (using pdf export), with the connection/parameter information held in a session-based xml document. All the reports I have set up to use OLEDB work fine, but the latest one which uses a dataset (built on the page) is causing problems. I have...
  2. Bertrum

    Error 525

    They are copied from the server to client machines, so users access reports which are stored locally. Originally we used a central shared folder, but soon found that this was not going to work as the files became locked.
  3. Bertrum

    Error 525

    We do use the BDE within the app, but all our reports use ODBC connectivity. It's definitely a CR error. Thanks anyway
  4. Bertrum

    Error 525

    Hello I have a user who experiences this error (the helpfile provides an ambiguous description of 'There is something wrong with the report you are trying to open' !!) whenever he tries accessing a report through our client software (which uses the CR8.5 Delphi VCL for loading and viewing...
  5. Bertrum

    Soundex() function on thin-client machines

    Cheers. Although the article was for CR4.5, a couple of searches for the same subject came up with the goods.
  6. Bertrum

    Can CR8.5 call on and attach a file to a report?

    Erm, I've done this loads of times in 8.5 for creating mailouts. You need to insert the doc as an OLE object. Just browse for the file and that's it. Dead simple. Even better - when inserting the doc as an OLE object, there is a 'link' checkbox. When ticked, this causes the file to be...
  7. Bertrum

    Soundex() function on thin-client machines

    Hi all I have written a report in CR 8.5 which uses soundex() to search for peoples names. This is integrated into a Delphi application using the viewer component. Database connection is ODBC to either Oracle 8 or Interbase 5.6 (depends on client) The problem is that it does not run on client...
  8. Bertrum

    Displaying Page Number in On-Demand Subreports

    It's annoyong ain't it. I had to create a workaround for this, but it does add a slight performance hit: 1. Create a formula which always returns the same value. It must be based on field data 2. Create a group based on the formula you just created and get it to 'repeat group header on each...
  9. Bertrum

    Oracle Stored Procedures

    Finally got a report working with an Oracle 8.17 stored procedure by getting the updated CR Oracle8 driver. However, this driver only seems to work on machines with CR installed - I got a colleague to install the driver and he gets an error (setup routine could not be loaded - system error code...
  10. Bertrum

    Problems with report based on stored procedure

    <slaps self on head> Yup, forgot to grant privileges! It's working now, thanks for pointing out the simple thing I'd overlooked. PS: It's not using a union per se, just 3 selects - couldn't use a union in IB5.6 even if I wanted to :(
  11. Bertrum

    Problems with report based on stored procedure

    Hello All, I had a hideous report to write for one of our customers. As it required a union of two datasets I wrote a stored procedure to do the business (customer DB is Interbase 5.6, which doesn't allow unions to be performed within a view). Created the report using my procedure in Crystal...
  12. Bertrum

    Accessing mult. databases in a single report

    Oh come on peeps - why all the technicalities when you could just use a subreport to access the other datasource? That's the simplest way of looking at separate databases you will find. If you're using any parameters then you can just pass them across from the main report to the child. Easy as...
  13. Bertrum

    Using the same table under different aliases

    Hello, I'm having problems with CR 8.5 when using the same table twice in the same report. Example: On our property database (Interbase 5.6, accessed via INTERSOLV ODBC Driver), all our streets are held in the same reference table (STREET). For each property (LPI), there are two Street ID's...

Part and Inventory Search

Back
Top