时间戳

首页 > 解决方案 > 尝试根据用户输入选择表，但它不起作用

sql-server - 尝试根据用户输入选择表，但它不起作用

问题描述

我是水晶报表的新手，我正在尝试根据 SAP 水晶报表中的用户输入更改选定的表，但是当我输入一个值时，它会显示一条错误消息，这是代码：

if({?Type}='Commande client') begin select rdr1.docentry,rdr1.itemCode, rdr1.dscription, rdr1.quantity,rdr1.price,rdr1.currency,rdr1.slpCode,rdr1.basedocnum,
rdr1.shiptocode,rdr1.shiptodesc,rdr1.baseprice,rdr1.itemtype,ordr.docnum,ordr.doctype,ordr.docstatus,ordr.docTotal,ordr.docdate,
ordr.cardcode,ordr.cardname,ordr.address,ordr.doccur,ordr.paidtodate,ordr.doctime,ordr.docsubtype,ordr.basetype,
ordr.baseEntry from ordr inner join rdr1 on ordr.docentry=rdr1.docentry end

if({?Type}='Offre/Devis client') begin select qut1.docentry,qut1.itemCode, qut1.dscription, qut1.quantity,qut1.price,qut1.currency,
qut1.slpCode,qut1.basedocnum,qut1.shiptocode,qut1.shiptodesc,qut1.baseprice,qut1.itemtype,oqut.docnum,oqut.doctype,oqut.docstatus,
oqut.docTotal,oqut.docdate,oqut.cardcode,oqut.cardname,oqut.address,oqut.doccur,oqut.paidtodate,oqut.doctime,oqut.docsubtype,
oqut.basetype, oqut.baseEntry from oqut inner join qut1 on oqut.docentry=qut1.docentry end

if({?Type}='Livraison client') begin select dln1.docentry,dln1.itemCode, dln1.dscription, dln1.quantity,dln1.price,dln1.currency,
dln1.slpCode,dln1.basedocnum,dln1.shiptocode,dln1.shiptodesc,dln1.baseprice,dln1.itemtype,odln.docnum,odln.doctype,odln.docstatus,
odln.docTotal,odln.docdate,odln.cardcode,odln.cardname,odln.address,odln.doccur,odln.paidtodate,odln.doctime,odln.docsubtype,
odln.basetype, odln.baseEntry from odln inner join dln1 on odln.docentry=dln1.docentry end
```[text is in French but it basically translates to: impossible to extract data from data base
Native error: 102 [supplier code of the database: 102 ][1]
could anyone tell where the problem is.


  [1]: https://i.stack.imgur.com/Pro8O.png

标签： sql-servercrystal-reportscrystal-reports-2013

解决方案

找到了修复它的方法，它只需要引号：

声明@type nvarchar(30)

设置@type='{?Type}'

推荐阅读