Search results for query: *

I suppose I should be thankfull - 12 months ago I had great difficult creating SQL statements/queries and today I can at least perform basic queries etc. That said I spent hours last night trying to create a query that performs the following. I have three Tables. Employees with Fields EmpID...

...SumYearHours, Vehicles.Vehicle FROM manhours INNER JOIN Vehicles ON manhours.VehicleID = Vehicles.VehicleID WHERE (((manhours.RptDate) Like "*")) GROUP BY Vehicles.Vehicle, manhours.VehicleID" I also use the query below (in the same report). Query 2 "SELECT...

Many thanks again Parm. I have been trying different ways of obtaining the data and I ended up with the code being quite different from that above. Following your reply above - I returned all the code to original (ready to bundle for you) and ran. You would not believe it - it worked OK. All I...

Thanks parm Tried you suggestion but still no luck. I have been trying also to use the DataEnvironment connection before I go using the rsado connection. What I mean is that the Dataenvironment has a connection to the access database via a query, however this query is never used. I seem to be...

Appears no one can help me. I suspected this would be a tough one. I have spent some time looking at my problem and it appears that if I use the VB Datareport to do the reporting under cmd InjClass_Click. All is OK so it looks like Crystal does not like using the Data report + runtime...

The data environment is a VB6 ActiveX designer (see under Project/More ActiveX Designers) that allows you to connect to the database specifically for reporting etc. In VB6 you can also add a Data Report that uses the data presented by the Data Environment to create reports. Instead of using MS...

...are fine. However - if I first open the cmdManhours report - that works fine but when I select the cmdInjClass report I get the following error. ****************************** Crystal reports Database Error Unable to Access first Record ****************************** I select OK and then...

...are fine. However - if I first open the cmdManhours report - that works fine but when I select the cmdInjClass report I get the following error. ****************************** Crystal reports Database Error Unable to Access first Record ****************************** I select OK and then...

Worked a treat - it looked to me like there were too many brackets in my query - but that is what the SQL designer created after I used the wizard. Thanks.

I have 2 tables: Manhours with fields: ManID, VehicleID, ManHours and RPTDate Vehicles with fields: VehicleID and Vehicle I am trying to create a query that sums the ManHours for each vehicle based on a given date range. The following query works: SELECT Sum(manhours.Manhours) AS SumYearHours...

Many thanks Gary

I have an Access 2000 table with an ID, dates and other info. Eg: ID Date 1 1/1/99 2 2/1/99 3 3/1/99 1 10/6/00 2 11/6/00 2 12/6/00 I need to extract the latest date for each ID but I also need that ID as I use the dataset created in Crystal reports. My dataset should contain 1...

...is: Set cn = new ADODB.Connection Set rsADO as New ADODB.Recordset strConnect = "Provider etc" cn.Open strConnect SQL = "Select * from qryOperations" rsADO.open SQL,cn, adOpenDynamic, adLockBatchOptimistic DisplayReport.Database.setrecordsource rsADO etc If I remove...

I am using VB6 with Crystal reports 8.5. I have a single viewer on a form and within my VB code I have multiple instantiations of reports. Eg at the start of my code I have: Dim svcClass as new rptClass ' Crystal rpt with class info Dim svcEquip as new rptEquip ' Crystal rpt with equip info...

Have tried using the EMPID from the main table (ie that table with Names) without a subreport and it seems to work reliably except I now get blank lines if the criteria is not met. I am trying to get format as below: Name Elect LicNo Expires First Aid No Expires Joe XY123...

dgillz - When I created my initial report I did not use a subreport as you suggested and I do have a link via EmpID to each table. If I only pass the single parameter from VB I seem to get the correct presentation but the VB program can pass up to 5 values of the same parameter and that is when...

I am using CR8.5 to create a report. I am grouping by a list a names with an ID number and using this ID number as a parameter that is entered by users. The names and ID come from a table called 'Employee'. The report works fine to this point - not much to brag about I know. Under each group I...

Thanks Jim i will try it and see if I can get it to work. I am still a novice when it comes to parameters.

Sorry - I cannot see how this will help. I suppose I was a bit short with my description of what I am trying to do. I am using VB6 to present a report (.rpt) and as default I currently have selected 'Format Section' and then selected Group header (that which I am grouping on, and selected 'New...

I have created a Crystal report (8.5) and have used group by Name, with details following. I have also checked the box that forces a page break before each group, this allows each persons details to be displayed/printed on a separate page. I would like to be able to perform the initial report...