cr_Report.Database.SetDataSource rs_Report, , Using that line returns the entire contents of the query table instead of the items in the query., , If I assign the recordset to an array the array contains ONLY the items I requested but when I assign the same recordset to the crystal report it contains ALL the items in the table., , Any help would be greatly appreciated., , Thanks,, , Mike

Posted to MB Topic: VB Classic Database Tasks « VB Classic Board

In order to get the right result from the table., I would write a stored procedure. CR would show the data base on this stored procedure. , , If it works, use VB to call this CR. Good luck

Posted to MB Topic: VB Classic Database Tasks « VB Classic Board

I am having trouble calling a SQL Server 7.0 Stored Procedure from C++ that returns a recordset and an output parameter., , Here's the criteria - I wish to bind parameters at run time and I need to return an output parameter. Presumably, I need to use rs.Open not execute in order to get the recordset - the problem is that I don't get the output parameters if I am opening the recordset., The stored procedure may change so I don't really want to implement a static wrapper for it., I have tried to implement this with ADO, MFC DAO and MFC ODBC support classes., , A sample piece of code that does exactly what I need would be ideal...

Posted to MB Topic: MS SQL « DBA Board

It will work, It will work. I try it before.

Posted to MB Topic: MS SQL « DBA Board

Hello Friends,, , Can any body help me, how to include a sum of a field in the page footer section in vb data reports., , Regards

Posted to MB Topic: VB Classic Database Tasks « VB Classic Board

I will go ahead creat a sum of field in the REPORT FOOTER. And creat a function that is sum of the sum of field from REPORT FOOTER. and put this function in PAGE FOOTER.

Posted to MB Topic: VB Classic Database Tasks « VB Classic Board