Reports

show XML schema and values
I have an XML document that looks like the following: <record> <Field1>value1</Field1> <Field2>value2</Field2> <Field3>value3</Field3> </record> What I'm aiming to do is to show the data in a report as in the following example: record: Field1 value1 Field2... 21 Apr 2010 08:26

group totals w/criteria?
SSRS 2005 I'm relatively new to RS and have a challenge I don't know how to overcome. I have a report where I need to subtract one group total from another. I read that this isn't possible in 2005, but that 2008 will support aggregations on aggregations. I'm sure someone has figured out how to do this in 2... 26 Apr 2010 17:14

Report Builder
Is it possible to have dynamic datasources (like in BIDS) for report models? We have 200 vendors wanting access to our ReportBuilder, but I don't want to build discreet ds's for each one. I've googled it but can't find anything that relates. TIA, Michael C. ... 20 Apr 2010 19:42

Insufficient permissions
We have SSRS 2005 integrated with MOSS 2007. As of this morning one user can no longer run reports. Every report results in the exception pasted below. Strangely, this same error has been appearing in the log files for that last two weeks for a number of users but none of them have any problem viewing report... 22 Apr 2010 11:23

SSRS 2005 migration to sharepoint MOSS 2007 & SSRS 2008
Hi Folks, We are using sql server 2005 reporting services using native mode from past 2 years. we have 100 reports got deployed and users are using them using SSRS 2005 report URL. we have different folders,datasources,permissions configured on this report url. Now our company deployed MOSS 2007 a... 20 Apr 2010 16:33

credentials to run this report are not stored
Hi all, I'm getting this problem when I try and create a timed subscription. Error: ...credentials to run this report are not stored..... ok I created another folder under the same folder where I'm having this problem. loaded the report and I have no problem. I even moved the current folder with that ... 20 Apr 2010 10:20

SQL Server 2005 SP3 Failed IIS 6.0
I have a SQL Server 2005 Enterprise Edition database server (32-bit) with service pack 2. When I tried to install SQL Server 2005 SP3 on the database server, it completed on all SQL Server programs except reporting services (Database Engine, SSIS, and Analysis Services). The present IIS version is 6.0. Is... 19 Apr 2010 17:48

ReportViewer LocalReport in own AppDomain ?
Wondering if anyone has done this successfully and has any code they can share ? I have a non-GUI app that runs 24 / 7, and there has always been a memory leak in the LocalReport.Render call. In VS 2008 this was around (average) 20k per report, with VS 2010, I was hoping this leak would be fixed, instead it's mu... 19 Apr 2010 11:34

Chart Question
I have a column chart that is working. I have the value of the column shown in the series. On some of the column bars there is a value underlined with an arrow pointing either up or down. Does anyone know what this is and how can I turn it off? I am using RS2008 with SQL Server 2005. Thanks in advance ... 19 Apr 2010 08:28

How to create multiple hyperlink's dynamically for a single Row
From a Sub quary i will get multiple records as a , separated list for a column id. can we create hyperlinks for that subquared value as each value in it will give its own hyperlink. EX: the values are coming like this Row 1 Row 2 ------------------------------------- id value1,value... 19 Apr 2010 10:32