I have been converting a crystal report to MSRS. Crystal allows sharing variables (called shared variables) between main reports and it's subreports. Also, it has a concept of global variables which are available throughout a report. Many decisions (e.g. hiding the footer of a report) are based on t...more >>

I have a report with a dataset that returns one row with many columns. I want to put some of it's fields in footer. When I tried to compile the report, I've got subj message. Can somebody explain what is the stupid limitation? What is wrong with expression =First(Fields!AuthorDescr.Value) It w...more >>

Tim: I had this problem last week and here is my work around on the #tmp table. In the Data tab, Click the Fefresh Fields Button it will ask you for your parameter/s (if you have parameter/s then put in your parameter/s), then Click on Generic Query Designer and then Run. This should do the trick...more >>

Dear Sir, How can reporting servicing receive parameter from Asp.net program? ...more >>

When I preview the report In design mode all contents in the body of the report allign perpectly. After I deployed my report, some of the fields did not allign properly. I am using a combination of text boxes and tables. I have tried to put the text box and/or the table in rectangles, but th...more >>

Hello I have a dataset with a date field and a value field. I wish to display the value fields for current year as well as the previous 2 years together with different colours on the same month interval on the X-axis. Can someone lend a hand on how to do this? thanks in advance Chris Pulfo...more >>

Hello All, In my stored procedure I use the following code to strip the time off date paramteres passed in: declare @Now datetime, @pos int set @Now = convert(datetime, convert(varchar(10), getdate(), 120), 120) set @pos = charindex(' ', @FromDate) if @pos > 0 set @FromDate = left(@FromDa...more >>

Hi, I have one column group and 3 columns under it in a matrix. I added subtotal to that column group and now all the 3 columns are summarized and shown. Now I want to hide one column summary(The other 2 column summary should be shown). How to do that? TIA, Sam ...more >>

I would like to embed an .ASP page INSIDE my report.... I know I can add images inside through URL. But can add an asp page? Can I do that with custom assembly? If not, what version of reporting services would allow us to do so. Thanks...more >>

Are the style templates offered by the Report Wizard accessible somewhere? Can I add my own standard templates (beyond the bold, casual, corporate, etc.)? Thanks, Warren Thornthwaite...more >>

Hi, I made a post earlier today entitled 'Forms authentication & Windows authentication side by side' - no replies to this as yet - but I'm desperate to know how to get around this. Here is the post again: 'Is it possible to configure the ReportingServices webservice to authenticate met...more >>

Hi Guy, During installation of Reporting Services we didn't completed SMTP info. Up to now thos info are really important for subsription delivery via mail. I found an article in Technet describing which parameter configure in RSWebApplication.config file to activate RS SMTP Service. The config...more >>

Hello All, I am having a lot of fun when exporting to excel. When there is a control (image etc) above a table and the sides of the image stop half way through a column this creates a merged column in excel. This creates headaches for clients when trying to chart this data. Is there anyway around...more >>

I have a Background image and it disappears on the 2nd page when it is outputted to PDF. If I set the repeat property the background image starts partically again on the same page. On the Reports viewer it repeats on each page, but redering to PDF seems to have an issue. I have SP1 installed. Wh...more >>

Hello, I have troubles with hidden parameters. What am I doing: 1) define a report parameter based on a dataset's field (a dataset is "Stored proc." type, the procedure returns the only string value -- if it is important) 2) Build & deploy a solution, run the report from Report manager -- i...more >>

Is there any example how to make Report available over internet to our customers? How to get username and password from customers? How to connect aspx page and report? ...more >>

Hi: My long and sad tale of woe. Many months ago I tried to install a very early version of the RS download. I got partially thru when it told me I didn't have the right version of MS Studio. So I stopped and ordered the upgrade and put the whole thing on the back burner for several months. I...more >>

Hello, Is it possible to define a global variable within a report? It has to be populated in one DataSet and accessed from other DataSets. Thanks, Lucy. ...more >>

Can anyone help me out with an error that I get when attempting to create a dataset that uses a stored procedure? I wrote a moderately complex sp that utilizes temporary tables. In fact, the result set returned is that of a select statement against a temp table. However, when I try to d...more >>

Is there a version of SQL Reporting Services that can be used with SQL Server Personal Edition?...more >>

Where would I find published reports in IIS Thank you ...more >>

I have created a matrix that looks like the following example: APRIL MAY JUNE PRODUCT X 10 20 30 PRODUCT Y 20 30 40 where the data is profit per unit sold (=PROFIT/# of UNITS) I need to add a row that is the average profit for each month. I kn...more >>

Reporting Service SP1 provides an option to cache the data during design time for preview, which seems to be making the preview to take lot longer time than pre SP1. This is what Reporting Services SP1 is doing: During preview it is making a call to SQL and in between it is writing into repor...more >>

Hi, I've done a report based on several fields and i want to export my report in a CSV file. Unfortunatly my fields have commas in it. So, is there a opportunity to change the deliminator to e.g. ; or #? Thanks for answering Tom. ...more >>

Hi. Please, can anybody tell me in DETAILES how to set a FullTrust permission for my custom assembly. I try many ways, but its dosn't work. My simple asembly reads some text from file. In preview mode its work fine. Thanks very much. ...more >>

This probably is easy, but I haven't seen a good way to do it yet. I have a stored procedure that returns a numer or rows that get grouped. Details are available if the person expands the tree. I would also like to add the percentage of total records as part of the display, but can no...more >>

Hello, We have our Report Server installed on the same box as our SQL server. The Report Server does not require user logins, it captures the network ID of our users. The problem we are having is with e-mailing of subscriptions. The user name defaults as the e-mail address, users can not ent...more >>

I am in need of some advice on my first project. I have a chart which displays as I would expect when a static query is executed. I need to somehow dynamically add the datafields to the chart at runtime which is where I am coming unstuck. The number and name of datafields could change each tim...more >>

I have a matrix report. I put a rectangle with two text boxes - inside the column group. Works great! However - now I can't seem to fix the width of the columns. It just grows and ignores the property. I have tried to set it for each individual cell in that matrix. And I have tried to specify ...more >>

Hi All, I really need some help with subreporting in SQLRS. I have wasted 2 full days trying to get a simple subreport working in Reporting Services and am on the brink of going back to Active Reports if RS continues to be so confusing! I have a main report and for each line I need a subreport l...more >>

I want to display a column or bar in red if the value needs to be highlited. Is that possible? DougS ...more >>

Hi, Im relatively new at SQLRS and am having a total nightmare trying to get a subreport to work. I have a main report from which I am trying to pass a parameter (OrderID) to a subreport and all I get is Error: Subreport cannot be displayed and some stuff about "An attempt was made to set a report ...more >>

I have a table that groups on one field. I would like the group row to show an incrementing number for each group, i.e. if there are twenty records in the dataset that are grouped into 4 groups on the report, I would like the group headers to show Group 1, Group 2, Group 3 and Group 4 respectivel...more >>

Hi Everyone: We are evaluating the SQL Server Reporting Services for use in our current web project. The users will have the ability to select report fields that they can group on and filter on, via a web page. The materials I have read so far have not touched on how one can programmatically al...more >>

Hi, I have a problem to get a fixed X-Axis in my chart. I need a scale from -100 to +100 which does not depend on the values that come from my database. At this moment The scale increases or decreases when I for example only have values between 20 and 30. This is not useful for comparing diffe...more >>