Search results for query: *

I have connected a report to VB via OLEDB to a SQL Server 2000 database. I have created a table which contains the necessary values, which is populated with the userId of the individual who has entered the fields. At the moment my report brings back all fields independant of this userID, how can...

The field comes from a recordset which is produced in VB via ADO, using a query sent back to an SQL Server 2000 database. The unboundfields are produced in the same way, by querying the database and returning the results as the recordset from which I use the individual fields as unboundfields...

I am using a number of unbound fields in VB and wish to group them from a field from an ADO recordset, from within VB. How can this be done? Thanks

Thanks for your help, both of you, I have tried both methods, but eventually just used the following (abbreviated) stored procedure, which went through all the selects and inserted them into a table. It went as follows. BEGIN Insert Into table item1 , item2, item3 select ---- insert into table...

I am looking for a way to concatenate 9 ADO recordsets into one , or to put the queries within them into one recordset. I have select queries, which I need to put into one for use in a report. Is their a simple way to do this. Thanks for any help

How can I create a trigger, so that when I delete a table causes the record to be saved to a new audit-table AND deletes all records associated with that record in another table, passes these records to its own audit-table. I have got a trigger which works for the main table, but the trigger on...

thanks for everyones help, using underlay following sections worked best though, it got me the look I wanted. Best Wishes Eamon

I have tried this method, but it only seems to group properly by the first group. Are there any other ways that you know of. Thanks for your help :-) Eamon

I have 4 groups, but I want to keep them on one row, instead of the way they step downwards, as this wastes space on the report. I have tried dragging the fields up into the same group, but this results in grouping by the first group only. If anyone could help I would be grateful. I am using CR...

I have partially solved my problem by passing the query back to SQL server, and creating a table for use, which makes it easier to perform grouping. I am accessing SQL Server 2000 via OLE DB, but when I run the report in VB, I get a SQL Server Not Available message. I have been able to access...

I am having problems creating a report in VB using an SQL query, which is created in VB from data in SQL server. Can anyone show me some code that might help? My problems are in particular with grouping. I am using Crystal Reports version 8 and VB6 Thanks