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 > july 2006 > threads for thursday july 27

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

datediff with parameter
Posted by Tango at 7/27/2006 6:57:02 PM
Hi I am trying to run the following query but want to use a parameter instaed of the -7 BETWEEN GETDATE() AND DATEADD(d, -7, GETDATE()) ive tried BETWEEN GETDATE() AND DATEADD(d, @date, GETDATE()) with the parameter set is an int & text but to no avaial. Thanks in advance...more >>


How do I disable the help (?) link?
Posted by dnbreaks at 7/27/2006 4:45:04 PM
I'm using RS 2000 SP2 and have implemented a custom security extension. The reports are embedded in our web application. Everything works great except for the help link, which when clicked, launches an IE window that displays the login page. Is there any way to disable, hide, or change the hr...more >>

DataSet populated by multiple DataSources at once
Posted by Lance M at 7/27/2006 4:42:04 PM
Hi all, I have seen this question asked many times, but never an answer posted. Here is the situation: I need to connect dynamically to an unknown number of databases at runtime, which the user will be no part of (any parameters involving the Servers or DBs will be internal/hidden). The d...more >>

Restricting Data by User
Posted by sullins602 at 7/27/2006 4:03:08 PM
Greetings... I am looking at setting something up to filter the data displayed on a report based on the user viewing the report. Has anyone else done this? Here's a break down of how I imagine implimenting it, let me know your thoughts... o Create a user_properties table containing (userid...more >>

using values from parameters
Posted by florian at 7/27/2006 2:03:36 PM
hi, I'd like to add 2 parameers to my report. both of them are datetime datatypes. how can I use the values from this parameters further in my report? I want to buil the differnce in days between 2 dates. my approach would be =datediff("d",Parameters!Date1.label, Parameters!Date2.label) ...more >>

SQL Server 2005 Report Builder/Reporting Services Question
Posted by AmrnTim at 7/27/2006 1:15:48 PM
Using SQL Server 2005, specifically the Report Builder Interface. Two unrelated questions: 1) Is there a way to disable clickthrough reporting when exporting data to Excel? I want the clickthrough reporting enabled for reports created and viewed using Report Builder. However, when I export...more >>

<ReportServerExternalUrl> with SSRS 2005
Posted by Jon Limmer at 7/27/2006 1:15:01 PM
When we were on SSRS 2000, I had to add a line in my RSWebApplication.config file in order for people outside our firewall to access our internal report server. It looked like <ReportServerExternalUrl>http://xxx.mydomain.com</ReportServerExternalUrl> We just upgraded to SSRS 2005 and I...more >>

SSRS 2005 and Internet Explorer 7 (beta)
Posted by Jon Limmer at 7/27/2006 11:22:02 AM
I have reports developed in VS 2003 over the past couple of years. They were set up using SQL Server 2000 and deployed to an IIS 6.0 server, using IE 6 and IE 7 (beta) client browsers with no problems. I just upgraded my SQL Server from 2000 to 2005 yesterday and, using VS2005, re-deployed...more >>



compability of visual studio express vs visual studio
Posted by Dave Sundell at 7/27/2006 11:11:02 AM
Can anyone tell me if Visual Studio Express and Visual Studio Report Designer are compatible when designing reports? We tried to import .RDL files between the two and were unsuccessful. Our intent is to give our user something like Visual Studio Express to develop reports , but yet be flex...more >>

Re: SQL Report Builder 2005
Posted by Bob Meyers [MSFT] at 7/27/2006 10:05:24 AM
This message is displayed when the report model does not have any entities in it. Does your model have at least one entity? -----Original Message----- From: cobol Posted At: Wednesday, July 26, 2006 2:04 PM Posted To: microsoft.public.sqlserver.reportingsvcs Conversation: SQL Report Builde...more >>

UDF requiring parameters from parent report in sub-report
Posted by mn_ms_user at 7/27/2006 7:59:01 AM
I am trying to create a sub-report that is using a UDF(user defined function on the SQL Server) requiring parameters from the parent report for a datasource for that sub-report. (I hope that made sense). Basically, the UDF needs to be run for every record that is in the parent report. The UDF ...more >>

Percent in diagramms
Posted by florian at 7/27/2006 3:43:24 AM
Hi, I'd like to display a chart with simple bars. I'd like 0-100% (in 20% steps) displayed on the y-axis. At the moment my y-Axis is only as big as the highest bar. Example: I have to baras one with 12% and the other one with 56% my diagramm will only go until about 60%. How can I resol...more >>

deploy reports directly into right folders
Posted by florian at 7/27/2006 3:25:45 AM
hi, is it possible to deploy an report directly to a folder from the business intellegence studio? or can I only move reports via the Report Manager? Thanks! ...more >>


DevelopmentNow Blog