Generate sql: areas

hi!,
Can we use RS to format the report to look like an invoice?
The areas I have been having problems is defining the table with the invoice
items to always stay the same size regardless of the number of lines it
prints. I was using a table embedded in the report to print this with borders
on the table.
How do I get this to a fixed length column or let it page break with headers
and footers defining number of fixed lines for the body of the report. Are
there any samples of invoices either, Microsoft or anyone else has done?
Ranjit CharlesHi Ranjit,
You can control the number of rows in your report by:
1) add a group to table, and set grouping with
"=Ceiling(RowNumber(Nothing)/30)" try 30 or whatever number fits into
your spacing
2) turn off group header and footer
3) set PageBreakAtEnd for group
HTH
Matt A
www.reportarchitex.com

My client's want certain areas of my expression to be bold and also a
different color. Via HTML or CSS this would be the solution:
="Resource(s) Name: " &
Fields!ResourceName.Value & vbcrlf &
"Role: " & Fields!Role.Value & vbcrlf &
vbcrlf & "Other Resource(s) Name: " &
Fields!OtherResourceName.Value & vbcrlf & "Other Resource
Role: " & Fields!OtherResourceRole.Value
However, this does not work with SSRS. Is this something that will be
allowed in SSRS 2008 or is it possible with 2005?
--
<moojjoo/>RS 2008 is going support rich format. I have not played with the CTPs
(general pre-release software) so I am not totally firm in my head on how
this support will show itself.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Moojjoo" <Moojjoo@.discussions.microsoft.com> wrote in message
news:522D7736-6B3C-48BB-8DC7-D9147A802978@.microsoft.com...
> My client's want certain areas of my expression to be bold and also a
> different color. Via HTML or CSS this would be the solution:
> ="Resource(s) Name: " &
> Fields!ResourceName.Value & vbcrlf &
> "Role: " & Fields!Role.Value & vbcrlf &
> vbcrlf & "Other Resource(s) Name: " &
> Fields!OtherResourceName.Value & vbcrlf & "Other
> Resource
> Role: " & Fields!OtherResourceRole.Value
> However, this does not work with SSRS. Is this something that will be
> allowed in SSRS 2008 or is it possible with 2005?
> --
> <moojjoo/>|||So basically I am up the river without a paddle on what my client wants at
this time with formating the font?
--
<moojjoo/>
"Bruce L-C [MVP]" wrote:
> RS 2008 is going support rich format. I have not played with the CTPs
> (general pre-release software) so I am not totally firm in my head on how
> this support will show itself.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Moojjoo" <Moojjoo@.discussions.microsoft.com> wrote in message
> news:522D7736-6B3C-48BB-8DC7-D9147A802978@.microsoft.com...
> > My client's want certain areas of my expression to be bold and also a
> > different color. Via HTML or CSS this would be the solution:
> >
> > ="Resource(s) Name: " &
> > Fields!ResourceName.Value & vbcrlf &
> > "Role: " & Fields!Role.Value & vbcrlf &
> > vbcrlf & "Other Resource(s) Name: " &
> > Fields!OtherResourceName.Value & vbcrlf & "Other
> > Resource
> > Role: " & Fields!OtherResourceRole.Value
> >
> > However, this does not work with SSRS. Is this something that will be
> > allowed in SSRS 2008 or is it possible with 2005?
> > --
> > <moojjoo/>
>
>|||You can do things like put multiple text boxes next to each other and format
each of those (which really only works for very simple scenarios).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Moojjoo" <Moojjoo@.discussions.microsoft.com> wrote in message
news:17509CDD-B058-44DF-8DD9-004D6B027AF4@.microsoft.com...
> So basically I am up the river without a paddle on what my client wants at
> this time with formating the font?
> --
> <moojjoo/>
>
> "Bruce L-C [MVP]" wrote:
>> RS 2008 is going support rich format. I have not played with the CTPs
>> (general pre-release software) so I am not totally firm in my head on how
>> this support will show itself.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Moojjoo" <Moojjoo@.discussions.microsoft.com> wrote in message
>> news:522D7736-6B3C-48BB-8DC7-D9147A802978@.microsoft.com...
>> > My client's want certain areas of my expression to be bold and also a
>> > different color. Via HTML or CSS this would be the solution:
>> >
>> > ="Resource(s) Name: " &
>> > Fields!ResourceName.Value & vbcrlf &
>> > "Role: " & Fields!Role.Value & vbcrlf &
>> > vbcrlf & "Other Resource(s) Name: " &
>> > Fields!OtherResourceName.Value & vbcrlf & "Other
>> > Resource
>> > Role: " & Fields!OtherResourceRole.Value
>> >
>> > However, this does not work with SSRS. Is this something that will be
>> > allowed in SSRS 2008 or is it possible with 2005?
>> > --
>> > <moojjoo/>
>>|||Bruce, I totally can understand that the only problem is I have this in a
table... and they are wanting multiple items in a cell along with that
formatting I am referrring to.
--
<moojjoo/>
"Moojjoo" wrote:
> So basically I am up the river without a paddle on what my client wants at
> this time with formating the font?
> --
> <moojjoo/>
>
> "Bruce L-C [MVP]" wrote:
> > RS 2008 is going support rich format. I have not played with the CTPs
> > (general pre-release software) so I am not totally firm in my head on how
> > this support will show itself.
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Moojjoo" <Moojjoo@.discussions.microsoft.com> wrote in message
> > news:522D7736-6B3C-48BB-8DC7-D9147A802978@.microsoft.com...
> > > My client's want certain areas of my expression to be bold and also a
> > > different color. Via HTML or CSS this would be the solution:
> > >
> > > ="Resource(s) Name: " &
> > > Fields!ResourceName.Value & vbcrlf &
> > > "Role: " & Fields!Role.Value & vbcrlf &
> > > vbcrlf & "Other Resource(s) Name: " &
> > > Fields!OtherResourceName.Value & vbcrlf & "Other
> > > Resource
> > > Role: " & Fields!OtherResourceRole.Value
> > >
> > > However, this does not work with SSRS. Is this something that will be
> > > allowed in SSRS 2008 or is it possible with 2005?
> > > --
> > > <moojjoo/>
> >
> >
> >|||You are out of luck. This is very common requirement which is why it is
being implemented in RS 2008.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Moojjoo" <Moojjoo@.discussions.microsoft.com> wrote in message
news:C4A3785A-A03A-4855-B524-F6E9A65D39E4@.microsoft.com...
> Bruce, I totally can understand that the only problem is I have this in a
> table... and they are wanting multiple items in a cell along with that
> formatting I am referrring to.
> --
> <moojjoo/>
>
> "Moojjoo" wrote:
>> So basically I am up the river without a paddle on what my client wants
>> at
>> this time with formating the font?
>> --
>> <moojjoo/>
>>
>> "Bruce L-C [MVP]" wrote:
>> > RS 2008 is going support rich format. I have not played with the CTPs
>> > (general pre-release software) so I am not totally firm in my head on
>> > how
>> > this support will show itself.
>> >
>> >
>> > --
>> > Bruce Loehle-Conger
>> > MVP SQL Server Reporting Services
>> >
>> > "Moojjoo" <Moojjoo@.discussions.microsoft.com> wrote in message
>> > news:522D7736-6B3C-48BB-8DC7-D9147A802978@.microsoft.com...
>> > > My client's want certain areas of my expression to be bold and also a
>> > > different color. Via HTML or CSS this would be the solution:
>> > >
>> > > ="Resource(s) Name: " &
>> > > Fields!ResourceName.Value & vbcrlf &
>> > > "Role: " & Fields!Role.Value & vbcrlf
>> > > &
>> > > vbcrlf & "Other Resource(s) Name: " &
>> > > Fields!OtherResourceName.Value & vbcrlf & "Other
>> > > Resource
>> > > Role: " & Fields!OtherResourceRole.Value
>> > >
>> > > However, this does not work with SSRS. Is this something that will
>> > > be
>> > > allowed in SSRS 2008 or is it possible with 2005?
>> > > --
>> > > <moojjoo/>
>> >
>> >
>> >

Friday, March 23, 2012

Formatting RS to look like invoice

Friday, February 24, 2012

Format Expression

Generate sql

Blog Archive

About Me