Multi- value parameter!

Hi every body!
I have two reports ,in first i have one multi value parameter .in
first report i select more than one value ,then in second report i
want to have these values becuse i have another multi value
parameter ,when i join these reports via navigation
in parameters (in first report) i put the values of multi value
parameter in fisrt report for value of multi value parameter in second
report,but in this case fore example i have it:
in first reprt-> navigation->parameters->
ParameterName ParameterVaue
EmployeeID =Parameters!EmployeeID.Value(0)
but in second report i need all of my selections in first report not
just first value
Can anybody help me?On Nov 4, 4:35 am, SHIMAR...@.gmail.com wrote:
> Hi every body!
> I have two reports ,in first i have one multi value parameter .in
> first report i select more than one value ,then in second report i
> want to have these values becuse i have another multi value
> parameter ,when i join these reports via navigation
> in parameters (in first report) i put the values of multi value
> parameter in fisrt report for value of multi value parameter in second
> report,but in this case fore example i have it:
> in first reprt-> navigation->parameters->
> ParameterName ParameterVaue
> EmployeeID =Parameters!EmployeeID.Value(0)
> but in second report i need all of my selections in first report not
> just first value
> Can anybody help me?
If I'm understanding you correctly, you should be able to use an
expression similar to the following to obtain the multi-select
parameter's values from the main report.
=Join(Parameters!EmployeeID.Value,",")
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant

Multi Select Parameter in RS2005

I'm using the possibility to define some parameters of my reports having the
property multi-select. On all my reports I always give information on the
first page on the parameters used to generate the output. For parameters that
do not have the property multi-select this works by using expressions
= Parameters!id_status.Value and = Parameters!id_status.Label
where id_status is a parameter
For a multi-select parameter I want to do the same; how ?I guess the new release of RS 2005 does support multi value select. I was
reading FAQ section on Microsoft site, that it is possible to pass multi
value parameters into the report. The way it is implemented is like this.
In a dropdown which lists the values, check all the values and then view the
report. RS constructs the SQL behind the scene.
Hope this helps..
Suresh
"RDC" wrote:
> I'm using the possibility to define some parameters of my reports having the
> property multi-select. On all my reports I always give information on the
> first page on the parameters used to generate the output. For parameters that
> do not have the property multi-select this works by using expressions
> = Parameters!id_status.Value and = Parameters!id_status.Label
> where id_status is a parameter
> For a multi-select parameter I want to do the same; how ?|||I known it works; I want to display the selected values in my report by using
something like
= Parameters!parameter_name.Value and = Parameters!parameter.Label
"Suresh" wrote:
> I guess the new release of RS 2005 does support multi value select. I was
> reading FAQ section on Microsoft site, that it is possible to pass multi
> value parameters into the report. The way it is implemented is like this.
> In a dropdown which lists the values, check all the values and then view the
> report. RS constructs the SQL behind the scene.
> Hope this helps..
> Suresh
> "RDC" wrote:
> > I'm using the possibility to define some parameters of my reports having the
> > property multi-select. On all my reports I always give information on the
> > first page on the parameters used to generate the output. For parameters that
> > do not have the property multi-select this works by using expressions
> > = Parameters!id_status.Value and = Parameters!id_status.Label
> > where id_status is a parameter
> > For a multi-select parameter I want to do the same; how ?|||If you change a report parameter to be multi value, the .Value property will
return an object[] rather than an object. Hence you can no longer e.g. write
expressions like =Parameters!MVP1.Value.ToString().
To access individual values of a multi value parameter you can use
expressions like this:
=Parameters!MVP1.IsMultiValue
boolean flag - tells if a parameter is defined as multi value
=Parameters!MVP1.Count
returns the number of values in the array
=Parameters!MVP1.Value(0)
returns the first selected value
=Join(Parameters!MVP1.Value)
creates a space separated list of values
=Join(Parameters!MVP1.Value, ", ")
creates a comma separated list of values
=Split("a b c", " ")
to create a multi value object array from a string (this can be used
e.g. for drillthrough parameters, subreports, or query parameters)
See also MSDN:
* http://msdn.microsoft.com/library/en-us/vblr7/html/vafctjoin.asp
* http://msdn.microsoft.com/library/en-us/vbenlr98/html/vafctsplit.asp
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"RDC" <RDC@.discussions.microsoft.com> wrote in message
news:4CBB1232-BEC3-4D0F-BC55-F1FD732F3AB8@.microsoft.com...
>I known it works; I want to display the selected values in my report by
>using
> something like
> = Parameters!parameter_name.Value and = Parameters!parameter.Label
> "Suresh" wrote:
>> I guess the new release of RS 2005 does support multi value select. I was
>> reading FAQ section on Microsoft site, that it is possible to pass multi
>> value parameters into the report. The way it is implemented is like this.
>> In a dropdown which lists the values, check all the values and then view
>> the
>> report. RS constructs the SQL behind the scene.
>> Hope this helps..
>> Suresh
>> "RDC" wrote:
>> > I'm using the possibility to define some parameters of my reports
>> > having the
>> > property multi-select. On all my reports I always give information on
>> > the
>> > first page on the parameters used to generate the output. For
>> > parameters that
>> > do not have the property multi-select this works by using expressions
>> > = Parameters!id_status.Value and = Parameters!id_status.Label
>> > where id_status is a parameter
>> > For a multi-select parameter I want to do the same; how ?

Multi report subscription

Hello,

Is it possible to create a subscriptions for more than one report ? (I would like to pack in one e-mail three or four reports).

Thanks, Regards

Braulio

Sorry, this is not currently supported.

Multi comboboxes

Hi,
My instructions are to add more functionality to current reports by adding a
second dropdown. The reports currently have one combobox that lists
Application names. When an Application is chosen the report opens with all
the data associated with that Application.
Now there is a request to add a second combo that would only be visible if
certain choices were made on the first combo. The choice from the second
combo open the report with a more limited set of values from the same source.
Currently stored procedures are used for the combos and the data returned
from choices uses stored procedures with parameters.
Is this possible to do and what is the best plan of attack?
Thanks,
--
FairfieldIf you have the first parameter in the second dataset query, it will
refresh the second list when the first parameter is changed.
So if your first parameter is called Team then the 2nd dataset query
might be something like;
EXEC dbo.sp_GetMyData2 @.Team
This should give you what you want.
Chris
Fairfield wrote:
> Hi,
> My instructions are to add more functionality to current reports by
> adding a second dropdown. The reports currently have one combobox
> that lists Application names. When an Application is chosen the
> report opens with all the data associated with that Application.
> Now there is a request to add a second combo that would only be
> visible if certain choices were made on the first combo. The choice
> from the second combo open the report with a more limited set of
> values from the same source.
> Currently stored procedures are used for the combos and the data
> returned from choices uses stored procedures with parameters.
> Is this possible to do and what is the best plan of attack?
> Thanks,|||Chris,
Thanks for the suggestion about using the first parameter in the second
query. That is a good idea.
But I think I need to clarify the situation a bit to make sure that I'm
fully explaining the situation. Normally the report is driven off of the
first query. However if certain choices are made then they want the second
combo to be visible and the report to run off of that query. Does this make
sense?
Thanks,
--
Fairfield
"|||You do not have that level of control of the parameters. It is possible to
hide parameters, it is not possible to hide/show on demand.
You can decide whether to use the second parameter or not (an easy way is to
send both to a stored procedure and make the decision there). Also, your
query can be an expression so based on the values of the parameters then
create the queries on the fly.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Fairfield" <Fairfield@.discussions.microsoft.com> wrote in message
news:38DD9B46-AD22-4926-B78A-1A8F3A9A2101@.microsoft.com...
> Chris,
> Thanks for the suggestion about using the first parameter in the second
> query. That is a good idea.
> But I think I need to clarify the situation a bit to make sure that I'm
> fully explaining the situation. Normally the report is driven off of the
> first query. However if certain choices are made then they want the
> second
> combo to be visible and the report to run off of that query. Does this
> make
> sense?
> Thanks,
> --
> Fairfield
>
> "|||Thanks Bruce,
My thinking here is slowly catching up to what we really need. It is 2
levels of choices. The dropdown lists all the choices but on some of them
there needs to be a second choice. There are far too many to list all in
one. An example might be listing cities in the dropdown and then having a
second dropdown open if there are multiple zip codes for that city. Smaller
towns might have 1 or 2 but large cities could have hundreds. The report
would show data on the particular zip code. In this case at the zipcode
level there could be hundreds to choose from so they can't be listed just in
the first dropdown.
Does this make sense? How can this kind of choice by made? It is something
like a treeview.
Thanks,
--
Fairfield
"Bruce L-C [MVP]" wrote:
> You do not have that level of control of the parameters. It is possible to
> hide parameters, it is not possible to hide/show on demand.
> You can decide whether to use the second parameter or not (an easy way is to
> send both to a stored procedure and make the decision there). Also, your
> query can be an expression so based on the values of the parameters then
> create the queries on the fly.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Fairfield" <Fairfield@.discussions.microsoft.com> wrote in message
> news:38DD9B46-AD22-4926-B78A-1A8F3A9A2101@.microsoft.com...
> > Chris,
> >
> > Thanks for the suggestion about using the first parameter in the second
> > query. That is a good idea.
> >
> > But I think I need to clarify the situation a bit to make sure that I'm
> > fully explaining the situation. Normally the report is driven off of the
> > first query. However if certain choices are made then they want the
> > second
> > combo to be visible and the report to run off of that query. Does this
> > make
> > sense?
> > Thanks,
> >
> > --
> > Fairfield
> >
> >
> > "
>
>|||Did you try and make queries that have (with a union) a static entry item
(like "NONE"), if it doesn't result in anything, and then default it to an
equation. That equation will determine if the default should be NONE or the
1st item?
--
"Everyone knows something you don't know"
"Fairfield" wrote:
> Thanks Bruce,
> My thinking here is slowly catching up to what we really need. It is 2
> levels of choices. The dropdown lists all the choices but on some of them
> there needs to be a second choice. There are far too many to list all in
> one. An example might be listing cities in the dropdown and then having a
> second dropdown open if there are multiple zip codes for that city. Smaller
> towns might have 1 or 2 but large cities could have hundreds. The report
> would show data on the particular zip code. In this case at the zipcode
> level there could be hundreds to choose from so they can't be listed just in
> the first dropdown.
> Does this make sense? How can this kind of choice by made? It is something
> like a treeview.
> Thanks,
> --
> Fairfield
>
> "Bruce L-C [MVP]" wrote:
> > You do not have that level of control of the parameters. It is possible to
> > hide parameters, it is not possible to hide/show on demand.
> >
> > You can decide whether to use the second parameter or not (an easy way is to
> > send both to a stored procedure and make the decision there). Also, your
> > query can be an expression so based on the values of the parameters then
> > create the queries on the fly.
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Fairfield" <Fairfield@.discussions.microsoft.com> wrote in message
> > news:38DD9B46-AD22-4926-B78A-1A8F3A9A2101@.microsoft.com...
> > > Chris,
> > >
> > > Thanks for the suggestion about using the first parameter in the second
> > > query. That is a good idea.
> > >
> > > But I think I need to clarify the situation a bit to make sure that I'm
> > > fully explaining the situation. Normally the report is driven off of the
> > > first query. However if certain choices are made then they want the
> > > second
> > > combo to be visible and the report to run off of that query. Does this
> > > make
> > > sense?
> > > Thanks,
> > >
> > > --
> > > Fairfield
> > >
> > >
> > > "
> >
> >
> >|||I think a combination of my original suggestion and Davids is the best
you can hope for. As Bruce said, you can't conditionally show/hide a
parameter itself at run-time. So you'll just have to limit the options
in the second parameter based on the 1st parameter and whatever other
conditions required.
Chris
David Bienstock wrote:
> Did you try and make queries that have (with a union) a static entry
> item (like "NONE"), if it doesn't result in anything, and then
> default it to an equation. That equation will determine if the
> default should be NONE or the 1st item?|||Thanks for all the help. The 2 dropdowns are now populating correctly and
I'm happy with the way they are working. However a new problem is popping
up. I know it's simply my inexperience with Reporting Services and will soon
seem quite simple.
The first combo chooses the AppID. When the user makes a choice most of the
time the 2nd combo is not filled. But on certain choices the second is
filled. The user then makes a selection on the second and a report should be
returned.
The second combo actually output an AppID, just like the first combo, only
it is different number. The problem is that the report dataset only uses the
AppID from the first combo and doesn't change to the second.
I'm trying to figure out code or a function to force it to use the new
AppID and ignore it when the 2nd combo is null. My experience is in classic
vb and vba and DTS scripts. This all just doesn't seem as intuitive. I
purchased the Hitchhiker book last night and this has helped my understanding.
Thanks
--
Fairfield
"Chris McGuigan" wrote:
> I think a combination of my original suggestion and Davids is the best
> you can hope for. As Bruce said, you can't conditionally show/hide a
> parameter itself at run-time. So you'll just have to limit the options
> in the second parameter based on the 1st parameter and whatever other
> conditions required.
> Chris
>
> David Bienstock wrote:
> > Did you try and make queries that have (with a union) a static entry
> > item (like "NONE"), if it doesn't result in anything, and then
> > default it to an equation. That equation will determine if the
> > default should be NONE or the 1st item?
>|||Fairfield,
This is an easy one;
In SQL, assuming the parameters return integer values (just change
datatype accordingly and add single quotes if a text value);
Select * From MyTable Where AppId = IsNull(@.Combo2, @.Combo1)
or you can use VB to build the query, but this is slightly less
efficient;
="Select * From MyTable Where AppId = " +
IIf(IsDBNull(Parameters!Combo2.Value), Parameters!Combo1.Value,
Parameters!Combo2.Value)
Chris
Fairfield wrote:
> Thanks for all the help. The 2 dropdowns are now populating
> correctly and I'm happy with the way they are working. However a new
> problem is popping up. I know it's simply my inexperience with
> Reporting Services and will soon seem quite simple.
> The first combo chooses the AppID. When the user makes a choice most
> of the time the 2nd combo is not filled. But on certain choices the
> second is filled. The user then makes a selection on the second and
> a report should be returned.
> The second combo actually output an AppID, just like the first combo,
> only it is different number. The problem is that the report dataset
> only uses the AppID from the first combo and doesn't change to the
> second.
> I'm trying to figure out code or a function to force it to use the
> new AppID and ignore it when the 2nd combo is null. My experience is
> in classic vb and vba and DTS scripts. This all just doesn't seem as
> intuitive. I purchased the Hitchhiker book last night and this has
> helped my understanding.
> Thanks|||Thanks for all the help. It's working now.
--
Fairfield
"Fairfield" wrote:
> Hi,
> My instructions are to add more functionality to current reports by adding a
> second dropdown. The reports currently have one combobox that lists
> Application names. When an Application is chosen the report opens with all
> the data associated with that Application.
> Now there is a request to add a second combo that would only be visible if
> certain choices were made on the first combo. The choice from the second
> combo open the report with a more limited set of values from the same source.
> Currently stored procedures are used for the combos and the data returned
> from choices uses stored procedures with parameters.
> Is this possible to do and what is the best plan of attack?
> Thanks,
> --
> Fairfield

Mullti-report navigation through hyperlinking in Crystal Reports XI

Hi everybody.
I have 4 fields(columns) in report A, 3 fields in report B and 3 fields in report C. What I want is, when a user clicks on the values in the first field in report A, say EmpId, it should jump to report B with only the data for the EmpId on which the user clicked. Again, when the user clicks on the 3rd field in report B(the opened/generated from A), it should open the report C with corresponding values of report B. In short, it should jump from A->B->C.
A part of it can be achieved by using subreports, but it cannot jump from B->C.
Can anyone suggest anything.
Thanks in advance.
Waiting eagerly for reply.

Thanks.U can use on demand subreports, but a main report can have many subrepports but a subreport cannot have another subreport.

mssql,oracle reports or crystal reports

Hello
I am jumping between oracle and mssql
In oracle i use oracle reports which works fine
What do i use for MSSQL, can i use Oracle reports or should i buy some other one like crsytal reports
SEJCrystal reports would be the way to go without a doubt.

It can of course also be used to report against Oracle etc..

Mark

Originally posted by sjumma
Hello

I am jumping between oracle and mssql

In oracle i use oracle reports which works fine

What do i use for MSSQL, can i use Oracle reports or should i buy some other one like crsytal reports

SEJ|||Originally posted by mtracey
Crystal reports would be the way to go without a doubt.

It can of course also be used to report against Oracle etc..

Mark

where do i get the trial/free version is it part of multimedia suite

salim|||I don't know that you can get a free trial. It comes with Microsoft Visual Studio if you have it.

Crystal is a bit of an industry standard reporting tool.
Runs on MS platforms only though (unless they have some new products)

Here for more info.

http://www.crystaldecisions.com/products/crystalreports/default.asp