|
Title: Pass Parameter to Stored Procedure in Reporting Services Post by: jtrapat1 on October 11, 2007, 05:03:26 AM Im using sql server 2005 and visual studio 2005.
I just want to create some reports and deploy them to the local reportserver for an intranet application by using reporting services. I'd like to use the report designer to create my reports but it seems kind of confusing with the many ways you can get into the report designer and be offered different options thru the wizards. Heres what I can do: I can create a generic report by using this route: (from inside the visual studio 2005 ide): File > New Project > Report Project Wizard and then I can set the datasource to my database table. Next, I get to the Query Builder and I dont know how to hook up my sp as the query: For my test query, I chose a table, selected all the fields in it and dragged them onto the report form. But, the designer seems very limited: most of the items in the toolbox are grayed out: labels, etc. Heres my sp: -------------------------- Select ClientId, ContactName, ContactFirstName, ContactLastName,CompanyName, Address1,Address2, City, State, Zip, EMail,phone,Fax, Status,Description From Client Where ClientId = @ClientId --------------------------------- This stored procedure takes one parameter and I would like to browse for this sp so that I can set up and pass my parameter but Im lost. I went thru a bunch of tutorials all week and im at a dead end. It seems like it should be easier than Im making it. What is the best way to accomplish what I want for my situation? Thanks in Advance. Title: Re: Pass Parameter to Stored Procedure in Reporting Services Post by: Kevin3NF on October 11, 2007, 06:42:30 AM Hello jtrapat1,
Sadly, I find that there are a very limited number of folks that are proficient in SSRS, and I am not one of them. I will see if I can get a system setup to test this out, but it could take some time. Please continue to read tutorials and Bokos Online help. Kevin3NF Title: Re: Pass Parameter to Stored Procedure in Reporting Services Post by: VGR on October 29, 2007, 01:00:33 PM creating a stored procedure, which is an SQL concept, is done using CREATE FUNCTION or CREATE PROCEDURE which are SQL reserved keywords.
your problem's causes are, in bold hereafter : Quote I just want to create some reports and deploy them to the local reportserver for an intranet application by using reporting services. I'd like to use the report designer to create my reports but it seems kind of confusing with the many ways you can get into the report designer and be offered different options thru the wizards. Heres what I can do: I can create a generic report by using this route: (from inside the visual studio 2005 ide): File > New Project > Report Project Wizard and then I can set the datasource to my database table. Next, I get to the Query Builder and I dont know how to hook up my sp as the query: For my test query, I chose a table, selected all the fields in it and dragged them onto the report form. But, the designer seems very limited: most of the items in the toolbox are grayed out: labels, etc. Heres my sp: What is the best way to accomplish what I want for my situation? Thanks in Advance. Im using sql server 2005 and visual studio 2005. The good answer is to use standard SQL statements, tools and databases and not the items in bold over there. The easiest way is probably to use a real SQL99-compliant database system.
Powered by SMF 1.1 RC2 |
SMF © 2001-2005, Lewis Media
Joomla Bridge by JoomlaHacks.com |