Dear all, I'm new to SQL Server. Please advise is there any good starter guides in using Sql Server Reporting tools with SQL Server 2000? ex, Sql server reporting tools programming guide & documentation guide in how to create a graphical chart based on query? There is some example come with t...more >>

Why doesn't the Page Footer get exported to EXCEL? Any experience this before? Thanks, David ...more >>

Hi I download my report using SQL Server Reporting service export function (excel format), The file size is very big, when compare to my previous asp download function. Note: The no of rec is same. Ex: Using ASP, the file size is about 1000 kb Using RS, the file size is about ...more >>

Hi, I am trying to setup a subscription but I keep running into problems. I setup the subscription fine, I see that it creates a job in SQL Server. It shows a specific domain account as the owner and I can't figure out why. The problem is that this account is in a different domain and it's havi...more >>

Is there a way to suppress a group row if there is only one detail row; ie nothing to total? ...more >>

Hi, in my matrix, i have a cell like: "text1"+ vbcrlf + "text2". On the matrix, it show correctly, text2 is under text1 because vbcrlf is a carriage return. But when i export my matrix to excel, i Have a line between text1 and text2. it seem that exporting to excel does two vbcrlf and it shoul...more >>

Hi! I would like to stop processing of a report that has no data in a specific dataset. Is this somehow possible? In Access its possible to not process a report if there is no data behind it. Or is the only way to write an application that checks if the data exist and if not just skips the...more >>

We want to create a simple report based on a SharePoint list using the Report Writer installed in Visual Studio by the SQL 2000 Report Server Installation software. Background: We have installed Windows 2003 Server, SQL 2000, SQL Report Server, Windows SharePoint Services and Visual St...more >>

I have three tables all of which are on located on the same list. Table 1 Table 2 Table 3 When table 1 expands it overwrites Table 2. what can be done to ensure that all 3 tables are displayed?...more >>

I am planning to install/deploy SQL Reporting Services at our agency. We have a web server, a SQL Server (Enterprise license), and various other servers. I know that the RS database has to be installed on a server with SQL Server 2000 license, but is it also advisable to install the report serv...more >>

Folks, Is it common to have Reporting services and sharepoint portal server on the same server??? We are having these two on two different servers and I'm really having problem authenticating back and forth between these two.For intance I have a web part witch calls Reporting services Web serv...more >>

Hi all, I'm having a tough time finding what kind of permissions are needed for the account that runs the Report Server windows Service. I have my Report Server on a Win2K workstation with IIS and SQL Server on a different computer (win2k Server and SQL Server 2000 with Sp3a). We were a...more >>

I need help please. According to our Network Technician we are set up for the following: Windows NT Integrated Security When you use the Windows NT Integrated Security option, the report server passes the credentials of the user accessing the report to the server hosting the external data s...more >>

I have set up a vary basic report that connects to a SQL Server database, executes a stored procedure that takes two parameters (start date and end date). In the report I created in VS, I create the data source in VS using a trusted connection and test the connection and it works fine. I can p...more >>

I'm trying to restrict my users from being able to delete or move any of the reports. Using the Browser Role ( View Folders, View Reports ) still allows them to get to the "Show Details" page with full access to delete my reports. What am I missing? TIA Tina ...more >>

I found that lines/colors disappear starting from page 3 or 4 when rendering report page by page in any IMAGE format (TIFF, Metafile, BMP) When you render all pages at once into multipage TIFF - all lines/colors are preserved. It looks like bug to me. I have SP1 installed and it did not f...more >>

Good day. Has anybody experienced problems with their Reporting Service after installing the latest Critical Update for windows (KB833407)? Thanks Karl ...more >>

I'm creating a chart showing different types of work hours registered per person during a given period. I'm using a "Simple Column" chart type. It works nicely. But I'm quite sure that our customer wants a different chart type, that can be found in Excel 2003. It's a 3D Column chart, that shows ...more >>

When I export my report containing Japanese characters to PDF, the Japanese text gets translated to a string of question marks ("? ? ? ?"). Yet the Japanese characters display just fine in Visual Studio Preview, or when I export the report to Excel, or when I execute the report's stored proc ...more >>

Dear friends and guru: I am trying to do insertion with alias insert into TableName t (t.columnName) value (value) it does not work, please give me any useful input on this. Thanks in advance! -- Sincerely ...more >>

Since installing SP1, RS does not render color information to Excel correctly. The report in question renders to all other formats correctly. The error occurs on a variance report where individual cells of a table have color dynamically assigned based on the variance values (green = good, red ...more >>

I'm installing RS on a server that currently has MSDE for several applications. I've installed Sql Server 2000 on the box for the purpose of RS but the installer keeps telling me I'm using the wrong version. Not sure what to do???...more >>

I am defining the Output parameter from Sybase Stored Proc. How can I define the OUT Parm in RS and display that parm result in Header? Any help is appreciated....more >>

I have the problem palcing the field from my Stored proc on the header. Depending on the user name, I have to dynamically change the department name that comes from the stored proc. But, RS is not allowing me to put any expression (with fields) on header. Any ideas how to do that ?...more >>

Hide parameter toolbar and send par via querystring? I have some stored proceures that receive some parameters and output some querys. I dont want the user to select parameters because I need to gice those parameters via query string from My Applications How can I achieve tha? -...more >>

I want to show a different image on my header depending on some data on the database, the path of the image could be on a table. How can I do that? -- LUIS ESTEBAN VALENCIA MICROSOFT DCE 3. MIEMBRO ACTIVO DE ALIANZADEV http://spaces.msn.com/members/extremed/ ...more >>

Hi, Is it possible to manage users outside of the Report Manager ? I would like to manage from our win32 app. I looked at the RS database and for some reason,i can't find the table that holds the relation between reports and users.. Thanks, Eric ...more >>

RS installed on machine outside the firewall using SQL installed locally, accessing data on SQL server inside the firewall using a shared data source. Have given group browser rights on the top-level folder in RS. When user initially accesses the reports home page, they are prompted for a ...more >>

Hi, I have the following sp: if (@Paramreport =1) or (@Paramreport =0) begin select count(CASE family WHEN '420' THEN 1 END) as Unmarried, count (case family when '421' then 1 end) as Separated, count (case family when '422' then 1 end ) as' Divorce, sum (1) as Total from ( select stud...more >>

Is it possible to override the To: textbox for editing when assigning the task "Manage individual subscriptions" to an item role? It is greyed out. It puts in the login, but doesn't put in the @address.com. Our email system is Novell GroupWise 6.5. It doesn't send the email without the @addres...more >>

Hi! I Have a problem with subscriptions. Scenario: account A = account with the rights to do most things account B = account with the rights to do most things except some(B<A) account C = ordinary user account RS runs under Account A When i schedule a subscription with account A it work...more >>

I've just installed SQL Reporting Services. I have a Report Project in Visual Studio and added already existing reports. When I try to build the solution, I get the following error for each report: An internal error occurred on the report server. See the error log for more details. Looki...more >>

Hello, I am trying to hide (or possible show a calculated value in a subtotal) a value in a matrix. My dataset returns something in this format. RowHeader1, RowHeader2, ColumnName, ColumnType, Amount 1, 1, Total, Amount, 100 1, 1, Total2, Amount, 0 1, 1, Variance, Percent, 1.00 1, 2, Tota...more >>

Any way to remove the borders between pie chart slices? ...more >>

Hi, I have spent 5 days trying to find out how to generate a one-time report and have it send out by e-mail. An example is an invoice, that I only generate once for a certain Invoice ID . I tried different things, but couldn't get it to work. Does anyone have a piece of sample code to h...more >>

I have a table that just contains text at the bottom, but depending on the query, it might land anywhere. it always needs to be one inch from the bottom. Any help is appreciated. trint ...more >>

I would like to have my report subscription run every month and to give the results for the previous month. At the moment my report has the parameters @start and @end where i can put the dates in manually, but i dont know how to make @start the first day of the last month and @end the fi...more >>

I create a report and add an embedded image control - a company logo .bmp file. The image is too large, so I resize it, making it smaller. Then set the Image's "Sizing" property to be "FitProportional". The image appears as I want it to look. This report also contains a link to another r...more >>