Groups | Blog | Home
all groups > sql server reporting services > june 2006 >

sql server reporting services : My own report parameters


Ravi Manda
6/22/2006 1:45:02 PM
Hi there,

Can I add my own report parameters on report parameter area of a sql server
report 2005.

I have a label, textbox followed by a button. Open a aspx search page
onclicking the button.

Thanks,
Wayne Snyder
6/23/2006 4:34:01 AM
I not sure I really understand your question..

However one of the things you can do , create and upload an aspx page to
Reporting Services, which you have programmed to collect any parameter
information you wish. It could also contain a button, that calls your report
URL, passing in the parameter values you have collected.
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC

I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.


[quoted text, click to view]
Ravi Manda
7/7/2006 7:52:02 AM
My requirement is something like this, I want to have a label, textbox and
button, on clicking the button I will open a page and the page returns a some
value which should be populted in the textbox. But we don't have control on
report parameter area of a report.

As per my understadning from your reply is I need to have a aspx page with
my own parameters and a reportviewer control pass these parameters with the
URL to the report. (I'm ok with this answer).

Please confirm me that we cann't add our own controls on the report
parameter area.

(We don't want to have a dropdownlist incase the items cross's more then
100. In this case we add a text box and a button on the report parameter
area. Onclicking the button I will open a search page in a popup window).
Search page contains all search fields and a grid. Selecting on a particular
row on the grid I need to pass the value to the textbox of the report).

Thanks

[quoted text, click to view]
AddThis Social Bookmark Button