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 :-(
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...
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...
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
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.