Programmability of parameter bar(layout/items)?

Hot Topic

Creation name for ComponentMetadata
Can we use cubes of MSAS2000 in MSAS2005
SP permissions under SQL Server 2005
Scripting: How to customize? And Why not Level 7.0
Dynamic Database Source Changing
Hide/Show parameter based on Multi-Valued Parameter Selection
Save TextBox to Database as new row?
Problem With LookUp
More installation woes
Query Editor standalone? Like Query analyzer

SQL Server

Parent Child Relationship
connect to MSSQL2005 via ODBC
security context could not be retrieved
How do I add Virtual table to Report Model (dsv)?
Transmission Queue problem
Replication from a 2005 database to a 2000 database
upgrading MSDE with SP4
SELECT permission denied on object
.Net CF 2.0 Error , "Can't find PInvoke DLL 'dbnetlib.dll'."
SQL 2005 Standard error on Windows XP Pro SP2

Programmability of parameter bar(layout/items)?

Hi all,

does anybody of you know how to code and customize the parameter bar of the
SSRS reports I know about putting code behind expressions but how is it with
parameters

How is it possible to...
1. define the layout of the parameter bar and the positions of the parameter
items
2. make the parameter items user-specific

Is it possible to define a report with the report designer and hand over
data (parameters) by code-behind or a referenced assembly

Thanks a lot for any help

Best Regards
Marc

Answer this question

Programmability of parameter bar(layout/items)?

  • ngvtech

    You need to query the web service to find out which parameters a report has, their data types and values etc. then programatically populate dropdowns etc. and arrange them how you like in your custom UI. You can use either a web or a windows UI for this.

  • j_o_h_a_n_n_e_s

    Thanks ... Can i find some article / sample code somewhere on how to build custom UI and use it as the Parameter Area in Reporting Services

  • Phil C

    Unfortunately, you can't do either of these things. (#1, #2, or the "hand-over" of parameter selection via Report Designer).

    If the parameter selection needs to be as dynamic as you describe, the best solution is to actually build your own custom UI in which you display the appropriate parameter UI in the appropriate places to the appropriate users...Then take the values that get selected and pass them to the report via URL Access, or plug them into the ReportViewer with code, andrender the report in the viewer. www.gotreportviewer.com has samples of the latter.

    Hope this helps!

  • Yhert

    Hi Marc,

    I have a similar problem. Could you please explain how you were able to solve this problem.

    Thanks a lot for your help.

    Regards,

    Simranjeev

  • Joni

    Hey Russell,

    that's not really good news...but thanks a lot for your help anyway..i'm going to try the solution with passing parameters by code into the ReportViewer control.

    Cheers
    Marc
  • Programmability of parameter bar(layout/items)?
Answer this question