Friday, March 30, 2012
Passing of parameter
How to pass the "record_id" from main report to the sql command of subreport. To clarify, i add a sql command in database expert in fmy subreport. This is my query....
For the main report..
Select record_id, distributor_name... from distributor
In the sql command of my subreport....
Select record_id, distributor_name, customer_id, sum(sales) as amount where record_id =2 group by record_id, distributor_name, customer_id
order by amount desc limit 20.
All i want to do is how to pass the record_id from the main report into the sql command of my subreport to look like this....
Select record_id, distributor_name, customer_id, sum(sales) as amount where record_id =("record_id from main_report") group by record_id, distributor_name, customer_id
order by amount desc limit 20.
My goal is how to view the top 20 accounts per distributor
Thanx a lot!!!1. Make main report
2. make sub report with same parameters.
3. In Design mode of main report, edit->subreport links.
Select main report parameter and link it to subreport parameter.
Wednesday, March 28, 2012
Passing Multi-Valued Parameter to Subreport
I have a multi-valued parameter that I want to pass to a subreport. The values are 11, 12, 13, and 14.
So here's what I've done:
1. For the properties of the clickable field of the first report, I have gone to the Navigation tab and chosen the subreport in the "jump to report" pulldown.
2. Then I clicked on the Parameters button and added a parameter name for the multi-valued parameter I am trying to send. For the Parameter value, I have tried 11,12,13,14. I have also tried =Split(11,12,13,14)
3. On the subreport, I create a report parameter with the same name, data type is string, multi-value is checked, and the available values pulldown is populated by a query.
So I run the first report and click on the link that brings me to the subreport, but all the subreport shows is the results for 11, not 12, 13, and 14.
How can I get the second report to understand that I want it to show all the records related to 11, 12, 13, and 14? If I bypass the first report and simply use the drop-down to choose 11, 12, 13, and 14 in the subreport, it works fine. I just can't seem to figure out how to correctly have the first report tell the subreport that it wants 11, 12, 13, and 14.
Thanks in advance for any advice!
Dan
Hello Dan,
You should check out this post in which Robert explained a solution.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=164056&SiteID=1
Jarret
|||Jarret,
Thank you so much! That post revealed my mistake. I was forgetting to specify the delimiter in the Split statement.
When I pass the following: =Split("11,12,13,14", ",") out of the first report
it works just fine.
Have a great day!
Dan
passing multi-value parameter to subreport
parent report has multi-value parameter: part_code
this gets passed to subreport which has part_code setup as multi-
valued paramter
what is the syntax in the parent...subreport properties/parameters box
and
what is the syntax in the child report parameters form?
thanks very muchon the subreport properties->parameters give
"=Join(Parameters! <ParameterName> .Value,", ") so that the multi value is
passed to the subreport as well.
Amarnath, MCTS
"roy@.mgk.com" wrote:
> ok - i've googled this and have tried everything to no avail...
> parent report has multi-value parameter: part_code
> this gets passed to subreport which has part_code setup as multi-
> valued paramter
> what is the syntax in the parent...subreport properties/parameters box
> and
> what is the syntax in the child report parameters form?
>
> thanks very much
>|||On Mar 21, 9:10 am, Amarnath <Amarn...@.discussions.microsoft.com>
wrote:
> on the subreport properties->parameters give
> "=Join(Parameters! <ParameterName> .Value,", ") so that the multi value is
> passed to the subreport as well.
> Amarnath, MCTS
>
> "r...@.mgk.com" wrote:
> > ok - i've googled this and have tried everything to no avail...
> > parent report has multi-value parameter: part_code
> > this gets passed to subreport which has part_code setup as multi-
> > valued paramter
> > what is the syntax in the parent...subreport properties/parameters box
> > and
> > what is the syntax in the child report parameters form?
> > thanks very much- Hide quoted text -
> - Show quoted text -
did that Amarnath ))...and i have in the parent the subreport
properties/parameters: "=Parameters!PART_CODE"
all i get is 'error - subreport could not be shown'......|||On Mar 22, 8:07 am, r...@.mgk.com wrote:
> On Mar 21, 9:10 am, Amarnath <Amarn...@.discussions.microsoft.com>
> wrote:
>
>
> > on the subreport properties->parameters give
> > "=Join(Parameters! <ParameterName> .Value,", ") so that the multi value is
> > passed to the subreport as well.
> > Amarnath, MCTS
> > "r...@.mgk.com" wrote:
> > > ok - i've googled this and have tried everything to no avail...
> > > parent report has multi-value parameter: part_code
> > > this gets passed to subreport which has part_code setup as multi-
> > > valued paramter
> > > what is the syntax in the parent...subreport properties/parameters box
> > > and
> > > what is the syntax in the child report parameters form?
> > > thanks very much- Hide quoted text -
> > - Show quoted text -
> did that Amarnath ))...and i have in the parent the subreport
> properties/parameters: "=Parameters!PART_CODE"
> all i get is 'error - subreport could not be shown'......- Hide quoted text -
> - Show quoted text -
i should've said i implemented that...as well as the "=Parameters!
PART_CODE" in my previous reply...
is there some change in the SQL?...i'm just using the "....part_code
in (@.PART_CODE)" with the paramter setup normailly in the subreport's
report parameter properties......|||To be very clear, The problem is due to parameters only. First go to the
report which you include as "Subreport" in the main report. open the report
properties, check for multi-value.
close that remaining same. (ie string, non queried or queried, default null.)
Go to the main report where you have placed subreport. on the subreport
right click for properties and the parameter, this is the main culprit for
not working.
Parameter Name: select from the drop down.
Parameter Value: "=Parameters!cn.Value" here just include value instead of
Value(0)
This should work. Let me know if it works.
Amarnath, MCTS.
"roy@.mgk.com" wrote:
> On Mar 22, 8:07 am, r...@.mgk.com wrote:
> > On Mar 21, 9:10 am, Amarnath <Amarn...@.discussions.microsoft.com>
> > wrote:
> >
> >
> >
> >
> >
> > > on the subreport properties->parameters give
> > > "=Join(Parameters! <ParameterName> .Value,", ") so that the multi value is
> > > passed to the subreport as well.
> >
> > > Amarnath, MCTS
> >
> > > "r...@.mgk.com" wrote:
> > > > ok - i've googled this and have tried everything to no avail...
> >
> > > > parent report has multi-value parameter: part_code
> >
> > > > this gets passed to subreport which has part_code setup as multi-
> > > > valued paramter
> >
> > > > what is the syntax in the parent...subreport properties/parameters box
> >
> > > > and
> >
> > > > what is the syntax in the child report parameters form?
> >
> > > > thanks very much- Hide quoted text -
> >
> > > - Show quoted text -
> >
> > did that Amarnath ))...and i have in the parent the subreport
> > properties/parameters: "=Parameters!PART_CODE"
> >
> > all i get is 'error - subreport could not be shown'......- Hide quoted text -
> >
> > - Show quoted text -
> i should've said i implemented that...as well as the "=Parameters!
> PART_CODE" in my previous reply...
> is there some change in the SQL?...i'm just using the "....part_code
> in (@.PART_CODE)" with the paramter setup normailly in the subreport's
> report parameter properties......
>|||On Mar 23, 1:21 am, Amarnath <Amarn...@.discussions.microsoft.com>
wrote:
> To be very clear, The problem is due to parameters only. First go to the
> report which you include as "Subreport" in the main report. open the report
> properties, check for multi-value.
> close that remaining same. (ie string, non queried or queried, default null.)
> Go to the main report where you have placed subreport. on the subreport
> right click for properties and the parameter, this is the main culprit for
> not working.
> Parameter Name: select from the drop down.
> Parameter Value: "=Parameters!cn.Value" here just include value instead of
> Value(0)
> This should work. Let me know if it works.
> Amarnath, MCTS.
>
> "r...@.mgk.com" wrote:
> > On Mar 22, 8:07 am, r...@.mgk.com wrote:
> > > On Mar 21, 9:10 am, Amarnath <Amarn...@.discussions.microsoft.com>
> > > wrote:
> > > > on the subreport properties->parameters give
> > > > "=Join(Parameters! <ParameterName> .Value,", ") so that the multi value is
> > > > passed to the subreport as well.
> > > > Amarnath, MCTS
> > > > "r...@.mgk.com" wrote:
> > > > > ok - i've googled this and have tried everything to no avail...
> > > > > parent report has multi-value parameter: part_code
> > > > > this gets passed to subreport which has part_code setup as multi-
> > > > > valued paramter
> > > > > what is the syntax in the parent...subreport properties/parameters box
> > > > > and
> > > > > what is the syntax in the child report parameters form?
> > > > > thanks very much- Hide quoted text -
> > > > - Show quoted text -
> > > did that Amarnath ))...and i have in the parent the subreport
> > > properties/parameters: "=Parameters!PART_CODE"
> > > all i get is 'error - subreport could not be shown'......- Hide quoted text -
> > > - Show quoted text -
> > i should've said i implemented that...as well as the "=Parameters!
> > PART_CODE" in my previous reply...
> > is there some change in the SQL?...i'm just using the "....part_code
> > in (@.PART_CODE)" with the paramter setup normailly in the subreport's
> > report parameter properties......- Hide quoted text -
> - Show quoted text -
((
tried but not working...have logged incident with microsoft on this..|||On Mar 27, 12:53 pm, r...@.mgk.com wrote:
> On Mar 23, 1:21 am, Amarnath <Amarn...@.discussions.microsoft.com>
> wrote:
>
>
> > To be very clear, The problem is due to parameters only. First go to the
> > report which you include as "Subreport" in the main report. open the report
> > properties, check for multi-value.
> > close that remaining same. (ie string, non queried or queried, default null.)
> > Go to the main report where you have placed subreport. on the subreport
> > right click for properties and the parameter, this is the main culprit for
> > not working.
> > Parameter Name: select from the drop down.
> > Parameter Value: "=Parameters!cn.Value" here just include value instead of
> > Value(0)
> > This should work. Let me know if it works.
> > Amarnath, MCTS.
> > "r...@.mgk.com" wrote:
> > > On Mar 22, 8:07 am, r...@.mgk.com wrote:
> > > > On Mar 21, 9:10 am, Amarnath <Amarn...@.discussions.microsoft.com>
> > > > wrote:
> > > > > on the subreport properties->parameters give
> > > > > "=Join(Parameters! <ParameterName> .Value,", ") so that the multi value is
> > > > > passed to the subreport as well.
> > > > > Amarnath, MCTS
> > > > > "r...@.mgk.com" wrote:
> > > > > > ok - i've googled this and have tried everything to no avail...
> > > > > > parent report has multi-value parameter: part_code
> > > > > > this gets passed to subreport which has part_code setup as multi-
> > > > > > valued paramter
> > > > > > what is the syntax in the parent...subreport properties/parameters box
> > > > > > and
> > > > > > what is the syntax in the child report parameters form?
> > > > > > thanks very much- Hide quoted text -
> > > > > - Show quoted text -
> > > > did that Amarnath ))...and i have in the parent the subreport
> > > > properties/parameters: "=Parameters!PART_CODE"
> > > > all i get is 'error - subreport could not be shown'......- Hide quoted text -
> > > > - Show quoted text -
> > > i should've said i implemented that...as well as the "=Parameters!
> > > PART_CODE" in my previous reply...
> > > is there some change in the SQL?...i'm just using the "....part_code
> > > in (@.PART_CODE)" with the paramter setup normailly in the subreport's
> > > report parameter properties......- Hide quoted text -
> > - Show quoted text -
> ((
> tried but not working...have logged incident with microsoft on this..- Hide quoted text -
> - Show quoted text -
i've spoken to microsoft tech support - and they could not get it to
work...i'm assuming at this point we cannot reference a multi-value
paramenter in a subreport that rerferences it in the SQL statement
with the 'IN (@.MYPARAM) manner...too bad...will have to figure out a
work-around.|||I simulated your problem , it perfectly works for me..
Amarnath, MCTS.
"roy@.mgk.com" wrote:
> On Mar 27, 12:53 pm, r...@.mgk.com wrote:
> > On Mar 23, 1:21 am, Amarnath <Amarn...@.discussions.microsoft.com>
> > wrote:
> >
> >
> >
> >
> >
> > > To be very clear, The problem is due to parameters only. First go to the
> > > report which you include as "Subreport" in the main report. open the report
> > > properties, check for multi-value.
> > > close that remaining same. (ie string, non queried or queried, default null.)
> >
> > > Go to the main report where you have placed subreport. on the subreport
> > > right click for properties and the parameter, this is the main culprit for
> > > not working.
> >
> > > Parameter Name: select from the drop down.
> > > Parameter Value: "=Parameters!cn.Value" here just include value instead of
> > > Value(0)
> >
> > > This should work. Let me know if it works.
> >
> > > Amarnath, MCTS.
> >
> > > "r...@.mgk.com" wrote:
> > > > On Mar 22, 8:07 am, r...@.mgk.com wrote:
> > > > > On Mar 21, 9:10 am, Amarnath <Amarn...@.discussions.microsoft.com>
> > > > > wrote:
> >
> > > > > > on the subreport properties->parameters give
> > > > > > "=Join(Parameters! <ParameterName> .Value,", ") so that the multi value is
> > > > > > passed to the subreport as well.
> >
> > > > > > Amarnath, MCTS
> >
> > > > > > "r...@.mgk.com" wrote:
> > > > > > > ok - i've googled this and have tried everything to no avail...
> >
> > > > > > > parent report has multi-value parameter: part_code
> >
> > > > > > > this gets passed to subreport which has part_code setup as multi-
> > > > > > > valued paramter
> >
> > > > > > > what is the syntax in the parent...subreport properties/parameters box
> >
> > > > > > > and
> >
> > > > > > > what is the syntax in the child report parameters form?
> >
> > > > > > > thanks very much- Hide quoted text -
> >
> > > > > > - Show quoted text -
> >
> > > > > did that Amarnath ))...and i have in the parent the subreport
> > > > > properties/parameters: "=Parameters!PART_CODE"
> >
> > > > > all i get is 'error - subreport could not be shown'......- Hide quoted text -
> >
> > > > > - Show quoted text -
> >
> > > > i should've said i implemented that...as well as the "=Parameters!
> > > > PART_CODE" in my previous reply...
> >
> > > > is there some change in the SQL?...i'm just using the "....part_code
> > > > in (@.PART_CODE)" with the paramter setup normailly in the subreport's
> > > > report parameter properties......- Hide quoted text -
> >
> > > - Show quoted text -
> >
> > ((
> >
> > tried but not working...have logged incident with microsoft on this..- Hide quoted text -
> >
> > - Show quoted text -
> i've spoken to microsoft tech support - and they could not get it to
> work...i'm assuming at this point we cannot reference a multi-value
> paramenter in a subreport that rerferences it in the SQL statement
> with the 'IN (@.MYPARAM) manner...too bad...will have to figure out a
> work-around.
>|||On Mar 29, 1:24 am, Amarnath <Amarn...@.discussions.microsoft.com>
wrote:
> I simulated your problem , it perfectly works for me..
> Amarnath, MCTS.
>
> "r...@.mgk.com" wrote:
> > On Mar 27, 12:53 pm, r...@.mgk.com wrote:
> > > On Mar 23, 1:21 am, Amarnath <Amarn...@.discussions.microsoft.com>
> > > wrote:
> > > > To be very clear, The problem is due to parameters only. First go to the
> > > > report which you include as "Subreport" in the main report. open the report
> > > > properties, check for multi-value.
> > > > close that remaining same. (ie string, non queried or queried, default null.)
> > > > Go to the main report where you have placed subreport. on the subreport
> > > > right click for properties and the parameter, this is the main culprit for
> > > > not working.
> > > > Parameter Name: select from the drop down.
> > > > Parameter Value: "=Parameters!cn.Value" here just include value instead of
> > > > Value(0)
> > > > This should work. Let me know if it works.
> > > > Amarnath, MCTS.
> > > > "r...@.mgk.com" wrote:
> > > > > On Mar 22, 8:07 am, r...@.mgk.com wrote:
> > > > > > On Mar 21, 9:10 am, Amarnath <Amarn...@.discussions.microsoft.com>
> > > > > > wrote:
> > > > > > > on the subreport properties->parameters give
> > > > > > > "=Join(Parameters! <ParameterName> .Value,", ") so that the multi value is
> > > > > > > passed to the subreport as well.
> > > > > > > Amarnath, MCTS
> > > > > > > "r...@.mgk.com" wrote:
> > > > > > > > ok - i've googled this and have tried everything to no avail...
> > > > > > > > parent report has multi-value parameter: part_code
> > > > > > > > this gets passed to subreport which has part_code setup as multi-
> > > > > > > > valued paramter
> > > > > > > > what is the syntax in the parent...subreport properties/parameters box
> > > > > > > > and
> > > > > > > > what is the syntax in the child report parameters form?
> > > > > > > > thanks very much- Hide quoted text -
> > > > > > > - Show quoted text -
> > > > > > did that Amarnath ))...and i have in the parent the subreport
> > > > > > properties/parameters: "=Parameters!PART_CODE"
> > > > > > all i get is 'error - subreport could not be shown'......- Hide quoted text -
> > > > > > - Show quoted text -
> > > > > i should've said i implemented that...as well as the "=Parameters!
> > > > > PART_CODE" in my previous reply...
> > > > > is there some change in the SQL?...i'm just using the "....part_code
> > > > > in (@.PART_CODE)" with the paramter setup normailly in the subreport's
> > > > > report parameter properties......- Hide quoted text -
> > > > - Show quoted text -
> > > ((
> > > tried but not working...have logged incident with microsoft on this..- Hide quoted text -
> > > - Show quoted text -
> > i've spoken to microsoft tech support - and they could not get it to
> > work...i'm assuming at this point we cannot reference a multi-value
> > paramenter in a subreport that rerferences it in the SQL statement
> > with the 'IN (@.MYPARAM) manner...too bad...will have to figure out a
> > work-around.- Hide quoted text -
> - Show quoted text -
ok - this works when you have different names for the same parameter
in the parent and sub reports.......
passing multiple parameters to subreport
Is it possible to pass multiple parameters down to a subreport? If so how?
I am using this code in the report to show the contents of the parameters on
the top of the report.
Function ParameterList(ByVal Parameter As Object) As String
Dim sParamItem As Object
Dim sParamVal As String = ""
For Each sParamItem In Parameter
If sParamItem Is Nothing Then Exit For
sParamVal &= sParamItem & ", "
Next
'-- Remove last comma & space:
Return sParamVal.SubString(0, sParamVal.Length - 2)
End Function
Therefore I was expecting to use this to pass it through like this:
Code.Parameterlist(Parameters!Division.Value)
But that doesnt work unfortunately. Does anybody know an approach that
works....
Thanx
PerryDoes anybody have a clue?
thanx again
Perry
"Perry" <sjaak@.sjaak.net> wrote in message
news:OjSF%23CdzGHA.576@.TK2MSFTNGP03.phx.gbl...
> Hello Group,
> Is it possible to pass multiple parameters down to a subreport? If so how?
> I am using this code in the report to show the contents of the parameters
> on the top of the report.
> Function ParameterList(ByVal Parameter As Object) As String
> Dim sParamItem As Object
> Dim sParamVal As String = ""
> For Each sParamItem In Parameter
> If sParamItem Is Nothing Then Exit For
> sParamVal &= sParamItem & ", "
> Next
> '-- Remove last comma & space:
> Return sParamVal.SubString(0, sParamVal.Length - 2)
> End Function
>
> Therefore I was expecting to use this to pass it through like this:
> Code.Parameterlist(Parameters!Division.Value)
> But that doesnt work unfortunately. Does anybody know an approach that
> works....
> Thanx
> Perry
>
>
>
Monday, March 26, 2012
Passing figures calculated in subreports
I have to list (eg) an opening balance, set of processing data, adjustments, then a closing balance.
The opening balance is a single figure in my main report, and the processing data is in the details section along with it's sum. This leaves the adjustments which have to be listed individually and then summed - done in a subreport. Can I access this sum in the body of the main report, as I need it to calculate a closing balance.
Thank you!Use shared variable|||Thanks for pointing me in the right direction. If anyone else is interested here is an article which gave a clear step by step explanation:
http://www.experts-exchange.com/Databases/Crystal_Reports/Q_21141425.html
Friday, March 23, 2012
Passing DateTime Parameter to Subreport (Error)
Hi guys,
I have managed to pass a string parameter form the main report to the subreport with no problems, but when i try and use the same method to pass a datetime type, i am issued with the following error messase:
"[rsErrorExecutingSubreport] An error occurred while executing the subreport ‘SubReportName’: The value provided for the report parameter 'MasterDate' is not valid for its type."
I cant see why it work for strings, but not for datetime. Any suggestions will be very much appreciated
Passing data from subreport to main report
I need to convert a Crystal report that contains three subreports. Each of these subreports uses a different stored procedure to obtain data. The main report uses data from these subreports to calculate averages in the footer etc.
How do i get the data contained in these subreports so i can use it in my main report?
Thanks in advance
Pass the data through parameters from the subreport to the main report.
Or maybe you just need to restructure how these reports work. The main report shouldn't be dependent on the subreports. The subreports should be dependent (most likely) on the main report.
|||You cannot reference a sub report from the main report to get totals, etc.
The only way parameters will work is if the user clicks on the subreport and opens the main report, but you are not doing that.
The way I have gotten around this is to calculate the totals/averages in a different dataset, load them into parameters (You cannot put fields into the footer) and put the value of the parameter in a textbox in the footer.
HtH
BobP
sqlTuesday, March 20, 2012
Passing a value from parent report to subreport
I have the following report layout
Day Sales Expenses
1 10 2.5
2 12.5 3.2
3 10 4
4 14 7
5 12 5
When a user clicks on a day number a subreport will launch with layout
below:
Day Product Sales Expenses
* Core 2 .45
* Cobrand 2 1
* Franchise 5 1
* Other 3 3
Has anyone ever developed something like this that can give me some
help. I can pass parameters from the parent report to the subreport, I
just don't know how to pass a click action value from the parent report
to the subreport as a parameter.
Thanks in advanceHi John,
Yes have worked on it.
1. You need to create two reports. (one with day, sales, expenses 2nd with
day prod, sales,exp)
2. On the main report. go to the layout (expect u will place it on a table)
and on your "day field" just right click for properties. On the navigation
click hyperlick.
Jump to report.
3. On jump to report option select your detail file and give the parameters
if exists.
There you go you will get you reports. you will have a automatic previous
button to return it to the parent report. If you want to place a back button.
you can place a "back" textbox and give the hyperlink to the parent report.
So th users can click the back button to come to the parent. Ofcourse this is
optional.
Any doubts let me know
Amarnath
"john.r.carter@.bankofamerica.com" wrote:
> This is what I want to do:
> I have the following report layout
> Day Sales Expenses
> 1 10 2.5
> 2 12.5 3.2
> 3 10 4
> 4 14 7
> 5 12 5
> When a user clicks on a day number a subreport will launch with layout
> below:
> Day Product Sales Expenses
> * Core 2 .45
> * Cobrand 2 1
> * Franchise 5 1
> * Other 3 3
> Has anyone ever developed something like this that can give me some
> help. I can pass parameters from the parent report to the subreport, I
> just don't know how to pass a click action value from the parent report
> to the subreport as a parameter.
> Thanks in advance
>|||Amarnath,
Thank you for you reply. I have one more question. Is there a way to
filter the subreport table based on the day the user cloicked on the
parent report. Meaning, if a user clicks the 5th, the subreport will
launch with only the subreport table loaded w/ data for the 5th, no the
entire month.
Thanks in Advance,
John C|||Hi John,
Yes it works like this. when you click it takes the parameter of the clicked
field. In this case 1,2,3,5 etc.. so the sub rport takes 5 as the parameter.
Hope you have given the parameter on the "jump to report" report.
Amarnath.
"john.r.carter@.bankofamerica.com" wrote:
> Amarnath,
> Thank you for you reply. I have one more question. Is there a way to
> filter the subreport table based on the day the user cloicked on the
> parent report. Meaning, if a user clicks the 5th, the subreport will
> launch with only the subreport table loaded w/ data for the 5th, no the
> entire month.
> Thanks in Advance,
> John C
>|||Hello Armanath,
I have a report with a subreport. Both reports use the same parameters.
The user is prompted for the parameters, and they can be null. I'm
saving the parameter values in text fields on the main report and pass
them via the jump to report link. (I tried to use the original
parameters and pass them directly to the subreport, but that caused
errors and I therefore now save them on the report) I have created the
parameters for both reports,just as you described. But the sub report
does not render when one of the parameters is null. I have set the
parameters on the subreport to accept null values. I tried to set the
default value to null for the subreport parameters, but then it said
that "null" is no longer valid and I should use System.DBNull instead.
When I did that, it says that DBNull is a type in System and cannot be
used (or something similar).
Do you know what I need to do to be able to run the subreport with some
or all of the parameters being null? The error I get says" The value
for the report parameter [whatever parameter is null] is not valid for
it's type".
I would be very grateful if you have any idea of what needs to be done.
Thank you,
Mimi|||Hello Armanath,
I have a report with a subreport. Both reports use the same parameters.
The user is prompted for the parameters, and they can be null. I'm
saving the parameter values in text fields on the main report and pass
them via the jump to report link. (I tried to use the original
parameters and pass them directly to the subreport, but that caused
errors and I therefore now save them on the report) I have created the
parameters for both reports,just as you described. But the sub report
does not render when one of the parameters is null. I have set the
parameters on the subreport to accept null values. I tried to set the
default value to null for the subreport parameters, but then it said
that "null" is no longer valid and I should use System.DBNull instead.
When I did that, it says that DBNull is a type in System and cannot be
used (or something similar).
Do you know what I need to do to be able to run the subreport with some
or all of the parameters being null? The error I get says" The value
for the report parameter [whatever parameter is null] is not valid for
it's type".
I would be very grateful if you have any idea of what needs to be done.
Thank you,
Mimi|||Hello Armanath,
I have a report with a subreport. Both reports use the same parameters.
The user is prompted for the parameters, and they can be null. I'm
saving the parameter values in text fields on the main report and pass
them via the jump to report link. (I tried to use the original
parameters and pass them directly to the subreport, but that caused
errors and I therefore now save them on the report) I have created the
parameters for both reports,just as you described. But the sub report
does not render when one of the parameters is null. I have set the
parameters on the subreport to accept null values. I tried to set the
default value to null for the subreport parameters, but then it said
that "null" is no longer valid and I should use System.DBNull instead.
When I did that, it says that DBNull is a type in System and cannot be
used (or something similar).
Do you know what I need to do to be able to run the subreport with some
or all of the parameters being null? The error I get says" The value
for the report parameter [whatever parameter is null] is not valid for
it's type".
I would be very grateful if you have any idea of what needs to be done.
Thank you,
Mimi|||Nevermind. The way to solve it is to insert
<Omit>=Iif(Parameters!EndDate.Value is Nothing, True,False)</Omit>
under each parameter in the main report.
see
http://www.sqlmonster.com/Uwe/Forum.aspx/sql-server-reporting/5825/The-value-provided-for-report-parameter-StartDate
Monday, March 12, 2012
Passing a parameter from main report SP to subreport SP
I am using crystal reports 8.5
I have a report which has a subreport. The main report and the subreport are driven by two separate sybase SPs. The main report SP accepts 3 input parameters while the subreport SP accepts one.
One of the 3 input parameters of the main report SP is to be passed to the subreport SP as its input parameter.
So ideally when the report is run, it should ask for only 3 input params.
I tried to link the subreport. But somehow in the link box, I can't see the input parameter of the subreport which is what I want to link to the param of the main report.
Can anybody help ?
Thanks a lot,
AparnaYou can make use of Shared variables.
Assign parameter values to them and use them in subreports. Read it in help file
Passing a null parameter from a report to a subreport
I have a report with a subreport and I'm trying to make them work in the
report designer in VS2003.
The report has some parameters and one of them is DepartmentIndex, which can
be NULL.
This parameter is being passed down to the subreport.
I set the DepartmentIndex parameter to accept both blank and null values and
gave it a default value of " " (one space),
in both the report and the subreport.
If I run the SUBREPORT alone and check the null checkbox for this parameter,
the subreport works fine and displays the records with a null value in the
DepartmentIndex field.
But if I try to run the REPORT and check the null checkbox, it displays an
error :
An error occurred while executing the subreport '<subreport_name>': One or
more parameters required to run the report have not been specified.
Though, the report data is displayed correctly (showing the rows with null
DepartmentIndex).
Can anybody help, please ?
Thanks,
Andrei.I got the same error and I would someone can help?
One or more parameters required to run the report have not been specified
Linh
"andrei" wrote:
> Hi Group,
> I have a report with a subreport and I'm trying to make them work in the
> report designer in VS2003.
> The report has some parameters and one of them is DepartmentIndex, which can
> be NULL.
> This parameter is being passed down to the subreport.
> I set the DepartmentIndex parameter to accept both blank and null values and
> gave it a default value of " " (one space),
> in both the report and the subreport.
> If I run the SUBREPORT alone and check the null checkbox for this parameter,
> the subreport works fine and displays the records with a null value in the
> DepartmentIndex field.
> But if I try to run the REPORT and check the null checkbox, it displays an
> error :
> An error occurred while executing the subreport '<subreport_name>': One or
> more parameters required to run the report have not been specified.
> Though, the report data is displayed correctly (showing the rows with null
> DepartmentIndex).
> Can anybody help, please ?
> Thanks,
> Andrei.
>
>|||How do you pass parameter into subreport?
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Linh Phan" <LinhPhan@.discussions.microsoft.com> wrote in message
news:FA2946C8-ECD9-47E1-AC80-B7AA2EF041B2@.microsoft.com...
>I got the same error and I would someone can help?
> One or more parameters required to run the report have not been specified
> Linh
> "andrei" wrote:
>> Hi Group,
>> I have a report with a subreport and I'm trying to make them work in the
>> report designer in VS2003.
>> The report has some parameters and one of them is DepartmentIndex, which
>> can
>> be NULL.
>> This parameter is being passed down to the subreport.
>> I set the DepartmentIndex parameter to accept both blank and null values
>> and
>> gave it a default value of " " (one space),
>> in both the report and the subreport.
>> If I run the SUBREPORT alone and check the null checkbox for this
>> parameter,
>> the subreport works fine and displays the records with a null value in
>> the
>> DepartmentIndex field.
>> But if I try to run the REPORT and check the null checkbox, it displays
>> an
>> error :
>> An error occurred while executing the subreport '<subreport_name>': One
>> or
>> more parameters required to run the report have not been specified.
>> Though, the report data is displayed correctly (showing the rows with
>> null
>> DepartmentIndex).
>> Can anybody help, please ?
>> Thanks,
>> Andrei.
>>|||Hi Lev,
I just figured it out by right click on each subreport and set the missing
parameters for each. It worked well.
Thanks!
Linh
"Lev Semenets [MSFT]" wrote:
> How do you pass parameter into subreport?
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Linh Phan" <LinhPhan@.discussions.microsoft.com> wrote in message
> news:FA2946C8-ECD9-47E1-AC80-B7AA2EF041B2@.microsoft.com...
> >I got the same error and I would someone can help?
> >
> > One or more parameters required to run the report have not been specified
> >
> > Linh
> >
> > "andrei" wrote:
> >
> >> Hi Group,
> >>
> >> I have a report with a subreport and I'm trying to make them work in the
> >> report designer in VS2003.
> >> The report has some parameters and one of them is DepartmentIndex, which
> >> can
> >> be NULL.
> >> This parameter is being passed down to the subreport.
> >> I set the DepartmentIndex parameter to accept both blank and null values
> >> and
> >> gave it a default value of " " (one space),
> >> in both the report and the subreport.
> >> If I run the SUBREPORT alone and check the null checkbox for this
> >> parameter,
> >> the subreport works fine and displays the records with a null value in
> >> the
> >> DepartmentIndex field.
> >> But if I try to run the REPORT and check the null checkbox, it displays
> >> an
> >> error :
> >> An error occurred while executing the subreport '<subreport_name>': One
> >> or
> >> more parameters required to run the report have not been specified.
> >>
> >> Though, the report data is displayed correctly (showing the rows with
> >> null
> >> DepartmentIndex).
> >>
> >> Can anybody help, please ?
> >>
> >> Thanks,
> >>
> >> Andrei.
> >>
> >>
> >>
>
>
Passing a multi-value parameter to a Subreport
For example, if my main report has a multi-value parameter named @.p1 and my
subreport's dataset is generated by SQL
SELECT a,b FROM MyTable WHERE a IN (@.LongList)
how do I then pass the user-selected @.p1 values from the main report to the
@.LongList parameter in the subreport?
I tried specifying JOIN(@.P1.Value,",") for a parameter value, but it did not
work.
Any help/suggestions will be appreciated. Thanks in advanceThis is just a guess based on what I know is going on behind the covers but
try the following. In your subreport make the Report Parameter @.LongList a
multi-value parameter. Test the subreport stand alone and make sure it
works. Then drop the subreport into your main report, right mouse click on
it, parameters and map the report parameter from the subreport to the report
parameter from the main report. You should not have to do anything fancy.
Let me know if it works.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"isaak" <isaak.peretsman at usa.dupont.com (no spam)> wrote in message
news:4785EFE4-9436-4715-8AA4-A57CC8E9AC78@.microsoft.com...
> How do I pass a multi-value parameter to a subreport?
> For example, if my main report has a multi-value parameter named @.p1 and
> my
> subreport's dataset is generated by SQL
> SELECT a,b FROM MyTable WHERE a IN (@.LongList)
> how do I then pass the user-selected @.p1 values from the main report to
> the
> @.LongList parameter in the subreport?
> I tried specifying JOIN(@.P1.Value,",") for a parameter value, but it did
> not
> work.
> Any help/suggestions will be appreciated. Thanks in advance
>|||Bruce,
This works. Once again - thanks for your help.
Isaak
"Bruce L-C [MVP]" wrote:
> This is just a guess based on what I know is going on behind the covers but
> try the following. In your subreport make the Report Parameter @.LongList a
> multi-value parameter. Test the subreport stand alone and make sure it
> works. Then drop the subreport into your main report, right mouse click on
> it, parameters and map the report parameter from the subreport to the report
> parameter from the main report. You should not have to do anything fancy.
> Let me know if it works.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "isaak" <isaak.peretsman at usa.dupont.com (no spam)> wrote in message
> news:4785EFE4-9436-4715-8AA4-A57CC8E9AC78@.microsoft.com...
> > How do I pass a multi-value parameter to a subreport?
> >
> > For example, if my main report has a multi-value parameter named @.p1 and
> > my
> > subreport's dataset is generated by SQL
> >
> > SELECT a,b FROM MyTable WHERE a IN (@.LongList)
> >
> > how do I then pass the user-selected @.p1 values from the main report to
> > the
> > @.LongList parameter in the subreport?
> >
> > I tried specifying JOIN(@.P1.Value,",") for a parameter value, but it did
> > not
> > work.
> >
> > Any help/suggestions will be appreciated. Thanks in advance
> >
>
>|||Appreciate you getting back and letting me know the result. As I said it was
a guess on my part.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"isaak" <isaak.peretsman at usa.dupont.com (no spam)> wrote in message
news:D71C1BB0-7AB0-4CFF-BD5F-D6B789D59906@.microsoft.com...
> Bruce,
> This works. Once again - thanks for your help.
> Isaak
> "Bruce L-C [MVP]" wrote:
>> This is just a guess based on what I know is going on behind the covers
>> but
>> try the following. In your subreport make the Report Parameter @.LongList
>> a
>> multi-value parameter. Test the subreport stand alone and make sure it
>> works. Then drop the subreport into your main report, right mouse click
>> on
>> it, parameters and map the report parameter from the subreport to the
>> report
>> parameter from the main report. You should not have to do anything fancy.
>> Let me know if it works.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "isaak" <isaak.peretsman at usa.dupont.com (no spam)> wrote in message
>> news:4785EFE4-9436-4715-8AA4-A57CC8E9AC78@.microsoft.com...
>> > How do I pass a multi-value parameter to a subreport?
>> >
>> > For example, if my main report has a multi-value parameter named @.p1
>> > and
>> > my
>> > subreport's dataset is generated by SQL
>> >
>> > SELECT a,b FROM MyTable WHERE a IN (@.LongList)
>> >
>> > how do I then pass the user-selected @.p1 values from the main report to
>> > the
>> > @.LongList parameter in the subreport?
>> >
>> > I tried specifying JOIN(@.P1.Value,",") for a parameter value, but it
>> > did
>> > not
>> > work.
>> >
>> > Any help/suggestions will be appreciated. Thanks in advance
>> >
>>|||Isaak,
Since yours works, may I ask you a question?
In my main report, the parameter that I want to pass to subreport is
"Fields!CallID.value", so I right-click the subreport in main report,
properties, parameter, parameter name is "CallID", parameter value is
"Fields!CallID.value". In my subreport, my sql query is (In subreport)
select Tracker, EntryDate, EntryText from dbo.Journal
where CallID = @.CallID
I go to paramters tab, I see the name is "@.CallID" and value ="Parameters!CallID.value".
when I run from main report, there is no error but subreport is not showing
in the main report. Do I miss something here? Thanks!
Henry
"isaak" wrote:
> Bruce,
> This works. Once again - thanks for your help.
> Isaak
> "Bruce L-C [MVP]" wrote:
> > This is just a guess based on what I know is going on behind the covers but
> > try the following. In your subreport make the Report Parameter @.LongList a
> > multi-value parameter. Test the subreport stand alone and make sure it
> > works. Then drop the subreport into your main report, right mouse click on
> > it, parameters and map the report parameter from the subreport to the report
> > parameter from the main report. You should not have to do anything fancy.
> >
> > Let me know if it works.
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "isaak" <isaak.peretsman at usa.dupont.com (no spam)> wrote in message
> > news:4785EFE4-9436-4715-8AA4-A57CC8E9AC78@.microsoft.com...
> > > How do I pass a multi-value parameter to a subreport?
> > >
> > > For example, if my main report has a multi-value parameter named @.p1 and
> > > my
> > > subreport's dataset is generated by SQL
> > >
> > > SELECT a,b FROM MyTable WHERE a IN (@.LongList)
> > >
> > > how do I then pass the user-selected @.p1 values from the main report to
> > > the
> > > @.LongList parameter in the subreport?
> > >
> > > I tried specifying JOIN(@.P1.Value,",") for a parameter value, but it did
> > > not
> > > work.
> > >
> > > Any help/suggestions will be appreciated. Thanks in advance
> > >
> >
> >
> >|||Issak,
I got it to work. Thanks!
Henry
"Henry Chen" wrote:
> Isaak,
> Since yours works, may I ask you a question?
> In my main report, the parameter that I want to pass to subreport is
> "Fields!CallID.value", so I right-click the subreport in main report,
> properties, parameter, parameter name is "CallID", parameter value is
> "Fields!CallID.value". In my subreport, my sql query is (In subreport)
> select Tracker, EntryDate, EntryText from dbo.Journal
> where CallID = @.CallID
> I go to paramters tab, I see the name is "@.CallID" and value => "Parameters!CallID.value".
> when I run from main report, there is no error but subreport is not showing
> in the main report. Do I miss something here? Thanks!
> Henry
> "isaak" wrote:
> > Bruce,
> >
> > This works. Once again - thanks for your help.
> >
> > Isaak
> >
> > "Bruce L-C [MVP]" wrote:
> >
> > > This is just a guess based on what I know is going on behind the covers but
> > > try the following. In your subreport make the Report Parameter @.LongList a
> > > multi-value parameter. Test the subreport stand alone and make sure it
> > > works. Then drop the subreport into your main report, right mouse click on
> > > it, parameters and map the report parameter from the subreport to the report
> > > parameter from the main report. You should not have to do anything fancy.
> > >
> > > Let me know if it works.
> > >
> > >
> > > --
> > > Bruce Loehle-Conger
> > > MVP SQL Server Reporting Services
> > >
> > > "isaak" <isaak.peretsman at usa.dupont.com (no spam)> wrote in message
> > > news:4785EFE4-9436-4715-8AA4-A57CC8E9AC78@.microsoft.com...
> > > > How do I pass a multi-value parameter to a subreport?
> > > >
> > > > For example, if my main report has a multi-value parameter named @.p1 and
> > > > my
> > > > subreport's dataset is generated by SQL
> > > >
> > > > SELECT a,b FROM MyTable WHERE a IN (@.LongList)
> > > >
> > > > how do I then pass the user-selected @.p1 values from the main report to
> > > > the
> > > > @.LongList parameter in the subreport?
> > > >
> > > > I tried specifying JOIN(@.P1.Value,",") for a parameter value, but it did
> > > > not
> > > > work.
> > > >
> > > > Any help/suggestions will be appreciated. Thanks in advance
> > > >
> > >
> > >
> > >|||Sorry Isac,
I was trying to do the same thing but it did not work for me. Am I missing
something?
"Bruce L-C [MVP]" wrote:
> This is just a guess based on what I know is going on behind the covers but
> try the following. In your subreport make the Report Parameter @.LongList a
> multi-value parameter. Test the subreport stand alone and make sure it
> works. Then drop the subreport into your main report, right mouse click on
> it, parameters and map the report parameter from the subreport to the report
> parameter from the main report. You should not have to do anything fancy.
> Let me know if it works.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "isaak" <isaak.peretsman at usa.dupont.com (no spam)> wrote in message
> news:4785EFE4-9436-4715-8AA4-A57CC8E9AC78@.microsoft.com...
> > How do I pass a multi-value parameter to a subreport?
> >
> > For example, if my main report has a multi-value parameter named @.p1 and
> > my
> > subreport's dataset is generated by SQL
> >
> > SELECT a,b FROM MyTable WHERE a IN (@.LongList)
> >
> > how do I then pass the user-selected @.p1 values from the main report to
> > the
> > @.LongList parameter in the subreport?
> >
> > I tried specifying JOIN(@.P1.Value,",") for a parameter value, but it did
> > not
> > work.
> >
> > Any help/suggestions will be appreciated. Thanks in advance
> >
>
>|||Sorry I forgot to mention, did you manage to get working with multivalue
parameter?
"Henry Chen" wrote:
> Issak,
> I got it to work. Thanks!
> Henry
> "Henry Chen" wrote:
> > Isaak,
> > Since yours works, may I ask you a question?
> >
> > In my main report, the parameter that I want to pass to subreport is
> > "Fields!CallID.value", so I right-click the subreport in main report,
> > properties, parameter, parameter name is "CallID", parameter value is
> > "Fields!CallID.value". In my subreport, my sql query is (In subreport)
> >
> > select Tracker, EntryDate, EntryText from dbo.Journal
> > where CallID = @.CallID
> >
> > I go to paramters tab, I see the name is "@.CallID" and value => > "Parameters!CallID.value".
> >
> > when I run from main report, there is no error but subreport is not showing
> > in the main report. Do I miss something here? Thanks!
> > Henry
> >
> > "isaak" wrote:
> >
> > > Bruce,
> > >
> > > This works. Once again - thanks for your help.
> > >
> > > Isaak
> > >
> > > "Bruce L-C [MVP]" wrote:
> > >
> > > > This is just a guess based on what I know is going on behind the covers but
> > > > try the following. In your subreport make the Report Parameter @.LongList a
> > > > multi-value parameter. Test the subreport stand alone and make sure it
> > > > works. Then drop the subreport into your main report, right mouse click on
> > > > it, parameters and map the report parameter from the subreport to the report
> > > > parameter from the main report. You should not have to do anything fancy.
> > > >
> > > > Let me know if it works.
> > > >
> > > >
> > > > --
> > > > Bruce Loehle-Conger
> > > > MVP SQL Server Reporting Services
> > > >
> > > > "isaak" <isaak.peretsman at usa.dupont.com (no spam)> wrote in message
> > > > news:4785EFE4-9436-4715-8AA4-A57CC8E9AC78@.microsoft.com...
> > > > > How do I pass a multi-value parameter to a subreport?
> > > > >
> > > > > For example, if my main report has a multi-value parameter named @.p1 and
> > > > > my
> > > > > subreport's dataset is generated by SQL
> > > > >
> > > > > SELECT a,b FROM MyTable WHERE a IN (@.LongList)
> > > > >
> > > > > how do I then pass the user-selected @.p1 values from the main report to
> > > > > the
> > > > > @.LongList parameter in the subreport?
> > > > >
> > > > > I tried specifying JOIN(@.P1.Value,",") for a parameter value, but it did
> > > > > not
> > > > > work.
> > > > >
> > > > > Any help/suggestions will be appreciated. Thanks in advance
> > > > >
> > > >
> > > >
> > > >
Wednesday, March 7, 2012
Pass parameters to OLAP sub-report
Using RS 2005
I've got a main report onto which I've placed a subreport to which I
need to pass 2 parameters.
I've done this a 100 times in the past but here I am getting this error
message:
[rsErrorExecutingSubreport] An error occurred while executing the
subreport 'subreport1': One or more parameters required to run the
report have not been specified.
(The report shows "Error: Subreport could not be shown)
The only thing different this time is that the subreport uses OLAP as
a datasource.
Is there anything else which could be producing a misleading error
message, or do I need to be aware of other things when OLAP is
involved?
Thanks
WayneCan u try to refresh the fields in the dataset of the sub-report to
make sure that the field names are being picked up correctly? I've
run into this before as well-
Matt A|||Hi Wayne,
It seems most of the questions being posted here that relate to OLAP are not
being answered. Either we're missing something obvious or not a lot of
people are doing this. Or those who are don't come to this forum!
I'm new to RS and have limited AS exposure but am slowly piecing things
together through trial-and-error - not finding much assistance in books
online or the web at large. So I can't solve your issue but maybe I'll say
something that points you in the right direction.
So far, I gather that in the case of a parameterised OLAP datasource, one
must pass in the full unique name.
Example :
territoryRegionSite = [Territory].[Region - Site].[Site].&[25]
In this example, the &[25] denotes the key value for the specified site.
Or did you know that already?
Note :
URL access requires encoding, particularly in the case of the extra
ampersand. Something like this :
territoryRegionSite =%5BTerritory%5D.%5BRegion%20-%20Site%5D.%5BSite%5D.%26%5B25%5D
Martin Dreyer
"waynest" <wayne.swaby@.tribaleducation.co.uk> wrote in message
news:1144837002.247963.133960@.i39g2000cwa.googlegroups.com...
> Hi there
> Using RS 2005
>
> I've got a main report onto which I've placed a subreport to which I
> need to pass 2 parameters.
> I've done this a 100 times in the past but here I am getting this error
> message:
> [rsErrorExecutingSubreport] An error occurred while executing the
> subreport 'subreport1': One or more parameters required to run the
> report have not been specified.
> (The report shows "Error: Subreport could not be shown)
> The only thing different this time is that the subreport uses OLAP as
> a datasource.
> Is there anything else which could be producing a misleading error
> message, or do I need to be aware of other things when OLAP is
> involved?
> Thanks
> Wayne
>|||Okay, I was missing something obvious. Well, its obvious in retrospect.
When setting, in "Jump to report" the report parameters, I needed to use the
.UniqueName property instead of the default .Value property.
Eg. Fields!Region.UniqueName instead of Fields!Region.Value
That then sends the whole value [Region-Site].[Region].&[2] , which the
receiving report is expecting. It makes sense that it needs the whole path
to uniquely identify what members you're looking for.
Martin Dreyer
"Martin Dreyer" <martindr@.avision.co.za> wrote in message
news:%23eulHH$dGHA.2068@.TK2MSFTNGP02.phx.gbl...
> Hi Wayne,
> It seems most of the questions being posted here that relate to OLAP are
> not being answered. Either we're missing something obvious or not a lot of
> people are doing this. Or those who are don't come to this forum!
> I'm new to RS and have limited AS exposure but am slowly piecing things
> together through trial-and-error - not finding much assistance in books
> online or the web at large. So I can't solve your issue but maybe I'll say
> something that points you in the right direction.
> So far, I gather that in the case of a parameterised OLAP datasource, one
> must pass in the full unique name.
> Example :
> territoryRegionSite = [Territory].[Region - Site].[Site].&[25]
> In this example, the &[25] denotes the key value for the specified site.
> Or did you know that already?
> Note :
> URL access requires encoding, particularly in the case of the extra
> ampersand. Something like this :
> territoryRegionSite => %5BTerritory%5D.%5BRegion%20-%20Site%5D.%5BSite%5D.%26%5B25%5D
> Martin Dreyer
>
> "waynest" <wayne.swaby@.tribaleducation.co.uk> wrote in message
> news:1144837002.247963.133960@.i39g2000cwa.googlegroups.com...
>> Hi there
>> Using RS 2005
>>
>> I've got a main report onto which I've placed a subreport to which I
>> need to pass 2 parameters.
>> I've done this a 100 times in the past but here I am getting this error
>> message:
>> [rsErrorExecutingSubreport] An error occurred while executing the
>> subreport 'subreport1': One or more parameters required to run the
>> report have not been specified.
>> (The report shows "Error: Subreport could not be shown)
>> The only thing different this time is that the subreport uses OLAP as
>> a datasource.
>> Is there anything else which could be producing a misleading error
>> message, or do I need to be aware of other things when OLAP is
>> involved?
>> Thanks
>> Wayne
>