.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Forum >> Sql Server >> Post New QuestionBookmark and Share Subscribe to Forum

I am using Pentaho Report Builder -- what is wrong with my code -- brings back "No Data"

Posted By: mbuchanan     Posted Date: October 11, 2011    Points:5   Category :Sql Server
SELECT
"RPT_CLIENT_PROGRAMS"."BEGIN_DATE",
"RPT_CLIENT_PROGRAMS"."CLIENT_ID",
"RPT_CLIENT_PROGRAMS"."END_DATE",
"RPT_CLIENT_PROGRAMS"."PROGRAM",
"RPT_CLIENT"."FULL_NAME"
FROM
"RPT_CLIENT_PROGRAMS" INNER JOIN "RPT_CLIENT"
ON "RPT_CLIENT_PROGRAMS"."CLIENT_ID" = "RPT_CLIENT"."CLIENT_ID"

WHERE
( "RPT_CLIENT_PROGRAMS"."PROGRAM" <> 'Referrals Crisis Screening (CS-R)'
OR "RPT_CLIENT_PROGRAMS"."PROGRAM" <> 'Referrals CS Jail Diversion (CSJD-R)'
OR "RPT_CLIENT_PROGRAMS"."PROGRAM" <> 'Partial Care Referrals (PC-R)'
OR "RPT_CLIENT_PROGRAMS"."PROGRAM" <> 'Intensive Outpatient Referrals (IOP-R)'
OR "RPT_CLIENT_PROGRAMS"."PROGRAM" <> 'PACT Referrals (PACT-R)')

AND "RPT_CLIENT_PROGRAMS"."BEGIN_DATE" >= ${Start}
AND "RPT_CLIENT_PROGRAMS"."BEGIN_DATE" <= ${End}

ORDER BY
"RPT_CLIENT_PROGRAMS"."PROGRAM" Asc

Responses

No response found. Be the first to respond this post
Post Reply

You must Sign In To post reply
 
 
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more Here
Quick Links For Forum Categories:
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  OOPs  SilverlightIISJQuery
JavaScript/VBScriptBiztalkWPFPatten/PracticesWCFOthers
www.DotNetSpark.comUnAnsweredAll

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend