Web service as a data source for a SSRS report

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Reporting Svcs
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - Installation on Windows 2000 Server I have a client that has run SQL Reporting Services 2000 for the last 4 years. They have have installed SQL Server 2005 and are finally ready to move their reporting services to the new version. The installation completed without error. Running the configuration, steps 1 - 4 went through seamlessly, however when attempting to set the Web Service Identity, the ASP .NET Service Account is blank. All attempts at manually changing the rsreportserver.config file have made no change. Help please. They are running Windows 2000 Server SP4, IIS5. Thanks in advance. Tag: Web service as a data source for a SSRS report Tag: 80695
  - 2
    - Totals with Top N or other filter When using the Top N operator on the detail section, any group totals continue to display the totals for the entire set. For example, if I want to see the top 5 products for each department by sales, and I have a group on department, I want the totals to reflect just those top 5 products for each department, but the totals reflect all products. We put a query in to MS, and they said this was by design. Does anybody have a workaround for this? Tag: Web service as a data source for a SSRS report Tag: 80693
  - 3
    - Aligning Matrices and tables in SRS I am working on creating custom report cards for our school district using SRS 2005. The problem I'm having is that I have several Matrices and tables side by side on the report and I have set the items to be in the correct spot on the layout tab but when I go to preview the report there is an excess of white space between the different areas making the report longer. Different things I've tried are: I had one rectangle for all the tables and matrices on the report and they were all in one but still had the same problem. Tried seperate rectangles for each column of tables and matrices with the same result Tried seperate rectangles for each of the items with the same result. All Items are grouped together but I have yet to figure out how to keep the items together on the report. I was going to attach some screen prints but the forum won't allow attachments so you can see what I'm looking at. Thanks in advance for any suggesstions. -- Wayne Hess Tag: Web service as a data source for a SSRS report Tag: 80692
  - 4
    - Upload rdl file via Report Manager Hi All, I am trying to "manually" deploy a report to my Reporting Services Server using Report Manager. Basically, I used the Business Intelligence Development Studio to create my report. After that, I have tried to upload my report using Report Manager. Namely, I tried to do an "Upload File" of the .RDL file. The report itself showed up correctly but when I invoked it, I noticed that it does not provide the two datetime parameters that I specified as needed in my report. Basically, my report consists of running a stored procedure that takes two datetime parameters. When I preview the report, it does contain the two date time parameters that the user can populate and works correctly. But as I said, when I manually upload it to the server, it does not. I also tried to upload the .data file associated with my report but that didn't change anything. BTW, I have created other reports that call stored procedures and that require 2 datetime parameters and they all worked correctly. The difference was that I used the "Deploy Report" option in Business Intelligence Development Studio rather than manually uploading the .RDL file. Am I missing something? Thanks! Tag: Web service as a data source for a SSRS report Tag: 80691
  - 5
    - Report Services Web Part - How to set default zoom I am using a report services web part in sharepoint. The Report was designed using Visual Studio 2005 and I can't figure out how to change the Report Web Part's default Zoom from 100% to 75%. Any help would be appreciated. Tag: Web service as a data source for a SSRS report Tag: 80690
  - 6
    - restrict report folders hello. I need help with this report permission issue that is driving me nuts. On the report server we have certain reports folders that is suppose to ONLY be visible by departments. Now all the folders and contents can be seen by every user. I went and created a folder stripped all the permission and left just my account and it still visible by others. Can any help with identifying where permissions are inherited from or how to resolve this issue. Thanks in advance for your help. Tag: Web service as a data source for a SSRS report Tag: 80688
  - 7
    - Render a dynamic image with handler Hello, All. I'm trying to use a HttpHandler( .ashx ) to generate dynamics images. I have a image object in my report with the source property setted to "External" and a expression to my handler. If i try to use the handler outside of the report everything works , but inside the report the image is never showed. Everyone already try to use this! Eug=EAnio Tag: Web service as a data source for a SSRS report Tag: 80687
  - 8
    - How to load in ReportViewer a rdlc report located in another assembly Hi, I'm using VS2008 and I'm trying to use ReportViewer in WinForm applications. I created a project containing a report that i have to load in a ReportViewer control. The ReportViewer control is in a different project so i referenced the project where the report is contained as embedded resource. I tried to load the report with this code: ReportViewer.LocalReport.ReportEmbeddedResource = "MyApp.Reports.MyReport.rdlc"; but when i try to load the report i receive the following error message: "The report definition for report 'MyApp.Reports.MyReport.rdlc' has not been specified" So, how can I solve this? Tnx Tag: Web service as a data source for a SSRS report Tag: 80683
  - 9
    - SSRS - Get IP - returning wrong IP address I am trying to resolve a simple problem, yet am again totally stuck - please help!! I have 2 datasets - one dataset should get the IP Address of the person running the report: SELECT client_net_address as p_IP_Address FROM master.sys.dm_exec_connections WHERE session_id = @@SPID; I pass the p_IP_Address from this dataset as a default value for the report parameter into my second dataset - which merely runs a simple SP to get several rows which are displayed on the report - this is working fine now. The GET_IP_Address dataset does return one row with one field - but it is returning the IP Address of the SSRS SQL Server machine - where the RDL is run from - not the end-user IP Address. I have tried several different tacks to get the correct IP address into the second dataset, but to no avail. When the report is run in Visual Studio 2005, it shows the correct IP Address, but when I deploy it to the produciton server, and then run it - it does not return the IP address of the person running the report - the report is executed via URL. Please help -- vpdj @ yahoo.com TIA Tag: Web service as a data source for a SSRS report Tag: 80681
  - 10
    - SQL Server 2005 express "report design" folder not found I user SQL server 2005 express reporting service to design a report, also a net .dll library is required , i need to copy it to "C:\Program Files\Microsoft SQL Server\80\Tools\Report Designer.", however i can not find this folder on my box, i can only see "C:\Program Files \Microsoft SQL Server\80\Tools\", there are "Binn" and "Devtools" sub folders under that folder, no "Report Designer" sub folder, did I miss something during installing SQL Server 2005 and SQL Server 2005 Toolkit? Thanks, Bob Tag: Web service as a data source for a SSRS report Tag: 80680
  - 11
    - Kerberos Errors and Reporting Services only accesable from localho I've setup SQL Reporting Services 2005 a coupld of times in the past have never had this issue. However this time, it seems that the reporting sites are only available via the http://localhost/reports Logon fails when trying to login to the sites via their fqdns and I'm getting kerberos errors in my systems logs. I've tried using setspn for this however, it just doesn't seem to resolve the issue. Right now my only work around it to run of integrated windows security in IIS and turn on basic authentication. However some links still wnat users to login via http. Has anyone run into an issue like this where integrated windows authentication will not work to authenticate users to the SSRS web sites (if so how can on resolve the issue). Tag: Web service as a data source for a SSRS report Tag: 80679
  - 12
    - How do you create a new chart for each variable? I am using SSRS 2005 SP2. I am wondering if it's possible to create a new chart for every variable from a query. My data consists of server/database/log sizes. So server A has databases DB1, DB2, DB3. I want to have each database/log pair show on a separate chart. Eash server could have several databases and of course databases could come and go, so this needs to be dynamic. Is this even possible? Thanks, Peter Cwik Tag: Web service as a data source for a SSRS report Tag: 80677
  - 13
    - Sub-report within Matrix Hello, Is it possible insert a table as subreport into a Matrix? What i want is to allow the user to drill-down and see the detail of the matrix. Thanks in advance, Carlos Tag: Web service as a data source for a SSRS report Tag: 80675
  - 14
    - Error when i try access Report Server Hello, After i applied SP2 in a Cluster of SQL SERVER 2005 the Report Server stop working. The message is "The report server cannot open a connection to the report server database. The logon failed. (rsReportServerDatabaseLogonFailed) Get Online Help For more information about this error navigate to the report server on the local server machine, or enable remote errors " How can I fix this issue ? I already try rsconfig to recreate the key. Thank you. Marcelo. Tag: Web service as a data source for a SSRS report Tag: 80674
  - 15
    - RSViewerPage failing RSViewerPage.aspx will not display reports. Configuration- Reporting services in Sharepoint Integrated mode, all security is managed in the underlying database. Data model and connection use integrated security. User can create and modify Sharepoint content freely in the reports folder. If we create a wep part page, we are able to add a reporting web part, which shows the data appropriate to that user. However, when RSViewerPage.aspx tries to render a Reporting Services Report, 'Access Denied' is returned to the browser. Something specific to the execution of RSViewerPage.aspx is failing. Is there anything else I should be investigating? Tag: Web service as a data source for a SSRS report Tag: 80672
  - 16
    - gif image shows jpg image does not I am puzzeled as to why one image type will show in the browser when the report is viewed and the other type (jpg) will not. I have both image files in the same folder as the report. When I view the report with te gif image and select the properties for the image I get all the infomationsuch as type = GIF location etc. When I use the jpg image I get a red x box and no values show for the image when right clicked and the properties option is selected. Any ideas of why this may be? Thanks, Tag: Web service as a data source for a SSRS report Tag: 80669
  - 17
    - SSRS-Grand totals in the last page when grouping is applied Hi All, My report consists of a single group based on customer name and we print totals in group footer for each customer. The "Page Break On End" is set to true for the group. I have also placed the grand totals in the table footer. However, the grand total alone prints in the new page, after the last reporting group. I want it to be printed just below the group total of the last group in the report, instead of printing in a new page. Is there any way to do it?. Any help will be appreciated. Cheers, Pradeep Tag: Web service as a data source for a SSRS report Tag: 80667
  - 18
    - Subscriptions on SRS 2005 We are in the process of migrating all of our reports from anSRS 2000 implementation to an SRS 2005 implementation, and I am having a problem with subscriptions. On the old box, when someone wanted to subscribe to a report, they simply clicked on the subscription link and their domain name (example: pmcbride) would appear in the To: field. They would add a subscription, hit enter, and the subscription would work. Now, it appears to work exacltly the same. However, when they submit the description, it does not work. Why? Because the new implementation requires not just the domain name, but the entier email address in the To: box. So where the subscription page opens with "pmcbride" on the screen, what SRS needs is the full email address of pmcbride@mycompany.com. Did we forget to set some important configuration? Thanks in advance... Paul Tag: Web service as a data source for a SSRS report Tag: 80658
  - 19
    - Adding a dataset problem Good Morning, I have a very frustrating problem. I have a report that needs two datasets from two different data sources. i have reaports that already have multiple datasources, and eveything is okay. THis report however, when i add the dataset and source, once i save the report, it chages the datasource. let me explain: dset A uses dsource 1 i added dset B that uses dsource 2 everything sets up ok, then, i go into the properties of dset A, and it has dsource 2 as the dsource if i change that back to 1, then it changes dset B's dsource to 1 also This is really driving me nuts! TIA ~K -- Message posted via SQLMonster.com http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200807/1 Tag: Web service as a data source for a SSRS report Tag: 80655
  - 20
    - Reporting Services - Portfolio Server Installation/Config Issue Hello I'm setting up a demo box for Portfolio Server for the PM group. I installed everything on the one box for the demo: Microsoft Windows Server 2003 R2 SP2 SQL Server 2005 SP2 SharePoint Server 2007 SP1 Project Server 2007 SP1 Portfolio Server 2007 After installing SQL Server, I ran the configuration utility for Reporting Services and everything was successful. After installing Portfolio Server 2007, I was supposed to check to see that the Reporting Services integration was successful by browsing to a couple of sites: http://<servername>/ReportServer http://<servername>/Reports I can navigate to http://<servername>/ReportServer, but when I navigate to http://<servername>/Reports I get the following error: Server Error in '/Reports' Application. -------------------------------------------------------------------------------- Configuration Error Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately. Parser Error Message: Cannot use 'partitionResolver' unless the mode is 'StateServer' or 'SQLServer'. Source Error: Line 183: </webParts> Line 184: <machineKey validationKey="588ECF8DDE8B5707B90224C2C11E60EAA6B8A6974AC80560" decryptionKey="74F69FA872AED6DDB83CEECC7644DCE1FFDB34ECF6A949CF" validation="SHA1" /> Line 185: <sessionState mode="SQLServer" timeout="60" allowCustomSqlDatabase="true" partitionResolverType="Microsoft.Office.Server.Administration.SqlSessionStateResolver, Microsoft.Office.Server, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" /> Line 186: </system.web> Line 187: <runtime> Source File: c:\inetpub\wwwroot\web.config Line: 185 -- any help would be appreciated. Tag: Web service as a data source for a SSRS report Tag: 80652
  - 21
    - Dynamic Report on Dynamic recordset sorry, maybe I didn't searched enough, but I can't find an answer for this question ... I'd like to build a dynamic report based on a dynamic record set. How can I do it? Just to make me understand, here you find an hypothetical origin of data I'd like to output: create procedure [dbo].[SP_Dynamic_report] @param int =1 as BEGIN if @param=1 select top 10 * from SYSOBJECTS else select top 10 * from syscolumns end then the user can chose between param 1 or 2 and get in the same report different data ... exec [SP_Dynamic_report] 1 exec [SP_Dynamic_report] 2 Is it possible? Can you provide me an example? or a link? Thank you very much for any help! Lorenzo Tag: Web service as a data source for a SSRS report Tag: 80649
  - 22
    - Can I define what order I want reports displayed via SQL Server I have a list of reports, which I have published into one folder. Ideally, I would like to order the reports when the user logs onto the web page. At the moment they default to A to Z sorting. Users would not want to see the details screen. can this be done? Thanks Paddy Tag: Web service as a data source for a SSRS report Tag: 80647
  - 23
    - What is the best way to setup SSIS, SSRS, SSAS within a two note cluster? Hi All, I'm fairly new Clustering and I'm looking for advices. I have successfully setup a test SQL Server Database Engine on a two node ( passive/active ) cluster using MS Virtual Server. I would now like to setup SQL Server Reporting, Integration, and Analysis Services on the same cluster. I know Reporting Services and Integration Services are not cluster aware. Can anyone give me advices on the best way to install these three components for high availability within a two node cluster. Are there any good articles or install guides on the web? Current Setup: 1) SQL Server 2005 Ent - Windows 2003 Ent 2) Node1 - Windows 2003 Ent 3) Node2 - Windows 2003 Ent Sorry if my Cluster terminology is incorrect. Many thanks Colin Tag: Web service as a data source for a SSRS report Tag: 80646
  - 24
    - return results from stored procedure Hi All, I have managed to get my Reporting Services 2005 up and running. I have a question though: Instead of defining my dataset as a text query (such as select * from table..) I would like to define it as executing a stored procedure. This stored procedure will be a little bit more complex than just a simple (select * from..) In other words, it will look into some tables and then iterate through some values... WHILE BEGIN -- get my values here -- Here i Used to build a string with the data needed and just print it (e.g., SET @PrintString = @Value + N' ' + @Value2... ) -- PRINT @SPrintString FETCH NEXT..@Value, @Value2.. ... END I used to create a string and print that, but now I would like the results in a table form so that Reporting Services renders them correctly as a report. Should I somehow create a temporary table and insert the values in it and then have my query something of the form (INSERT INTO TempTable exec sp_StoredProcedure) ? Is this the correct way of doing it or should I go about it a different way ? And if this is the solution, how would I create this table and how would I actually return it ? Would I just create it before calling the stored procedure and drop it after that? Thanks. Tag: Web service as a data source for a SSRS report Tag: 80645
  - 25
    - Access a named parameter in an RDLC report in local mode I need information on how to programmatically access a named parameter within an RDLC file associated with a ReportViewer in local mode. I also want to verify that a parameter set up like this =Fields!personID.Value will return what I am expecting. For example if "LName" is displayed in a box and the parameter name is 'person_id' with the associated parameter value =fields!PersonID.Value then when the user clicks on the textbox with "George" then the ID for george will be available in that parameter and can be obtined programatically from the ReportViewer1_Drillthrough event. Thanks, Doug Tag: Web service as a data source for a SSRS report Tag: 80644
- Next
  - 1
    - Help on installing Reporting Services NOT on Default Web Site Hello: Long story short, our IIS box does not have the "Default Web Site". And, for whatever reason, it does not appear that you can configure SRS 2005 to use a site other than the Default Web Site. I have followed Microsoft's instructions, on creating a new web site for SRS. The problem is that we cannot use port 80, because that is our Sharepoint port. (The instructions seem to indicate the typical port used is the one for the Default Web Site--port 80.) Anyway, when I went into SRS Report Configuration Manager to create a new virtual directory, it errorred-out saying that it could not create one. Has anyone out there been able to successfully configure SQL Reporting Services 2005 to use a site (and a port) other than the Default Web Site? If so, I really would like instructions for this, other than the ones that Microsoft has posted (because they are not any good). You may please send them to my Hotmail address at sqlprogrammer@hotmail.com. Thanks! Please let me know, if you have these instructions. SQL Programmer (it's just a name) Tag: Web service as a data source for a SSRS report Tag: 80640
  - 2
    - Problem with printing a SSRS report Hi I'm working with SQL Server 2005 and Visual Studio 2005. I'm creating an SSRS report and everything works fine...until I try to print it. When I do so on the local printer it prints fine, but when I run the application via Citrix and use ThinPrint to print it the report prints itself, but strangely, on paper I get black rectangles instead of my textboxes with information. Help would be appreciated, thanks! Da From http://www.developmentnow.com/g/115_2006_3_0_1_0/sql-server-reporting-services.ht Posted via DevelopmentNow.com Group http://www.developmentnow.com Tag: Web service as a data source for a SSRS report Tag: 80638
  - 3
    - Export to MSProject Is there a direct way to export a SQL Server report to a Microsoft Project file? -- stullhe104 Tag: Web service as a data source for a SSRS report Tag: 80637
  - 4
    - change label, error with asp and network reports Hi, I hope someone can help me with three newbie problems . 1) When I have a user editable parameter in my reports, the user can edit the parameter and then hit the "View Report" button to see the report. Is it possible to change the label of the "View Report" button to something else? I basically need to translate "View Report" to a different language. 2) For some reason, I can't start my Report Server. All the configuration sections are OK except the "Web Service Identity" one. In that particular section, my ASP .NET Service account is listed as "COMPUTERNAME\ASPNET" where COMPUTERNAME is my computer name. The ASP.NET State service is started. When I hit the Apply button, I get an error stating: "There was an error setting the identity for the web service. The previously set identity will still be used." If I click "Tell me more about this problem... " it says "ReportServicesConfigUI.WMIProvider.WMIProviderException: An unknown error has occurred in the WMI Provider. Error Code 8007056B" in the "SetWebServiceIdentity" function. 3) I am using SQL Express and I have two computers on a network (no domain, the computers are just in a workgroup.) I have both SQL Server Express and Reporting Services installed on Machine 1 together with IIS. Would it be OK to connect from Machine 2 to Machine 1 via IIS and navigate to the Report Server and see the Machine's 1 reports ? By that I mean, is it technically possible and is it allowed by the licensing constraints ? Thanks! Tag: Web service as a data source for a SSRS report Tag: 80634
  - 5
    - Document layout in reporting services Good morning, I have a question about reporting services. I have to generate a report in a document format, not a table format. Does it allow a report layout to simulate a document? Fields in a paragraph, text dinamically suited to margins.... If not, could you give me any suggestions?? I have to generate it for ms crm. Thank you very much!!! Tag: Web service as a data source for a SSRS report Tag: 80633
  - 6
    - Connecting with management studio? I recently installed a new server with SQL 2005 Server and want to use Reporting Services. I've logged into the server as the local administrator, launched the Management Studio and tried to connect to the Reporting Services. It blanks the server name so I reenter it and click connect. That's when I get the error message listed below. I added the local adminastrator account as well as the Domain Admins account to the Distributed COM User group but I still cannot connect. What am I doing wrong? Why can't I connect to the Reporting Services Server? Heck, while I'm here, I was reading through the tutorials on Microsoft's web site and it tells me to go to the following URL: http://<serverName>/reports I find that when I go there, replacing the <serverName> tag with my actuall server name, it prompts me for login credentials but won't take anything I give it. If I go to http://localhost/reports, it works just fine. Can someone explain that too me too? Why does it do this? The server name does resolve in DNS. Thanks in advance, Linn TITLE: Connect to Server ------------------------------ Cannot connect to cmw-sql2k5. ------------------------------ ADDITIONAL INFORMATION: A connection to the report server failed. Most likely, you do not have permission to connect to the computer. You should either try to connect using report server URL for the Server name, or if the Distributed COM Users group exists on the remote computer, verify that you are a member. (Microsoft.SqlServer.Management.UI.RSClient) ------------------------------ BUTTONS: OK ------------------------------ Tag: Web service as a data source for a SSRS report Tag: 80629
  - 7
    - subtotal problem of calculated field I have a matrix report that is based on an AS cube. There are two dimensions defined as rows. The report has three measures, 'Total Value' and 'Number of Orders' are from the cube, and 'Average value' is an calculated one, equals 'Total Value'/'Number of Orders'. Below is what the report shows. State Zip Total Value Number of Orders Average Value AZ 11111 100 10 10 11112 200 5 40 11113 90 10 9 Total 390 25 10 (should be 15.6) AK 22222 400 2 200 22221 50 1 50 Total 450 3 200 (should be 150) As you can see the problem, in total, I am getting the currect sum(Total Value) and sum(Number of Orders), but Average Value is not correct, it's replicating the first row of the group. Can someone tell me where the problem is coming from? Thanks very much. Tag: Web service as a data source for a SSRS report Tag: 80626
  - 8
    - Access to the temp directory is denied I receive the following error when I go to http://<server>/reports for SSRS 2005. Access to the temp directory is denied. Identity 'CASINO\MichaelP' under which XmlSerializer is running does not have sufficient permission to access the temp directory. CodeDom will use the user account the process is using to do the compilation, so if the user doesnt have access to system temp directory, you will not be able to compile. Use Path.GetTempPath() API to find out the temp directory location. This issue seemed to go away when full access was given to the 'Everyone' group on C:\Windows\Temp. I want to avoid giving the 'Everyone' group full access to the Server's Temp directory. Any ideas? Tag: Web service as a data source for a SSRS report Tag: 80623
  - 9
    - Querying ExecutionLog Table I'm writing a quick and dirty report to give to the powers that be showing just how often - or not - certain reports are run. I'm also going to include some other anecdotal information. One of the things I'd like to include are average times (rendering, data retrieval, etc.). Here's what I've got so far that works really well: SELECT DISTINCT c.Name, c.Path, c.CreationDate, c.Description, COUNT(e.ReportID) AS [Number of Times Executed], MAX(e.TimeStart) AS [Last Time Executed], AVG(e.[RowCount]) AS [AVG NUMBER OF ROWS], AVG(e.timedataretrieval) AS [AVG DATA RETRIEVAL TIME], AVG(e.timeprocessing) AS [AVG TIME PROCESSING], AVG(e.timerendering) AS [AVG TIME RENDERING] FROM ExecutionLog AS e INNER JOIN Catalog AS c ON e.ReportID = c.ItemID GROUP BY c.Name, c.Path, c.CreationDate, c.Description ORDER BY c.Name While this works great, there's one problem. When calculating the averages, I only want to include those executions that had a status of rsSuccess. For example, one report was run three times. One execution had an rsInternalError with a row count of half a million. The other two times succeeded and had significantly lower row counts. When calculating the averages, I'd like to throw out the "bad" executions, so as not to skew the results. Could someone suggest how I can tweak this query to accomplish this? Thanks!! Tag: Web service as a data source for a SSRS report Tag: 80621
  - 10
    - Parameter not being passed to stored procedure eI have created a report that contains several stored procedures and they except a parameter to be passed to it... The parameter name is the same in all the stored procedures. I created a report parameter and named it exactly like the parameter in the stored procedures. I can run the report on my local machine without a problem. However, when I depolyed the report to a report server and try to run the report it comes back with an error that one of the sp's is excepting a parameter. How can I fix this since it works on my machine without an issue. Thanks in advance. Tag: Web service as a data source for a SSRS report Tag: 80615
  - 11
    - Show/Hide Tables based on parameters Has anyone created a report that shows/hides tables based on selections from a parameter list? For example, I have a report that has 10 tables, each one summarizing sales and dollars based on various types within an attribute of a product. I want to allow the user to be able to select 1,2,3 or all 10 attibutes, then display the ones they select on the report. Has any one done this or changes attributes of a table, textbox, etc... based on some parameter or even a value? Any help would be greatly appreciated. Thanks in advance for your help. Tim Tag: Web service as a data source for a SSRS report Tag: 80609
  - 12
    - Subscription tab not showing All, This is probably something stupid that I am missing, but I want to set up a subscription and there is no subscription tab in Report Manager; I only have View, Properties and History. The security around here is insane, so could this be a security setting? Any ideas would be helpful; our DBA knows nothing about Reporting Services! Thanks, Kathryh Tag: Web service as a data source for a SSRS report Tag: 80608
  - 13
    - Background image on more than one page? Greetings, My background image only prints on the first page of a multi page report. Is that normal? I do have some logic that tells what image to use but even when I took that out and hard coded it to a single image it still did not repeat. Thank you. Tag: Web service as a data source for a SSRS report Tag: 80606
  - 14
    - Upgrading from SQL Report Server Standard Edition to Enterprise Ed Hi All, We need to upgrade our production environment from SQL Report Server Standard Edition to Enterprise Edition. For some reason, our development environment is already on Enterprise Edition whereas the production environment is on Standard Edition. So we canâ??t test in the development environment to see what the impact of upgrading will be. So here are some questions we have: â?¢ Is this considered a high risk change? â?¢ What impact should we expect to the reports we currently have? â?¢ What other risks/issues should we be looking into regarding such an upgrade? Thanks for any pointers. Regards, Woody Tag: Web service as a data source for a SSRS report Tag: 80602
  - 15
    - call external program (msaccess) from RS report? I have developed a set of reports using Reporting Services that look at a SQL Server database. There is a simple MS Access application for users to insert/update/delete records against the same database. I've been asked if there is a way to click on a link/hyperlink in a field so that it brings up the MS Access application with the same record loaded in the form. I've found out how to start msaccess from the command line with a specific record loaded (basically just use the /cmd switch for msaccess.exe to pass in a parameter which is the ID value for the record in question). So, I would like to stress that this isn't an MS Access question as I already have that side of it figured out. The question is, can I enable something like the existing 'ACTION' property with 'Jump to URL' from a column/field in a report to run the required command line to start msaccess and pass in the value of that field? I've tried using the file:/// URL and I can start MSAccess itself but it doesn't work when trying to add the ADP file on the 'command line' to open up the specific Access application. It would be nice if there was a better method anyway. Any suggestions? Thanks Tag: Web service as a data source for a SSRS report Tag: 80599
  - 16
    - snapShot with userID Hello. I have a report with parameter that depend on another parameter that take the value of the current user (=User!UserId). The report run fine until I'm trying to make a snapshot of the report. I then get the error: "The defaultValue expression for the report parameter 'user_alias' has a user profile dependency. (rsRuntimeUserProfileDependency)". I didn't find any help onLine. Can anybody help with this issue? Thanks in advance, Roy. Tag: Web service as a data source for a SSRS report Tag: 80596
  - 17
    - Designer Louis Vuitton Utah Carryall - Coffee M92993coffee Handbags, Designer Louis Vuitton Utah Carryall - Coffee M92993coffee Handbags, Luxury, Best,Inspired Designer Handbags : http://www.bagsbrand.com Louis Vuitton Utah Carryall - Coffee M92993coffee Link : http://www.bagsbrand.com/Louis-Vuitton-M92993coffee.html Brand : Louis Vuitton ( http://www.bagsbrand.com/Louis-Vuitton-Handbags.html ) Model : M92993coffee Louis Vuitton Utah Carryall - Coffee Details : Louis Vuitton dark coffee color leather bagRound type leather handle with bronze color buckleZipper closure on top in bronze colorAd also it has flat pocket om both sideFour bronze color stud at the bottomComes with serial numbers, authenticity card, dust bag, and care booklet SIZE: 16.5" x 10.6" x 9.4" Louis Vuitton Utah Carryall - Coffee M92993coffee : http://www.bagsbrand.com/Louis-Vuitton-M92993coffee.html Tag: Web service as a data source for a SSRS report Tag: 80595
  - 18
    - Good Monitoring tool Hi All, Does anyone have a recommendation of a monitoring tool? Something to monitor a response time to a particular report on a scheduled basis? Monitor spun up COM components? Thanks! Tag: Web service as a data source for a SSRS report Tag: 80593
  - 19
    - Report Model with SQL Uniqueidentifier data type - I can't filter on them. I am trying to filter a resultset from a report model that contains columns that have a sql uniqueidentifier data type. When I attempt to use one of these columns in a filte expression I get the following error. I haven't been able to modify the report or model to accept this data type in a filter. Anyone using Report Model with UniqueIdentifier data type? Thanks, Steve MunLeeuw Tag: Web service as a data source for a SSRS report Tag: 80591
  - 20
    - Page break not working I have two tables one on top of the other... The second table is only visible, via expression. I have set the properties of the table to insert a new page after it... When I run the report, it does not add a page break and the table is visible due to the expression being told to show the table... However, if I make the table visible no matter what it inserts the page break. Has anyone come across this issue and found a resolution. Tag: Web service as a data source for a SSRS report Tag: 80590
  - 21
    - Internationalization Support for SSRS Hi, i want to make my report multilingual.for that i need change static label(like table header,textbox text) used in report according to the current culture.How i can do it? Also i am using ReportViewer control which is using text like "Find,Next,Export etc...." with their tooltip.How i can change those in site's present culture info? Note: i am not looking for the client localization,but looking to make a site for say Germany as weel as in English and language will change according to user choice. Thanks Dibakar Tag: Web service as a data source for a SSRS report Tag: 80587
  - 22
    - Multiple Rectangles with Tables and Matrices on one Page I'm working on report that has multiple tables and matrices divided up into 2 rectangles on one report plus a subreport at the bottom. The problem I'm having is that in Print Prview mode it moves the rectangle and all the information to a 2nd page so I end up with a lot of white space on the first page next to the 1st Rectangle. At first It was having problems with matrices and tables showing with a significant amount of white space between them when I had everything in one rectangle. Then I divided the 2 columns of tables and matrices into 2 rectangles and now get the above problem. I have everything in one group but cannot get the 2 to stay side by side. Thanks in advance to any suggesstions. -- Wayne Hess Tag: Web service as a data source for a SSRS report Tag: 80586
  - 23
    - Sharepoint integration + publishing through ISA Server problems Hello. I'm trying to publish my internal sharepoint portal in internet using ISA Server Sharepoint publication. All works fine except reporting services that is integrated with Sharepoint. Consider my intranet portal URL to be http://myportal and Internet URL of the same portal published is http://portal.mydomain.com So First of all when I tried to browse .rdl-files in Sharepoint list, IE was automatically changing URL from http://portal.mydomain.com/doclist/myreport.rdl to http://portal.mydomain.com/doclist/myreport.rdl Then I read a good article here http://blogs.msdn.com/sharepoint/archive/2007/03/06/what-every-sharepoint-administrator-needs-to-know-about-alternate-access-mappings-part-1.aspx and made a mapping of internet URL to local URL. After that, loading .rdl files in IE leads to error "The request failed with an empty response". Trying to browse .rdl files through reportviewer.aspx interface (ReportServer directory) leads to internal error. Here is a log file (sorry, a part is in Russian): System.Web.HttpException: Error executing child request for /ReportServer/Pages/ReportViewer.aspx. ---> Microsoft.Reporting.WebForms.InvalidConfigFileTypeException: Ð¢Ð¸Ð¿ Microsoft.SharePoint.Portal.Analytics.UI.ReportViewerMessages, Microsoft.SharePoint.Portal, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c Ð½Ðµ Ñ?ÐµÐ°Ð»Ð¸Ð·Ñ?ÐµÑ? IReportViewerMessages Ð¸Ð»Ð¸ Ð½Ðµ Ð½Ð°Ð¹Ð´ÐµÐ½. at Microsoft.Reporting.WebForms.ConfigFilePropertyInterface`1.EnsurePropertyLoaded() Can you help me troubleshoot this issue? Thank you Dmitry Jolobov Tag: Web service as a data source for a SSRS report Tag: 80585
  - 24
    - XPS support in Reporting Services 2005 or 2008 I see lots of information about the new XPS format but can't seem to find anything on support for it within SQL Server 2005 or 2008 Reporting Services (RC0). Will either support it like it does PDF as a report format? Thanks SJ Tag: Web service as a data source for a SSRS report Tag: 80583
  - 25
    - Inserting data from an excel file to SQL Server Hi, I have an auto generated excel file(.xlsx) in a particular format . I tried importing the file to the SQL server database using the query below. SELECT * INTO temp_ExcelData2 FROM OPENROWSET('Microsoft.ACE.OLEDB. 12.0','Excel 12.0 Xml;Database=C:\test \DashboardData.xlsx;HDR=No;IMEX=1','SELECT * FROM [Sheet1$]') It is showing an error as Could not locate registry entry for OLE DB provider 'Microsoft.ACE.OLEDB.12.0'. SELECT * INTO temp_ExcelData2 FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0','Excel 12.0 Xml;Database=C:\test \DashboardData.xlsx;HDR=YES;IMEX=1','SELECT * FROM [Sheet1$]') OLE DB error trace [Non-interface error: Provider not registered.]. Also I tried importing an xls file using the below command the same worked perfectly fine. SELECT * INTO temp_ExcelData FROM OPENROWSET('Microsoft.Jet.OLEDB. 4.0','Excel 8.0;Database=C:\test\mydata.xls;IMEX=1','SELECT * FROM [Data$]') Please provide help Tag: Web service as a data source for a SSRS report Tag: 80577

Hi All,

We have a need to use a web service as a data source for SSRS report/
s.
Basically we have data from remote systems available as a web service
and I would like to source this into SSRS.

The reason they have been published as a web service is to enable
real
time reporting.

Please advice how I can do this in SSRS.

Thanks
Karen

Top

Re: Web service as a data source for a SSRS report by prabhupr

prabhupr
Sun Jul 20 11:28:05 CDT 2008

On Jul 19, 3:56=A0am, KarenM <karenmiddl...@yahoo.com> wrote:
> Hi All,
>
> We have a need to use a web service as a data source for SSRS report/
> s.
> Basically we have data from remote systems available as a web service
> and I would like to source this into SSRS.
>
> The reason they have been published as a web service is to enable
> real
> time reporting.
>
> Please advice how I can do this in SSRS.
>
> Thanks
> Karen

These URLs may help
http://msdn.microsoft.com/en-us/library/ms159219.aspx
http://msdn.microsoft.com/en-us/library/aa964129.aspx

Top