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 > january 2007 > threads for january 1 - 7, 2007

Filter by week: 1 2 3 4 5

SQL 2005 Reporting Services Licensing Question.
Posted by Manny123 via SQLMonster.com at 1/5/2007 9:53:27 PM
Hi there, got this question for anyone out there that knows this. I am planning to install SQL 2005 Server on a server machine + the Report Server and the Report Database on the same Machine/CPU. I know under this setup I need only one valid license for SQL Server 2005 since all are going to ...more >>


Jump to URL mangling
Posted by Sean Carpenter at 1/5/2007 3:05:07 PM
I am using "Jump to URL" in a few reports to jump to other reports on the same reporting services instance. The problem I'm having is that when RS renders the report, it changes the URL to include a prefix of "http://reportingserver.domain.com/Reports/Pages/Report.aspx?ServerUrl=". This is ...more >>

Using more then one value in a parameter to create more then one report
Posted by ewasil NO[at]SPAM gmail.com at 1/5/2007 1:30:51 PM
Does anyone know if this is possible. I have a parameter called salesperson. It has 5 possible values. If two of the 5 values are checked and the report is run, I would like to return two reports to the user. One for each salesperson. If anyone has done anyone similiar please point me i...more >>

Multiple Renderings of the same report in a single email
Posted by Jason_Schaitel at 1/5/2007 1:02:13 PM
We currently have a data-driven subscription that renders our report as a PDF and sends it to each client via email, no problem there. The question is how do I have both a PDF rendering AND an Excel rendering of the same report attatched to the email? I know that we can create a custom delivery ...more >>

Top N + The Rest = TOTAL
Posted by jordi_ramis NO[at]SPAM hotmail.com at 1/5/2007 8:09:32 AM
Hi, I want to make something like this: TOP 3 Sellers! Seller Profits ----------------------------- Maggie 130 John 70 Mike 30 *THE REST* 200 ------------------------------- TOTAL 430 Showing the TOP 3...more >>

Cognos Comparison
Posted by Abhishek at 1/4/2007 11:11:00 PM
Hello Everyone, Does anyone have a comparison of Cognos with SSRS? regards, Abhishek....more >>

Recover RDL file
Posted by Jean-Nicolas BERGER at 1/4/2007 6:55:31 PM
Hello, I've got a huge problem with SQL Server 2005. I've lost the RDL file built with SQL Server BI Studio (developper hard disk format, with no backup), and the only thing that I've got now is the server itself, with the ReportServer database. Is it possible to re-create a RDL file from th...more >>

Restricting access to certain folders?
Posted by Tarun Mistry at 1/4/2007 2:16:45 PM
Hi all, I have a user who I only want to provide access to a single folder within RS2005. I don't seem to be able todo this, they can either see everything or nothing at all. What am I missing? Any help much appreciated. Kind regards Tarun ...more >>



Problem with navigation - Jump to URL
Posted by Karim Sameh Wahba at 1/4/2007 11:54:10 AM
HI, I'm trying to make my reports have a hyperlink to an URL, i have done the following steps: On a textbox ->right click-> Properties ->Navigation->Jump to URL and i typed =www.google.com how ever when using the perview still the textbox is not clickable , ??? does any one have a soultion...more >>

Report based on XML
Posted by HDI at 1/4/2007 1:48:42 AM
Hi, How can I create a report with the actual data comming fom a self created xml in memory (created in code, vb.net). Thx ...more >>

Data in Report Headers
Posted by Barry Seymour at 1/3/2007 2:37:53 PM
I'm having the devil of a time working around RS limitations here. I have a report that displays a purchase order. ON all pages but the first I'm supposed to display a header like this: From: OUR NAME To: Vendor Name PO 123456 Page 2 of 4 ...more >>

Data regions are not allowed inside a table detail ..
Posted by eamon at 1/2/2007 9:30:33 PM
Developing using Visual Studio .Net (2003). I have a simple table on my report showing data from a dataset. Works fine. Displays a bunch of records. One of the values from my dataset is a percentage value (integer from 0 to 100). I'm attempting to illustrate this using a chart. So I'm attem...more >>

Line Chart with a "Single Category Group"
Posted by Profundus at 1/2/2007 9:01:04 PM
Hi Folks I have a line chart showing some data vs time. The chart is okay when we have multiple periods (say Q1 2006 and Q2 2006). However, the chart is empty when only period (the category group) is being displayed. This leaves me with two questions..., 1. is this because line charts are su...more >>

Use login name as parameter?
Posted by ana9 via SQLMonster.com at 1/2/2007 3:54:27 PM
My users are logging into a secure database with their own usernames/pwd's. I want the individual users to only be able to see their own information and not the entire report. Is there any way to grab their username and put it in a parameter? I really don't want to create a separate report fo...more >>

forcing report to refresh
Posted by c-eric.geil NO[at]SPAM mci.com at 1/2/2007 1:05:27 PM
I have a RS report that I am integrating in to an ASP web site. I have a menu page that gathers some user parameters (report dates etc) and then opens the report in a new browser window, passing the user parameters as querystring variables. I have noticed that the report does not refresh if you ...more >>


DevelopmentNow Blog