Hi I m a final yr comp Engg student.
I m working on .NET,i m usin mssql with ASP.NET,VB.NET for creatin online banking site.I hv a problem:

Hw i can record the transaction made by client for report generation.
shal i use database for report generation?if yes then hw?
otherwise tel me proper way to generate report.

Plz giv me detailed answer.

thnx in advance

How rae your tables setup in the database backend? In a accounting / banking type of application, you should use a transcation table, which will be a bridge entity. I would put a time stamp in the transaction table that would show when the transaction was made. If you use a tranaction table, then querying this table to generate a report would be easy.

Chester

Hi I m a final yr comp Engg student.
I m working on .NET,i m usin mssql with ASP.NET,VB.NET for creatin online banking site.I hv a problem:

Hw i can record the transaction made by client for report generation.
shal i use database for report generation?if yes then hw?
otherwise tel me proper way to generate report.

Plz giv me detailed answer.

thnx in advance

Thnx,
But i planned same solution,I wnted 2 knw is there ny other soln.