?
Solved

SUBREPORTS REQUIRES REFRESH TO SHOW DATA FIRST TIME - MS RS2005

Posted on 2006-04-07
2
Medium Priority
?
283 Views
Last Modified: 2012-06-27
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
Comment
Question by:jsteidl
2 Comments
 

Author Comment

by:jsteidl
ID: 16404142
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
 

Accepted Solution

by:
EE_AutoDeleter earned 0 total points
ID: 16573235
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

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Problem Statement In an SAP BI BO Integration project when a BO universe is built on a BEx query, there can be an issue of unit & formatted value objects not getting generated in a BO universe for some key figures. This results in an issue whereb…
How to increase the row limit in Jasper Server.
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses
Course of the Month13 days, 12 hours left to enroll

755 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question