Hi, Is there a difference between exec sp_executesql N'SELECT a.pt_orgn,a.pt_ogdesc, a.pt_grop, a.pt_dept, a.pt_pros,b.cs_orgn, b.cs_orgn_x, b.cs_ssym, b.cs_dept, b.cs_pros FROM vRsPros a LEFT OUTER JOIN vRs22130101A b ON a.pt_orgn = b.cs_orgn AND a.pt_dept = b.cs_dept AND a.pt_p...more >>

hi every one well can anyone help me out how to handle the drilldown reports (toggled Subreports) through SOAP API i m using Render method of reporting services class now report renders perfectly with toggled items but when i click on any toggled item the report jumps to the reportserver (inste...more >>

I have a table with 3 fields (defect1,defect2 & defect3) I would like to be able sum the number of defect1's that are the same and then select the top n of defect1 where n is a dynamic variable. In the report I would like to display the top N but be able to drilldown and see the defect2, and d...more >>

Hello, How can i use and define parameters in an query using oracle database ? When i try to use =@param, the system make an automatic transformation to ='@param'. Thanks for the answer, Benoit ...more >>

I'm trying to input data from a second dataset into a table. The Edit tool only gives me First(Fields!Name.Value, "DataSet2"). How do I remove the "First" and just get the actual value with the correct Dataset? Sorry if this is a stupid question. Thanks....more >>

Hi My report displays User!UserID in a field. It works fine for all the users except one user. It displays the report server's administrator id for one user. E.g My report server is DBASERVER It shows DOMAIN\LoginName for all the users. For one user it shows DBASERVER\Administrator. Yo...more >>

I'm wondering if there's any way to use Reporting Services's charts to provide the same functionality as that from Excel when charting data coming out from an olap cube. This can be easily done with Excel but is there a way to slice and dice data in RS's charts like how its matrix table all...more >>

Hi, I need to be able to disable (or turn-off) a report during database maintenance. Any suggestions? Bryan ...more >>

Hello all, Is there a way to incorporate OWC pivot table into reporting services? I am trying to display a pivot table within the report. I know that I can use ASP.Net and OWC but this is not an option. They want me to put the pivot table within the report. Is this feasible? I am aw...more >>

How do you create reports based on data that is in the AS cubes? We have cubes that we are able to hit from Excel via the Pivot Table Service and Analysis Services. However, we are trying to determine the best way to do this in .Net and Reporting Services. Thanks for your assistance. Chr...more >>

Hi NG, i got a frameset. Users can select several reports in the left pane. The reports will be displayed in the main-frame via the ReportViewer-Control. Everything works fine. But if user klicks in a report on a link to a subreport, the subreport breaks the whole frameset. Any way to avoid t...more >>

I am using an external image which I have placed in the same directory as the report and would like to have it be a background image in the textbox. I set the following BackgroundImage = logo.gif Source = external Value = logo.gif MIMEType = BackgroundRepeat = Repeat Any thoughts why not...more >>

I have just read about Reportig Services and attended to a WebCast about it. It sound good and we want to give it a try. We have a SQL Server 2000 Std. licensed and [...] Reporting Services is part of the SQL Server 2000 license. There is not a separate license for Reporting Services. If you h...more >>

I have created a stored procedure, and selected it from the dropdown within the VS IDE. When I hit "refresh", however, it shows me all the parameters twice. Even if I only supply values for half of them, the query fails. What is the deal with that?...more >>

Hi All, I need to change the color of the column name based on the filed value stype. So in the expression column I have written this code... but the column name is appearing as Black and Orange Instaed of the color...sName is the column name... =switch (First(Fields!sType.Value) = "P","...more >>

Hello all- I need to get the label value of a parameter drop down box which is being filled from a database. The actual value is used for for another query, but I would like to get the selected "displayed value" to show on the report. I.E. Value, Label Value 1, 20MM HEI 2, 20MM PGU 3, 2...more >>

Hi MSRS Mentors, I need to add two columns in a matrix, my stored procedure is tweaked so that I need to display two dynamic columns. is it possible to add two dynamic columns in a matrix. Need your help on this Thanks Balaji -- Message posted via http://www.sqlmonster.com...more >>

If I export my report to excel the last row is missing, any other exporting format is correct, also in preview the last row is shown. Can anyone help me please, thank you in advance !!! Installed version: Reporting Services SP 1 ...more >>

Dear MSRS Mentors, I have a SP which returns the Credit card information like CC Number, CC Expiry date, my requirement is I need to encrypt the CC Number and show that in the report. How can I achieve that. Thanks in advance Balaji -- Message posted via http://www.sqlmonster.com...more >>

I need to edit a report that has been in existence for several months. When I re-deploy it, how can I keep from losing the execution history that is stored in the reportserver db for that report? I am assuming that it would get a new ItemID. Would it? thanks, db...more >>

Report: RS report calling funtions/expressions from a custom assembly developed in VB.NET. The report works fine when run from the development PC Problem: Added report onto report server but does not display the result the custom assemby functions correctly. I think the issue is related ...more >>

I have deployed my web app as shown in the Crystal Reports.NET documentation (I'm using the bundled version of CR). However the problem is with the directive at the top of the html page, when I drap and drop a CrystalReportViewer onto the design surface it automatically adds a CR page direc...more >>