Reporting

Web reporting

[hazee]

Hi guys!

How can I make reports on my website.

Any idea.

[carguy84]

ummmm....what kind of reports? traffic? stocks? sports? news?

[hazee]

I need to take the report of Ledger of all the customers. I want each customer Ledger to be printed on different page with same page headers and page footers. Only the the Name of the customer and his ledger information would be changed.

One cutomer's Ledger can go for more than one page, In that case it must print the data on the same number of pages and start the next customer page after this customer's ledger finishes.

Infact I am looking for complete reporting system as we can make in Crystal Reports with Classic Visual Studio or .net.

Hope its clear now. Any idea how to do?

[txbakers]

You can learn how to use Crystal, or use Actuate for prebuilt tools.

I do all my reports in old fashioned HTML and ASP and SQL.

[hazee]

I do all my reports in old fashioned HTML and ASP and SQL

This is what I want ... Can i have the script as an example to understand?

[txbakers]

no, but I'll share the idea.

run a SQL query to get the data.

write a header line

Do a while not EOF loop to display the data on the screen.

If you want subheaders set an inner loop on one of the fields.

[hazee]

I tried but couldnt. Can you help me to make headers and subheaders.

Will be thankful if you can share any dummy source code.

regards,
Thnx.

[aspdaddy]

For all the paging/printing etc sounds like you need a reporting tool. If you have a SQL licence then you can use SQL Reporting Services for free. It does the kind of reports you are after.

You do need .net installed on the machine that designs the reports.

[hazee]

run a SQL query to get the data.

write a header line

Do a while not EOF loop to display the data on the screen.

If you want subheaders set an inner loop on one of the fields.

What would u say about this?