Dynamic Select Query - SQL Server Forums

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.

All Forums

SQL Server 2012 Forums

Analysis Server and Reporting Services (2012)

Dynamic Select Query

Author

Topic

Zocker-3001
Starting Member

1 Post

Posted - 2014-04-30 : 05:00:34

Hi there,

I have a SQL Select:

= "SELECT Form, Nummerzuweisung, Bestellnr, ltsnArtPlanVk, teil, BELEGNR, MENGE, MIETDAUER, RABATT2, Gesamt, rabatt, BEL_TYP, BEL_DATUM, Kuli, KdNr_OpSystem, Firma, Branche, teil_ausld, teil_kz_ok, kundverf, teil_bez1 FROM Ablaufdatum_Auswertung WHERE Firma is Not Null and teil_ausld > " & Parameters!teilausld.Value & " "

i become "Error has occurred during report processing" but why i not know. I Think my Select fx is right.

teil_ausld = Date

or the same Select i make with Text and include iif but the Error is the Same.

= "SELECT Form, Nummerzuweisung, Bestellnr, ltsnArtPlanVk, teil, BELEGNR, MENGE, MIETDAUER, RABATT2, Gesamt, rabatt, BEL_TYP, BEL_DATUM, Kuli, KdNr_OpSystem, Firma, Branche, teil_ausld, teil_kz_ok, kundverf, teil_bez1 FROM Ablaufdatum_Auswertung WHERE Firma is Not Null " & iif(Parameters!Kunde.Value = "<alle>", "", " and KdNr_OpSystem = '" & Parameters!Kunde.Value & "'") & "

can you help me?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources