作者:cheny 来源: 浏览:Loading... 日期:2013-07-12
下面是我的例子:
返回一大串,看得人头痛:
select ...
IsNull((select 1+IsNull(reshimat_mashtela_kav_tchuna.maslul_id * 0,-1) from reshimat_mashtela_kav_tchuna where reshimat_mashtela_kav_tchuna.kav_id = reshimat_mashtela_kav.kav_id
and reshimat_mashtela_kav_tchuna.reshimat_mashtela_id = reshimat_mashtela.reshimat_mashtela_id
and reshimat_mashtela_kav_tchuna.mispar_mashtela = reshimat_mashtela_kav.mispar_mashtela
and reshimat_mashtela_kav_tchuna.tchuna_type = 145),'') VeBM,
IsNull((select 1+IsNull(reshimat_mashtela_kav_tchuna.maslul_id * 0,-1) from reshimat_mashtela_kav_tchuna where reshimat_mashtela_kav_tchuna.kav_id = reshimat_mashtela_kav.kav_id
and reshimat_mashtela_kav_tchuna.reshimat_mashtela_id = reshimat_mashtela.reshimat_mashtela_id
and reshimat_mashtela_kav_tchuna.mispar_mashtela = reshimat_mashtela_kav.mispar_mashtela
and reshimat_mashtela_kav_tchuna.tchuna_type = 149),'') I1BM,
etc..
from table1, etc...
如何解决这个问题呢,修改代码,是真心无法解决的,这是一个来自数据库不服务器错误,唯一途径只能从数据库服务器中运行。你可以自己试试,欢迎一起交流学习。
Tag标签:Stimulsoft Rrport
上一篇: Stimulsoft Reports.Net使用交流:分配数据板块
下一篇: 注意用户变量数据列出现空值