| |
ActiveReports for .NET 3.0 Support
Started by Mathew at 03-05-2010 2:56 AM. Topic has 4 replies.
  
|
|
Sort Posts:
|
|
|
|
 03-05-2010, 2:56 AM
|
Mathew
Joined on 08-25-2009
Slovenia
Posts 26
|
Problems with parameters (bool)
|
|
|
|
|
I have a problem that I get in my ActiveReports.
I get into parameters <%BuyerType%> false instead 0. That SQL don't suport and that why I get error "Invalid column name 'false'."
EXAMPLE: when (TRUE = 1) then DealerPriceWOTax -> THAT IS WORNG
when (1 = 1) then DealerPriceWOTax -> THAT IS RIGHT
That hapens ON MY NEW SERVER (Windows server 2003 R2)
I have tested on diferents servers (computers) and the two of one works ,but the third don't work?
Is maybe SOMETHING wrong something in Framework???
PLease help me.
SELECT DocumentPos.ArticleID, ArticlePartList.PartID,
Articles.Title,
Articles.SupplierArticleID,
Articles.MeasureUnitID,
ArticlePartList.Quantity,
DocumentPos.PrintPartList as Prikazi
,case when (<%BuyerType%> = 0) then CustomerPriceWOTax
when (<%BuyerType%> = 1) then DealerPriceWOTax
Else ''
END as CenaBrezDDV,
case when (<%BuyerType%> = 0) then CustomerPriceWTax
when (<%BuyerType%> = 1 ) then DealerPriceWTax
Else ''
END as CenaZDDV
|
|
|
|
|
Report
|
|
|
|
|
03-07-2010, 9:53 PM
|
AnkitN
Joined on 03-03-2009
Posts 844
|
Re: Problems with parameters (bool)
|
|
|
|
|
|
If I understood your issue correctly then you are getting the value of “BuyerType” as Boolean instead of number/integer i.e True instead of 1 and False instead of 0.
Could you please let me know the data type of “BuyerType” in the database?
Are you getting the type difference in other machines also?
Regards,
Ankit Nigam
|
|
|
|
|
Report
|
|
|
|
|
03-07-2010, 11:16 PM
|
Mathew
Joined on 08-25-2009
Slovenia
Posts 26
|
Re: Problems with parameters (bool)
|
|
|
|
|
|
Hi,
I get this error only on one maschine.
The BuyerType is String and I did even try as bolean, but doesn't work.
I get this error only in one maschine.
|
|
|
|
|
Report
|
|
|
|
|
03-07-2010, 11:36 PM
|
AnkitN
Joined on 03-03-2009
Posts 844
|
Re: Problems with parameters (bool)
|
|
|
|
|
|
Hello,
I would suggest you to use the following parameter syntax in the SQL query
‘<%BuyerType | PromptString | DefaultValue | S%>’ = ‘0’
Regards,
Ankit Nigam
|
|
|
|
|
Report
|
|
|
|
|
03-08-2010, 1:17 AM
|
Mathew
Joined on 08-25-2009
Slovenia
Posts 26
|
Re: Problems with parameters (bool)
|
|
|
|
|
|
Thax for that Info.
That works.
Thanx
|
|
|
|
|
Report
|
|
|
|
|
GrapeCity » Product Support » ActiveReports f... » Problems with parameters (bool)
|
|
|
|
|