Reporting SQL/ASP.net

[Bakedgoods]

I'm struggling to find much information on creating reports for SQL data in ASP.net.

Or should I be doing these calculations in the query? If so can you please point me in the right direction for learning how to do this? All i'm going to be doing really is calculating monthly totals, possible weekly totals and totals like 'So far this month'. It'll just be displayed as text in a label or whatever. Is there any controls I can use to help with this?

Any help is appreciated guys

 

[Bakedgoods]

SQL Server 2005

 

[Bakedgoods]

I'm not actually sure, it's running on a test server at work i'll have to find out.

Any way I can find out without having to chase someone down or whatever? Like something inside SQL Server Management or whatever?

 

[Bakedgoods]

Running standard edition of Microsoft SQL Server.

 

[Bakedgoods]

Doing all that at work is not quite as simple as it sounds ha-ha, i'll have to give it a test at home and see what it's like then go through the process at work.

Is an application like this really needed though? From what I can tell I can embed reports from it into web pages with relative ease yeah?

I'm just using the lightweight web server that comes with VWD at the moment, but the database is elsewhere.

Cheers for this Kev.

 

[Bakedgoods]

I used the express version and found it relatively simple to use.
If you've ever used Access and created reports in that, it's very similar imo.

You create your query then create a new report, link to the query and design it how you like.
When it comes to putting it on an aspx page, you drag a control over from the toolbox, and link it to the report server and the report.

That sounds as if i'm still going to be stuck with the initial problem though, I don't know the SQL to be able to make calculations. I need to calculate monthly totals, totals so far this month, weekly totals possible.

 

[Bakedgoods]

I'll just have to have a play with it and see I suppose.

Still have a dodgy update query that wont work, along with not knowing how to get data based on who is logged in.

I really can't find many good resources for learning ASP to be honest and it's becoming frustrating.