Recent content by tezzyr

hi, apologies if this is in the wrong forum. I have a timestamp which is stored as as a 32bit integer in a database. I need to convert this integer value back into an understandable format (datetime or string showing 12/12/2007 14:32:01 etc)At the moment is is a nine digit integer 769590025)the...

Hi, I have an application which uses crIX on an sql express database. The application deals with time and attendance data for employees of a company and basically stores the time they clock in of a morning, the time they clock in and out for breaks/dinner etc during the day and the time they...

Hi everyone, I'm creating an application which uses an sqlexpress database to store details on company employees. My database has 14 tables but only 3 of them will ever have any more records added to them (the other 11 tables will never be written to once they have been initially populated) I...

I'm still only seeing one event per line, either a login event or a logout event. formulae for the date/time events are:- INevent formula: IF ({Accessevent.Eventtype}=1) Then {Accessevent.Eventtime} Outevent formula: IF ({Accessevent.Eventtype}=2) Then {Accessevent.Eventtime} each record...

Thanks for all the help so far guys! I've grouped by employee but because the events are in two seperate database records, the log in event is displayed on one line and the log out event is displayed on the line below. I've used a formula that will only display the login time if the eventtype...

Thanks for the help Madawc. The report will need to show the time in and time out for each employee as well as the total time. so, my report will look like the following:- name time in time out total Fred bloggs 01/01/2007...

Hi guys, I'm writing an application using crIX and a ms access database. I'm new to CR so please bear with me and forgive any obvious mistakes :) The report I am writing will show how long a person has been in work, ie total number of hours, minutes seconds between them logging in at the start...

Hi, I need to create a backup of a database whenever a user clicks on a button. As I'm using sqlexpress, I'll need to run a stored procedure which contains code that tells the database to backup to a file (I've got examples of how to do this). My problem is that I've never really had to run a...

hi, I'm creating an application in c++ which uses an sqlexpress database to store data. I want to be able to add functionality to my application that allows a backup to be made of this database as well as allows the database to be restored from the previous backup. I understand sqlexpress does...

sorry, I meant {date}>(currentdate - 2 months) as i dont want any records displayed that are more than 2 months old.

hi, probably a really easy one for you guys, but im a newbie so please forgive my ignorance! I'm trying to setup a record selection filter so that when my report is run, the only values shown on the report are ones that contain a date which is 1 month less than the date the report is viewed, i.e...

thanks for the fast reply, I had an idea that I'd need to upgrade the server to cr XI but wasnt 100% sure. I cant upgrade the server unfortunately as it doesnt belong to our company and there are already lots of reports using the current version already and i dont want to break them :) the...

I have a report created in crXI which runs off an sql server db. the report contains a parameter to gather user input which is generated dynamically from the db. when running the report on my machine I see a nicely formatted window which populates a drop down list containing all the companies in...

Im using cr IX on an sql server db which I cannot modify in any way ie change datatypes, add fields etc as an existing application uses the database as it stands at the moment. I have 2 db fields, USER and COMPANY set up as follows USER:- field type userid int username text...

I have a value (11832) which relates to an accountnumber in an sql server db. is there any way i can find out from which table this value comes from? eg select * from * where *=11832? i need to add a field to a report but ive no clue where the field comes from and there are 400 tables in the db...