Deploying Reports/Models with WSS 3.0 integrated mode

Using BIDS, and trying to deploy to a newly created reporting server. I can deploy the report but cannot figure out how to display it in the WSS 3.0 teamsite. My document library settings allow 'new report builder report' and 'new report datasource' but I don't see how to upload reports built in BIDS for use in the Sharepoint site.

Models that I created in BIDS I cannot deploy at all. Just get an error saying 'this operation is not supported in sharepoint integrated mode.

Anyone else worked through the deployment of existing datasources and reports yet to a WSS 3.0 reporting server in integrated mode?

If I just upload an RDL file to the document library and try to display it, I get the following:

System.Web.Services.Protocols.SoapException: An internal error occurred on the report server. See the error log for more details. > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.InvalidCastException: Specified cast is not valid.
at Microsoft.ReportingServices.Library.Security.get_UserToken()
at Microsoft.ReportingServices.SharePoint.Server.SharePointSecurity.GetCatalogItemPermissions(ItemType catItemType, Byte[] secDesc, String itemPath)
at Microsoft.ReportingServices.Library.GetPermissionsAction.PerformActionNow()
at Microsoft.ReportingServices.Library.RSSoapAction`1.Execute()
End of inner exception stack trace
at Microsoft.ReportingServices.Library.RSSoapAction`1.Execute()
at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.GetPermissions(String Item, String[]& Permissions)
End of inner exception stack trace
at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.GetPermissions(String Item, String[]& Permissions)
at Microsoft.ReportingServices.WebServer.ReportingService2006.GetPermissions(String Item, String[]& Permissions)

Which authentication mode did you choose, on the Reporting Services integration page in Central Admin? SP2 CTP2 only supports Windows Authentication mode.|||

I've changed back to the windows mode. And I'm a little better off. After publishing the RDL file in my shared documents, I'm only lacking a datasource. Can't quite figure out how to get that there.

Maybe it's time to upgrade my visual studio 2005 with the Sharepoint package for wss 3. Would that enable me to publish reports again directly from the BIDS project?

Where I'm stuck then is putting both data models and datasources up on the sharepoint site using the reporting services integrated mode.

|||

Solved the datasource issue by just creating it in the Sharepoint document library. Then hooked it up to the report I had loaded in manually using the 'Upload' menu. For the report you will find a 'manage datasources' context menu item off the report object.

Now if someone comes up with the answer of how to get the data models up to my Sharepoint server so that the report builder can be called on, I'll be in pig heaven.

|||

You can upload an .SMDL file into SharePoint, and it will "just know" that it's a Reporting Services model (because of the file extension).

In CTP3, Models are fully supported -- you can design in Model Designer, autogen from SharePoint, manage drillthroughs and model item security, and launch Report Builder from a model's ECB menu.

|||

Slowly but surely it is coming together. Now, the magical CTP3, when will that be posted?

I have a suggestion for CTP3 if you have not thought of it. These RS documents display context menus in the shared document library. But if I do a search, the search results page does not give me the ability to use the Report/Model/Datasource with the same contextual choices. Same idea when I display things with the 'dependent items' choice (which is a slick feature in and of itself). And the last display I'd expect more of would be the page that opens when you click on the found file would offer the same contextual choices. (reports open fine, but models don't link to the report builder and open)

Now wouldn't that be a totally seamless feature that would sweeten the end-user experience?

BTW, I'm still constructing datasources for each model or report I upload to a document library. Can I simply copy a datasource (extension=rds, or ds) and just change the extension to rsds before uploading it?

Deploying Reports with WSS 3.0 integrated mode

Hi ,

I am trying to deploy reports through visual studio. In the Target server URL, specified the url of the report server as http://<localhost>:<portnumber>/reportserver/Shared Documents/. But
When i deploy it asks for username and password. when i provide them, again login screen appears. Finally deployment fails when i press cancel.

Did anybody face this kind of problem ?

Thanks & Regards,
Kiran Kumar

For deploying reports to a Report Server in SharePoint Integrated mode use the updated Report Designer that ships with SQL 2005 SP2 CTP3. Additionally, it is reco'd to deploy to the SharePoint Document Library with settings as follows:
TargetDataSourceFolder: http://<MyServer>/<mySharePointsite>/Shared Documents/
TargetReportFolder: http://<MyServer>/<mySharePointsite>/Shared Documents/
TargetServerURL: http://<MyServer>/<mySharePointsite>/

Hope this helps.

thanx,
Prash

|||

Can you also check for the following in the web.config file of the SharePoint web site:

- Do you see multiple entries looking like (?):

<location path="_vti_bin/ReportServer/ReportServiceAuthentication.asmx">
<system.web>
<authorization>
<allow users="*" />
</authorization>
</system.web>
</location>

There should be only one such entry for the ReportServiceAuthentication.asmx in the web.config. Please ensure there is only one such entry and retry deploying.

This is a bug that we are working on fixing for RTM.

Depending on the selection of the user of the asp.net web-form how can i do changes in the

Hi frdz,

  I have created the following stored procedure in sql server 2005.

 In my database i have one option for the payment mode which can be done thru cash or credit(cheque).  

 I have created my web-application in asp.net with C# 2005.

 There i have a dropdownlist box for the user to select the option whether wants to do the payment thru cash or cheque.

Depending on that selection if user selects cheque then all the reqt for cheque like it's no,dt,bankname etc...are visible.

but if user selects the option as cash then the cheque details become invisible.

Depending on the selection of the user of the asp.net web-form how can i do changes in the stored procedure...  

i can write the condition like

if paymentmode=cash

then ........

else

..........

but where and how can it be written ...pls tell me

thanxs in adv...u can go thru my below SP  

ALTER PROCEDURE MiscellaneousStoredProcedure @.miscidint output, @.storenamevarchar(20),--store name to storeid @.accountnamevarchar(20), @.groupnamevarchar(20), @.paymentdtdatetime,@.payeenamevarchar(30),@.paymodevarchar(20),@.banknamevarchar(50), @.chqdtdatetime, @.chqnovarchar(20), @.amtnumeric(10, 2),@.balnumeric(10, 2), @.remarksvarchar(50)asdeclare@.storeidint,@.accountidint,@.groupidintbeginset nocount onselect @.miscid =isnull(max(@.miscid),0) + 1from miscellaneourpayifexists (select *from storemasterwhere storename = @.storename)select @.storeid = storeidfrom storemasterwhere storename = @.storenameifexists (select *from accountmasterwhere accountname =@.accountname)select @.accountid = accountidfrom accountmasterwhere accountname =@.accountnameifexists (select *from accountgroupmasterwhere groupname=@.groupname)select @.groupid=groupidfrom accountgroupmasterwhere groupname=@.groupnamebegin transactioninsert into miscellaneourpay(miscid,storeid,accountid,groupid,paymentdt,paymode,payeename,bankname,chqdt,chqno,amt,bal, remarks)values( @.miscid,@.storeid,@.accountid,@.groupid,@.paymentdt,@.paymode,@.payeename,@.bankname,@.chqdt,@.chqno,@.amt,@.bal,@.remarks)commit transaction end

What about creating two different stored Proceedures for both cases?|||

Hi,

Try to use two different stroed procedure for cash and credit. The value from your DropDownList decides which one to use. In this way,you can make your stored procedure easier.

Thanks.