SQL 2005 SRS error

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
    - Multiple SRS instances one SQL default instance Hi, I have a default instance SQL 2005 (SP2) server and a SRS (SP1) server configured to this SQL box. I want to know if it is possible to install SRS (actually SP2 this time) to another server and have it also configured to the SQL box above. I want this second SRS instance to be independent from the first. It's not for scalability or NLB of the current set of reports on the existing box. TIA Simon Tag: SQL 2005 SRS error Tag: 77756
  - 2
    - Using stored Procs in Report Wizard? I am trying to figure out how I can set the query in the report wizard to a stored procedure. In the Query Builder, I see a place for Command Type, and I figured I could just choose or type in an sProc there, however, it's disabled and I can't change it. The only way for me to enter a query to enter a query directly. Any ideas on how I can choose a stored procedure in the Report Wizard? Tag: SQL 2005 SRS error Tag: 77755
  - 3
    - Multiple Parameters I have a stored procedure that I have declared 3 parameters - @Inv_status value (open, paid), @Contract_type (a 4 digit code, i.e. 3000, 3500) and @ProjectID (could be null or could have a projectID similiar to like '30839%') Not all of these parameters will have a value - I am having trouble putting together the where clause I have started with where (Main.Contract_type = @Contract_Type and Main.ProjectID like (@ProjectID + '%')) --ProjectID not empty --or (Main.Contract_type = @Contract_Type or Main.ProjectID like (@ProjectID + '%')) -- ProjectID empty and it is not working. Does anyone have any suggestions? I am getting desperate. thanks Normad Tag: SQL 2005 SRS error Tag: 77754
  - 4
    - Printing options when Export to Excel Hi, My report is fine when viewed, but when i select print preview, it chops off a lot of the report and places it on a separate page. Is there any way of setting the entire report to print on a single page (fit to page) through RS ? Thanks in advance. Tag: SQL 2005 SRS error Tag: 77753
  - 5
    - Data value in footer based on grouping I have an invoice report for printing multiple invoices that groups (and page breaks) the invoice according to the customer. I'd like to get a value in the footer of the report that will change/reset upon the group change of the report. Tried using ="Invoice for "&(ReportItems!NAME.Value) which works for the first page but not the second page of the invoice (as the NAME field is not on the second page I take it?). Any suggestions on how to have the value show on the footer of all pages for that particular invoice, etc.? Tag: SQL 2005 SRS error Tag: 77752
  - 6
    - play a WAV sound file in a report I have an html rendered report in Reporting Services 2005. Everything is fine, the layout, the data, the table has rows in different colors depending on certain conditions. But now I want to have the report to play a WAV sound file when is showed in Internet Explorer and I looked and googled for it but I have found nothing. Any help would be apprecitate. Thanks in advance. Regards, Freddy Chavez. Tag: SQL 2005 SRS error Tag: 77750
  - 7
    - Hotfix for Reporting Services 2005 in Sharepoint Integrated mode with Can someone give me a valid link for this hotfix? official link does not work :( http://hotfixv4.microsoft.com/SQL%20Server%202005/sp2/SQL_Server_2005... Thanks in advance Tag: SQL 2005 SRS error Tag: 77749
  - 8
    - Turn-off autoscroll when drilldown Hi, When i m clicking on the '+' sign on the report for drilldown, the page scrolls the toggled item to the top position of the table header in report. Is there any option to turn-off autoscroll feature for report in ssrs 2005. Thanks for any help in advance! SriLakshmi. Tag: SQL 2005 SRS error Tag: 77748
  - 9
    - Prevent users from browsing the reporting server site? Dear MSDN! Are there some way to prevent users from browsing the reporting server site? The reason for this is that we want to access the reports on the reporting services from our own website with POST parameters to the reports. Thanks in advance! Tag: SQL 2005 SRS error Tag: 77746
  - 10
    - Initial Report generation time Hi, I want my report to generate only when I click the drill down(+ plus) group column like in SSAS cube browser. My report has SSAS MTD and YTD columns. The report server is taking huge amount of time to generate for the first time. So I want to reduce the initial generation time. Is there a way where in I can restrict the report to generate only when i expand the group column ? Please help. Thanks, RK Tag: SQL 2005 SRS error Tag: 77744
  - 11
    - Report generation with SSAS MTD, YTD measures Hi, Iam trying to build a report with SSAS cube as underlying database. My cube has three dimensions (namely Time, Location and Product Type) and one Measure group called Sales with just one measure SalesAmt. I have defined two calculated members for MTD_SalesAmt and YTD_SalesAmt which calculate the Month-To-Date and Year-To-Date sales amount. Now Iam trying to build a report using SSRS with all three dimensions and two calculated measures. But report is taking huge amount of time to generate. If I include just two dimensions say Time and Location the report generation is pretty fast. Can anyone help me ? I can see the values with all three dimensions in cube browser. Thanks, RK Tag: SQL 2005 SRS error Tag: 77743
  - 12
    - Can Matrix Control handle this? -- Revised Again and Again I don't know how to solve this reporting services requirements using Matrix control. Can someone help me please? 1. The number of columns is unknown until run-time. 2. % Of Grand Total = Row Total / Grand Total 3. Display grouping of stores by city without using a separate column, only padded by spaces. 4. Display sub-total for each city without using a separate column, only padded by spaces. Col1 Col2 Row Total % Of Grand Total City1 Store1 11 12 23 10.85% Store2 21 22 43 20.28% Total 32 34 66 31.13% City2 Store3 31 32 63 29.72% Store4 41 42 83 39.15% Total 72 74 146 68.87% Grand Total 104 108 212 100.00% Thanks a million! Tag: SQL 2005 SRS error Tag: 77735
  - 13
    - Cant preview report Hi , I have a long sql statement(a little bit complicated), but I've tried to excute it in MS Sql server Management studio and it works correctly then I put it in the dataset of Reporting services(MS Visual studio) , when I change the panel to "Preview" ,MS visual studion seems no response and I have to stop it through the system tool... Please help! If you have the same experience. Thanks in advance. Lance Tag: SQL 2005 SRS error Tag: 77734
  - 14
    - Can Matrix Control handle this? -- Revised Again I don't know how to solve this reporting services requirements using Matrix control. Can someone help me please? 1. The number of columns is unknown until run-time. 2. PctOfGrandTotal = RowTotal / GrandTotal 3. Display grouping of stores by city without using a separate column, only padded by spaces. 4. Display sub-total for each city without using a separate column, only padded by spaces. Col1 Col2 Col3 RowTotal PctOfGrandTotal City1 Store1 11 12 13 36 11.11% Store2 21 22 23 66 20.37% Total 32 34 36 102 31.48% City2 Store3 31 32 33 96 29.63% Store4 41 42 43 126 38.89% Total 72 74 76 222 68.52% GrandTotal 104 108 112 324 100.00% Thanks a million! Tag: SQL 2005 SRS error Tag: 77733
  - 15
    - Can Matrix Control handle this? -- Revised I don't know how to solve this reporting services requirements using Matrix control. Can someone help me please? 1. The number of columns is unknown until run-time. 2. % of Grand Total = Row Total / Grand Total 3. Display grouping of stores by city without using a separate column, only padded by spaces. 4. Display sub-total for each city without using a separate column, only padded by spaces. Column1 Column2 Column3 Row Total % of Grand Total City1 Store1 11 12 13 36 11.11% Store2 21 22 23 66 20.37% Total 32 34 36 102 31.48% City2 Store3 31 32 33 96 29.63% Store4 41 42 43 126 38.89% Total 72 74 76 222 68.52% Grand Total 104 108 112 324 100.00% Thanks a million! Tag: SQL 2005 SRS error Tag: 77732
  - 16
    - Can Matrix Control handle this? I don't know how to solve this reporting services requirements using Matrix control. Can someone help me please? 1. The number of columns is unknown until run-time. 2. % of Grand Total = Row Total / Grand Total 3. Display grouping of stores by city without using a separate column, only padded by spaces. 4. Display sub-total for each city without using a separate column, only padded by spaces. Column1 Column2 Column3 Row Total % of Grand Total City1 Store1 11 12 13 36 11.11% Store2 21 22 23 66 20.37% Total 32 34 36 102 31.48% City2 Store3 31 32 33 96 29.63% Store4 41 42 43 126 38.89% Total 72 74 76 222 68.52% Grand Total 104 108 112 324 100.00% Thanks a million! Tag: SQL 2005 SRS error Tag: 77731
  - 17
    - SQL Reporting Services - Report model data update Hi, I created a report model using reporting services, deployed model and then built a report based on that model. The report works fine, but any data updates don't show up, seems like data is cached. I bounced reporting services, cleared cached tables in ReportServerTempDB but of no use. Has anybody faced this problem? How can I get updated data for reports built through a report model. Any help is appreciated. Thanks, Sri Tag: SQL 2005 SRS error Tag: 77730
  - 18
    - Creating CSV for Outlook: E-mail We've created a report that is intended to be delivered as a CSV file. This report contains contact information that users will import into Outlook. We would like this to be as seamless as possible. We are running into issues with importing email addresses. By default, Outlook expects the column in the CSV file to be named "E-mail". When SRS exports my table, it ignores the column headers and instead uses the textbox names for the first row of the CSV. SRS will not allow us to the textbox "E-mail". We cannot turn off column headers on the server. We have too many other CSV exports working just fine, unless there is a way to turn it off for a single report. We really perfer the users don't have to do a custom mapping when they import the file. Does anyone have any sugesstions on how to either get SRS 2005 to export a column named "E-mail" or what other label we can use that Outlook would use to automatically map our column to the "E-mail" field? We've tried a few varition of Email to no avail. SRS 2005 SP2 Outlook 2003 and greater Any help would be appreciated - Chris Tag: SQL 2005 SRS error Tag: 77728
  - 19
    - Printing Error This has never happened before. My report runs just fine, but when we try to print from the Report Manager, we get the following error: "An error occurred during printing. (0x80004005)" When I try to do a print preview in the Report Designer, i get the following error: "Operation is not valid due to the current state of the object." Does anyone know what causes this? (Using RS 2000) Thanks. Tag: SQL 2005 SRS error Tag: 77726
  - 20
    - Floating Group header column for Matrix I've created a report with a matrix that has a group header. Problem is, I want the grouping column to appear outside the matrix and not in one of the matix columns since this eats up a lot of report real estate. How can I do that? Would a better option be to create a subreport instead? Thanks for any help or information. Tag: SQL 2005 SRS error Tag: 77724
  - 21
    - ASP.NET Session has expired - please help Hi, We are experiencing random "ASP.NET Session has expired" errors when viewing reports (see exception message and stack trace below). The sessions in question are not our application sessions (this is proved by the stack trace). Some relevant info * We use the ReportViewer control in remote processing mode. * The ReportViewer control is not inside an IFRAME. * The ReportServer app pool is setup to use one worker process. * The error occurs seemingly randomly: sometimes on first view, sometimes during paging, and sometimes not at all. * On the server we invoke the report using code like: --- viewer.ServerReport.ReportPath = "/Reports/ReportName"; --- viewer.ServerReport.SetParameters(parmList); --- viewer.ServerReport.Refresh(); * We have not enabled cookieless sessions anywhere. * Our application uses SSL Environment * Windows Server 2003 Standard * SQL Server 2005 SP2 * Intel Core 2 6600 @ 2.4GHz * 2GB RAM ASP.NET session has expired Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: Microsoft.Reporting.WebForms.AspNetSessionExpiredException: ASP.NET session has expired Stack Trace: [AspNetSessionExpiredException: ASP.NET session has expired] Microsoft.Reporting.WebForms.ReportDataOperation..ctor() +679 Microsoft.Reporting.WebForms.HttpHandler.GetHandler() +561 Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context) +10 System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +358 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64 Thanks in advance Stu Tag: SQL 2005 SRS error Tag: 77722
  - 22
    - Metrics Report I have created Metrics Report but I am having problem to add summarized detail of my rows and Columns. For instance. Col1 Col2 R1 1 2 R2 2 3 I want to result look like Col1 Col2 Col3Rs R1 1 2 3 R2 2 3 5 3 5 8 I want appeciate if anybody can help me out. Tag: SQL 2005 SRS error Tag: 77721
  - 23
    - Using Like function y RS Expression Hi all, I´m tryint to use LIKE function in a chart filter with no success. I need to set up a filter that brings only the rows beginning with "TEXT". What I´m doing is to set up this filter is: Expression: ucase(Fields!MyField.Value) Operator: like Value: ="TEXT%" This doesn´t work. Could anybody tell me how to do it? Thank you. Mónica Tag: SQL 2005 SRS error Tag: 77720
  - 24
    - Help me on using Report Builder Hi, I am trying to create a report using the Report Builder tool. Please send me if you have any of the best articles, tutorials or resources on how to add filters, group by fileds for drilldown, and for custom code. Thanks, Sharat Tag: SQL 2005 SRS error Tag: 77718
  - 25
    - Passing Parameters Hi All, In my report I use multiple stored procedures. All of the params, in the sprocs, are the same name and type (@ClientId int). A user picks a client from a drop down parameter list and the ClientID is in the value property of the drop down. There is a dataset for each stored procedure. My question is, how do I use the ClientID, from the drop down box as the parameter for the rest of the dataset stored procedures? Your help is appreciated. Roy Tag: SQL 2005 SRS error Tag: 77714
- Next
  - 1
    - Can't create Subscriptions in Reporting Services When I try to create a Subscription in Reporting Services I get an rsInternalError server error and can't find any other helpful info anywhere. Does anyone have any tips? Thanks! url:http://www.ureader.com/gp/1157-1.aspx Tag: SQL 2005 SRS error Tag: 77713
  - 2
    - RSConfigTool Command Line I'm looking for a way to automate the configuration of Reporting Services once is installed using command line switches, does anyone know if this is possible? Thanks Tag: SQL 2005 SRS error Tag: 77712
  - 3
    - URL access to MS SQL Server Reporting Services I'm trying to create an ASP front end to a report hosted in Reporting Services on our MS SQL Server. MSDN, SQL Server 2005 Books Online, and other sources claim that a URL structured like this will work: http://server/reportserver?/SampleReports/Territory Sales Drilldown&rs:Command=Render However, when I structure my URL like this, RS takes me to the "front page" for the server. I can get to the report's page with this URL: http://sql1/Reports/Pages/Report.aspx?ItemPath=/HAL+Reports/CEO+Call+Sheet+(mult) but I haven't been able to pass any parameters, nor to make the report render. Can you advise me on the correct way to structure URLs, and an accurate web resource for further research? Tag: SQL 2005 SRS error Tag: 77704
  - 4
    - Rendering to PDF problems (Unicode Charecters/Fonts) Hello, We have a requirement to produced PDF reports (through MS Reporting Services or any 3rd party tool) for the corporate marketing website. PDF reports have to be of the highest quality since they are intended for the marketing purposes. Now, I am seeing that the PDFs produced by Reporting services are not rendered very well, to put it softly. Some Fonts that support Unicode characters are not coming through (Fonts are installed on the server) Tables lines very in thickness, etc. So, My questions: 1.) Did anyone experience these kinds of problems when converting to PDF, and how did you deal with them? 2.) Can we "plug-in" any other 3rd party (or write our own) PDF rendering engine Tag: SQL 2005 SRS error Tag: 77703
  - 5
    - Getting rsAccessDenied error for a completely different user?! When userA is not permitted to view the report server, the following message would normally appear when userA tries to access http://localhost/reportserver Reporting Services Error -------------------------------------------------------------------------------- The permissions granted to user 'domain\userA' are insufficient for performing this operation. (rsAccessDenied) Get Online Help -------------------------------------------------------------------------------- This is the correct behaviour. Now say userB and userC both have access to reports. When userB opens the page, it displays the list of RDLs correctly; when userC opens the page, he gets the above error message EXACTLY, meaning the report server thinks userC is userA and displays "The permissions granted to user 'domain\userA' are insufficient ..." So userC becomes userA and is denied access to the reports -- how could this have happened? I've checked the permission of that folder and IIS settings and there is no mention of special translation of username or permission settings for either user. Any ideas where else I should check? Tag: SQL 2005 SRS error Tag: 77702
  - 6
    - Matrix pivot column question I have a report that I'm setting up as a matrix. The dataset is returning: Description | Total | Available | Section | SectionQty Item 1 | 4 | 4 | | Item 2 | 8 | 6 | DIS | 1 Item 2 | 8 | 6 | FNC | 1 Item 3 | 4667 | 4651 | FNC | 16 Which shows, for each item, the total # and the available #, along with which section has how many. The Item, Total & Available columns are set up as row groups, the Section column is the column group, and the SectionQty is the detail. When the report renders, I get results of: Item | Total | Available | | DIS | FNC Item 1 | 4 | 4 | Item 2 | 8 | 6 | | 1 | 1 Item 3 | 4667 | 4651 | | | 16 Note the empty column showing up between the Available and DIS columns. How do I get rid of that empty column caused by the null for the first item (which still needs to be on the report to show the total / available qty)? Thanks, Wayne Tag: SQL 2005 SRS error Tag: 77697
  - 7
    - MOSS 2007 integrated - AAM - default zone problem SSRS 2005 and MOSS are integrated and both configured correctly. I can render the reports on the internal Sharepoint site (default zone) but not the external. Is there a work around/hotfix for this? Any tips would be appreciated. Tag: SQL 2005 SRS error Tag: 77689
  - 8
    - subreport with optional parameters Using report server 2005. Say I have a subreport with report parameter "p1" which is nullable, and has a static default value. In the parent report, is it mandatory to map the subreport's "p1" parameter and pass a value to it ? I'm thinking the parent report should run without errors even if the optional parameter is not mapped, but this is not what I'm seeing. Is this by design ? Thanks, Moe Tag: SQL 2005 SRS error Tag: 77684
  - 9
    - Matrix calculation issues Hello, I have a matrix that has the following data Week1 Week2 Week3 Week4 Week 5 .... Week 52 Total % a/z b/y c/x d/v e/ u aa/zz Value 1 a b c d e aa Value 2 z y x v u zz The expression for Total %, sum(value1)/sum(value2) The expression for Value1 is sum(value1) The expression for Value2 is sum(value2) All calcuations are correct. Now, I added another level called Year and made Week expandable. So Week can rolled up/collapsed into Year. For some reason, when I collapse Week into year, the calculation for Total % is incorrect. It shows me the Average of Total% In other words, I see this: +Year Total % Avg( a/z, b/y,c/x.....aa/zz) Value 1 Sum(a,b,c,d...aa) Value 2 Sum(z,y,x,v,u..zz) Can anyone tell me why Total% is showing me an average as opposed to Sum(a,b,c,d...aa)/Sum(z,y,x,v,u..zz)? Thanks in Advance. Clem Tag: SQL 2005 SRS error Tag: 77682
  - 10
    - Matrix / Table Combo Hello, I have an request that is throwing me for a loop. The user is asking for a report that provides purchasing amounts by months for the last 15 months, then asking for summary stats from different tables, i.e sales, cogs and inventory. Normally I would use a matrix report to present the 15 months of data. I could use sub queries to retrieve all the columns that are needed, but I was hoping there was a simpler solution. Any thoughts or suggestions would be greatly appreciated. R/ Anthony Tag: SQL 2005 SRS error Tag: 77678
  - 11
    - View reporting services reports in Access 2003 It is possible to view reports created using reporting services in Visual Studios 2005 from Access 2003? Tag: SQL 2005 SRS error Tag: 77674
  - 12
    - Parent Child OLAP report I have a parent/child type dimension in a cube that I'm trying to write a report against. I can't figure out how to get it to display correctly. When browsing the cube it displays all the hiarchies ok - but can't get RS to work. Anyone got some samples or direction they can send me? Tag: SQL 2005 SRS error Tag: 77673
  - 13
    - ignore browser locale Hi, How can I configure Reporting services to ignore the browser locale. I want to be able to configure sitewide the locale of the parameters. Thanks, Ignacio Pd: I know of the existence of the rs:ParameterLanguage , it's just that I would like it to be a sitewide config option and not a parameter for each report. -- Ignacio Machin http://www.laceupsolutions.com Mobile & warehouse Solutions. Tag: SQL 2005 SRS error Tag: 77671
  - 14
    - Month Function - left pad single digit months Month(now()) returns 1 in January. How do I left pad that 1 such that it will return 01 for all single digit months? Thanks. Tag: SQL 2005 SRS error Tag: 77669
  - 15
    - a group rows are intermixing with those of detail group Group's rows are intermixing with the next group. Say I have two groups Group1 and then Group2 on the report. Group 1 rows are intermixing with the second instead of first displaying all the rows from Group1 and then Group2. What I am missing here, any help appreciated. Thanks. Tag: SQL 2005 SRS error Tag: 77666
  - 16
    - Subreports: Parameter value dropdown shows sum and Count fields bu I have just started using SQL Server reporting services and am stuck with creating subreports. I have a added a sub report to the main report. When I right click on the sub report, go to properties -> Parameters, and click on the dropdown for Parameter Value, I see all Sum and Count fields but not the data fields. For example, In the dropdownlist for the Parameter value, I see Sum(Fields!TASK_ID.Value, "AppTest"), Count(Fields!TASK_NAME.Value, "CammpTest") but not Fields!TASK_NAME.Value, Fields!TASK_ID.Value which are the fields retrieved from the dataset assigned to the subreport. When I manually change the parameter value to Fields!TASK_ID.Value, and try to preview the report, I get Error: Subreport could not be shown. I have no idea what the underlying issue is but am guessing that it's because the field - Fields!TASK_ID.Value is not in the dropdown but am trying to link the main report and sub report with this field. Am I missing something here? Any help is appreciated. Thanks, Sirisha Tag: SQL 2005 SRS error Tag: 77665
  - 17
    - Point Labels on Chart control are not visible sometimes Some of the Point Labels on a chart (chart type = Bar) are not visible under certain circumstances. In many cases it is the label of the widest bar (with the biggest value), but most of the time it is the last label (on the bottom oft the chart). To reproduce place a chart control on a report layout, set the chart type to Bar. Set up a datasource, and drop a datafield onto the datafield area of the chart control. Select "Show point labels" and select a data label source. Normally the labels are shown for each bar now. The behaviour of disappearing labels can be observed in layout view of report designer when the chart (height) is resized (by mouse draging). If the size of the chart is changed, some labels (in most cases the lowest one) disappeares for certain sizes of the chart. If a label is disappeared it can be observed in Preview as well as in Runtime. Tag: SQL 2005 SRS error Tag: 77664
  - 18
    - SharePoint Reporting Services I configured SQL Server Reporting Services to be integrated with SharePoint. But From SharePoint side when I try to set SharePoint Report server default I get a big error message which start like below : An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode. --> Server was unable to process request. ---> Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'. Tag: SQL 2005 SRS error Tag: 77663
  - 19
    - ValueLocID Hello, Do someone know how to use the property ValueLocID in RS 2005? I would like to have my report in two different languages. Can I use the ValueLocID property for this? Regards, Mattias Tag: SQL 2005 SRS error Tag: 77661
  - 20
    - Refresh Button Not Working In 2005? Hi, in RS 2000 if you ran a report, then change some parameters and press the RS Refresh button (not browser refresh button) the report would re-run with the new parameter values. In RS 2005, you do the same thing, the report re-runs but with the old parameter values and the new parameter values are still visible. Is this a bug in 2005 or an intentional behaviour change? I know you can press View Report but some users prefer Refresh because the View Report button can disappear off the right of the screen for some reports. This is nothing to do with caching because in both cases, caching is turned off. Thanks. Tag: SQL 2005 SRS error Tag: 77658
  - 21
    - How to add a line chart while building report This is my first time with Reporting Services. I was using the wizard and it only had the options of Matrix or tabular. I want to add a line chart instead. How can I do so ? Thanks Tag: SQL 2005 SRS error Tag: 77655
  - 22
    - Reporting Services and Temp tables I was going over through the report wizard and in the query string specified the stored procedure that i want to run such as exec dbo.sproc1 and it gives me an error There is an error in the query. Invalid object name '#temp1'. #temp1 is one of the temp tables in my stored proc that I use. Sproc runs fine when run in Management studio.. just gives me that error in the report wizard. Thanks Tag: SQL 2005 SRS error Tag: 77653
  - 23
    - Problem in report format in Outlook 2003 I am emailing reports to employees every night through Subscription feature of SQL Reportings Services 2005. I used Render Format as "Web Archive" The report looks good in the email but once an employee tries to print out that email then some of the rows got half copied copied to next page. Can anyone please help? Thanks in advance Tag: SQL 2005 SRS error Tag: 77648
  - 24
    - Report Server Security I have been playing around with the security on my SQL Reporting Server and want to make sure I have reset it correctly. Under my default website I have \Reports (http://server/reports). When I Right Click the virtual and go into the Properties/Directory Security Tab/Edit button on the Authentication and Access control what should I have checked for "Enable Anonomous" checkbox and and "Integrated Security" checkbox? Same goes for default website\ReportServer. What would happen if only Anonomous is checked? When I have only Integrated checked on \ReportServer I get just a plain page giving me the Reporting server name and a MSRS version of 9.00.3042.00 But nothing else. Does this virtual directory do nothing and only used by the configuration manager? Thanks -Richard K Tag: SQL 2005 SRS error Tag: 77647
  - 25
    - SRS Webinars I have a client that wants to get some SRS Training with regards to Microsoft CRM, but before I provide this to them, I would like them to be well versed on SRS or at the very least, to have attended an introductory/overview webinar of just SRS. Does anyone know if there are any good Microsoft or other webinars that our clients can attend to get a basic understanding of just SRS? Tag: SQL 2005 SRS error Tag: 77646

Hi,
I have oÅ?e problem by SRS installation - after installation the SRS - is SQL
2005 WE, when I install the CRM I receive this error message - "not exist
file WAConfigFilePath" - can anybody help me, what is possible try ?
Regards
Jaro

Top