Hi all, when i create a reports deploy on the Report server, i usually choose a filter prompted on Run. The lsit containt for example the list of my customers, but the list in empty like i want (like that, user can put a list from excel by copy-paste). But ... , if the want all the customers, what is the " * " operator to select all my records ?
Thanks for help
Erwan, France
Do you meanIn a drop down for a report parameter you want <all> to appear?
Hello,
I use a Report Model Project to build a Report Model and I'd like to deploy it on my production server (Win 2003 server).
I can't use Visual Studio to deploy since I don't have web access to the server (only Remote Desktop access)
The command line tool RS seems to work for a simple report (rdlc) but I have a model (smdl)...
Hi
Did you find a solution to this problem?
Cheers
|||
Not sure this is exactly what you arelooking for, I tried this tool and it solved my problem,
Reporting Services Scripter -http://www.sqldbatips.com/showarticle.asp?ID=62
Overview
Reporting Services Scripter is a .NET Windows Forms application that enables scripting and transfer of all Microsoft SQL Server Reporting Services catalog items to aid in transferring them from one server to another. It can also be used to easily move items on mass from one Reporting Services folder to another on the same server. Depending on the scripting options chosen, Reporting Services Scripter can also transfer all catalog item properties such as Descriptions, History options, Execution options (including report specific and shared schedules), Subscriptions (normal and data driven) and server side report parameters.
