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

Results displayed in visual studio, but not on website

I've created a simple report (June CTP) based on a paramaterized stored procedure using integrated windows security. When I preview the report in the designer, I get results as expected. Deployment to the web server was successful. After entering paramaters and clicking [View Report], the page refreshes with no data - just my paramater bar. I am using the same paramaters as in the designer. Any ideas?
[405 byte] By [Cytosoul] at [2008-2-15]
«« executescalar returns incorrect number
»» Enabling Keyword Expansion
# 1
I was thinking it was a permissions issue, so re-deployed the report specifying sa in the datasource connection string. Still no dice.
Cytosoul at 2007-9-8 > top of Msdn Tech,SQL Server,SQL Server Reporting Services...
# 2
Not a parameter issue either, as I removed them and still have the same issue.
Cytosoul at 2007-9-8 > top of Msdn Tech,SQL Server,SQL Server Reporting Services...
# 3

Figured this out.

I didn't really remove the SQL paramaters, just ignored them in my SP. Apparently, even though I was allowing empty strings in one of the paramaters, this rule was being ignored and the report was not running. It wanted a value. After allowing nulls instead, the report ran fine.

I am not sure if this is bugged via web reporting, but it worked in the designer. Maybe an error message should be displayed, prompting for paramaters.

Cytosoul at 2007-9-8 > 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