Bob's SQL Reporting Services Blog

Bob, thanks for these launch parameters. When you use the parameter to automatically load a specific model it bypasses the first window where you select a model and report type and goes directly to the design view. In the design view it does not provide you with a drag and drop area. Is there a solution to this.

Is there a way to hide the Report Builder button, but still access it via the URL?

Bob,

I use http://<servername>/reportserver/reportbuilder/reportbuilder.application  launched reportbuilder.

When user created an report and Save / Save As we like to store the report name and path to our database. How can I interface with report builder?

Thanks,
tim

Do you have an update on the issue with it skipping the screen where you choose table/matrix/chart? I tried this under SP1 and it still skipped the screen.

Any ideas as to why the Report Builder button does not show on my Report Manager form/toolbar?

I can still access via URL, just not RB button.

Thanks.

Great.  Thanks Bob.

Here's another one.  We are using Forms Auth and have been wrestling with an "Object moved..." error when a SOAP call is made to the ReportService2005 web service (ListChildren(), for example).  A month after opening an incident w/ MS we got some code to get around this error -- was pretty simple, actually.

Well, I just got the "Object moved..." error again in Report Builder.  The error popped up when I attempted to move to page 2 of a report -- I am guessing about the time my session would have timed out due to no activity in a web app --, then again every time I clicked Run Report.  

I was busy in Report Builder constantly making (and testing) a report.  RB is a client app, right?  However, it is launched by accessing a URL.  Does this make RB subject to a timed out session?  Any suggestions?

Thank you !!

re: "Object moved..." error.

Now I am having no problems.  I've had a report open in Report Builder for quite some time in design mode and all is working fine (designing / running / etc).

I'm not sure what is worse: a problem, or a sporadic problem.

Still interested in any ideas.

Thanks.

Great stuff, Bob. Thanks, as always. There a couple of useful things related to this which you may know how to enable (they're not discussed in the docs you point to).

First, what if one wanted to open the ReportBuilder so that instead of opening a given model, it instead shows that model only (and its available perspectives) in its "select a source of data" (the right pane where one would select from available models)? Is there any means to ask for that?

Similarly, what if one has setup various folders. Is there any way to launch the ReportBuilder with it showing only the models in a given folder? I've tried a "folder" and "path" parameter, both of which were rejected with an error stating that the parameter given was "unexpected" and that "all parameters would be ignored".

Even if you don't know of any parameter to do what I ask, might you be able to ask someone with access to the source code or its internal docs to get a list of all parameters that the ReportBuilder.application does accept? There may be one there that the doc writers just didn't think to mention. Any help would be appreciated. Thanks

As another follow-up to your points, is there also a parameter we can use when launching the Reportbuilder to specify where reports should be saved, by default? It would seem a useful corollary to the parameter to open the RB at a given model.

Do you have any guidance on how to actually reference a Perspective from within the Report Designer. Although I suppose it may be possible to work out the Perspective ID, it would surely be more user friendly to allow the Friendly Perspective Name to be entered. Probably SP3 plus request, but thought I'd ask just in case we are missing some check box / configuration / set up parameter somewhere, or even an alternative data source definition mechanism etc...:)

Having problem using URL to launch a report model and a selected Perspective; Using SQL 2005 SSRS - generating a Report Model in MOSS 2007 against a cube with one defined perspective. I try and specify a Perspective ID (not the perspective name) and the model fails to open saying no such perspective exists in the model.

I can find no way to get the following documented methods to work for getting the Perspective id: "You can find the perspective ID by opening SQL Server Business Intelligence Development Studio, selecting the perspective in list view, and then copying the General Category ID number in the Properties window. Alternatively, view the report model XML and search for the <Perspectives> tag. The perspective ID is listed within the <Perspectives> tag." quoted from SQL Server Developer Center MSDN

I cannot get the "list view" when viewing a cube Perspective in BIDS. Alternatively, when I view the content of the Report Model file, the "Perspective ID" it gives are not of the same format I'd expect for the GUID. They look like: "udm:Perspective_Cube_<Perspective_Name>", and they do not work when I try and use them in the URL.

Any ideas on how else I can get the perspective id -or- allow the top level cube to be used in Report Model (and not force user to specify a perspective)? I have spent a good amount of time so far...