| Thread | Last Post | Replies |
|
| Error: 7105, Severity: 22, State: 6 | 31 Oct 2006 23:24 GMT | 1 |
My SQL server logs this in Application log: Error: 7105, Severity: 22, State: 6 Page (1:952446), slot 39 for text, ntext, or image node does not exist. MS KB890755 http://support.microsoft.com/kb/890755 asked to contact MPSS for
|
| Querying XML containing <![CDATA[ elements | 31 Oct 2006 22:13 GMT | 1 |
Anyone know a way around this one? I needed to get XML data from a web service. The web service (which I can't change) outputs some of the elements as CDATA. Doesn't look like the XML data provider included in RS2005 can handle these. Thinking it might be a problem
|
| Styles for reports to Reporting Services 2005? | 31 Oct 2006 22:10 GMT | 5 |
We are currently working on a project where we need to have all our reports to have a common style (Reporting Services 2005), but we struggling to find out how to find a way where we can have a common style
|
| Name multiple sheets in excel export? | 31 Oct 2006 21:41 GMT | 4 |
I have a report that when exported to Excel creates multiple sheets. Im doing this on purpose. I wanted know if anyone new a way to automatically name the Sheets in the Excel export? I wanted to name them from a field on the report.
|
| Report Services Bug? ----Sub Report and Page break!!! | 31 Oct 2006 21:38 GMT | 2 |
When the main report calls the meeting sub report, if the content of the sub report is longer than the pare space on the current page, it will jump to the next page without filling the rest space on the current page. Is it a bug of Report Services?
|
| rsExecutionNotFound | 31 Oct 2006 21:24 GMT | 1 |
Has anyone figured out what causes a "Execution '2ye0gq45qszd0m55wlgy0n55' cannot be found (rsExecutionNotFound) " error? Our scenario is this: A relatively new/unused sql server 2005 (so load is not a factor). A new report (the first one on this server) conisting of a main report ...
|
| conditional IF | 31 Oct 2006 20:41 GMT | 2 |
Hello. I have a query whice look like this: select a,b,c,d from table1; Now - when pressing a cell in the first column we are jumping to another report with the value as parameter (called- p_param);.
|
| conditional IF | 31 Oct 2006 20:41 GMT | 2 |
Hello. I have a query whice look like this: select a,b,c,d from table1; Now - when pressing a cell in the first column we are jumping to another report with the value as parameter (called- p_param);. In the other report the query is:
|
| Using variables in text dataset does not work | 31 Oct 2006 19:44 GMT | 2 |
I have a query that I am using in my report as a text dataset (i dont want it in a stored proc yet) but my issues is that I have a variable defined that I want to become a parameter for the report. What happens is if I refer to the variable at all before the select statement its ...
|
| Using LIKE in a Filters for a Table | 31 Oct 2006 19:38 GMT | 2 |
I am trying to filter a dataset that is displayed in a table. However when I use LIKE as the Operator I cant get it to work. What is the correct syntax for the VALUE column? I have tried (where Text is my sample string I am searching for):
|
| Parameter multi-value problem when using a stored procedure | 31 Oct 2006 17:21 GMT | 2 |
I am describing the issue as below: 1. create a stored procedure as below .....where age in (@p_age) note: age is the table coumn of table table1 with datatype tinyint
|
| Select All parameter option missing on Report Mgr Website | 31 Oct 2006 16:13 GMT | 8 |
I have designed a report that has a parameter that allows you to select multiple customers. When I preview the report in Visual Studio 05, the drop down list has a checkbox at the top that says "select all". When I deploy the report to the Report Mgr Website (SQL Server 2005 STD ...
|
| Incorrect page count on reports that use drill-down or have hidden | 31 Oct 2006 10:51 GMT | 9 |
I am getting an incorrect page count on reports that use drill-down or where report items are hidden. The Globals!TotalPages returns 1 on a report that clearly has more than one page. On these reports, the Globals!TotalPages returns the correct page count for the print preview. ...
|
| Textbox Renders Incorrectly Across Multiple Pages in PDF | 31 Oct 2006 10:45 GMT | 11 |
We have a repot that contains a textbox that may contain a large text string with embedded line breaks. This textbox is positioned in the lower portion of page 1 of the report. We are running into a situation when the text string is long enough to cause a page break when ...
|
| Best parctices in SSRS 2000 reports development | 30 Oct 2006 23:33 GMT | 1 |
Any ideas or known approaches on how to better develop reports. I have about 30 Crystal Reports based on stored procedures. Now I need to develop SSRS 2000 reports. What is the best way to achieve this in terms of layout development? Is there any kind of a style sheet or ...
|