INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

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.

Jobs

SSRS 2008 and passing parameters to subreports...

SSRS 2008 and passing parameters to subreports...

(OP)
Okay, I've been modifying a previous guru's RDL files via both Report Builder (for look and feel) and Notepad (for parm data lists)... but only since February...

Essentially, the main report has a list of comma-delimited values used to look up data in the OLAP Cube. The data was in the reports like this (real code can't be shared, sorry):

CODE -->

{ Value01,
Value02,
Value03,
Value04,
Value05 } 

Everything has worked well up until recently, when a number of the required values were added that contained hyphens:

CODE -->

{ Value01,
Value02,
Value-0-3,
Value-0-4,
Value05 } 


The reports started "breaking" and research showed it was at the point where the hyphen was--so "Value-0-3" was interpreted as "Value", an incorrect lookup key. This was solved after some research and mentoring by adding square brackets as follows:


CODE -->

{ Value01,
Value02,
[Value-0-3],
[Value-0-4],
Value05 } 

However, many subreports were involved and those required the parm-passing to be edited from

CODE -->

Parameter1 = Field.Parm.value 


to

CODE -->

Parameter1 = "[" & Field.Parm.value & "]" 

I just haven't figured out how to change it for the reports where:
a. the parm is the whole list, not a single value, and
b. the parm is passed to a complicated sub-report that includes .Net or javascript code.

Any advice will be gratefully received and attempted...

JTB
Have Certs, Will Travel
"A knight without armour in a [cyber] land."

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!

Resources

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