Reporting SQL/ASP.net

Bakedgoods

Bakedgoods

Bakedgoods

Capodecina
Permabanned
Joined
31 Dec 2003
Posts
5,172
Location
Barrow-In-Furness
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 :)
 
Last edited:
Which version of SQL Server are you using?

There is a tool called Reporting Services for SQL Server. This allows you to create queries and design reports based on those queries.
Although, if you have SQL Server Express it will only allow you to create reports on the local machine where SQL Server is installed.

If not then Visual Studio has Crystal Reports built in. But it is a nightmare to use imo, compared to Reporting Services. :(

Failing that, you could create query to use on a gridview in a seperate page that is only read only that you could print out.
 
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?
 
Wardie said:
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?
Click to expand...

See if you can run reporting services configuration... that wont let you run if its not installed

Stelly
 
If you are running the express version I think it usually has /SQLEXPRESS after the server name in SQL Server Management in the login box.
You will probably also have the express version of SQL Server Management as well.
 
The standard version comes with Reporting Services.
It should be on the SQL Server disk if you have it, you would have to find out if it is installed on your server.
Do you also use the test server for your ASP.NET applications?

Reason I ask is that Reporting Services uses IIS, so it may be better installing it on the server you use for web applications.
Else you will need to set up IIS on your SQL Server machine as well.

This site should help you in setting up Reporting Services, and other bits to do with SQL.
http://msdn2.microsoft.com/en-us/library/ms169620.aspx
 
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.
 
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.
 
KevinCB said:
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.
Click to expand...

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.
 
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.
 
You must log in or register to reply here.
Back
Top Bottom