Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. eamonskelly

    Selecting from a table dependent on a VB variable

    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...
  2. eamonskelly

    Grouping with Visual Basic and Crystal Reports 8

    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...
  3. eamonskelly

    Grouping with Visual Basic and Crystal Reports 8

    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
  4. eamonskelly

    How can I concatenate ADO recordsets

    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...
  5. eamonskelly

    How can I concatenate ADO recordsets

    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
  6. eamonskelly

    Createing Triggers for deleting records with Microsoft SQL Server 2000

    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...
  7. eamonskelly

    Keeping Groups on one row

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

    Keeping Groups on one row

    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
  9. eamonskelly

    Keeping Groups on one row

    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...
  10. eamonskelly

    Grouping in Crystal reports via VB

    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...
  11. eamonskelly

    Grouping in Crystal reports via VB

    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

Part and Inventory Search

Back
Top