Audit RS

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
    - Passing default parameters I have created some reports for our school district and would like to make a 2nd parameters default to what matches the 1st parameter in a drop down list. Example: If a teacher selects their school from the parameter drop down listing, what I am trying to do is so that the teacher does not have to type in their name and ensure the sysntex is correct, but to have the 2nd parameter default to all teachers in that school so they could choose from the listing. I've tried using the school and the teachers in a seperate dataset but when I then select on the school it shows the school multiple times for each teacher. I just want the school to appear for it's parameter then the 2nd parameter would be populated with the teachers names based on the school selected. Thanks in Advance -- Wayne Hess Tag: Audit RS Tag: 75838
  - 2
    - Defining custom column groups on a matrix report in report builder I have table called Buildings which has market and sq. ft information. I want to create a matrix report that has the market as the row group and sq. ft ranges as the column group and shows the # of buildings in each market that fall in the sq. ft ranges. Sq. ft ranges are 0-5000, 5001-10000 etc... My questions is a) is this something that can be done using report builder b) how do i define the sq. ft ranges c) how do I find the count of buildings whose sq. footage falls within the range. Thanks Tag: Audit RS Tag: 75836
  - 3
    - About a RS version and previous conditions of use I own a Windows Small Bussiness 2003 license which includes SQL server 2000 Standard Edition and additionally came with a version of Reporting Services. I want to learn and use it (Reporting Services) as a beginner but when I try to install it a message appears indicating that I need to install or configure previously two products: a) Visual Studio .Net 2003 b) IIS 5.0 Do I need both of 'em just to begin doing simple reports? I supposed a simple use like I could obtain through Crystal reports 7.0 or so on. Please, help me. Probably next year we will migrate to a new version of Microsoft SBS Is it worth to do efforts with the versions I own nowadays or not? Thanks alot in advance. -- sanpetus Tag: Audit RS Tag: 75834
  - 4
    - How to wrap single column on one page I have serveral reports that are single column. They waste a lot of paper because they go on for a while. What I would like to do is present that data in 3 to 4 columns per page to save paper. How? Tag: Audit RS Tag: 75833
  - 5
    - Allow List to Grow Hello. I have nested lists that are working the way I want it to, but the parent list does not grow vertically to accomodate the child list. If it gets too long it just displays right over top of the child list rather than push the child down. BJ Tag: Audit RS Tag: 75831
  - 6
    - Table initial visibility I have a parameterized report and I'd like the main table to be empty the first time the report is opened. In other words, I want the user to have to enter/select parameter values before the report displays any data. Any ideas would be very helpful. Thanks in advance. (By the way, does anyone know why my postings to MSDN newsgroups sometimes post three times???) Tag: Audit RS Tag: 75823
  - 7
    - Table initial visibility I have a parameterized report and I'd like the main table to be empty the first time the report is opened. In other words, I want the user to have to enter/select parameter values before the report displays any data. Any ideas would be very helpful. Thanks in advance. (By the way, does anyone know why my postings to MSDN newsgroups sometimes post three times???) Tag: Audit RS Tag: 75822
  - 8
    - Publishing from RS 2000 to RS 2005 I want to publishing many reports from RS 2000 to RS 2005. These reports have several server parameters. In order to do it I have used the utility RSScripter, but this application produces .rss and .cmd files for RS 2000. I have modified their code to do to function them to publish to RS 2005. Does exist another version of this utility to do this migration? Does exist another manner to solve this issue? Many thanks Tag: Audit RS Tag: 75820
  - 9
    - SSRS Back End Standards We are in the middle of putting together an Enterprise level Reporting Services roll out. While we have covered folder structures in our versioning, to folders on the deployment side, templates, and captured many other items to be included - one of the developers is pushing that we have some sort of back end standards. The way he is explaining it is sort of like; say we have 3 data sources; we should copy those 3 data sources into a central Reporting DB area; so that all reports are drawing from this central area. He isn't talking about making a data mart or doing any cleansing - just copying whatever tables that we are reporting from - into this central area. Is this common - is there any information anyone knows of on how best to implement what he is calling database backend standards? Tag: Audit RS Tag: 75810
  - 10
    - Need help executing an Oracle Stored Procedure The following is my Oracle SP and the call : (WORKGROUP in CHAR, WG_NUMBER in CHAR, WG_COPY in NUMBER) as i NUMBER := 1; BEGIN DELETE FROM LIMS_FLD_RS_RPTS; LOOP INSERT INTO PENR.LIMS_FLD_RS_RPTS (SITE, ADDRESS, WORK_GROUP_NUMBER) (SELECT FACILITY_NAME AS SITE, UPPER(ADDRESS) AS ADDRESS, WORK_GROUP_NUMBER FROM FACILITIES_PERMITS_FULL, VIEW_ADDRESSES WHERE RTRIM(WORK_GROUP) =RTRIM(WORKGROUP) AND RTRIM(WORK_GROUP_NUMBER) =RTRIM(WG_NUMBER) AND VIEW_ADDRESSES.LOCATION_ID = FACILITIES_PERMITS_FULL.LOCATION_ID); commit; i := i+1; EXIT WHEN i >WG_COPY; END LOOP; END LIMS_PEN_VERSION; CALL LIMS_PEN_VERSION(:WORKGROUP :WG_NUMBER :WG_COPY) I keep getting the error SYS.DBMS.UTILITY and I have researched this error and get 3 solutions that are basically the same response but I still cannot understand why is not functioning when the SP works in Oracle. Tag: Audit RS Tag: 75809
  - 11
    - passing parameters using a URL I'm knew to SSRS and SSAS so please bear with me. I understand the concept of how the URL works. I tested with one of my reports (below) and was able to see that the parameter in the received SSAR report displayed the correct item. The parameter in the receiving report parm_year contains the 2006. But how does the receiving report take the parmater (parm_year) and automaticaly run based on the parm_year contents (2006) The data source is an SSAS OLAP cube. In other words, how do I tie the resports data source with the parameter. http://usmidea-srmsql/reportserver?%2fNew_Gold_Reports%2fReport1&rs:Command=Render&parm_year=2006 Tag: Audit RS Tag: 75808
  - 12
    - ReportViewer posts OnChange when params are updated w/o regenerat ReportViewer control will post automatically if a user updates a parameter control (e.g. textbox) and changes focus, without regenerating the report. The problem is that it will postback to refresh the parameter, without re-generating the report, resulting either in the old report still being displayed or a blank report being displayed, both of which are misleading to the user because it is not what the user expects to see. I've gotten several complaints from the users about this issue. Occurs in both IE7 and Firefox 2 Tag: Audit RS Tag: 75804
  - 13
    - Server time dimension I 've created a Time dimension using server time. I would love to rename the attributes, e.g. instead of "Calendar 1980" "Year 1980" and instead of "Quarter 1,1980" "Qu 1, 1980" Does somebody know how to do so? -- Heimo Tag: Audit RS Tag: 75795
  - 14
    - Need different FROM addresses for each email subscription I am converting to SSRS from a home-grown datawarehouse reporting solution. We have multiple large customers, and the reports need to "appear" to come from different email addresses, so they can be properly managed. I know I can change the from address server wide, but how do I make my custom email address come up in the FROM field of the email, and not just reply-to? I got the reply-to to work just fine, but it is confusing to the report consumers if they see the reports coming from "SSRS@mycompany.com", and when replying to the email, they get "differentreplytoaddress@myothercompany.com" Thanks! Tag: Audit RS Tag: 75793
  - 15
    - How to find my rdl filesn the sql server? Hello. I have a few reports that I've published to my reportserver. Now, my rdl files have been delete from my local computer. Is there a way to find the rdl files on the server so I can download them to my local pc so I can continue working on them? I have full access to the report server of course (and the the sql server itself). I'm useing rs2005. Thanks. Tag: Audit RS Tag: 75789
  - 16
    - Get IP Address of end-user What would the VB.NET code that I can use in a function call in the Report Properties of SSRS to determine the IP Address of the person running the report? Or is there another way to get the IP Address and pass it into the stored procedure call that is being used for the report data connection? I am trying to secure the report execution to limit the report URL execution to only the original user at the original IP address. My concern is that if someone got the URL of the execution of a report, that someone other than the user who has gone through our forms authentication can view the report information. Thanks In Advance, -- Paul J. Tag: Audit RS Tag: 75785
  - 17
    - Is there a way to loop over report parameters, and format them before passing them onto the query Good morning all, I have a report which is getting its parameters from an ASP.net page. My ASP developer wants to send in simple values, such as the list 1,2,3,4 for a parameter. However my report needs that list to look like [CD RSRC].[RSRC].&[1], [CD RSRC].[RSRC].&[2], [CD RSRC]. [RSRC].&[3], [CD RSRC].[RSRC].&[4]. Is there any way, on the report services side, to capture an incoming report parameter, parse it, loop over the parsed values and format them? I don't think there is, but I wanted to check before I go back to the developer and tell him he has to send in tuple lists. Thanks, Kathryn Tag: Audit RS Tag: 75784
  - 18
    - The last graph in the report mail is cut off in lower part Hello, I'm using Microsoft SQL Server Report Designer Ver. 8.00.1038.00 in connection with Microsoft Development Enviroment 2003 Ver. 7.1.3088 nad Microsoft .NET Framework 1.1 Version 1.1.4322 SP1 to model my Reporting Service Project and Reporting Services is living on the SQL Server 2000 SP4. I made a report with more pairs of tables and graphs laid down one by one and the lenght of report is slowly growing every day in dependence with cumulative sales of the year. What I observe in last day is that the last graph in the report mail is partly cut off in its lower part. This behavior appears but only in the (outlook) mail not but in the previewing the report with Internet Explolrer neither in the prewiev pane of the designer. How can I solve this unpleasant situation? Ivan Tag: Audit RS Tag: 75781
  - 19
    - DateTime type Report parameter Hi, I have three parameters in my report. The first one is called QuickDate which is of type string with options like "Current Month", "Current Week", "Prior Week" etc. The next to parameters are called FromDate & ToDate which are of type DateTime. When the user selects an option say 'Prior Week', the system should populate corresponding FromDate and ToDate values. To accomplish this I have written code with two functions which return Date type variables. Iam calling these functions in Default values, Non-queried of Fromdate and ToDate parameters. When the user selects a QuickDate option for the first time, the system populates the FromDate and ToDate correctly. From second time onwards the same old values are retained in the FromDate and ToDate parameters(I can understand this because Iam calling functions in default values) . If I call the functions in Avaliable values: Value, SSRS doesnt show calendar icon but Fromdate and ToDate are populated correctly. Can anyone help me overcoming this problem ? I need to show calendar icon and correct dates depending on QuickDate option selected. Thanks, RK Tag: Audit RS Tag: 75780
  - 20
    - Batch Printing Hi All I have a customer report that I need to automatically print at the end of each month. What is the best way to programmatically print the report? Is it also possible to specify the customers so that the report gets printed for say all customers with a transaction in the last 30 days? Thanks Tag: Audit RS Tag: 75779
  - 21
    - Switch Columns with Rows I have the following data: Strengths Weaknesses Threats Opportunities Company 1 Company 2 Company 3 Company 4 The company names could change with the data, the Strengths, Weaknesses, Threats, Opportunities will not be a growing list. I need to data to be used in SRS to be: Company1 Company2 Company3 Company4 Strengths Weaknesses Threats Opportunities The company1-5 will be limited to 5 columns. How do I do this? Tag: Audit RS Tag: 75777
  - 22
    - Hyperlink files How do I get the *.xls and *.txt files from 'c:\files1\*.*' and 'c:\files2\*.*' ? I need to display a hyperlink from my web page (I am using Reporting Services project) instead of going to each folder. I would to list in my report all files from these folders and able to open them in Excel or text format. I try to use 'Jump To URL' it did not work. Probably I was doing something wrong. Please help. Tag: Audit RS Tag: 75769
  - 23
    - Add Blank Page I have a report that is grouped by employee. The report lists the training each employee has taken. What I want to do is have a page with just the employee's name and some lines that can be used for writing comments to print after the last page of data for the employee is displayed. So, if page 1 and page 2 have employee training data, page 3 will just have the employee's name and than a bunch of blank lines. Any help is appreciated. Thanks. MK Tag: Audit RS Tag: 75767
  - 24
    - Report Manager Configuration Error I've completed the SRS Configuration Manager on my SQL 2005 server and I receive a Configuration Error when I try to browse the Report Manager web page (http://localhost/ReportServer). What should I check next? The complete text from the error message is below: Server Error in '/ReportServer' 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: An error occurred loading a configuration file: Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportServer\web.config' is denied. Source Error: [No relevant source lines] Source File: C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportServer\web.config Line: 0 -------------------------------------------------------------------------------- Version Information: Microsoft .NET Framework Version:2.0.50727.832; ASP.NET Version:2.0.50727.832 Tag: Audit RS Tag: 75766
  - 25
    - Using textboxes in calculations First of all, I want to apologize if this is already out there but I couldn't find it. Here's my issue (and being new to 2005 Reporting Services, I seem to have many): I am trying to do a simple LYTD/YTD sales report. I have two columns with the totals as I need them. Each column, however, is in a seperate list and gets it's information from date parameters. Since the expressions are exactly the same in each Sum field, I can't simply divide one by another to get my Margin $ or %. In Access, I would have just said =textbox1/textbox2 but it doesn't appear I can use the name of the field as a variable. In a very simple view, what I am wanting is something like this: LYTD YTD Margin +/- 3000000 3500000 14% =Sum(Fields!OrderedAmount.Value) is the expression in both LYTD and YTD with report parameters for the date range for each. I may be going at this the wrong way, but I'm trying to work strictly with the menu options and not write code. Thanks in advance. Tag: Audit RS Tag: 75764
- Next
  - 1
    - Multi_parameter problem using Oracle datasource I create a SQL 2005 report using oracle datasource, I use: select * from category where category_name in (:p_category_name) and parameter :p_catehory_name is from a dataset. I set :p_category_name as multi-parameter. But when select more than one category_name from drop-down list, I got data type not match error. How do I solve the problem? han_frank@hotmail.com Tag: Audit RS Tag: 75762
  - 2
    - Auto Render as .pdf Is there a way to force the output of a manually run report using Report Manager to output as .pdf rather than html and having to export from there? I would like to enter a shipment number as a prompt, then go straight to creating a shippping document as a .pdf Thanks Bob Tag: Audit RS Tag: 75761
  - 3
    - Default to empty report I'd like a report to not render the first time the page is loaded. This seems like it should be easy, but I cannot find the answer. Thanks. Tag: Audit RS Tag: 75760
  - 4
    - Default to empty report I'd like a report to not render the first time the page is loaded. This seems like it should be easy, but I cannot find the answer. Thanks. Tag: Audit RS Tag: 75759
  - 5
    - Default to empty report I'd like a report to not render the first time the page is loaded. This seems like it should be easy, but I cannot find the answer. Thanks. Tag: Audit RS Tag: 75758
  - 6
    - Subscriptions for cube based reports Hi Can anyone help? We have reports that have been defined against AS 2005 cubes. The data source for these reports have been set as windows authentication and access to the cube is controlled via membership of an AD group. Now we want to create subscriptions against these reports and get the error "Data-driven subscriptions cannot be created because the credentials used to run the report are not stored, the report is using user-defined parameter values, or if a linked report, the link is no longer valid." How do we get this to work? Surely we dont have to create the data source against one user!! Tag: Audit RS Tag: 75756
  - 7
    - how to set datasource for 'dashboard' style reports? I am trying to write a report in VS Business Intelligence Development Studio that will be used like the Dashboard Reports from SQL 2005 sp2 (e.g. right click on object and choose custom report). I need to be able to pass the server name & object to the report dynamically (not created the datasource or dataset with predfined values). Are there any examples of how to do this? Thanks in advance! Tag: Audit RS Tag: 75755
  - 8
    - Can I print ssrs report to printer from c# without rendering to an EMF first Hi, Is it possible to print a ssrs report to the printer from c# without rendering it to a EMF file first? The problem is that when I'm forced to render the entire report out to an image file first and then send that image to the printer a 400 page report takes almost an hour. thanks, Tag: Audit RS Tag: 75752
  - 9
    - XML Data Type SqlServer has an XML data type. Can you do anything with this type in SSRS reports? Ideally I would like to have xpath queries to the data I want in each detail record in my reports, but I don't see anything about using the XML datat type in SSRS. Tag: Audit RS Tag: 75734
  - 10
    - Changing a value of a textbox I am using a textbox to show/hide a table. I would like to change the value of the textbox itself from "Show Table" to "Hide Table" when the table is showing and vice versa. How can I do this? I am used to reports in access but new to Reporting Services! Thanks in anticipation Tag: Audit RS Tag: 75733
  - 11
    - w3wp AdomdConnectionException This error message persecutes us for one week now. [rsNone] Cannot create a connection to data source 'myCube'. A report calls a subreport in a list giving it 40 times a different Argument (List is grouped by). The endresult is a report with 40 pages. The subreport retrieves data via one MDX Query from SSAS (each time of the 40 times only one MDX Query). The RDLs are absolutely clean from ANY MDX-Drag&Drop autogenerated BIDS-Code. This only MDX-Statement is cleaned from all overhead (e.g. property-retrieval). SELECT NON EMPTY { [Measures].[A], [Measures].[B], [Measures].[C], [Measures].[D], [Measures].[E], [Measures].[F], [Measures].[G], [Measures].[H]} ON COLUMNS, NON EMPTY { ([A].[B].MEMBERS * [Country].[Country].ALLMEMBERS * [Date].[Month].ALLMEMBERS ) } ON ROWS FROM ( SELECT ( STRTOSET(@XX, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( { [W].[X].[Y].[Z] } ) ON COLUMNS FROM ( SELECT ( STRTOMEMBER(@FromDate, CONSTRAINED) : STRTOMEMBER(@ToDate, CONSTRAINED) ) ON COLUMNS FROM [myVeryCube]))) The complete Report execution time is 40 seconds! So there cannot be any timeouts. This report shows then up and can be printed and exported to pdf and so forth from A to Z But on one ore two pages in the middle, there appear errors: Error: Subreport could not be shown Important: every time I execute the report the errors show up on another page of the report. So there are intermittent problems. The error messages (here at the end) where retrieved using Sysinternals Dgbview while executing the report from ReportManager in IE7 on the Server. I used Dbgview, since the error messages in BIDS are minimal: [rsErrorExecutingSubreport] An error occurred while executing the subreport â??subreport1â??: An error has occurred during report processing. [rsNone] Cannot create a connection to data source 'myCube'. Installed Infrastructure - Windows Server 2003R2 SP2 - SQL Server 2005 SP2 - BIDS with VS2005 SP1 - Connection is made with the standard SSAS Provider (no older OLEDB or such) "Microsoft SQL Server Analysis Services (AdomdClient)" DataSource.rds: <?xml version="1.0" encoding="utf-8"?> <RptDataSource xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"> <Name>myCube</Name> <DataSourceID>...</DataSourceID> <ConnectionProperties> <Extension>OLEDB-MD</Extension> <ConnectString>Data Source=.\SQL2005;Initial Catalog=thisCube;Connect Timeout=60</ConnectString> <IntegratedSecurity>true</IntegratedSecurity> </ConnectionProperties> </RptDataSource> I found that this very problem has been experienced only by one person on: http://sqlforums.windowsitpro.com/web/forum/messageview.aspx?catid=258&threadid=85315&enterthread=y Important to say: - There ar NO error message in any Eventlog (System, Application, SQL Server...) - Also nothing in any of the currently 196 SSRS Log-Files!!! Really nothing! So maybe this is an IIS-Problem? Or an error introduced with a SP? ERROR Messages (Dbgview): [2712] w3wp!processing!5!11/10/2007-09:25:38:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'myCube'., ; [2712] Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'myCube'. ---> Microsoft.AnalysisServices.AdomdClient.AdomdConnectionException: The 'SQL2005' instance was not found on the '.' server. [2712] at Microsoft.AnalysisServices.AdomdClient.XmlaClient.GetInstancePort(ConnectionInfo connectionInfo) [2712] at Microsoft.AnalysisServices.AdomdClient.XmlaClient.GetTcpClient(ConnectionInfo connectionInfo) [2712] at Microsoft.AnalysisServices.AdomdClient.XmlaClient.OpenTcpConnection(ConnectionInfo connectionInfo) [2712] at Microsoft.AnalysisServices.AdomdClient.XmlaClient.Connect(ConnectionInfo connectionInfo, Boolean beginSession) [2712] at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.AdomdConnection.IXmlaClientProviderEx.ConnectXmla() [2712] at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ConnectToXMLA(Boolean createSession, Boolean isHTTP) [2712] at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.Open() [2712] at Microsoft.ReportingServices.DataExtensions.AdoMdConnection.Open() [2712] at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.ReportRuntimeDataSourceNode.OpenConnection(DataSource dataSourceObj, ReportProcessingContext pc) [2712] --- End of inner exception stack trace --- [2712] w3wp!processing!5!11/10/2007-09:25:38:: e ERROR: Data source 'myCube': An error has occurred. Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'myCube'. ---> Microsoft.AnalysisServices.AdomdClient.AdomdConnectionException: The 'SQL2005' instance was not found on the '.' server. [2712] at Microsoft.AnalysisServices.AdomdClient.XmlaClient.GetInstancePort(ConnectionInfo connectionInfo) [2712] at Microsoft.AnalysisServices.AdomdClient.XmlaClient.GetTcpClient(ConnectionInfo connectionInfo) [2712] at Microsoft.AnalysisServices.AdomdClient.XmlaClient.OpenTcpConnection(ConnectionInfo connectionInfo) [2712] at Microsoft.AnalysisServices.AdomdClient.XmlaClient.Connect(ConnectionInfo connectionInfo, Boolean beginSession) [2712] at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.AdomdConnection.IXmlaClientProviderEx.ConnectXmla() [2712] at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ConnectToXMLA(Boolean createSession, Boolean isHTTP) [2712] at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.Open() [2712] at Microsoft.ReportingServices.DataExtensions.AdoMdConnection.Open() [2712] at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.ReportRuntimeDataSourceNode.OpenConnection(DataSource dataSourceObj, ReportProcessingContext pc) [2712] --- End of inner exception stack trace --- [2712] at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.ReportRuntimeDataSourceNode.OpenConnection(DataSource dataSourceObj, ReportProcessingContext pc) [2712] at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.ReportRuntimeDataSourceNode.Process() [2712] w3wp!processing!5!11/10/2007-09:25:38:: e ERROR: An exception has occurred in data source 'myCube'. Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'myCube'. ---> Microsoft.AnalysisServices.AdomdClient.AdomdConnectionException: The 'SQL2005' instance was not found on the '.' server. [2712] at Microsoft.AnalysisServices.AdomdClient.XmlaClient.GetInstancePort(ConnectionInfo connectionInfo) [2712] at Microsoft.AnalysisServices.AdomdClient.XmlaClient.GetTcpClient(ConnectionInfo connectionInfo) [2712] at Microsoft.AnalysisServices.AdomdClient.XmlaClient.OpenTcpConnection(ConnectionInfo connectionInfo) [2712] at Microsoft.AnalysisServices.AdomdClient.XmlaClient.Connect(ConnectionInfo connectionInfo, Boolean beginSession) [2712] at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.AdomdConnection.IXmlaClientProviderEx.ConnectXmla() [2712] at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ConnectToXMLA(Boolean createSession, Boolean isHTTP) [2712] at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.Open() [2712] at Microsoft.ReportingServices.DataExtensions.AdoMdConnection.Open() [2712] at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.ReportRuntimeDataSourceNode.OpenConnection(DataSource dataSourceObj, ReportProcessingContext pc) [2712] --- End of inner exception stack trace --- [2712] at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.ReportRuntimeDataSourceNode.Process() [2712] at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSourceNode.ProcessConcurrent(Object threadSet) [2712] w3wp!processing!5!11/10/2007-09:25:38:: i INFO: Merge abort handler called for ID=7114. Aborting data sources ... [2712] w3wp!processing!5!11/10/2007-09:25:38:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing., ; [2712] Info: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'myCube'. ---> Microsoft.AnalysisServices.AdomdClient.AdomdConnectionException: The 'SQL2005' instance was not found on the '.' server. [2712] at Microsoft.AnalysisServices.AdomdClient.XmlaClient.GetInstancePort(ConnectionInfo connectionInfo) [2712] at Microsoft.AnalysisServices.AdomdClient.XmlaClient.GetTcpClient(ConnectionInfo connectionInfo) [2712] at Microsoft.AnalysisServices.AdomdClient.XmlaClient.OpenTcpConnection(ConnectionInfo connectionInfo) [2712] at Microsoft.AnalysisServices.AdomdClient.XmlaClient.Connect(ConnectionInfo connectionInfo, Boolean beginSession) [2712] at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.AdomdConnection.IXmlaClientProviderEx.ConnectXmla() [2712] at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ConnectToXMLA(Boolean createSession, Boolean isHTTP) [2712] at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.Open() [2712] at Microsoft.ReportingServices.DataExtensions.AdoMdConnection.Open() [2712] at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.ReportRuntimeDataSourceNode.OpenConnection(DataSource dataSourceObj, ReportProcessingContext pc) [2712] --- End of inner exception stack trace --- [2712] at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.ReportRuntimeDataSourceNode.Process() [2712] at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSourceNode.ProcessConcurrent(Object threadSet) [2712] --- End of inner exception stack trace --- [2712] w3wp!processing!5!11/10/2007-09:25:38:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'myCube'., ; [2712] Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'myCube'. ---> Microsoft.AnalysisServices.AdomdClient.AdomdConnectionException: The 'SQL2005' instance was not found on the '.' server. [2712] at Microsoft.AnalysisServices.AdomdClient.XmlaClient.GetInstancePort(ConnectionInfo connectionInfo) [2712] at Microsoft.AnalysisServices.AdomdClient.XmlaClient.GetTcpClient(ConnectionInfo connectionInfo) [2712] at Microsoft.AnalysisServices.AdomdClient.XmlaClient.OpenTcpConnection(ConnectionInfo connectionInfo) [2712] at Microsoft.AnalysisServices.AdomdClient.XmlaClient.Connect(ConnectionInfo connectionInfo, Boolean beginSession) [2712] at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.AdomdConnection.IXmlaClientProviderEx.ConnectXmla() [2712] at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ConnectToXMLA(Boolean createSession, Boolean isHTTP) [2712] at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.Open() [2712] at Microsoft.ReportingServices.DataExtensions.AdoMdConnection.Open() [2712] at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.ReportRuntimeDataSourceNode.OpenConnection(DataSource dataSourceObj, ReportProcessingContext pc) [2712] --- End of inner exception stack trace --- [2712] w3wp!processing!5!11/10/2007-09:25:38:: e ERROR: Data source 'myCube': An error has occurred. Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'myCube'. ---> Microsoft.AnalysisServices.AdomdClient.AdomdConnectionException: The 'SQL2005' instance was not found on the '.' server. [2712] at Microsoft.AnalysisServices.AdomdClient.XmlaClient.GetInstancePort(ConnectionInfo connectionInfo) [2712] at Microsoft.AnalysisServices.AdomdClient.XmlaClient.GetTcpClient(ConnectionInfo connectionInfo) [2712] at Microsoft.AnalysisServices.AdomdClient.XmlaClient.OpenTcpConnection(ConnectionInfo connectionInfo) [2712] at Microsoft.AnalysisServices.AdomdClient.XmlaClient.Connect(ConnectionInfo connectionInfo, Boolean beginSession) [2712] at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.AdomdConnection.IXmlaClientProviderEx.ConnectXmla() [2712] at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ConnectToXMLA(Boolean createSession, Boolean isHTTP) [2712] at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.Open() [2712] at Microsoft.ReportingServices.DataExtensions.AdoMdConnection.Open() [2712] at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.ReportRuntimeDataSourceNode.OpenConnection(DataSource dataSourceObj, ReportProcessingContext pc) [2712] --- End of inner exception stack trace --- [2712] at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.ReportRuntimeDataSourceNode.OpenConnection(DataSource dataSourceObj, ReportProcessingContext pc) [2712] at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.ReportRuntimeDataSourceNode.Process() [2712] w3wp!processing!5!11/10/2007-09:25:38:: e ERROR: An exception has occurred in data source 'myCube'. Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'myCube'. ---> Microsoft.AnalysisServices.AdomdClient.AdomdConnectionException: The 'SQL2005' instance was not found on the '.' server. [2712] at Microsoft.AnalysisServices.AdomdClient.XmlaClient.GetInstancePort(ConnectionInfo connectionInfo) [2712] at Microsoft.AnalysisServices.AdomdClient.XmlaClient.GetTcpClient(ConnectionInfo connectionInfo) [2712] at Microsoft.AnalysisServices.AdomdClient.XmlaClient.OpenTcpConnection(ConnectionInfo connectionInfo) [2712] at Microsoft.AnalysisServices.AdomdClient.XmlaClient.Connect(ConnectionInfo connectionInfo, Boolean beginSession) [2712] at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.AdomdConnection.IXmlaClientProviderEx.ConnectXmla() [2712] at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ConnectToXMLA(Boolean createSession, Boolean isHTTP) [2712] at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.Open() [2712] at Microsoft.ReportingServices.DataExtensions.AdoMdConnection.Open() [2712] at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.ReportRuntimeDataSourceNode.OpenConnection(DataSource dataSourceObj, ReportProcessingContext pc) [2712] --- End of inner exception stack trace --- [2712] at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.ReportRuntimeDataSourceNode.Process() [2712] at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSourceNode.ProcessConcurrent(Object threadSet) [2712] w3wp!processing!5!11/10/2007-09:25:38:: i INFO: Merge abort handler called for ID=7118. Aborting data sources ... Tag: Audit RS Tag: 75732
  - 12
    - Exchange Server 2007 Calendar Reporting Greetings, I've searched high and low for an answer to my question, and I have been unable thus far to find a precise answer. I need to report off of Exchange 2007 user calendars via SRS. Is this possible and, if so, how are the data sets and data sources configured? I am aware of the Web services that are available with Exchange Server 2007 and I have reviewed the WSDL for them but the parameters to be passed in to the Web methods are serialized object calls. Does anyone have an example of how one can retrieve data from shared Exchange calendars and display the data in SRS? Another wrinkle is that I want to loop through all users in Exchange and pull the calendar data for a duration of ninety days at a time so the XML calls need to accept parameters, for which I have seen examples on the Web. The examples, though, used simple arguments and not the complex constructs used by the Exchange services. Another option I am considering is creating a .NET app that calls the Exchange binding within the Web service to retrieve free/busy detail and then store the data in an SQL database. Doing that, I could call the app on demand when the report is run by saving the assembly in MSSQL 2005 and invoking it via an SP that is called from SRS. However, I prefer the more direct method of creating an XML data source in SRS and the using the <Query> tags in the data set to access calendar data. Any help that anyone could provide is much appreciated. Thanks in advance. -- ================================================================= William Schroeder, MCSD, CIDD Email: william@fanatical.us Tag: Audit RS Tag: 75731
  - 13
    - Page Footer Hi everybody! In my report i need to have one of my data set's fields in page footer! but i can't Please help me. Tag: Audit RS Tag: 75730
  - 14
    - Integrate PowerPoint and Reporting Services? I am trying to move many of our group's monthly report functions from Excel workbooks to a common Reporting Services environment, so data will be visible to everyone at the end of the reporting period. However, some of these slides have found their way into committee meetings, which are driven entirely out of PowerPoint presentations. I am being hit with a request to merge RS Reports with the existing PowerPoint presentations. Unfortunately, while RS does render to the screen, there is no easy way to copy the output to a file at a quality level equivalent to what we had. Right now, I can save my reports to Excel, then copy-paste the Range into PowerPoint, but many times the built-in export fails to render like the Report shows the data on the screen, often including cell borders in Excel that were not specified in the HTML as well as other spacing weirdness. * Is there way I can include an embedded object in PowerPoint that references a ReportViewer that pulls from the Reporting Server? The Include Object menu in PP does not list this as an option. * Is there a way to build a custom Render function to output the whole page to a WMF (Windows MetaFile) format? -- Scott Tag: Audit RS Tag: 75727
  - 15
    - SSRS Licensing Requirements I came across a webcast that indicated that the webserver that hosts the SSRS site should have a SQL Server license. Is this correct? I have my databases sitting on a different server with valid SQL Server license. Does my web site (which is on a different server) also need a SQL Server license? Thanks Tag: Audit RS Tag: 75725
  - 16
    - SMTP Authentication Not Working We have a lot of distribution lists set to only receive emails from authenticated users in my environment and I need to configure SSRS subscription to work with these distro lists. We are using Exchange 2003 and SSRS 2005. I have changed the RSreportserver.config file to allow SMTP authentication on the SSRS report server per MS' MSDN and Books Online documentation and rebooted the server. However, SSRS subscriptions will still not send to distro lists with authenticated users. They will send to distro lists not set to "authenticate only". Is there something else that I am missing here? The MS documentation states to only change"SMTPAuthenticate" to 2 on the RSreportserver.config file. Can someone help as the I need to get this reolved as soon as possible. Thanks in advance. Tag: Audit RS Tag: 75723
  - 17
    - how can I make a report that will run against a list of servers? Hi, I have SQL 2005 sp2 installed on a test server that I run admin type reports from. I have a report that I want to run against a list of servers, the list is from an SQL table on the same server as RS. I've found that data source parameters are possible, but I can't seem to get it to work. Can anyone point to an example? Tag: Audit RS Tag: 75718
  - 18
    - Using data from an Xml data type column in a report I am just starting to work with Reporting Services within Sql Server 2005 and would like some direction on where to look to find information on working with Xml data type columns in Reporting Services. I have a shared data source created to point to the database. I have a dataset created to retrieve my columns from the table. One of the columns is of the xml data type which is holding my information. I would like to take the data from the xml document and create a report on the xml information. Any links, help etc. would be appreciated. Tag: Audit RS Tag: 75717
  - 19
    - How to call subreports from a main report HI there, I want to know if someone know how to call subreports that depends from one main report. Could you help me? Regards, Oscar. Tag: Audit RS Tag: 75711
  - 20
    - Report Builder: Filter drop down list unspecified I have a report model which functioned correctly until I copied the project over to another server and changed the data source for it. I can still build a report that returns the correct data, but when I add a filter to the report data, the ddl for the filter never loads the data and says 'unspecified'. I'm not sure what the problem could be. Any ideas? Thanks Tag: Audit RS Tag: 75709
  - 21
    - Page Breack at start or end gives a blank page Hello, I found this post, which describes a similar situation to my own: http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/8ae3d9aee88cf1c0/4c9c2132b0ae9c83?lnk=gst&q=blank+page+break#4c9c2132b0ae9c83 I could not reply to this old post, so I had to make a new one (sorry!). No to resurect a "dead" thread, but has anyone found a solution to the above? I have the same symptoms (blank page at end or begining based on what was selected) and I can't seem to fix this. My report is very simple: just one group and one table on the report. I would appreciate any feedback or suggestions. Thank you! Tag: Audit RS Tag: 75708
  - 22
    - Subscription errors - Failure sending mail Subscriptions were working fine and now for no apparent reason, I get this message: Failure sending mail: Attempted to read or write protected memory. This is often an indication that other memory is corrupt. Anyone else ever have this issue? Thanks. Tag: Audit RS Tag: 75703
  - 23
    - Matrix "Group" and RunningValue Problems I have 2 problems at the moment and hope I'll be able to get some help here My first problem: I need some help on presenting data in a matrix. I have data like below : Amt 1-Jan 1 2-Jan 2 3-Jan 3 1-Feb 1 2-Feb 2 3-Feb 3 Is it possible for me to "group" my data to be like the following: Amt Jan 6 Feb 6 My Second problem is with runningvalue. My data has multiple records for one ID. But I only want to have a runningtotal based on one value from each ID and grouping by area. To illustrate my problem, Area 1 ID 1 4 ID 1 4 ID 1 4 ID 1 4 ID 1 4 ID 2 1 ID 2 1 ID 2 1 ID 2 1 I would like to have the runningtotal to be equal to 5 and not 24. If I use =RunningValue(Fields!Amt.Value, sum, "Area"), I will be getting 24. Currently I'm using a custom code to get the value but I can't pass the value to the "Area" group footer. I tried using ReportItems to pass the value out but received an error. The error message is given: "The Value expression for the textbox 'textbox100' refers to the report item 'textbox28'. Report item expressions can only refer to other report items within the same grouping scope or a containing grouping scope." Can anybody help me? Tag: Audit RS Tag: 75702
  - 24
    - Basic Parameter This is a beginning type of question - I am trying to set up a parameter that will contain 5 numeric digits. As the user starts typing i.e. a 3 I would like to see 30000 appear, then if they type a 1 then 31000 will appear, next if they type a 2 then I would see 31200 then a 5 they would see 31250 and lastly if they typed a 1 then 31251 would appear in the list and when they hit enter that would be the number of the work order that appears. Thank you. Tag: Audit RS Tag: 75690
  - 25
    - newbie questions about Models and Report Builder I had three questions regarding SSRS 1) Report Builder: I want to specify an optional - prompt for filter. If nothing is specified the report should return all data. Else, it should return what matches the criteria. Is there a way to do that? 2) Report Builder: How do I specify a group by filter. I have a field - Market in my table. I want to users to be able to filter by distinct markets 3) Models: Is there a way to edit a model that has been deployed on the server from within Visual Studio? thanks Tag: Audit RS Tag: 75689

I am trying to perform an audit of all of the reports and their respective
datasource, subscprition, etc., our RS server. Is there any pre-fab report
out there that already does this or do I need to build my own report using
the ReportServer db? If it's the latter, is there a schema for the tables?

Thx,

Top

RE: Audit RS by Michael

Michael
Fri Feb 08 17:12:01 CST 2008

Has anyone been able to come up with an answer to this? I am also wanting to
know this information as well as where it's logged whether a report succeeds
or fails as a scheduled event.

"Robert" wrote:

> I am trying to perform an audit of all of the reports and their respective
> datasource, subscprition, etc., our RS server. Is there any pre-fab report
> out there that already does this or do I need to build my own report using
> the ReportServer db? If it's the latter, is there a schema for the tables?
>
> Thx,

Top

Re: Audit RS by Alain

Alain
Tue Feb 12 08:49:17 CST 2008

Look at the following directory on your hard drive (assuming you installed
the code samples for MSSQL 2005):
C:\Program Files\Microsoft SQL Server\90\Samples\Reporting Services\Report
Samples\Server Management Sample Reports

There's a solution (.sln file), a readme, an SSIS package and some sample
reports that allow you to monitor report usage. If you want to do this over
time, you would have to schedule the SSIS package to run periodically.

Alain Quesnel
alainsansspam@logiquel.com

www.logiquel.com

"Michael" <Michael@discussions.microsoft.com> wrote in message
news:8C6F5F5B-9D15-49C5-8347-6A7936128CA5@microsoft.com...
> Has anyone been able to come up with an answer to this? I am also wanting
> to
> know this information as well as where it's logged whether a report
> succeeds
> or fails as a scheduled event.
>
> "Robert" wrote:
>
>> I am trying to perform an audit of all of the reports and their
>> respective
>> datasource, subscprition, etc., our RS server. Is there any pre-fab
>> report
>> out there that already does this or do I need to build my own report
>> using
>> the ReportServer db? If it's the latter, is there a schema for the
>> tables?
>>
>> Thx,

Top