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...
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...
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 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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.