Hi,
I have 5 report parameters to show in a report. I want to properly align the
controls(list boxes, text boxes) of parameters. How do we format the report
parameters in SQL Server 2005 Reporting Services using Report Designer tool?
Thanks in advance!
Regards,
VenkatOn Nov 6, 7:14 am, "Venky Dosap" <ven...@.translogicsys.com> wrote:
> Hi,
> I have 5 report parameters to show in a report. I want to properly align the
> controls(list boxes, text boxes) of parameters. How do we format the report
> parameters in SQL Server 2005 Reporting Services using Report Designer tool?
> Thanks in advance!
> Regards,
> Venkat
As far as I know, the best control you can get over this is to order
them differently in the Report Parameters' list (via Layout view >>
Report drop-down list >> Report Parameters...) by selecting the up/
down arrows on the left. Unfortunately, there is not much more in the
way of layout customization available. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant
Showing posts with label boxes. Show all posts
Showing posts with label boxes. Show all posts
Friday, March 23, 2012
Monday, March 19, 2012
Formatting cents
I am using RS 2000 and I am trying to format a total amount. I want the
total amount to be separted into two separate text boxes, one with dollars
and one with cents. I am able to get the dollars portion but unable to get
the cents portion.
For example: If I have 123.05 I want 123 in box A and 05 in box B. The
problem I have is that instead of 05 I get 5.
This is the expression I am currently using and not getting what I want :
= Round(((SUM(Fields!Amount.Value) - FLOOR(SUM(Fields!Amount.Value)))*100),0).
Any help would be greatly appreciated.
Scott BennettsTry this way
= (Fields!Amount.Value) - INT(Fields!Amount.Value)
Amarnath
"Scott" wrote:
> I am using RS 2000 and I am trying to format a total amount. I want the
> total amount to be separted into two separate text boxes, one with dollars
> and one with cents. I am able to get the dollars portion but unable to get
> the cents portion.
> For example: If I have 123.05 I want 123 in box A and 05 in box B. The
> problem I have is that instead of 05 I get 5.
> This is the expression I am currently using and not getting what I want :
> = Round(((SUM(Fields!Amount.Value) - FLOOR(SUM(Fields!Amount.Value)))*100),0).
> Any help would be greatly appreciated.
> Scott Bennetts
total amount to be separted into two separate text boxes, one with dollars
and one with cents. I am able to get the dollars portion but unable to get
the cents portion.
For example: If I have 123.05 I want 123 in box A and 05 in box B. The
problem I have is that instead of 05 I get 5.
This is the expression I am currently using and not getting what I want :
= Round(((SUM(Fields!Amount.Value) - FLOOR(SUM(Fields!Amount.Value)))*100),0).
Any help would be greatly appreciated.
Scott BennettsTry this way
= (Fields!Amount.Value) - INT(Fields!Amount.Value)
Amarnath
"Scott" wrote:
> I am using RS 2000 and I am trying to format a total amount. I want the
> total amount to be separted into two separate text boxes, one with dollars
> and one with cents. I am able to get the dollars portion but unable to get
> the cents portion.
> For example: If I have 123.05 I want 123 in box A and 05 in box B. The
> problem I have is that instead of 05 I get 5.
> This is the expression I am currently using and not getting what I want :
> = Round(((SUM(Fields!Amount.Value) - FLOOR(SUM(Fields!Amount.Value)))*100),0).
> Any help would be greatly appreciated.
> Scott Bennetts
Monday, March 12, 2012
Formating Reports To Print
How can I fixa report that displays correctly on the web page (Report
manager) but when I either print or convert to .pdf, some of the text boxes
shifts to a second and maybe a third ?
The report is actualy smaller than a regular letter page.
Any ideas ?You will have to build the report to render as a pdf. In doing so the
web formatting may look out of allignment but the pdf file will look
right. It is very difficult to get them both to look good.
Also, sometimes placing rectangles behind your report items will
prevent them from going outside the report boundries.
Another thing to check is to make sure the "report" page size and
"body" size properties are matching or similar (ie. set the report page
size to 11 x 8.5 for a Landscape print and set the body size to 10.75 x
8 to fit within the page boundries) and only work with in these
boundries. Take some time to try out different margin settings as
well. Work with it a little and usually you can come up with something
that works in the web and pdf worlds.
Let me know how it goes!
manager) but when I either print or convert to .pdf, some of the text boxes
shifts to a second and maybe a third ?
The report is actualy smaller than a regular letter page.
Any ideas ?You will have to build the report to render as a pdf. In doing so the
web formatting may look out of allignment but the pdf file will look
right. It is very difficult to get them both to look good.
Also, sometimes placing rectangles behind your report items will
prevent them from going outside the report boundries.
Another thing to check is to make sure the "report" page size and
"body" size properties are matching or similar (ie. set the report page
size to 11 x 8.5 for a Landscape print and set the body size to 10.75 x
8 to fit within the page boundries) and only work with in these
boundries. Take some time to try out different margin settings as
well. Work with it a little and usually you can come up with something
that works in the web and pdf worlds.
Let me know how it goes!
Subscribe to:
Posts (Atom)