Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 4 of 4 total
Thread Multi value parameter is not supported by data extension
Wed, Aug 17 2011 12:48 PMPermanent Link

lrsgk35

I am using Business Intelligence Development Studio (SQL Server 2005) with a ODBC connection to the DBISAM database provided to me by ACS technologies that interfaces with their ACS software.

I am trying to use two multi-value parameters with the following SQL statement

SELECT "awgrgrp_mg"."Name" as MasterGroup, "awgrgrp_cls"."Name" as Class, "awgrgrp_div"."Name" as Division, "awgrrost"."DateRemoved", "awgrindv"."First_Name", "awgrindv"."Last_Name", "awgrindv"."Family_Number", "awgrresf_position"."Value"
FROM   {oj ((((("awgrgrp" "awgrgrp_mg" LEFT OUTER JOIN "awgrgrp" "awgrgrp_div" ON "awgrgrp_mg"."GroupID"="awgrgrp_div"."ParentID") LEFT OUTER JOIN "awgrgrp" "awgrgrp_dpt" ON "awgrgrp_div"."GroupID"="awgrgrp_dpt"."ParentID") LEFT OUTER JOIN "awgrgrp" "awgrgrp_cls" ON "awgrgrp_dpt"."GroupID"="awgrgrp_cls"."ParentID") LEFT OUTER JOIN "awgrrost" "awgrrost" ON "awgrgrp_cls"."GroupID"="awgrrost"."GroupID") LEFT OUTER JOIN "awgrindv" "awgrindv" ON "awgrrost"."IndvID"="awgrindv"."IndvID") LEFT OUTER JOIN "awgrresf" "awgrresf_position" ON "awgrrost"."ReserveID1"="awgrresf_position"."ReserveID"}
WHERE  "awgrrost"."DateRemoved" IS  NULL  AND "awgrgrp_div"."Name"=? AND "awgrgrp_mg"."Name" IN (?) AND ("awgrresf_position"."Value"='Registered' OR "awgrresf_position"."Value"='Regular')
ORDER BY "awgrgrp_mg"."Name"

However, I am getting the following error:

An error occurred during local report processing
An error has occurred during report processing
Cannot add multi value query parameter "?" for data set "DataSource1" because it is not supported by the extension.

I am able to run multi value parameters with Crystal Reports but I am thinking of switching to Microsoft Reporting Services.

Are you able to tell me how to use a parameter that can hold 2 or more values in BI Development Studio?

Thank you,
Wed, Aug 17 2011 2:59 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com


<< However, I am getting the following error:

An error occurred during local report processing
An error has occurred during report processing
Cannot add multi value query parameter "?" for data set "DataSource1"
because it is not supported by the extension. >>

DBISAM doesn't support using a single parameter marker for multiple query
values (most engines do not), so that is probably the cause.

--
Tim Young
Elevate Software
www.elevatesoft.com
Tue, Sep 20 2011 10:44 AMPermanent Link

lrsgk35

In Crystal Reports XI, I can setup a multivalue parameter and use it with DBISAM.  But when I am using Visual Studio 2005 I cannot.  I need to know if I can create multivalue parameters in Visual Studio and pass them to the DBISAM dataset.
Fri, Sep 23 2011 3:38 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

<< In Crystal Reports XI, I can setup a multivalue parameter and use it with
DBISAM.  But when I am using Visual Studio 2005 I cannot.  I need to know if
I can create multivalue parameters in Visual Studio and pass them to the
DBISAM dataset. >>

Crystal Reports is probably "massaging" the multivalue parameters
automatically into an IN (Value1,Value2,Value3) type of SQL condition.  To
do the same in Visual Studio with the ODBC.NET data provider, you would
simply specify the IN condition manually.

--
Tim Young
Elevate Software
www.elevatesoft.com
Image