all groups > sql server reporting services > september 2005 > threads for tuesday september 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
Unable to preview
Posted by CSQL at 9/27/2005 8:37:05 PM
I have Reporting Services on my personal laptop with XP SP2, MS Visual Studio
..Net, and SQL Server 2000.
I can start a report project, connect to server, connect to database, when
it come to previewing the report in the designer, I get one of two messages:
Unable to connect to datasource
... more >>
Changing the color of the series label
Posted by Todd at 9/27/2005 4:19:04 PM
I am able to change the colors of the series inside the graph, however I
would like to make one data point stand out based on a parameter that is
passed in. I have already set up the color schemes for the series to do this
inside the chart but would like the label to make that distinction as ... more >>
Deployment: SRS2005 can use SQL2K as ReportDatabase
Posted by JDS at 9/27/2005 3:04:03 PM
Can the SQL Server 2005 Reporting Services configured to use the SQL2K Server
as reporting database server?
Rationale:
So that I can put the 2005 reporting services in the DMZ and use exisitng
sql2K server behind the DMZ to store the reporting database. Another reason
is that , I don't hav... more >>
PDF Margins
Posted by Kevin Karlin at 9/27/2005 2:49:25 PM
I have searched through out this newsgroup and seen several people
pose the question without response. I am trying to output some reports
to PDF from the standard RS interface
(http://localserver/reports/.....) The report generates a PDF
perfectly except that the margins are 1 inch on each side ... more >>
Conditional Sum trouble
Posted by rs_newbie at 9/27/2005 2:35:04 PM
Can someone help me figure this out? I'm trying to total up 4 columns which
have been X'd to indicate inventory types: RAWX, NSFGX, BUYX and SFGX.
I've tried:
=iif( Fields!RAWX.Value = "X", Sum(Fields!BKIC_PROD_AVGC.Value *
Fields!BKIC_PROD_UOH.Value), 0)
=iif( Fields!NSFGX.Value = "X"... more >>
Page Cannot be Displayed
Posted by Joe Hoggood at 9/27/2005 12:26:40 PM
When I try to run any of my reports from a non-domain member client PC I get
"the page cannot be displayed" message. I am authenticated on the SSRS server
because it lets me see the available reports but when I try to open the
report it fails with this message. Any ideas? This works fine from ... more >>
ReportServer Error - Please help!
Posted by Terry at 9/27/2005 11:59:06 AM
How should I resolve the following error message when attempting to access
ReportServer? (i.e. http://wardteserv/reportserver or /reports)
ERROR:
The version of the report server database is either in a format that is not
valid, or it cannot be read. The found version is 'C.0.8.38'. The ex... more >>
Setting default value for a Multi-value parameter
Posted by isaak at 9/27/2005 11:22:02 AM
I want the default value for a muti-value parameter to be the equivalent of
<Select All>. How can this be accomplished? Thanks in advance
... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Showing custom aggregates in Group Footers
Posted by isaak at 9/27/2005 10:19:06 AM
In my group footer I want to show a string that was built by concatenating
some data from individual records within a group. For example,
Group 1
10 AB
20 CD
30 EF
Group 1 Footer 60 for AB,CD,EF
I wrote a custom code function that bui... more >>
New Installation Error
Posted by Brian Ackermann at 9/27/2005 7:22:03 AM
Hello all.
After suffering a complete RAID failure, I am now tasked with the
responsibility of setting up reporting services again, on a new and
different machine. I had been successful getting it running last time,
so I figured this wouldn't be too much problem. The installation goes
fine,... more >>
Percent on a Matrix
Posted by anthonysjo at 9/27/2005 7:09:02 AM
Well, I finally got my first percentage on a Pie chart but when I went to use
the same technique on a Matrix report with the Pie being created for each new
row (Vice_President) then I started getting funny numbers. I think I have
figured out that I need to use the IN SCOPE function but I am a... more >>
Table visibility based on expression - Bug
Posted by capricorn at 9/27/2005 6:46:11 AM
Using MS SQL Server 2000 Reporting Services:
I have multiple tables on my report. Each one is visible based on report
parameters. 2 of the tables had the same expression on the Table Visibility
property:
=IIF( Parameters!group_by.Value = 5, False, True)
One of the tables appears on the re... more >>
Progress Bar in Table Cell
Posted by rSmoke at 9/27/2005 5:39:03 AM
I'm creating a report with several columns. One of which is a percentage
value. The business people have asked that that column show a progress bar of
sorts to give a visual indicator of the percentage complete, in addition to
the textual %. I have tried to figure out how to do this in a table... more >>
Location of error log?
Posted by Nicola Jones at 9/27/2005 3:52:01 AM
Hopefully this will be a simple question.
Where is the error log located? I am looking in
program files\microsoft sql server\mssql\reporting services\LogFile
at a file called ReportServer__09_27_2005_11_38_23.log inside that file is a
message:
e ERROR: Throwing
Microsoft.ReportingS... more >>
Windows Authentication
Posted by Tim Poynter at 9/27/2005 2:58:04 AM
I have a report that uses the Windows Username to filter the data in the
report, i.e. when a particular manager runs the report they only see the
information relevant to there department. Is there a way to prompt the users
for their Windows Account every time they run the report? Users are con... more >>
Calculation with Excel rendred values
Posted by Niklas at 9/27/2005 1:08:02 AM
We have a problem with Excel rendering. The target of Excel rendering should
be, that end users could use the rendered values for further calculations.
But, independent of the format of the values, we assigned within the report,
all cells have to be converted manually after excel rendering in ... more >>
Report export to pdf
Posted by andrei at 9/27/2005 12:00:00 AM
Hi Group,
We have an application that generates reports for one or more facilities
selected by the user.
The reports are generated in PDF format and are displayed in the browser
using something similar to :
report = rs.Render(...)
....
Response.BinaryWrite(report)
....
Most of the tim... more >>
Display Parameters/Global variables
Posted by Zean Smith at 9/27/2005 12:00:00 AM
I am trying to display this in TextBox in the Footer:
This is Page =Globals!PageNumber
However, it doesn't work. It only works if I remove the "This is Page". Is
there any way so that I can use one text box to display both my text and the
variable?
Thanks.
... more >>
|