Hi, I have a problem with group expressions in a list. I want to use two expressions: '=Ceiling(RowNumber(Nothing)/3)' and '=Cint(Fields!kpilevel.Value)' They work both individually, but when I insert them together only 1 works. I inserted them like this: img718.imageshack.us/img718/736/problemxq.png Does anyone know how to solve this...
I want to set up a SQL Server 2005 database, a Reporting Services instance, and IIS to view reports via the web and web applications. How many servers are optimal for this setup? I hear various things about the security of having IIS on the same box as a SQL Server. I'm preparing to price out some servers for this type of configuration...
Hi, I am writing an ASP.NET app that uses a SQL Server 2005 with SSRS setup. I want to use the ReportViewer control but I get an error when using ReportViewer 10 because it needs SSRS 2008. How can I use ReportViewer 9 within my application. I've added a reference to the Microsoft.ReportViewer.WebForms.dll version 9 and removed the r...
Hi, I am trying to use the Sharp-shooter Silverlight report viewer control. This control has a server side component that renders the reports as XAML for displaying in the client side control. I have tried manually installing the rendering extension, according to the instructions on their website, and also the instructions on MSDN. ...
See title. Basically, the data in this report is set up such that each value in Field A has multiple corresponding values in Field B, and I need to display Field B as a comma-separated list. According to the internets, this is totally easy via a combination of Join() and LookupSet() in 2008... but I'm on 2005. Anyone know how I can do th...
Is there a list anywhere that lists all the variables I can use in file names for report subscriptions from within SQL Server Management Studio? I currently use @timestamp in my file names, but would like to use other options or even remove parts of the time stamp (for example, just use the date, not the time). ...
I've managed to obtain the report definition schema for SQL Server 2005, but cannot find the xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner" schema anywhere. Is it part of the 2005 install buried somewhere? The reason I ask is because I've recently started writing RDL files for SQL Reporting Services. I'd lik...
Have you ever had a matrix in a report become too big to display it all? I think i am experiencing that now. My report has about 5 drop down filters. IF you select all the sites it can be approximately 230 items that will be down the left side of the matrix. If I select more than 32 it acts oddly, it doesn’t show them all and what it...
I have one report that does not export to excel friendly from SSRS 2005. I know I can use <Render> <Extension Name="EXCEL" Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Microsoft.ReportingServices.ExcelRendering"> <Configuration> <DeviceInfo> <SimplePageHeaders>True</S...
I'm asking this because i'm a n00b when it comes to Powershell. How do i use Powershell to add a particular domain user or group to a specific reporting role in SSRS2005 (say the Content Manager or Browser role)? Is there a simple one or two line script to achieve it? Thanks! Note: this is definately programming related (not server a...
Hi, I was wondering if there is a was to check if the "Current User" (User!UserID) running the report is in a network group, from the dataset query of a report? Currently we are restricting access to data based on the "CurrentUser" by checking in the where clause of a SQL query, for example, if the CurrentUser is the "Creator" of a dom...
Hi, I have custom code inside of a SSRS report that needs to get the current user. e.g. Dim myPrincipal As New System.Security.Principal.WindowsPrincipal (System.Security.Principal.WindowsIdentity.GetCurrent()) I would have expected GetCurrent() to return the principal of the user that was accessing the report; however, it give...
In our production server we have so many reports already deployed, and all are working fine with out any issues. But when ever we tries to load a new reports Report Server crashes. Our application dynamically generates RDL and deployed into SSRS. and later user can view it from another screen. When we restart the server every thing works...
I have a report in SQL Server Reporting Services 2005. It makes use of a page header and footer and has no subreports. The body portion contains a few smaller elements and then a simple single column table. The table has a single header row and a single detail row. The header is just a label, basically. The detail row is a single te...
Hi, I need to pass a value as a parameter from ASP.Net application to SSRS Report.How can i do this?Can anybody help me ? Thanks in advance. ...
Would like to know if methods need to be static in a C# assemble to be access from SSRS? ...
I have a SSRS 2005 report that lists data between two particular dates. I want to restrict the user from selecting more than a week's worth of data (so they can't do something silly and attempt to view five years worth). Is there any way do do a comparsion on parameters that are being entered, and prompt the user if they fail certain ...
I was wondering if there anyway to manipulate the position and size of the text boxes for the parameters in SSRS 2005. They generally take up a large part of the top of the page and I want to prevent that if possible. ...
I have two entities (A and B) which share a common key, but aren't related by primary/foreign key in the database. I have created a logical relationship between the two in the data source view, and a matching role in a model. The cardinality of the role is "OptionalMany to OptionalMany" since none of the columns are marked as unique in t...
Our company has a huge nasty report that takes about 50-60 minutes to run (it's for a university and lists all sorts of payment information for all students registered in courses). While it has been running each morning at 5am as a subscription, it recently stopped working and displays "An error has occurred during report processing." in...