Manipulating a reports visual appearance

Hi,
we are changing at the moment our reporting system from crystal report to MS
Reporting services. Our reports are highly customizable during display. In
Crystal Reports we were using scripts into the reports to set the text align
and the column back- and foreground color by user decisions. It was also
possible to choose whether the report should be displayed in landscape or
portrait format. Now I need to give the reports with MS Reporting Services
the same abilities but I didn't find any possiblity to that yet. Because our
main application in which the reports are shown is written in good old MFC
we are using URL access to render and display the reports.
Does anyone here knows how to solve one or all of my issues described above?
Thanks in Advance
Markus
P.S. I'm a really newbie in MS Reporting Services.Style properties (like text alignment and color) can be expressions. These
expressions can depend on parameters to the report.
For example:
<TextAlign>=Parameters!TextAlign.Value</TextAlign>
Or:
<Color>=iif(Parameters!ColorScheme.Value="Rainbow","HotPink","LightBrown")</
Color>
For page orientation, you can set the page height and width via parameters
in the URL (something like rc:PageHeight=8.5... Check the documentation for
details)
My employer's lawyers require me to say:
"This posting is provided 'AS IS' with no warranties, and confers no
rights."
"Markus Heid" <markus.heid@.logasys.com> wrote in message
news:efgHn3$YEHA.1448@.TK2MSFTNGP12.phx.gbl...
> Hi,
> we are changing at the moment our reporting system from crystal report to
MS
> Reporting services. Our reports are highly customizable during display. In
> Crystal Reports we were using scripts into the reports to set the text
align
> and the column back- and foreground color by user decisions. It was also
> possible to choose whether the report should be displayed in landscape or
> portrait format. Now I need to give the reports with MS Reporting Services
> the same abilities but I didn't find any possiblity to that yet. Because
our
> main application in which the reports are shown is written in good old MFC
> we are using URL access to render and display the reports.
> Does anyone here knows how to solve one or all of my issues described
above?
> Thanks in Advance
> Markus
> P.S. I'm a really newbie in MS Reporting Services.
>|||TextAlign, BackgroundColor, and ForegroundColor can be expressions, so you
can make them user-driven using user-entered parameters. Check
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSCREATE/htm/rcr_creating_expressions_v1_3983.asp
for details.
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Markus Heid" <markus.heid@.logasys.com> wrote in message
news:efgHn3$YEHA.1448@.TK2MSFTNGP12.phx.gbl...
> Hi,
> we are changing at the moment our reporting system from crystal report to
MS
> Reporting services. Our reports are highly customizable during display. In
> Crystal Reports we were using scripts into the reports to set the text
align
> and the column back- and foreground color by user decisions. It was also
> possible to choose whether the report should be displayed in landscape or
> portrait format. Now I need to give the reports with MS Reporting Services
> the same abilities but I didn't find any possiblity to that yet. Because
our
> main application in which the reports are shown is written in good old MFC
> we are using URL access to render and display the reports.
> Does anyone here knows how to solve one or all of my issues described
above?
> Thanks in Advance
> Markus
> P.S. I'm a really newbie in MS Reporting Services.
>|||Thank you very much. It is much easier than I though!
"Chris Hays [MSFT]" <chays@.online.microsoft.com> wrote in message
news:uetiBzFZEHA.2972@.tk2msftngp13.phx.gbl...
> Style properties (like text alignment and color) can be expressions.
These
> expressions can depend on parameters to the report.
> For example:
> <TextAlign>=Parameters!TextAlign.Value</TextAlign>
> Or:
>
<Color>=iif(Parameters!ColorScheme.Value="Rainbow","HotPink","LightBrown")</
> Color>
> For page orientation, you can set the page height and width via parameters
> in the URL (something like rc:PageHeight=8.5... Check the documentation
for
> details)
>
> --
> My employer's lawyers require me to say:
> "This posting is provided 'AS IS' with no warranties, and confers no
> rights."
> "Markus Heid" <markus.heid@.logasys.com> wrote in message
> news:efgHn3$YEHA.1448@.TK2MSFTNGP12.phx.gbl...
> > Hi,
> > we are changing at the moment our reporting system from crystal report
to
> MS
> > Reporting services. Our reports are highly customizable during display.
In
> > Crystal Reports we were using scripts into the reports to set the text
> align
> > and the column back- and foreground color by user decisions. It was also
> > possible to choose whether the report should be displayed in landscape
or
> > portrait format. Now I need to give the reports with MS Reporting
Services
> > the same abilities but I didn't find any possiblity to that yet. Because
> our
> > main application in which the reports are shown is written in good old
MFC
> > we are using URL access to render and display the reports.
> > Does anyone here knows how to solve one or all of my issues described
> above?
> >
> > Thanks in Advance
> >
> > Markus
> >
> > P.S. I'm a really newbie in MS Reporting Services.
> >
> >
>