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 > october 2006 > threads for thursday october 19

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 31

Is it possible to hide the report parameters after click on the view report button?
Posted by Vinod at 10/19/2006 7:38:22 PM
i am working in SQL Reporting services 2005. i had a requirement that after selecting all the report paramters and click on the view report button, i need to turn off or hide the report parameters. please let me know is it possible to implement to do this. any suggesstion Thanks Vinod ...more >>

Split data to pages according to field value
Posted by AB at 10/19/2006 4:29:41 PM
,Hi . I would like to have data of each field value in a diffrent page :for example I have an Employee Name column and I would like that the data ...more >>

Quick custom security question
Posted by cmay at 10/19/2006 2:39:08 PM
I am trying to implement some type of security based on the user, the report, and what parameters the are supplying. So lets say that I have a report called "Salary Report" that shows employees salary and bonus data. The people who can run the report with Department = 1 are not allowed to run...more >>

non-existent images
Posted by Erik Thijs at 10/19/2006 2:32:44 PM
Hi, I have a database that contains student-id's, and I created a report that shows the student ID along with a fotograph of the student. The picture is fetched from a website, and is not stored in the database. Problem: Not all students have a fotograph. If no picture exists, a red cross...more >>

Report Columns
Posted by Kenan Kilictepe at 10/19/2006 2:18:53 PM
Hi, I have a detailed report with 60 columns. How can user hide some columns in reportviewer? For example if he is interested in 5 columns, is it possible for him to hide rest 45 col. automaticly? Thanks ...more >>

BC30451 Name 'whatever' is not declared
Posted by c-eric.geil NO[at]SPAM mci.com at 10/19/2006 2:17:10 PM
I'm migrating a report from access to RS. What I want to do is for each group header, have a formula that shows that group's total as a % of the grand total. Example: Name Sales % of total Tom 5 25% Joe 15 75% so, in my table, I have a table footer with a t...more >>

ReportViewer control - load parameter
Posted by Elmo Watson at 10/19/2006 11:34:01 AM
Using Reporting Services in VS.Net 2005 (very much a newbie, though not a newbie to ASP.Net) I have a report which runs a Stored Procedure, requiring a parameter - BudgetID - In this particular case I just created an ASP.Net page (content page), and I add a reportViewer control - the wizard ...more >>

Set parameter value in Report Manager
Posted by Tim Kelley at 10/19/2006 11:12:49 AM
I need to set the default value of a parameter for a report in Report Manager. It is a datetime field and I have tried the Date() and Now() functions, but neither work. Is there another function that I need to use? Thanks, ...more >>



Report Server job failed
Posted by gv at 10/19/2006 10:52:52 AM
Hi all, I'm getting failed Report Server jobs. How do I find out what report it is, user and, more information? The only information I see is a Step Name which is a long number and then a message that says this: "Executed as user: MyDomain\AdminPass. Could not locate entry in sysdata...more >>

Parameter question
Posted by Tim Kelley at 10/19/2006 10:18:20 AM
I have a report that can be run by different offices in our company. The report should only report on data belonging to that office. Currently I have a parameter setup and when the report is run, the user picks the office. I would like to limit the report to only show info for the office ...more >>

Custom Column names in MDX queries for Reporting services 2005
Posted by Raj Chidipudi at 10/19/2006 8:56:40 AM
Hi Guys, I am trying to create a dynamic report using RS 2005 with AS2005. My report has fixed columns whose names and values are substitued at runtime with data from queries. I am actually facing the problem as described in this topic. http://groups.google.co.uk/group/microsoft.public.sqlser...more >>

How to Concatinate results to display results in a list from Left - Right instead of Top - Bottom
Posted by Chiro at 10/19/2006 7:28:09 AM
Hi, I am creating a report using SQL Server Reporting Services 2000. My report displays values in datatable. Say, the table looks like this EmpName Emp# Address Phone# ....... .... ....... .... I want all phone # for an employee to be displayed in a s...more >>

Jump to URL...
Posted by Kerrie at 10/19/2006 7:08:28 AM
Hey All, I have a report that tells the user all of the applied published fixes that are out there. The report has an ODBC connect to a .txt file on a defferent server. That is finally working great (i hate permissions :)). Now I have to take the Fix_nbr field (which is a calculated field) an...more >>

Display XML Hierarchies in Reporting Services
Posted by Rob at 10/19/2006 7:00:21 AM
Reply | Reply to Author | Forward | Print | Individual Message | Show original | Remove | Report Abuse | Find messages by this author To all, I have read several posts that say SQL 2005 Reporting Services does not display hierarchical XML data very well. It must first be flattened. ...more >>

Missing data-driven subscription button?
Posted by Qurius at 10/19/2006 6:49:04 AM
Hi, The data-driven subscription button is not visible. The version is 8.00.743.00 (SP1 and SP2 still have to be installed) and the SQL Server is enterprise edition. I have also saved the credentials in the report servers for the applicable datasource. These are the points to look for when da...more >>

Access COM+ component through embedded code
Posted by Devin at 10/19/2006 6:42:24 AM
I am trying to access a COM+ component through embedded code of my report. I added the reference to my COM+ component and a reference to EnterpriseServices in the report. I also added the following to rssrvpolicy.config: <CodeGroup class="UnionCodeGroup" ...more >>

Automating Reporting Services in my Windows App.
Posted by James at 10/19/2006 3:31:01 AM
Is there a way of automating SQL Server Reporting Services reports in my win app? I want to be able to pick up events when the user right-clicks on the report etc. I really want to provide a context menu with options relevant to what they've selected in the report. As I understood it, the g...more >>


DevelopmentNow Blog