I am new to SQL. I have created a tool in Visual Basic 6. With lot of hard work I have managed to connect the VB front end with the SQL backend. The data I update in the front end VB tool is automatically getting uodated in the backend. I also checked the data. Its updating real time.
End of every day/week, the users need a consolidated report to check productivity. I have a command button which when clicked asks for the date range. Beyond that how do I create a report.
I tried Crystal repots but with very less success rate. Now sure how to go about this.
This is very critical in helping me making the tool go live. Appreciate if I can get a correct answer at the earliest.