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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
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 >>
|