• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 286
  • Last Modified:

SUBREPORTS REQUIRES REFRESH TO SHOW DATA FIRST TIME - MS RS2005

Hi all,
I am having a very strange problem with RS2005. I have a report and a subreport.
Both of them have three multivalue parameters. I have a chart on my
main report, when I click on a column I go to a subreport passing
parameters to the subreport using Join functions (to pass multivalue
parameters) like this:

in my data filed for the chart, right-click on the field, action ->
jump to subreport -> parameters. There for each parameter I say
something like:


=Join(Parameters!MarketingVehicleID.Value, vbcrlf)


The newline character is for the multivalue drop down.


I click on the column and see my subreport with all the parameters
passed. They are seen in dropdowns but the data is not there. If I
click "View Report" my data shows up. In other words, parameters are
being passed but the subreport requires refresh. I can not explain this
behavior. Can anbody help me?


Thanks,
J.
0
jsteidl
Asked:
jsteidl
1 Solution
 
jsteidlAuthor Commented:
I just found a problem. By default RS places multivale paramater as:

Parameters!Field.Value(0)

Just remove the (0)! It will work then!

Stan
0
 
EE_AutoDeleterCommented:
jsteidl,
Because you have presented a solution to your own problem which may be helpful to future searches, this question is now PAQed and your points have been refunded.

EE_AutoDeleter
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now