Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM SQL » View Thread |
Messages 1 to 4 of 4 total |
Multi value parameter is not supported by data extension |
Wed, Aug 17 2011 12:48 PM | Permanent 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 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. 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 AM | Permanent 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 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. 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 |
This web page was last updated on Friday, March 29, 2024 at 03:30 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |