Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
urpalshu
Starting Member
21 Posts |
 Posted - 2006-04-20 : 18:02:58
|
| I have a data set in Reporting Services Report (2003)if (@prmAudit = 0 or @prmCellType = 0)BEGIN select top 5000 * from NECCCUSTAUDIT.dbo.vw_cust_audit_billing_problem b where datediff(d,@prmStartDate,b.fld_date_time) >=0 and datediff(d,@prmEndDate,b.fld_date_time) <=0 and b.fld_problem_type like @prmType + '%'ENDif (@prmAudit = 1 or @prmType = 0) BEGIN select top 5000 * from NECCCUSTAUDIT.dbo.vw_cust_audit_cell_problem b where (DATEDIFF(d, fld_date_time, @prmStartDate) <= 0) AND (DATEDIFF(d, fld_date_time, @prmEndDate) >= 0) and fld_problem_type not like 'A%' AND b.fld_problem_type like @prmCellType + '%' END-----------------------------------------------------------------------When I preview my reportEnter the Fist Date, Last Date, prmAudit, prmType >> I do not select anything for prmCellTypeThere is no data seen, it is totally blank.>> When I select FistDate, LastDate, prmAudit, prmType and prmCellType It works all fine.Question: I want my query to accept @prmType as blank, so I went to Reports-->ReportParameter and allowed for Blank. This parameter is a string.Still my Report does not do what I want?Please could somebody help me correct my query or give a better solution.Thank you, |
|
|
snktheone
Starting Member
20 Posts |
Posted - 2006-04-30 : 16:53:11
|
| also for prmCellType try doing this Reports-->ReportParameter and allowed for Blankhope i gave u a quick fix-www.snktheone.com |
 |
|
|
|
|
|
|
|
Allow Blank String