Search results for query: *

Auditing is enabled on all servers except for RAS & Event.

Hi, I have succesfully created an CE10 Audit DB on SQL Server 2000. I've been logging reports that have run ssuccesfully or failed. The problem I have is that not all users/groups reports that are run are logged. The logging of users logging in/out is working fine. Any ideas? Thanks, Dan

Hi, Am I right in saying that you want to display every month between the given dates regardless of whether there is data or not? Dan

Hi Lochbel, Yes, I am using a UNC path in my ODBC connection. Dan

Hi, I'm having problems connecting to a Microsoft Visual Foxpro database on Enterprise 10 using ODBC. I have created a DSN that connects to the database and have then created a business view based on the DSN which works fine in the Report Designer. When I save the report to Enterprise I get...

Use the totext function to format the date: totext(Currentdate,"yy")

Hi, If the {INLOC.Itemkey} field is always has the same amount of characters and is the same format ie EB-(3 digit number)-(letter) then you can use one the like command to format the field. Go to the format properties of the field, go to Border, tick background, select blue then in the...

Hi, You will need to use a command for this. Then you will need to use a union query. For example: SELECT ID, Entity, Description, Issue/Eff. Date, Currency, Notional/Face, Settlement Amt FROM BONDS WHERE [date_field]>={ts '2004-01-03 00:00:00'} AND [date_field]<{ts '2004-04-03 00:00:00'}...