Hi - I have created a report that is based on an Access database loacted on another server. I have set up a datasource using ole db provider. If I run the rport directly from the sql server it runs fine. When I try to run it from a remote desktop it give me an error that it cannot connect to ...more >>

I just wondered What's the disadvantegs of using direct queries for my datasets in comparison with sotred procedures? Thanks Ray ...more >>

Hello All My app has a central report that takes name as a param and returns all names matching and has a table of databases, where there are data regarding the particular person. So I print mark in the column for the particular DB for the row of the person. From here I provide a Drillthrough...more >>

How would I write a sql query in the criteria column of the following table/field eg. Employee.Name If (@pmGroupBy = 6) then (Employee.Name = @pmEmloyee) else (Employee.Name = *) note: * in above context = ALL...more >>

Greetings, I have a database that includes as one of it's fields, links to folders on a network share i.e. \\servername\SharedFolder\Subfolder When the user clicks on the link, it opens that folder up. I would like to be able to do the same functionality from a report. The only way I can see t...more >>

can someone tell me if it is possible to turn off Reporting Services query "beautifier" ? The particular query I am working on right now gets so re-written that it is much more dificult to read and understand. I would like it to be left the way I enter it. Is it possible, or Microsoft knows ...more >>

Hi, If i ship an RDL file to a client can they open it with a new project and edit it ? Thanks Scott ...more >>

Hi, An XP client connected to http://server/reports/ etc... and caused this error in the event log on 2003 server "The description for Event ID ( 0 ) in Source ( .NET Runtime ) cannot be found. The local computer may not have the necessary registry information or message DLL files to di...more >>

I have created tons of reports and ran them in their own window without using the home header to custumize them better, now I want to plug in the results in a separate frame the same way within another web app again without the home page header, the tabs, or those links to subscriptions and Si...more >>

eCan you call a stored procedure from a report that will update the database? I want to update som tables when a report has finished generating. I tried to call the update stored procedure from my code (Cold Fusion), but the update code was executing before the report call, so the report qu...more >>

I have a .net web app that uses windows authentication and database role based security. How can I use the same database roles with Reporting Services while using windows authentication and not forms based authentication ? Any help would be greatly appreciated. Regards, SM...more >>

I am trying to use the datediff function in RS to display dates in a column that are less than a week old, in other words records that are current for that week. Is using the datediff function the best way to go?...more >>

For the first time today when trying to add a New Role assignment for a (any) user, I am getting the error(s) below. I am also no loger able to edit or delete users from the Security page. I have restarted both the SQL Server and SQL RS services. Any help much appreciated! Error from...more >>

When I export the same report with Crystal and SQL Reporting Services, the Crystal is about 2MB and the SQL is around 48MB. Is this because of the creation of the css associated with the report? I cannot have reports at 48 MB when they can be rendered at 2MB, is this a deal breaker with SQLR...more >>

Hi guys... I would like to add a chart to the report, but all I get in the toolbox is Textbox, Line, Table, Matrix, Rectange, List, Image, and Subreport. Any ideas? Thanks!...more >>

How can I get the bleeding trailing zeros out of a textbox with format set to 'D', while still allowing values with decimals over zero to show 2 places.... yaya custom formatting, but I am in a report....tell me I have to jump thru more hoops and write a custom module or something... ...more >>

Hi, I have a data source on the SQL Analysis manager . I need the report to read data from there but it is not seeing that data source.. Even tough the sample report of Microsoft, Foodmart Sales report uses the Foodmart database of the ANAlysis Manager. But my reports are working fine ...more >>

Can I work with Reporting Services in 2.0?...more >>