Reporting Services and ASP Page

[mary555]

i need to create reports based on text fields in an asp page. the user can select a certain 'type' from a drop down box in an asp form (and other parameters as well), and then the report needs to be based on a query with that paramenter:
ie: select * from table where column=type(type comes form asp page form)

any help would be appreciated because i don't knwo where to start

 

[mary555]

I'm familiar with Access and how reports are made with queries and forms there, so im not sure if it works the same (like if u can access the web page directly from the report) or if it is more complicated...

 

[Sheco]

Are you talking about using the SQL Server Reporting Services or about using data from SQL Server in your ASP page to make a "report" ... the reason I ask is becasue SQL Server Reporting Services is a separate program that you install and make reports for using Visual Studio .NET

 

[mary555]

i am talking about sql server reporting services...i understand that u make the reports with visual studio.net, but theres gotta be a way to make it interact with an asp page...

 

[mary555]

can anyone help?

 

[MisterMo]

read through this document it should give you a good idea

http://www.microsoft.com/technet/prodtechnol/sql/2005/2005ssrs.mspx

-Mo