×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Populate Dynamic table columns based on parameter drop down values selection in SSRS report

Populate Dynamic table columns based on parameter drop down values selection in SSRS report

Populate Dynamic table columns based on parameter drop down values selection in SSRS report

(OP)


*Scenario:

We have one table with below columns: I need to use ONLY this table
ID ACCOUNTID STATUS COMPARE MODFIEDUSERNAME FILENAME FILEDESP
1 A2 IN MATCH Sam abc wew
2 A4 OUT MATCH Ken xcr wew
3 A2 IN MISMATCH Roy abc wew
4 A3 OUT MISMATCH Roy xcr wew

In the report we should have a drop down(SingleValue) for COMPARE column with values(MATCH/MISMATCH) where user can select either of one value.

If User select MATCH Option then Report should display a dropdown(MultiValue)(ReportFields Data Set) with these columns : ID ACCOUNTID STATUS

If User select MISMATCH Option then Report should display a dropdown(MultiValue) (ReportFields Data Set) with these columns : ID COMPARE MODFIEDUSERNAME FILENAME FILEDESP

Basically , populate column names dynamically based on MATCH and MISMATCH selection and when user clicks on View Report, Report should display respective column data.

I created the Data Set -ReportFields as below:

SELECT 1 ID, 'Id' AS ColumnName UNION
SELECT 2 ID, ACCOUNTID AS ColumnName UNION
SELECT 3 ID, 'Status' AS ColumnName UNION
SELECT 4 ID, COMPARE AS ColumnName

I created two parameters: @Compare and @ReportFields. I added Column Visibility for each column for ReportFields Data Set)

Problem: Need the logic to populate Dynamic columns based on user selection from first dropdown with (MATCH/MISMATCH) Values.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close