all groups > sql server reporting services > july 2005 > threads for wednesday july 6
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
Printing - SQL RS SP2
Posted by שמעון פ. at 7/6/2005 10:23:02 PM
Hi,
I am dealing with reports in hebrew.
In my report the cells direction is RTL and right alignment .
In the browser view it shows just fine - but when I try to print the report
all the cells are aligned to the left - and it doesn't look good.
On the other hand - if I align the cells to t... more >>
access rs reports through .aspx
Posted by Alex at 7/6/2005 7:39:01 PM
I'm not sure of what i should do to come up with a web site that allows the
users to access the reports that are in my reportserver, I would like to
know a step by step instructions on how to access my reports using asp.net
web application.
Is my problem has anything to do with configuring c... more >>
rotate the x axis labels?
Posted by Marcus K at 7/6/2005 6:36:01 PM
Is there any way to rotate the x axis labels?
If I have one long value it turns all my axis labels veritcal. I would
rather have them all at 45 degrees.
Thanks,
Marcus... more >>
Converting Integer Parameter To String!
Posted by Nitin M at 7/6/2005 5:39:10 PM
Hi,
I am trying to print the value of the report parameters in the report. I
want this because once I print the report I lose the parameters with with
the report was run.
I have a integer parameter and I am using the following expression to get
the parameter's value.
="MyInt: " + Iif ... more >>
HTML4.0 Export - Paging?
Posted by Gastón Pírez at 7/6/2005 4:29:56 PM
How can i obtain the the number of pages in a report when i use the render
method of the web service?.
I'm using the folowing devInfo:
<DeviceInfo>
<Toolbar>False</Toolbar>
<StartPage>4</StartPage>";
</DeviceInfo>
The StartPage parameter is no working.
Thanks in adva... more >>
PDF Export - fonts dont show up properly
Posted by D Witherspoon at 7/6/2005 2:42:07 PM
For example the reverse delta character (upside down triangle) (0xD1) from
the Symbol font will not show up on reports exported to PDF but other
characters from the Symbol font will. The reverse delta character shows up
when exporting to a TIFF just fine though.
Anyone seen this? or know ... more >>
SQL Bit Data Type parameters
Posted by Support Mechanic at 7/6/2005 2:19:02 PM
I am trying to use a stored procedure that is of data type of bit, however
SQL Reporting Services does not have this as a valid data type. I have added
the parameters to the report and have tried all the possible combinations but
keep getting error about converting string to the bit datatype.
... more >>
ReportItems and Columns - URGENT!!!
Posted by DragonVic at 7/6/2005 2:06:05 PM
I have a textbox in a table with one group, I am using the Switch( ) command
to get a numeric result for that textbox. at the end of the report I want to
add those values for that text box.
I tried using Sum(ReportItems!Textbox1.Value) but I keep getting an error,
I need to do this in SRS, ... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Is it possible to customize the look of the parameters form?
Posted by Jaime Stuardo at 7/6/2005 1:49:02 PM
Hi all...
When a report is viewed in web browser, a parameters form appear at the top
of the screen so that user can enter parameters and then press View Report.
Is it possible to display a title before that form? or to customize the
colors and fonts for that form?
Thanks
Jaime... more >>
Multi Select Parameter in RS2005
Posted by RDC at 7/6/2005 1:32:01 PM
I'm using the possibility to define some parameters of my reports having the
property multi-select. On all my reports I always give information on the
first page on the parameters used to generate the output. For parameters that
do not have the property multi-select this works by using express... more >>
SELECT TOP @variable
Posted by agenda9533 at 7/6/2005 1:14:02 PM
I want to do something like this: SELECT TOP @variable .
I've read all related topics BUT I cannot use stored procedure for this
report, 'cause I do not have access to prod db, I'm just sending rdl for
upload. How to make it work on dataset level or through the report layout?
I know SQLServe... more >>
Obtaining SQL RSS Developer Addition
Posted by Max Tyack at 7/6/2005 10:52:02 AM
I want to install SQL Reporting Services on my laptop which has Windows XP
Pro, SQL 2000 Dev. Edition, and Visual Studio .NET 2003.
Where can I download or obtain the install file for SQL Reporting Services
Developer Edition?
- Max... more >>
Deserialization failed error
Posted by DigitalVixen at 7/6/2005 10:06:03 AM
Can this be fixed by manually editing the rdl? I have tried however I
receive an error stating that Parameter name: Top must be between 0 and
85.33333in, when I change it to .5in, 1.5in I get ...is not a valid value.
Anyone, please help, I have created 11 pages and don't want to recreate the... more >>
Report Refresh Problem
Posted by Suresh at 7/6/2005 10:01:06 AM
Hi,
I had a report wherein it was taking a single parameter value and outputting
the data. In addition I pass other parameters to this report. Now the
functionality is that it can take multiple values in addition to the existing
params. The multiple value list is not passed into the report ... more >>
Expression for Color property
Posted by Stanley Hammer at 7/6/2005 9:35:22 AM
I keep getting a message when setting the expression for the color property.
When I exit the expression builder an error message is displayed showing the
expression and "not a valid color". I have tried numerous IIF but cannot get
past the error.
IIF( Fields!ACCOUNT_STATUS.Value="LOCKED","R... more >>
rc:Linktargetpossible bug
Posted by MadLawt at 7/6/2005 8:35:03 AM
Hi,
I have created a report that is displayed in an iframe using the
rc:Linktarget to force any links within the report to open in the same frame.
This works fine but when in this second report we click on a link it jumps
out of the frame and loads as the whole page. Now within the first r... more >>
Multi comboboxes
Posted by Fairfield at 7/6/2005 7:59:12 AM
Hi,
My instructions are to add more functionality to current reports by adding a
second dropdown. The reports currently have one combobox that lists
Application names. When an Application is chosen the report opens with all
the data associated with that Application.
Now there is a requ... more >>
Conditional Toggle ??
Posted by RP at 7/6/2005 7:54:02 AM
Hi i have a table that look something like this
School
Class
Section
studentA 1323 534543 543543 43534
studentB 657 7657567 66 9
Is there anyway i can set up the toggle for all like
if there is only 1 ... more >>
Q any group or freeze function
Posted by JIM.H. at 7/6/2005 7:49:02 AM
Hello,
I have a rectangle and a few textbox in it, now when I run report, the
textbox goes out of rectangle, Is there any way to group and freeze?
... more >>
datasets and parameters
Posted by kowalsky at 7/6/2005 7:33:05 AM
I am trying to put up together a report with several parameters. The first
parameter is independent, the second one, though depends of this first one.
Is there a way to link them somehow, so that when i pick my first parameter,
the second dataset I'm using for my second parameter will be popul... more >>
VS 2003 reports
Posted by jvh_bbb NO[at]SPAM yahoo.com at 7/6/2005 12:39:42 AM
I got a stupid question
can anyone explain to me how to force a page break in Visual Studio
reports?
I'll explain what I have done
I created a report with 2 ( or more ) subreports, but i am unable to
let the seconde , third subreports start on a new page.
Anyone a suggestion?... more >>
re: TOP QUESTION !
Posted by Jack Nielsen at 7/6/2005 12:00:00 AM
I have a problem with this because its sums up the totaldb for every line
(posting), how can I make the top 5 with sum only run once and not sum up
every time ? In the report group til makes a sum of whole sum for each
posting making the top 5 statement wrong, I find this very difficult. I
suppo... more >>
Switching Service user
Posted by Daniel Buchholz at 7/6/2005 12:00:00 AM
Hi!
I am trying to switch the log on user of the Reporting Services service.
Currently it is "NT AUTHORITY\NetworkService" which apparently does not
have the right to send mail. But this is what we are required to do for
mailing out report subscriptions.
When I switch to "Local System Ac... more >>
|