Showing posts with label expressions. Show all posts
Showing posts with label expressions. Show all posts

Monday, March 12, 2012

New options required in RS

Hi. Hope this reaches the RS development team.
I would like to know if in the new releases of RS there will be
expressions as there are in the DTS visual studio.
For example in the fields of width, height..at the moment we have to
put a fixed width and height whereas we could use the expressions.
Sometimes customers request double spacing instead of single space btw
records.
In addition to that, i need extra options in the matrix such as:
the ability to add fields to the right of the matrix column, (static
fields) that are not related to the matrix's expansion. The result
would be the possibility of having static columns at the left and right
of the matrix...what an improvement it would be.
Also, right now we are unable to add headers to the fields preceeding
the matrix column. This would be a of great help in explaining the
content of these fields. Right now i'm creating labels and placing them
on top of the matrix but it's not legitimate in a way when i export to
excel they are misplaced.
Thanks
Christinato add to this Allow the Duplicate Data in the Group Field so it can be
exported to excel and sorted :)
"Christina" wrote:
> Hi. Hope this reaches the RS development team.
> I would like to know if in the new releases of RS there will be
> expressions as there are in the DTS visual studio.
> For example in the fields of width, height..at the moment we have to
> put a fixed width and height whereas we could use the expressions.
> Sometimes customers request double spacing instead of single space btw
> records.
> In addition to that, i need extra options in the matrix such as:
> the ability to add fields to the right of the matrix column, (static
> fields) that are not related to the matrix's expansion. The result
> would be the possibility of having static columns at the left and right
> of the matrix...what an improvement it would be.
> Also, right now we are unable to add headers to the fields preceeding
> the matrix column. This would be a of great help in explaining the
> content of these fields. Right now i'm creating labels and placing them
> on top of the matrix but it's not legitimate in a way when i export to
> excel they are misplaced.
> Thanks
> Christina
>

Friday, March 9, 2012

New line in column?

Is it possible?
Sp1 said:
New Lines in Expressions
Previously, expressions had to be contained on a single line. With
SP1, expressions can include a newline character. New line characters
include carriage return (CR), line feed (LF), carriage return and
line feed (CRLF), paragraph separator (Unicode 2029), and line
separator (Unicode 2028). The newline characters are replaced with a
space when the report is processed.
But I can't use it.
Please help me!
--
Composed with Newz Crawler 1.7 http://www.newzcrawler.com/Could you please post an example of how you're using it?
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Sean.Xiao" <ydxiao@.suntowntech.com> wrote in message
news:ufUQ64dhEHA.1656@.TK2MSFTNGP09.phx.gbl...
> Is it possible?
> Sp1 said:
> New Lines in Expressions
> Previously, expressions had to be contained on a single line. With
> SP1, expressions can include a newline character. New line characters
> include carriage return (CR), line feed (LF), carriage return and
> line feed (CRLF), paragraph separator (Unicode 2029), and line
> separator (Unicode 2028). The newline characters are replaced with a
> space when the report is processed.
> But I can't use it.
> Please help me!
> --
> Composed with Newz Crawler 1.7 http://www.newzcrawler.com/|||These textbox expressions/values were entered using the expression editor.
The first item, in the examples, is the textbox expression/value while the
second is how it should render. Hopefully these will point you the right
direction for using VB constants in expressions.
Example 1
--
="The brown fox jumped" & vbcrlf & "over the fence
The brown fox jumped
over the fence
Example 2
--
The brown fox jumped
over the fence
The brown fox jumped
over the fence
Example 3
--
="The brown fox jumped" &
" over the fence"
The brown fox jumped over the fence
For more information about constants see Visual Basic Language Reference,
Print and Display Constants:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vblr7/html/vamscmiscellaneousconstants.asp
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Sean.Xiao" <ydxiao@.suntowntech.com> wrote in message
news:ufUQ64dhEHA.1656@.TK2MSFTNGP09.phx.gbl...
> Is it possible?
> Sp1 said:
> New Lines in Expressions
> Previously, expressions had to be contained on a single line. With
> SP1, expressions can include a newline character. New line characters
> include carriage return (CR), line feed (LF), carriage return and
> line feed (CRLF), paragraph separator (Unicode 2029), and line
> separator (Unicode 2028). The newline characters are replaced with a
> space when the report is processed.
> But I can't use it.
> Please help me!
> --
> Composed with Newz Crawler 1.7 http://www.newzcrawler.com/|||2004-08-20 00:32:50
"Bruce Johnson [MSFT]" <brucejoh@.online.microsoft.com> wrote in
message
<udj2toghEHA.556@.TK2MSFTNGP10.phx.gbl>
> These textbox expressions/values were entered using the expression
editor.
> The first item, in the examples, is the textbox expression/value
while the
> second is how it should render. Hopefully these will point you the
right
> direction for using VB constants in expressions.
>
> Example 1
> --
> ="The brown fox jumped" & vbcrlf & "over the fence
>
> The brown fox jumped
> over the fence
>
> Example 2
> --
> The brown fox jumped
> over the fence
>
> The brown fox jumped
> over the fence
>
> Example 3
> --
> ="The brown fox jumped" &
> " over the fence"
>
> The brown fox jumped over the fence
>
> For more information about constants see Visual Basic Language
Reference,
> Print and Display Constants:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-
us/vblr7/html/vamscmiscellaneousconstants.asp
>
> --
> Bruce Johnson [MSFT]
> Microsoft SQL Server Reporting Services
>
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
>
> "Sean.Xiao" <ydxiao@.suntowntech.com> wrote in message
> news:ufUQ64dhEHA.1656@.TK2MSFTNGP09.phx.gbl...
> > Is it possible?
> >
> > Sp1 said:
> >
> > New Lines in Expressions
> >
> > Previously, expressions had to be contained on a single line.
With
> > SP1, expressions can include a newline character. New line
characters
> > include carriage return (CR), line feed (LF), carriage return and
> > line feed (CRLF), paragraph separator (Unicode 2029), and line
> > separator (Unicode 2028). The newline characters are replaced
with a
> > space when the report is processed.
> >
> > But I can't use it.
> >
> > Please help me!
> > --
> > Composed with Newz Crawler 1.7 http://www.newzcrawler.com/
--
Composed with Newz Crawler 1.7 http://www.newzcrawler.com/|||Ok,Thanks Bruce.
--
Composed with Newz Crawler 1.7 http://www.newzcrawler.com/