all groups > sql server reporting services > january 2005 > threads for tuesday january 4
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
Book recommendation
Posted by collie at 1/4/2005 11:29:02 PM
Hi,
I am not sure which book to buy: Hitchhiker's Guide to SQL Server 2000
Reporting Services
or
Professional SQL Server Reporting Services -- by Paul Turley
I need a book that will also show me for example how to pass parameters from
asp.net to rss. I want the user to select parameters... more >>
URL Parameter and Default Values
Posted by Michael McCallum at 1/4/2005 10:52:02 PM
I need to ability to pass a parameter (a session variable) on the URL that
will drive the content of parameters used for lookups. An example is that a
person may be limited to only two districts out of 10, so for that person I
only want the two districts show in the drop down list in the para... more >>
Matrix row total
Posted by John Geddes at 1/4/2005 8:56:25 PM
I have a count(field!orderstamp.Value) in a field and I would like to
show the percentage that number is of the whole row?
I can add a column next to it, but how do I show a percentage of a row
in a matrix?
Thanks.
... more >>
Report Moving Script
Posted by Scott Meddows at 1/4/2005 4:54:14 PM
Does anyone have a script that they would like to share that would move some directory and it's tree from one server to another?
Thanks!
Scott
... more >>
Creating a group at run-time
Posted by Matt at 1/4/2005 4:05:07 PM
I have a request for a report to allow the user to render the output grouped
by start of last name (A's, B's, C's, etc) and have each group print on its
own page. This action would be controlled from a report parameter ideally
and the user would be able to toggle from normal output to this gr... more >>
Report wont render
Posted by sfibich at 1/4/2005 2:49:22 PM
I am having an issue with a particular report not rendering when
displaying in the web browser from reporting services web site. The
report never displays and if you check under site settings the job is
showing that it is in an Action of "Render". Has anyone else ever seen
this? Is there... more >>
same data set, different parameters
Posted by Ben Sullins at 1/4/2005 2:23:02 PM
greetings...
I have a stored proc that returns results based on startdate and enddate
parameters. I have a report that has a matrix on it which needs to show
totals for the previous day, month to date, and 3 previous months. To get the
data all that is required is for me to run the same pro... more >>
file share subscription problem
Posted by dcp12345678 NO[at]SPAM yahoo.com at 1/4/2005 1:53:54 PM
I've setup a file share subscription to render a report to an AS/400
file system, but it is failing with Logon failure: unknown user name
or bad password ---> System.Runtime.InteropServices.COMException
(0x8007052E):
I'm supplying the correct username and password to access the
directory, and... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
If...Then Statement in Table
Posted by sbaker at 1/4/2005 12:55:07 PM
I am new to using Reporting services and was wondering if it is possible to
use if...then statements within a table. Ultimatley, I would like to build a
table that displays prior day sales, current month, current quarter, and
current year sales. Any suggestions?
Thanks,
Scott... more >>
I can't get ANY query with Report Builder to work!!
Posted by trint at 1/4/2005 11:37:47 AM
I don't want to use a stored procedure, or do I have to?
I can't get any of my querying (whether from a dropdown or not) to do
anything other than display entire table...I'm creating report from
report wizard.
Help IS appreciated.
Trint
... more >>
Average of average in SP2
Posted by Gavin Pollock at 1/4/2005 11:37:00 AM
Does anyone know if we are expecting this to be included in Service Pack 2
at all?
Cheers
Gavin
... more >>
Letter Templates query
Posted by Daniel Williams at 1/4/2005 11:29:18 AM
It seems that letter templates are based on a simple query to PROJ. Does
anyone know if I can change that underlying query to get more data for a
template?
Thanks,
Daniel Williams
... more >>
Linked reports in ReportManager
Posted by Christian Nordbakk at 1/4/2005 10:47:46 AM
Hi,
I'm trying to link a number of reports that represents different drill
levels (reporting off a AS cube), that I had to split up for performance
reasons. My problem is that when clicking a link you are navigated out
of Report Manager, and so loose a lot of navigational control, plus that... more >>
printing
Posted by Servé La at 1/4/2005 10:43:39 AM
It is my understanding that after installing SP1 you get a print button on
the toolbar next to refresh and help.
However, it doesnt show and I'm certain that SP1 is installed because
javascript in hyperlinks does work now. What could be wrong there?
... more >>
Why does "Query Command Type" have to be "Stored Procedure"?
Posted by trint at 1/4/2005 10:04:26 AM
I have created a report that lists all contents of table but needs to
do query on certain records...why can't Report Designer create the
ability to do queries without stored procedures? Or can it?
Help is appreciated.
Thanks,
Trint
... more >>
Server Behind SSL Firewall
Posted by beanmasher at 1/4/2005 9:35:02 AM
Have server with Standard Edition Reporting Services, SQL Server Standard
Edition 2000, and portal application that uses ReportViewer. This is located
behind a firewall and must be accessed via https://some.domain.com/app. SSL
is not enable on the Server but on a content switch.
How sho... more >>
Failure Parsing The Config File
Posted by Help Me Rhonda at 1/4/2005 8:41:05 AM
I am trying to execute the rsactivate file and I am recieving the following
error:
"Failure parsing the config file. Invalid URI: The hostname could not be
parsed."
What could be causing this and what is the solution? Thank you in advance.
... more >>
Repeating report
Posted by TheRSBeginner at 1/4/2005 8:11:11 AM
I want to do the following with RS:
I have a invoice that I want to print three times and at the end of the
report I want to print a letter refering the invoices. I could do that making
2 reports, calling the first with three copies for the invoices and the
second report would be the letter.
... more >>
Format question of text concatenation
Posted by Sally at 1/4/2005 6:51:02 AM
I have a text like this '*'& Field!Item.Value. I would like to highlight the
asterisk '*' as red color and bold in order to make the end user notice it
easier.
How can I do it? Thanks for your help.
... more >>
using url to query?
Posted by trint at 1/4/2005 4:47:46 AM
Ok, I have created a report that is very simple.
SELECT DealerNumber, OrderNumber, ProdNum, QtyOrd,
FromDealerNumber, OrderDate, Amount, Type, SalesManagerOrganization,
DistributerOrganization
FROM TravMasNew
Here is the url that shows the report:
http://localhost/ReportServer?... more >>
|