I have an application that sends a report path and parameter collection to a Microsoft Reporting Services server. One of these reports is very long running and when users try to generate reports within a few seconds of one another, one will receive a duplicate of the report requested by the second user. This doesn't happen as a glitch,...
I am having some difficulty in determining how best to implement the different parts of reporting services. Our company has just bought a new slew of servers and a shared SAN to support our growing infrastructure. Our servers are running VMware and we have several virtual machines each with their own tasks load balanced across the set ...
For SSRS 2005 report how do i read inconsistent nvarchar data values from database as consistent numeric decimal data for plotting a line chart? the nvarchar column has lab readings to be plotted on a graph as nvarchar(15) datatype. sample column with inconsistent data as shown sample columnvalues: 00123 102 (NULL) 333 456 N/R No Resu...
I have implemented a printer delivery extension based on MS example in SSRS 2005. Everything works fine, however, I run into a problem when the dataset is empty. I get a single blank page. If there is no data I would rather not send the job to the printer. Anyone have any experience with this or ideas how to solve my problem? ...
Is there a better way to allow us to scan back a year at a time in addition to a month at a time rather than just only a month at a time? ...
Hi guys, I have a table in the database where a "Description" column is of nvarchar(MAX) type in which HTML string is saved. Now, what I want to do is to have a report view of that table and the "Description" column renders the contents as HTML formatted already. Is there a possibility for this to be done in SQL Server Reporting Servic...
I have SSRS report with its own datasets coming straight from the database. I have the report on ASP.NET application page. The application page header has the username and user region details defined in the master page. Now, I want to read this region id label from the ASP.NET page and build my report accordingly. Basically build...
I have an ASP.NET page which has report viewer control to access reports from report manager. I need to pass report parameter from this ASP.NET page to the report server. I want to pass region number based on user logged in, which is displayed on a label in ASP.NET page. Thanks. ...
I'm trying to pass a parameter via the url to SSRS and it appears not to work! I'm trying to pass a userId (string) via the url which will be passed to the database and used by the query. base url: http://blah/Reports/Pages/Report.aspx?ItemPath=MyReport tried this but it doesn't work: http://blah/Reports/Pages/Report.aspx?ItemPath=MyR...
I have just written a report using the Matrix control in SSRS 2005. I have coloured the rows and columns and when I preview the report the colouring is applied. Same with export to pdf. Only when I view the exported report in Excel do I get a problem. The report colours are rendered properly other than the Matrix controls. (they are re...
What are the required steps to properly allow domain users access to reports via the Reporting Services web site? What I've tried: Added users through Reporting Services site (i.e. http://servername/Reports) Given users access through SQL Management Studio Result: users are continuously prompted by the browser for their credential...
Hi, I am using Reporting services 2005, and am exporting the reports into Excel. Everything is fine except for cells that have been referenced to. An example is this: textbox1 has the value 10 textbox2 has the value 20 the formula in textbox3 is =ReportItems!textbox1.value + ReportItems!textbox2.value textbox3 would have the correct ...
I have a chart with these characteristics: chart type is XY (scatter ) all XY data have x-values that are integers; they are called "Update Cycle" numbers. This represents "score" data from a given program. in addition to the values that produce the XY data, I've added two other elements to the "Values:" list: one that is the average ...
I have a SQL Server Reporting Services site that I can get to by https://localserver/reports Now when for setting permissions on each folder and report item or datasource item in that folder I have to click on the "properties" then "security" of the item, and then assign the appropriate permissions. It's just that there are hundreds of i...
I have created a parameter on a report that allows the user to open all the group details or hide group details when the report is run. This works, but when you run the report and select to expand the groups, the little icon use use to show/hide on the report is a + symbol instead of a - one. While the actual report is right, i can se...
Some of our reports aren't displaying properly in Firefox - the first column lacks any css. After investigating, I'm finding: <tr> <td style="HEIGHT:6.93mm" style="...">1st Column</td> <td style="...">2nd Column</td> <td style="...">3rd Column</td> </tr> When I remove the style="HEIGHT:6.93mm", it renders properly in Firefox. ...
I am trying to evaluate a Price per Kilo ($/Kg) based on sales of a product. This works fine if the product was acutally sold during the period specified. However if the product is not sold the Kg (the denominator) ends up being 0 (zero) and an error results. - Divide by Zero error. I tried this =iif(KgSold=0,0,Revenue/KgSold) It a...
I know how to add a hyperlink to an http:// address, but it doesn't seem to work with file:// address when I want it to point to a file on the file share. Tried the following: file://\\server\folder\file.txt file:\\server\folder\file.txt \\server\folder\file.txt All 3 methods above work in Windows Start Menu's Run... box. But just no...
Background: Progress based ERP system called QAD 2008.1 (formerly MFGPRO. SQL Server 2005 Enterprise SP2. Reporting Services 2005 SP2. Progress OpenEdge 10.2A Driver. ODBC System DSN created using the Progress OpenEdge 10.2A Driver. Problem: I am creating a report with Reporting Services and will need to use the Progress OpenEdge 10.2A ...
Zilch on the web or BOL Any ideas? ...