I am trying to setup a data-driven subscription and it works fine except when 2 of the parameters are set to take dynamic values instead of static ones. The strucutre is basically Param1 -> read from database Param2 -> read from database Param3s -> read from database Param3 -> split Param3s (multivalued parameter, allowed val...
I can't figure out how to modify the C# code below, which works as it is. writer.WriteElementString("Value", "=Parameters!StartDate.Value + Parameters!EndDate.Value"); This results in the following in the XML file. <Value>=Parameters!StartDate.Value + Parameters!EndDate.Value</Value> I want to add the word "To", but I can't figu...
I'm presently working on a large intranet mashup that uses sharepoint to aggregate content from several other internal servers such as: moss.myapp.internalserver.local - The MOSS portal ssrs.myapp.internalserver.local - SQL Server reporting services reports app.myapp.internalserver.local - Custom ASP.NET MVC forms The moss portal inv...
I'm new in Reporting services and got little confused. in the screen shot you can see what I did. I have two groups, the inner is by employe name, and the outer is by Month. Now I want to calculate the sum of the hours for example and it doesn't works. In the textbox with the value of 755.434 the formula is : =Sum(Fields!time_differ...
I use VS2008 to develop a web application. When I open a local report, it's report datasource does not show. I click the report->DataSource to see it's datasource, but it appear an error message: "Could not load file or assembly ### " But the file or assembly does exist. How can I solve this problem? I searched everywhere and didnt...
Hello, please can someone help. I have two datasets I'm working with and two tables. I've managed to do one expression correct so do not understand why my second won't work. My first expression is where I need to state the target number based on a result e.g. =IIF(Fields!Line.Value = "B1", "10", IIF(Fields!Line.Value = "C1", "15", ""...
I have report developed and getting the data fine. But, when I scroll the report, I get the following: 1:microsoft JScript Runtime Error: Object Required. 2:microsoft JScript Runtime error:zofnhot is undefined . Nowhere have I used javscript, why is this error coming? ...
I have developed a Web Service using JAX-WS (v2.1.3 - Sun JDK 1.6.0_05) that works just fine when I use a Java client or SoapUI or other Web Services testing tools. I need to consume this service using 2005 Microsoft SQL Server Reporting Services and I get the following error <?xml version='1.0' encoding='UTF-8'?> <S:Envelope xmlns:S="...
I have a Reporting services project that has a number of reports in the the report folder and a Live, Test and Dev data source in the Shared Data Source folder. I have set up the solution configurations to deploy to different folders on the server based on the config (eg. debug -> dev). My problem is that i need the reports in the dev ...
Good morning, I have recieved a rather odd reqeust. I currently have a report that is grouped by weeks. The customer loves the report but he would like a toggle option that would switch the view to months instead of weeks. I have never recieved this kind of request before and am not certain how to do this. Any assistance, direction, ...
Hi, I have a line chart with four lines: - Total - A - B - C It is a only a limited number of lines, and I want to allow the user to specify via input parameters what lines to show (i.e. ShowTotal, ShowA, ShowB, ShowC booleans). Can it be done, and how? ...
I am trying to convert one of our most simple reports to Reporting Services. The original excel report calls several stored procedures using the results of one to structure the next as it drills down through the data. I currently have 2 datasets both of which call stored procedures. The first is called GetGlobalCustomers. This populat...
Hello, I have a report which has a document map for navigation. When I export it to PDF, the document map becomes "Bookmarks" which I can navigate from Adobe Reader. All good, but I need two ectra features: In addition to the Bookmarks I need a classic table of contents with page numbers and navigation links. I want the Bookmarks side...
How to create parametrized reports using microsoft report viewer? ...
I'm using Visual Studio 2008 and have created a Client Report Definition (.rdlc). In this report I add a single Textbox and double it's height. When I change the TextAlign to "Center" it correctly centers the text, but when I set the VerticalAlign to "Middle" nothing happens. The textbox is big enough that it's obviously not aligned to ...
I recently had the task of adding a barcode onto a SSRS report without being able to add anything to the report server other than the report itself. ...
In my vb6.0 desktop application currently it is using crystal report. i am upgrading to ssrs. can any one tell me how to connect to ssrs at runtime from vb6.0 ...
Developer has Samsung Bixolon SRP-270 printer hooked locally to their computer. When you print from the Report Server to a normal printer the text looks fine. When she prints to the mini-printer (like a receipt printer), it squashes the text into a very small area on the left of the receipt. I can't see any settings anywhere that woul...
I have an SQL Server Reporting Services (SSRS) report, that uses a view. That few had to be adjusted yesterday. Now the report shows online the correct data, however as soon as I click on export to Excel it seems to bring to outdated data. Opening the Excel yields data that was correct before the view adjustment. Is this Excel Version so...
I have some machines that when accessing SSRS Reports show "Internet" or "Unknown Zone(Mixed) instead of "Local Intranet". Some user never report this problem, for others it appears consistent. These machines should be all setup the same. We access the SSRS reports with a url like http://test-intranet.xxx.com. Have checked the security s...