all groups > sql server reporting services > may 2007 > threads for tuesday may 1
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
Report Activity Tracking
Posted by AD at 5/1/2007 11:38:34 PM
Hi,
We would like to track user activity on our reports, has anyone done
this before? Are there any best practicies available?
We are considering a couple of options but I thought I'll ask the
clever people as well :)
(If this is a duplicate post, please ignore, I'm battling with IE7...)
... more >>
Installing report server
Posted by Faiz at 5/1/2007 10:22:39 PM
Hi All,
I am using SQL Server reporting services for the first time through SQL server 2005 evaluation version. I am using windows xp and when I Start reporting services configuration manager it ask me to coonect to a machine. When I click on the find option, which is displaying my machines naem,... more >>
Reference report outside of current project
Posted by MarkusJNZ NO[at]SPAM gmail.com at 5/1/2007 6:52:16 PM
Hi, I am migrating across some reports from 2000 and some of the
reports reference reports outside of the current project when a person
clicks on a value.
In the report designer under Navigation -> Jump to report the report
has the following value
\parentFolder\Report Name
Under 2005, wh... more >>
datetime parameter
Posted by gv at 5/1/2007 5:33:23 PM
Hi all,
Is there a way to not allow a date older then a certain amount of time in
datetime paremeter in a report?
like from date not to allow anything older then 6 months.
thanks
gv
... more >>
duplicate rows in drill down
Posted by gv at 5/1/2007 5:02:40 PM
Hi all,
I have a report that drills down some, and is showing duplicate rows.
How can remove the duplicate rows? Cannot do this on the initial sp because
they are not duplicates.
do I need to have an DISTINCT expression in there?
thanks
gv
... more >>
Group Sum over multiple pages with IIF
Posted by Michael C at 5/1/2007 10:34:01 AM
I am using an IIF statement to sum a group of detail records that spans more
than 1 page. The sum looks like this:
Sum(IIf(Fields!MySwitch.Value = 'A', Fields!MyValue.Value,0))
Im doing the sum in the table1_group1 footer and it works fine if all the
data in the group remains on the sam... more >>
Hiding Table Grid Lines
Posted by John Wright at 5/1/2007 10:27:09 AM
I have a table that duplicate data in some of the columns. I have the
property set to hide the duplicates, but I also want to turn off the borders
for those cells that are duplicated so I gives the same appearance as a
Matrix report when it has duplicated items in a column. Does anyone have ... more >>
Run report automatically when a parameter changes
Posted by Stephanie at 5/1/2007 8:05:00 AM
I have a report with 6 parameters. They all have defaults so it is run
immediately when opened. Is there a way to run the report automatically when
any of the parameters is changed by the user instead of requiring the user to
click on the View Report button?
Stephanie... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
embedding RS into a java (j2ee) application
Posted by Stephanie at 5/1/2007 8:01:02 AM
Can anyone point me to some useful information on embedding reports into a
java (J2EE) application?
Stephanie... more >>
SQL 2000 RS and Vista
Posted by Mark Goldin at 5/1/2007 7:02:52 AM
I am trying to install SQL 2000 RS on my Vista box. Installation refuses to
run.
This is my home computer and I dont care if I have to tweak something.
Anyone got it working on Vista?
... more >>
custom code to populate parm default
Posted by ppbedz at 5/1/2007 5:24:03 AM
I am using custom code to retrieve the current year to populate the default
year parameter for a report. The custom code correctly retrieves the year
when tested within the body of the report. However, when referenced as an
expression code.CurYr in the "default" seection of the report parame... more >>
how to count rows in field
Posted by nicknack at 5/1/2007 1:44:58 AM
Hello.
I built a report with one field as a group.
I want to count the number of rows in each field so I can add it to
the group field or somw where in the report.
How can I count how many rows do I have in each group?
Thanks.
... more >>
Reporting Services Rendering is Slow
Posted by Namshub at 5/1/2007 12:00:00 AM
I use the web service as well as intergrated url link to display, but both
display the same characteristics. The first run is extreemly slow. We
could be talking up to 1 minute to generate a pretty basic report.
When the same report with a differnet parameter or even a different report
i... more >>
Unable to Select All
Posted by Todd Stoltz at 5/1/2007 12:00:00 AM
I'm sure someone else has experienced this:
I am writing a report in Visual Studio 2005/reporting services for SQL 2005
and a parameter is designated as 'multi-value'. When I attempt to run the
report in the preview pane of Visual Studio, I do not see the select all
option. I actually hav... more >>
|