I need to gather as much information as I can about event driven reports for both 2000 and 2005 versions of reporting services. I have a huge reporting project that involves 23 site company. So that means 23 databases (Oracle on top of it all) working off of one Sql Server box. It can be done but...more >>

Hi All suddenly our server give us the following error The underlying connection was closed Could not establish secure channel for SSL/TLS Any idea??? Regards cgf39 ...more >>

Hi gurus, after half a day (googling, reading lists and trying) I give up. I have win 2003, latest sp, latest updates. I have Visual Studio 2000, and want to migrate to VS 2005. But I have one serious problem: In MSSQL 2005 Upgrade Advisor I get in report services component: Virtual directory...more >>

How do I write expression to calculate a value to show percentage of the subtotal value in a Matrix? example: Matrix has Coulmn group Matrix_col and a Row group Matrix_Row and I would like to show the percentage of the subtotal for Matrix_Row in a column next to Matrix Col. ...more >>

We wanted to add a language parameter to a report and allow the user to output the report to multiple languages. We did this using three techniques: Static resource strings: We created a custom assembly with resource files. We have one property and one method. Each report has a textbox ...more >>

After viewing a report using the preview tab any custom assemblies become loaded in the Visual Studio instance. I can close the project and the custom assembly remains loaded, only after shutting down the VS instance does the assembly become unloaded. I have some post build code to copy the ...more >>

Still having this problem Bruce it is when designing af view and not in query analyzer where it is working now. Even if I remove 2 panes in the view it changes " to [ I'm really lost here ! Where are you doing this. If your SQL is getting changed then my guess is you are using the gra...more >>

This is gonna be simple - but not for me!! I need to record the number of hits each report gets from users. As a bonus, also the parameter values passed would be usefull also. What would be the simplist and most efficient way of achieving the above please. Thanks and Happy New Year T...more >>

I would like to point my Report Server to an ASPX page that outputs RDL. Can this be done? Any examples or tutorials that anyone can point me to? Thanks! -mdb...more >>

How can I format my date within Reporting Services to display like this: Monday, January 9, 2006 instead of like this: 1/9/2006 12:00:00 AM...more >>

I've created a stacked bar chart using reporting services. I'm building the chart from 20 records that include amounts, years, ect. The problem is whenever there are two amounts that are the same the chart only shows one of the amounts. I tried to find out if there was a property that was hidi...more >>

Hi All, Is there any way I can access the reportid in a report expression? Something similar to what I do to get the report name (Globals!ReportName). I guess in the worst case I could copy it from the rdl file but I would like not to hard code this. Thanks,...more >>

Hi all.. I can't seem to get parameters to pass via an URL according to the documentation.. http://certol/Reports/Pages/Report.aspx?ItemPath=%2fFSDBMR%2fManufacturing%2fPlanning+Data&Active_Obsolete_None_Filter=2 (btw Active_Obsolete_None_Filter is the parameter ) Is there something wr...more >>

I have two web servers. One is W2k w/ IIS 5.0. The other is W2003 w/IIS 6.0. Both have SQL 2K. Both have identical dlls, pages, etc. I have one report that runs fine in the viewer on the 2003 machine, but but fails to generate on the 2k machine. The viewer comes up, the single drop down pa...more >>

Looking for a little assistance... I have a query which runs within Query Analyzer in 8 sec. When I copy the query into Reporting Services and run the query under the "Data" tab with the"!", the query takes a really, really long time. I am not sure what the issue is. I have searched through...more >>

Hi, I am new and just installed SS2005 Developer Edition on a server. I can see the following services on Configuration Manager -> Services Integration Services - Running FullText Search - Running SQL Server - Running Analysis Service - Running Reporting Service - Stopped Browser - Running...more >>