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 > may 2007 > threads for wednesday may 23

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

hide column in a matrix
Posted by Efi at 5/23/2007 11:33:01 PM
I'm trying to hide a column in a matrix. I have noticed that you can't just set the columns visibility mode (no such proprty) so I tried the following: 1. set the visibility of the cells and lower level headers to hidden - works but the upper level header still takes the space of the hidden low...more >>

How do I use a parameter in a dataset field value using an MDX query?
Posted by Roger at 5/23/2007 8:46:55 PM
I am trying to run a report using dynamic MDX dimensions. The value of my dataset field Dimension_1 is [SOB Year].[Yr Id].[Yr Id].[MEMBER_CAPTION] I want to use parameters for SOB Year and Yr Id like I do on the query. But if I use ="["& Parameters!dimension_1_table.Value &"].["&...more >>

Date Parameter
Posted by Ridhima Sood at 5/23/2007 7:46:01 PM
hi All I am quiet new to sql reporting so would really appreciate some help. I am using this with CRM 3.0 I want to do a report where user can select a to date and a from date to see all completed phone calls. However both the to and the from are based on one field called actualend. A...more >>

Re: Model Query Designer
Posted by fmatamoros NO[at]SPAM yahoo.com at 5/23/2007 5:52:04 PM
I added the RS extension to RSReportServer.config. Then, I restarted the report server. Now it works! ...more >>

Programmatically change a textbox's contents
Posted by Andrew at 5/23/2007 3:10:10 PM
Quick question.... I have a C# ASP.Net (2.0) webpage with a ReportViewer control on it. In the code-behind I set the datasource of the report and then view the report data: DataSet ds = DBProvider.GetDataSet(SQL, DateFrom, DateTo); rvRR310.LocalReport.ReportPath = "RR310.rdlc"; rvRR310.Lo...more >>

Scheduling a report to run every 30 minutes
Posted by Zoomer Tech at 5/23/2007 11:38:04 AM
Hi all, I have a customer that wants a report to pull data, and report that data every 30 minutes is that possible in SQL 2000 Reporting? They are trying to upgrade to 2005 based on this request. How musch more functionslity in reporting is there in 2005 as opposed to 2000 Reporting. ...more >>

how to send all values for a field to a subreport
Posted by Stephanie at 5/23/2007 11:31:01 AM
How do I send all values of a field in a dataset to a subreport? Stephanie...more >>

report data with different char-set other than english
Posted by PS at 5/23/2007 10:45:06 AM
In my report i have to display data from sql db which has this data string in Russian language. The report object and the text box object have a very promising property called: language but setting this property to the required language is not helping. How can i make my report to display ...more >>



Retrieving total number of pages
Posted by Doogie at 5/23/2007 8:46:39 AM
How do I - inside my report, display the total number of pages? I looked at the expression functions and couldn't see anything to do that. ...more >>

he_reportViewer
Posted by Eric at 5/23/2007 8:36:02 AM
Hello All, I have a report that uses the character "â„¢" and when it is viewed through the reportviewer via a website, the character "â„¢" is displayed as a "?". However when I export to either pdf or excel, the "â„¢" is correctly displayed. Is there any documentation where I can be direc...more >>

Chart legend has too much data - how to only show 1 legend
Posted by NP at 5/23/2007 7:21:03 AM
I have created a hybrid bar chart / with line. Basically uses the bars to show sales for each geographic region. A single line is plotted showing the sales goal to be reached. The x axis is "Region" The y axis value 1 is total sales $. I added y value 2 to show the sales goal $ and the leg...more >>

SSRS 2005 link reports
Posted by farshad at 5/23/2007 6:59:01 AM
In SSRS 2005, Is it possible to have a link in one report (i.e. report A) to be directed to report B. Can you show me guidance on where to start please?...more >>

Reporting Services 2005 on Vista
Posted by David at 5/23/2007 5:48:01 AM
Hi All When I go to http://localhost/reports on my laptop running Vista and SQL Server Reporting Services 2005 SP2 I recive the following error: HTTP Error 401.1 - Unauthorized Description: You do not have permission to view this directory or page using the credentials that you supplied. ...more >>

Drillthrough Problem
Posted by Mike at 5/23/2007 12:59:01 AM
I have a problem with the drillthrough feature in reporting services. When I drillthrough from report A to report B it works fine and all parameters where processed. But if i drilltrhough from report B to report A now the parameters where ignored and i get an cached version of report A. How c...more >>

Culture problem with datepicker in report parameters
Posted by Stefan at 5/23/2007 12:00:00 AM
Hi, on the server of a customer I determined the following problem: The customer installed an English operating system (Windows server 2003) with English SQL server 2005. I go from a German Client on a report about http:// <servername>/reports (report managers) to calendars in the report pa...more >>

Passing datetime parameter to stored procedure
Posted by Antonin at 5/23/2007 12:00:00 AM
I want to pass a date parameter to stored procedure which is expecting smalldatetime. I need to subtract a number of days from the current time and pass it to the stored procedure. I tried DateAdd("d", -1, Now()). I can display the the result in a text field on the report but when passing it t...more >>


DevelopmentNow Blog