Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> SQL Server >> SQL Server Reporting Services

Reporting Services with Parameter

I can not build a report correctly with reporting services using a select parameter can anyone point me in the right direct of a step by step article I would be very appreicative.
[179 byte] By [RayClark096] at [2007-12-24]
«« User Aware Service
»» partial serialize/deserialize a structure
# 1
2 ways:
1) you have a parameters-tab for your dataset where you can define sql-parameters depending on your report parameters
eg @sqlparam=reportparam and use @sqlparam in your query

2) if your query is more complex, dont use the querybuilder and use a commandtext for the query
that looks like ="SELECT * FROM XY WHERE ab="+Parameters!par1.value

hope this helps you a bit

GerhardBrueckl at 2007-8-31 > top of Msdn Tech,SQL Server,SQL Server Reporting Services...
SQL Server
SQL Server Reporting Services

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified