all groups > sql server reporting services > december 2004 > threads for thursday december 16
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
Filtering the dataset
Posted by Terry at 12/16/2004 7:11:02 PM
Hi All,
I have reports which return employee information. I want the report to have
an optional 3 parameters representing Entity, Business Unit and Cost Centre.
If any of these parameters(or a combination is used) I want to filter the
returned dataset to display only relevant rows.
Before... more >>
Word rendering... WHEN?
Posted by Rodrigo Sánchez at 12/16/2004 6:49:38 PM
UIs it true thatr microsoft has no plans to create word rendering
extension?, I cant believe they wont support their own propietary format,
even when tehy support PDF, even rtf would do the trick, Is there some one
who can tell me if we are to expect that feature in the final release of sql
serv... more >>
Change report server database
Posted by May Liu at 12/16/2004 6:19:04 PM
I install reporting service on 2 machines. Each RS has it's own report
server database. e.g. A_ReportServer for machine A and B_ReportServer for
machine B. Can I dynamically change the report server database ??? i.e.
Machine A point to B_ReportServer database. If yes, how can I do this ??... more >>
sort correctly by month name
Posted by aaron_kempf NO[at]SPAM hotmail.com at 12/16/2004 5:53:20 PM
so i have month name in a field for a rs report..
and i want to be able to sort it correctly.
what are my options?
I'm doing this in MDX: and i cant change the cube or a dimension
aaron
... more >>
Reporting services initilization problem
Posted by Skeptical at 12/16/2004 4:06:24 PM
Hello,
I installed RS on a Windows 2003 box with SQL Server 2000 sp3. Unfortunately
setup reported that it could not initialize RS and it has to be initialized
manually
I have tried:
rsconfig & rsactivate with tons of different combinations of users ranging
from local system account ... more >>
Reporting-Server Grafik mit werten kleiner 0
Posted by Ralph Hüttenmoser at 12/16/2004 3:39:41 PM
Guten Nachmittag
ich habe einer Grafik eine DataSet zugewiesen (Thema ist: Über oder
Minusstunden) Auf der Grafik werden aber nur die postiven Zahlen angezeigt
(der 0-Punkt ist immer der Ausgangspunkt).
Es müssten z.B. aber noch -1, -2 oder noch tiefere Achsen angezeigt werden.
Muss man d... more >>
Report Parameter Defaults not being used in deployed reports
Posted by Kelly Gross at 12/16/2004 2:51:12 PM
When I set the default properties under Report Parameters in some
reports, it works perfectly, in other reports, the parameters specified
in Visual Studio under Report Parameters seem to have no effect when
the report is deployed to the ReportServer. The toolbar for the
parameters displays, and ... more >>
One subscription; Multiple Reports
Posted by HBWAL at 12/16/2004 2:45:02 PM
I have a report with 4 parameters.
Hierarchy:Dept, Team, Member
Report: List based on Hierarchy
Mgr: List based on Hierarchy
Person:List based on Manager
The managers want to send a "report card" to the team members letting them
know how their metrics are meeting goal. To do this they wo... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
I need to know how to deploy reports without Visual Studio
Posted by Kelly Gross at 12/16/2004 1:52:50 PM
I have reviewed the available documentation and was unable to locate a
method to deploy reports outside of Visual Studio without instantiating
the web service. We have a package we would like to bundle with some
reports.
Does anyone know an easy way to deploy reports using an .rdl file?
... more >>
Operation Not Supported: LogonUser method in the Reporting Web Service
Posted by Dave at 12/16/2004 1:51:13 PM
I'm getting a SoapException stating "This operation is not supported in
this edition of Reporting Services --> This operation is not supported
in this edition of Reporting Services" when I try to call
myReportService.LogonUser(myName, myPassword, myDomain)
I have verified that I am running t... more >>
A couple newbie questions: page breaks & grouping
Posted by Paul Enfield at 12/16/2004 1:42:00 PM
Referals to documentation references appreciated if applicable...
I've got a few questions regarding my task of creating a collection of fax
reports. I'm gathering I might be attempting to use the wrong tool for this.
Please indicate if this perception is correct.
Specifically:
I need to pr... more >>
DistinctCount
Posted by Myles at 12/16/2004 1:19:02 PM
I am running into a problem using DistinctCount - I have values in the report
that can either be a valid value, an empty string or null - I believe the
nulls are being discarded in the counts, but is there a way to make sure that
the empty strings are not being counted?... more >>
Why does adding a new static row to a matrix add a new column?
Posted by Stefan Wrobel at 12/16/2004 12:59:03 PM
In a matrix, when I add a static row it adds another column. I don't
understand this behavior. For example, take a Matrix, define a column group
and a row group (just the initial columns and rows groups, just give them
each a grouping expression), then right-click on the data area and do "ad... more >>
Formatting spoils when export to HTML Format
Posted by Jignesh Nakrani at 12/16/2004 12:45:01 PM
I have problem here. when I overlap two or more tables one on other and
export to PDF, it works fine. But when exported to HTML, it doesn't hold the
absolute position and renders tables sequentially.
Thanks,
Jignesh... more >>
Table Cell Formatting
Posted by Rory McCaw at 12/16/2004 12:24:27 PM
The cell formatting doesn't appear to be working in my report. In the
Textbox properties:
Name: Value
Value: =Fields!Value.Value
Format: Standard | Number | 1234
The output however in the cell is consistently 1234.123456789. How can I
round off to the nearest whole number (no decimals)?
T... more >>
Reporting Services
Posted by sai at 12/16/2004 12:03:01 PM
hi,
I trying to display list of values in the table footer. Here i am using
multivalued datafield and it is displaying only one value. How can I make the
footer to display all of the values of that field? Is there any other
solution?... more >>
Carriage returns
Posted by Microsoft at 12/16/2004 11:03:30 AM
I'm migrating from Crystal. When I inserted address fields which contained
carriage returns, Crystal seemed to recognise them automatically, putting
the second line beneath the first line, etc. RS doesn't do this - obviously
I have to do something more explicit. Cam anybody help?
Thanks
... more >>
Changing password
Posted by Patrick at 12/16/2004 11:02:31 AM
Hi Freinds,
SQL 2000 REPORTING SERVER
I changed my SA account password and Reporting service stop working.
Where should I modify the account crudentails in RSReportServer.config
Thanks,
Pat
... more >>
Change quality rendering to PDF
Posted by TiJei at 12/16/2004 10:47:07 AM
PDF - rendering of reports that contain images, makes very large pdf-files.
Is there any option that I can set the export quality of the images?
I have seen in this forum that there have been many questions about
rendering images, but very few good answers .... can anyone tell me if there
... more >>
Moving SQL Server/Report Server off public IP
Posted by DJM at 12/16/2004 10:28:50 AM
We are planning on moving our SQL Server off of the same machine as our web
server and securing it behind a firewall, removing all accessibility by
public IP. However, our web app uses the report viewer control to render
reports, and it points to <default IP of the web server>/ReportServer, w... more >>
Linking Reports in different projects
Posted by sfibich at 12/16/2004 9:59:26 AM
Is there a way to link reports from one project to reports in a second
project?... more >>
format Now()...
Posted by clutch at 12/16/2004 9:33:03 AM
How do I format Now() to look like dd/MM/yyyy (without time part) as a
default value for a report parameter?... more >>
Permission problems - Access Denied
Posted by CTSawyer at 12/16/2004 8:45:02 AM
When ever I attempt to access the Report Manager
(<rooturl>/Reports/Pages/Folder.aspx) page of RS I get:
The request failed with HTTP status 403: Access Forbidden.
If I try <rooturl>/ReportServer/ I get:
Directory Listing Denied
This Virtual Directory does not allow contents to be listed
Ou... more >>
How can I detect the user name and show only the Rows with his information?
Posted by Luis Esteban Valencia at 12/16/2004 8:26:14 AM
I have a table or view with a column name with the DOMAIN USER NAME. I want
to detect it and show only the information that they need to see.
--
LUIS ESTEBAN VALENCIA
MICROSOFT DCE 3.
MIEMBRO ACTIVO DE ALIANZADEV
... more >>
hidden parameters are not hidden
Posted by Pascal Simler at 12/16/2004 7:35:01 AM
Hello,
I've created a report with a parameter with no prompt ( hidden ) and a
second one with a prompt. When I switch to preview in Visual Studio only the
second parameter appears. This is OK.
When I launch the report in IE :
http://servername/ReportServer?/ReportFolder/Myreport&Param1=1&P... more >>
|