Reports

Subscription Ax data method provider
Hi, I try to use subscription on a report using the AX Data method provider quering a Dyamics AX 2008 installation. The report works fine when actively rendering but neither a snapshot or subscription on a schedule is possible. I recieve an error just saying there is a error rendering the report. I have tri... 11 Nov 2009 09:01

ReportViewer: A data source instance has not been supplied for the data source
HI All, I am trying to use a reportviewer control on my Web page to display some reports. I wanted to use the same control to display more than one reports. But when I have a preSelected report every thing works fine. but when I change the report path programmatically I am getting this error. "A data sourc... 8 Nov 2009 23:00

TextAlign problem?
Using SSRS 2005 (SP3) and having a table control I want to have an expression to align the text in the table Right--Left based on value So far I have in textAlign property of the cell =IIF(Dataset!FieldName.Value=0 "Right","Left") --does not work Thanks ... 10 Nov 2009 09:34

Style of the first details column messed up (IE8 and FF3)
Hi Bogdan, Sorry to bother you. I don't suppose you've found a fix for this problem have you? I am having exactly the same problem in IE8 as well as the columns in the detail table being too small. If I switch to compatibility mode it looks fine. Surely Microsoft would write a control to work with their o... 5 Dec 2009 21:45

SSRS 2008 Condition Column Visibility Whitspace Issue
I am using IIF statements to show/hide tablix columns based upon a parameter value. These statements are used as expressions in the visibility properties for the columns. If the parameter value is one that causes the column to be hidden, the coulmn does not appear on the report, but there is whitespace in its pl... 2 Nov 2009 15:45

Accessing SSRS through SSMS
Without giving someone membership into the "BUILTIN\Administrators" group, how would one enable a user to be able to access SSRS through SSMS? SSMS >> Connect >> Reporting Services >> {Server Name} I'm currently getting the error below: TITLE: Connect to Server ------------------------------ Cannot connect... 28 Oct 2009 10:41

Report that would list folder security setting
The xmldescription column in the SecData table in SSRS database contains the security (user access and role ) information for each object in SSRS. Linked back to the catalog table and you can get a complete listing of who has access to what. We'd like to be able to report on that information however we do not kn... 23 Oct 2009 09:59

Deserialization
I am getting this error recently SQL Server Reporting Services - Deserialization failed: Could not load type 'Microsoft.VisualStudio.Shell.IOleMenuCommand' from assembly 'Microsoft.VisualStudio.Shell.Interop.8.0, Version=8.0.0.0 I don't know if one of the following updates caused this. I have another compu... 20 Oct 2009 15:39

Keep Together on Subreports
When you render a report with a subreport, the subreport is having a kind of default KeepTogether = true, meaning that the subreport will leave the first page empty if its fits entirely in a new page. You can check this rendering the Ledger Card report (specific to my application) , check LC# 1 for example. I th... 21 Oct 2009 11:32

Export to Excel - Naming of Sheets
Hi, Using SSRS 2008, with the VisualStudio Report Writer I have a report which exports fine to excel. There are a number of page breaks which then get outputted to new sheets in the workbook. This is exactly what i wanted to happen. Only problem is that the sheets don't have names (except for the standard sheet... 19 Oct 2009 08:37