Archived Months
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
all groups > sql server reporting services > june 2005 > threads for wednesday june 15

Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30

Border Disappears
Posted by Lisa at 6/15/2005 2:52:09 PM
When I write an expression for the visability of a cell, I am finding that the border disappears when Hide = True. I don't really want the cell to disappear, just the text contained within it. And I want the border to always show up. Any ideas how I can make this happen? Thanks, Lisa...more >>


Reporting services and microsoft exchange on the same computer
Posted by Dale at 6/15/2005 2:50:10 PM
could u say if there would be a problem with reporting services and microsoft exchange running on the same computer ...more >>

Gradient background
Posted by Elmer Miller at 6/15/2005 2:21:50 PM
Does anyone know how to create a gradient for the background of a row. I know I can create a gradient bitmap and use that, but that seems like an inefficient way to go and may hurt performance. Any ideas? ...more >>

Automatic PDF/TIFF generation and saving?
Posted by Teros at 6/15/2005 12:28:06 PM
Ello folks... Question for you all - I'd like to make a call from a webpage (asp or aspx) that will call up a report with a given set of parameters, format it as a pdf or tiff file, and save it to a location. Any ideas? I know I can use the /ReportServer/ instance to directly call the rep...more >>

SQL Server 2005 - SQL Reporting services
Posted by scarri at 6/15/2005 12:09:15 PM
Do you know, with Visual Studio 2005 and SQL Server 2005, if I could use an item in the header section refers directly to a field. Thanks Sebastien...more >>

multiplue UI Report Tables using exact same dataset ?
Posted by D Witherspoon at 6/15/2005 11:42:04 AM
Is there an easier way to manage the table UI element on the report. For example in my report I have a table for the header info and the data, the data uses maybe 10 columns and we could be perhapps adding more columns (fields) to it in the future. The header uses 4 columns. It's a pain b...more >>

pass data between two datasets
Posted by Ramani at 6/15/2005 11:01:06 AM
Is there anyway i can pass data between two datasets ex: dataset 1 has select empid, fname,lname ,salary from employee dataset2 has select userid ,total/(dataset1.salary) from anothertable here i want to use a value from dataset 1 in dataset 2. Thanks in advnce...more >>

Geenral convention for naming the reports
Posted by J-T at 6/15/2005 10:33:21 AM
Is there a good convention for naming the reports?Our clients like to see friend names for the reports like Fiscal yeay summary,....... and we'd like to use names like rptFiscalYearSum,........Is there some one who can give me some suggestions on this. Thanks ...more >>



Use other Software as VS .NET?
Posted by MarkusPoehler at 6/15/2005 10:31:03 AM
Does there exist another possibility to develop RS Reports than using VS ..NET? I could enter XLS into notepad, yes :) but maybe anything more comfortable?? I have to know this for a study... Thanks...more >>

Printing directly to Printer from WinForms using Report Services
Posted by 2TheMax at 6/15/2005 10:29:11 AM
Even with Service Pack 2 (with or without RSClientPrint.dll) am I to understand that we still can't print from the Winforms platform/environment directly to a printer, it MUST go through a web page and then from a web page go directly to a Printer (of course with RSClientPrint ActiveX control,...more >>

Reports Stop Responding
Posted by Luke at 6/15/2005 10:17:06 AM
Does anyone ever have an issue where reports stop responding and you have to restart IIS and the Report Services to get the reports to respond again? I notice that this happens when a report runs too long. Does anyone know of a fix? I am still on SP1 waiting for our QA department to allow us to ...more >>

Create Cached Copies of All Reports
Posted by Joel Rumerman at 6/15/2005 10:13:28 AM
Hey all, Cmon folks! There's got to be somebody else who is trying this! I have a report that is setup to be cached for 24 hours. I have also setup a data-driven subscription to dump all possible variations of the report to a file share in hopes that the first user to hit the report will n...more >>

Capturing ODBC user name at runtime
Posted by bwschiek NO[at]SPAM hotmail.com at 6/15/2005 9:49:02 AM
Hi: We are using SRS to report from a DB2 database running on AS400's. It is working very well. Pushing ahead, we want to capture information on when certain reports (actually letters) are generated. The reports prompt for login credentials at run time. These DB2 database credentials ...more >>

Data Source file on Reporting Services server question
Posted by Mike at 6/15/2005 9:40:01 AM
In the Reporting Services Manager, when the user selects the folder where the reports reside there is a file that contains the connection string information along with a user name and password (Data Source). Is there a way to keep the file from being selected by the user ? Thanks....more >>

Navigation problem
Posted by bamboo at 6/15/2005 9:25:02 AM
I have one report that uses "navigate" to another report through the data region field. This works fine in the development environment (i.e. visual studio), but when I deploy the reports and try it online on the live environment, the 2nd report does not even open - i.e. goes to 2nd report s...more >>

Custom Assembly Using System.Web.Security.FormAuthenticationTicket
Posted by Nate at 6/15/2005 9:11:20 AM
We have created a custom assembly that creates a FormAuthenticationTicket object. When calling the custom assembly from an expression for "Jump to URL", the preview returns "Invalid URI: The hostname could not be parsed" error message. The FormsAuthenticationTicket is in System.Web.Security, w...more >>

Matrix column titles problem
Posted by Edgar at 6/15/2005 8:42:08 AM
Hi, I hope anyone can help me with a problem I've been struggeling with for some days now? I have a matrix that should look like this. It has a couple of static columns at the beginning and variable ones (week numbers) at the end -----------------------------------------------------------...more >>

mailto and picking a field for the subject line
Posted by Jeff Metcalf at 6/15/2005 7:59:04 AM
I've put a hyperlink on a report to send a message to the support center concerning service calls that are overdue for closure. How can I assign one of the report fields as the subject of the mail message? For instance, if the user clicks the 'Send Mail' link, the subject of the mail is "Cal...more >>

Sharing Parameters between reports
Posted by anandr at 6/15/2005 7:24:02 AM
I have two different reports that share the same set of parameters. I created the first report, report 1, with the parameters. I create a link/image in Report 1 body that would invoke Report 2 (using navigation action property). Now whatever criteria (parameter values) the user had supplied t...more >>

Stored procedure - DataSource
Posted by Suresh at 6/15/2005 6:27:01 AM
Hi, I am very new to Reporting Service. I have a report wherein the data is being pulled from a stored procedure. I am able to design the report to point the report to the stored proc, but I am not able to see the fields that are referenced in the stored proc. What do I have to do to see th...more >>

How Do I create report from ssis package?
Posted by Swapna at 6/15/2005 6:09:01 AM
Hi, I have developed a SSIS package which finally lands the data into DataReader Destination. How do I genarate a report from this datareader? What shud be my Dataconnection string? How to Access that Data? Plz reply asap. Swapna ...more >>

AS/OLAP data with RS
Posted by /jerome k at 6/15/2005 2:32:02 AM
Hi, I'm totally new to reporting services (but worked with mdx/asy2k). Tried today to build RS reports to an AS database. First, is it true you have to make a whole mdx query (as in mdx sample application) to create the query string/dataset ? No help or wizard ? Second, is there a way to get ...more >>

WebServices and Subscriptions
Posted by Bryan Avery at 6/15/2005 2:01:05 AM
I have really two questions to ask, I am writing my own front end and using WebServices to extract the information I need from the Reporting Server. I have all the Catalog information and it works well. But how do I get the Subscriptions information out? I would like to pull out the infor...more >>

permissions granted to user 'NT AUTHORITY\NETWORK SERVICE' are ins
Posted by Bryan Avery at 6/15/2005 1:41:05 AM
I am trying to read the WebServices to gather information about the catalog. When I run the application from my development box and reading from the Reporting Services server for the Catalog all run fine. But when I transfer the application (asp.net) to the server it fails with: System.We...more >>

Using filters in matrix and/or table
Posted by Kamil p at 6/15/2005 1:02:02 AM
I'm working on reports, which base on queries retrieved with store procedure. Report consists of list of customers with different types of products sold to them. I'd like to present in a matrix only customers with for example product with code 1. When I had tried to use "filters" option ...more >>

Dynamic columns in RS reports
Posted by Razvan Popov at 6/15/2005 12:00:00 AM
I have to design a report that will have a dynamic number of columns, in a dynamic order. For example: items and a selection from their attributes ITEM Attr 1 Attr 2 Attr3 Attr 4 I1 5 Realy large text ......................more >>

Sum Function
Posted by Kiran at 6/15/2005 12:00:00 AM
Hi, I am working on reporting service and I don't know much about crystal = reports. I have got a formula in crystal report like this inside a group(this = group is grouped by ID) Sum(Employees.Salary,Employees.ID) Can anyone tell me what is equivalent formula in reporting service and ...more >>


DevelopmentNow Blog