Hi, I am developing reports using Reporting Server.With these reports i am going to run in ASP.Net, but its prompting SQL Server User ID and Password. Can any one knows the solution for without prompting the User ID and Password. Is this Possible? Regards, Malli ...more >>

During the development of the project I used windows authentication on IIS and everything was working perfectly. But the user must access the reports through a web application, so I changed the security to anonymous and set the rights on RS for the anonymous user and since then, the server has...more >>

I am trying to write an invoice report for. It will include details of both companies involved and then list worked hours and expenses on a per project basis. I need the worked hours to display in a table under each project and the expenses in a seperate table under each project. I have trie...more >>

I have an Area Chart with four different values plotted on it, as 25th Percentile, Median value, 75th Percentile and the Customer data. Now that with SP1, we can specify FILL color, it has become very useful on this Area chart. (mind you this is Simple Area chart). However, in certain case...more >>

Report data comes from an iSeries batch server and the content must be hand-checked before reports are run. Some reports are very large, so we want to create snapshots. Can I automatically initiate generation of the snapshot after the data has been approved? Approval does not occur on a par...more >>

Table Properties, Filter Tab. Added a filter. Expression: =Fields!LastActionDate.Value Operator: = Value: "7/1/2004" Receive following when previewing report: "An error has occured during report processing. The processing of filter expression for the table 'table1' cannot be performed. Th...more >>

I tried for hours to pass a parm to a query like this: Select * from Table1 order by @SortField I defined sortfield as a parm in the report parm tab as well as in the sql statement parm tab. I used the generic designer to test it and when it prompted me for the parm I put in the correct colu...more >>

Hi, I'm having a little difficulty getting my head round windows integrated security/impersonation with reporting services, and I'd appreciate a little help with the problem I'm trying to solve (or an indication that what I'm trying to do is too hard to be worth it!) To give you the backgr...more >>

If I understand it right, the Plot Area includes the plotting of <Legend> as well as actual <Chart diagram>. Can I specify the size and location of the actual <Chart diagram> apart from the <Plot area> ?? I run into an overlapping of two Legends, when superimposing two charts..! If I cou...more >>

Does RS provide help specifying the width of a Bar in a Simple Bar Chart ? Right now, it creates even sized bar for a given size of a Chart. p.s. I've already applied SP1 (jfyi) -- which allows me to color code individual bar appearing on the Chart (I must say, that is really GOOD!!) Thanks...more >>

I have an Area Chart with four different values plotted on it, as 25th Percentile, Median value, 75th Percentile and the Customer data. Now that with SP1, we can specify FILL color, it has become very useful on this Area chart. (mind you this is Simple Area chart). However, in certain case...more >>

Does RS allow to use expression to generate titles for X- and Y-axis, either through a field obtained from the database or a Parameter ? Right now, even after SP1, I do not see a button that leads to <Expression> dialog for X and Y-axis title, similar to say a <textbox> control. Thanks....more >>

Why do I still have checkbox for Chart | Properties | .. <Plot data as line> still DISABLED, even after applying SP1 ? I however, see a button <Series Style> (which is right underneath the above mentioned checkbox) now enabled after application of SP1. I must say that by having <Series Styl...more >>