Hi, I am working on a solution that uses Web Apps, Class Libraries & SQL RS Reports. I have WebSetup projects etc. for the .NET projects ; and am looking for a way to deploy SQL RS Reports to a Reporting Server from an installer... any ideas? Regards -- _________________...more >>

greetings, in my report, i want to hide the drop down box for selecting multiple format, the paging and also the percentage for viewing the report size. can that be done? thanks in advance....more >>

When I try to delete this report from the admin it times out, same if I try to republish from the report designer. I am admin on the box and in reporting services. Error looks like: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Data.SqlClien...more >>

I have a Bar/Line Chart with two data fields. Field #1 is displayed as a bar, Field #2 a line. I would like to allow the user to choose via a parameter if the line is displayed. I tried the following expression for the Field: =iif(Parameters!ShowTrend.Value=True,Fields!Trend.Value,False) ...more >>

How do I refer to the actual value for the label inside my expression? Say you have datetime data across the x-axis for the data. I get one row per month in the dataset (every row is same date and time for each row/month). I understand how I can format this, for instance "MMM" to get month name...more >>

Say you have a few charts which you want to align vertically. Both left and right side of the charts should be at same vertical position. This is especially important if you have same measurement and scale for the x-axis for two charts and want to compare values across two diagrams. I have not f...more >>

Is there any way to use logged on user credentials in sql when rendering datasets? I'm using "Integrated authentication" on my IIS, I would like to use the domainuserid in my querys to the SQL-server. Any ideas??! Regards Kjell Brandes ...more >>

We are having an issue getting Report Manager to work with SSL. Here's the setup: We have thatken the forms authetication example and have modified it to suit our needs, and it works fine (no SSL at this point). Now, we want to make our application available over the Internet, so we have go...more >>

One of our user requirement is to include "Print" option to the Reporting Manager toolbar (either inlcude in the Export to .. list or a separate option to send the report to the printer). Is this possible.? If possible, how? if not, what are the alternatives? Thanks ...more >>

Hi, In the group footer I want to show: Total store with ABC systems is: 33% of Total stores 33% is a calculated field. The expression for this is: "Total store with ABC systems is: " & =Fields!A1.Value/Fields!B1.Value & " of Total stores" I merged 3 cells and put this expression is ...more >>

Is there a way to specify "Jump to Report - Self" rather than specifying the name? So that even if I change the name of the report, I can keep my logic carried forward... Thanks...more >>

I can easily get the max and min values of a dataset, but I want to get another value in the record associated with that max or min. For example, I am using a stored procedure to get average number of minutes per day of week. I would want to get the min value, plus the day of week associated ...more >>

I have a table report based on a single 50,000 row table. The report doesn't do anything unusual, but there are 5 grouping levels. The ExecutionLog table shows the report took < 1 second to pull the data, but 22 seconds to process the report. Given that my high end server can perform millions ...more >>

I'm experiencing an odd problem with Visual Studio 1.1 when using/developing reports, etc with the SQL Reporting Services. After I build/deploy SRS reports to my Reporting Service Visual Studio seems to lose its ability to display intellisense and format new/modified VB.NET code per the origin...more >>

I have looked at the SOAP method of integration as well as the URL method, and it is just not possible to save report parameters as selected by the user! The only way you can save them is if you re-invent your own parameter inputs! And keep in mind that a complete integration solution should be a...more >>

Hi all, I need to be able to get data from a query with parameters and use one of the fields returned in the Page Footer of a report. Any ideas, I know it is probably fairly simple but I am new to this. TIA Andy...more >>

I'm pretty new to this, so could someone tell me if this is possible? and if so, how? thanks...more >>

I'm trying to reference a image control value property. I want to show the contents of the value property in a textbox control. I thought I saw this before but cannot seem to find it again. For example, I have an image control called image1. Which has a value of: C:\images\xxxx.jpg In a tex...more >>

Hi: The database we are reporting from (DB2 running on AS/400) has a field with the data type of CLOB. We would like to perform an XSLT on this field within the same report that contains more "normal" data (strings, numeric, etc.) types. This database contains error and status message...more >>

Hello, In my report manager I am not able to set a default value for a report parameter, because the default value is indicated to be "query based". I do not seem to be able to change that whatever I do. Surely I tried setting the report parameters to "non-queried" and "none". The default v...more >>

Hi, I had a aspx page doing the front-end for my report page. Inside the aspx, I had a web user control ascx with 3 dropdownlist. How can I pass the selected value to my report page with http Post? So far other standard aspx control in my page can be post without any problem. Any suggesti...more >>

In my report, I have 4 report parameters and 1 query parameter(@userid). The query parameter I wish to pass through the URL, because iam actually calling the report from a hyperlink from a asp.net application. Iam also using the report parameter in the dataset query like @region, @location I...more >>