Search results for query: *

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...

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

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...

Hi, I need to setup cron so that it runs a task at 7:15 am for the first time and then every 5 minutes after that till 7 pm. I know how do set it up to do every 5 minutes between 7 am to 7 pm but am unable to figure out how to get it to run the task only at 7:15 am to start with. Is this...

Hi, Why is Crystal not passing the below record selection formula to SQL under "Show SQL Query"? I want all the OR's to be processed on the server... ( {TPTY_A_NEW.APTYNAM} <> {TPTY_A_OLD.APTYNAM} or {TPTY_A_NEW.APTYABB} <> {TPTY_A_OLD.APTYABB} or {TPTY_A_NEW.APTYDSC} <> {TPTY_A_OLD.APTYDSC}...

Hi, I have a table "TClIENT" on which I have auditing turned on in Oracle so I have a "TCLIENT_A" table too. TCLIENT has the fields Name, Address1, Address2, etc. There are about 10000 client records on this table. I want to write a report that will find where any changes have been done to a...

Hi everyone, I have a report that uses a Crystal Query Designer .qry file as the source of data. In the report I have a formula that calculates a specific date and I want to pass that date to the .qry so that it selects based on that date. How do I pass this date value that is auto-generated...

Hi everyone, Im trying to design a report where the financial month ends on the last Friday of every month and the financial year on the last Friday of November. So for example March 2004 ended on 26th March 2004 and the Financial Year ended on 28 November 2003. I need to calculate Month to...