Search results for query: *

Thanks Vidru... It works like a dream!!! [2thumbsup]

Any one have any idea how to fix this problem? Cheers, JSF

Oh and {?Run Date} = Today

Crystal Enterprise: 8.5 OS: Windows XP I need to set the start of the Financial year to the day after the last Friday of November i.e. the start of the financial year this time is 27/Nov/2004 The below formula that sets the start of the year to the day after the last Friday of November worked...

Its finally fixed.... changing from Native drivers to the Oracle ODBC drivers fixed it on the e-portfolio server. However it works even with Native drivers on my machine. Oh well as long as its fixed..... :D

No Ive got just one datasource. Using an Oracle 9i database. The very same report when opened in Crystal Reports works perfectly using the same datasource. Its weird and I dont know what to do :-(

I have found VisualCUT to be really good.

So no one has any idea why Im facing this weird problem in e-Portfolio?

Hi, Im running Crystal Enterprise 8.5 and have suddenly started facing a problem with something thats worked fine for ages. When I run the report in Crystal Reports it works fine and displays this: Avd A/c M A/c Name FI 3789/2 216561 XYZ Trust FI 3789/9 321615 JBC & Co FI 3789/12...

Thanks for that guys.... got it working :-) Cheers, John

Hi, Is there a way on Linux where by I can set it up to automatically open a text file every night and add a line of text right at the top of the file? I have a file which contains data and I need to add a header to it each night. Cheers, John

Hi, The query below takes exceptionally long to run and I reckon its because of the last line in the where clause. Can someone advise on how to speed it up? What would you change the last line to? Cheers, John SELECT DISTINCT MGN.APTYID, MGN.APTYSUBACC, PTY.APTYNAM, MGN.AMKTCDE...

I would use at if I knew how to get it to run a query and dump the results to a file.

Ive got Oracle9i.... Is it possible to do it with this version? Where can I find instructions on how? Cheers, John

Hi, Does anyone know of any tool available for Windows with which I can schedule some SQL to be run every night and the results be exported to a plain text or csv file? Cheers, John

You could write your report with the XML tags in the report itself and then export it as plain text..... thats what Ive done when I needed data from Oracle extracted as XML and it works just fine.

Oh well Ive got Crystal Enterprise 8.5 Standard so I cant schedule using it and need to use an external scheduling software. But I cant find any that will work with reports that are based on qry files.

Ive got Crystal Enterprise 8.5. Is it possible to schedule a report to run and export to a text file at a certian time in Crystal Enterprise 8.5? Thanks, John

Do reports written in 8.5 run seamlessly without any changes in Crystal 10? Cheers, John

Hi, Can anyone recommend a good Scheduler that works with reports done in Crystal 8.5 which have their datasource as Crystal SQL Designer qry files, which in turn use an ODBC data source? I cant seem to get reports that use .qry files as datasources to work with any of the schedulers...