Thanks in advance and Im new to RS.
I have a simple dataset of date records which can span 1 or more weeks up to
a month, I want to break the list up every time a Wed is encountered as this
is the end of a reporting week and some totals need to be printed at bottom
of the list.
I have been fiddling with a table, but dont seem to be quite able to nut it
out, has anyone else done this or similar at all, comments appreciated.
Thanks, Paul
DataSet...
Tue 2/11 $77 $99 $765
wed 3/11 $50 $450 $999
<Need a break here and total of each column)
Thu 4/11 $23 $888 $987
Fri 5/11 $98 $999 $999
Sat 6/11 $33 $ 99 $999
Sun 7/11 $999 $ 99 $999
Mon 8/11 $999 $ 99 $999
Tue 9/11 $999 $ 99 $999
Wed 10/11 $999 $ 99 $999
<Break here and total>
Thu
etc etc etcPlease ignore this, figured it out in the end. Just needed a grouping value uin
my sql and voila table grouped ok as desired.
"PaulQld" wrote:
> Thanks in advance and Im new to RS.
> I have a simple dataset of date records which can span 1 or more weeks up to
> a month, I want to break the list up every time a Wed is encountered as this
> is the end of a reporting week and some totals need to be printed at bottom
> of the list.
> I have been fiddling with a table, but dont seem to be quite able to nut it
> out, has anyone else done this or similar at all, comments appreciated.
> Thanks, Paul
> DataSet...
> Tue 2/11 $77 $99 $765
> wed 3/11 $50 $450 $999
> <Need a break here and total of each column)
> Thu 4/11 $23 $888 $987
> Fri 5/11 $98 $999 $999
> Sat 6/11 $33 $ 99 $999
> Sun 7/11 $999 $ 99 $999
> Mon 8/11 $999 $ 99 $999
> Tue 9/11 $999 $ 99 $999
> Wed 10/11 $999 $ 99 $999
> <Break here and total>
> Thu
> etc etc etc
>
Showing posts with label group. Show all posts
Showing posts with label group. Show all posts
Thursday, February 16, 2012
breakpage in details
Hi,
I have a table with a header, footer and details. I add in my table a group
with a header and footer but without details. So the probleme i have is that
the last row of my table's detail is show on new page.
Anybody can help me to resolve that.
Thank's.
Ã?ricdid you find a solution to this. I have the same problem.
"show the last row of details on new page" wrote:
> Hi,
> I have a table with a header, footer and details. I add in my table a group
> with a header and footer but without details. So the probleme i have is that
> the last row of my table's detail is show on new page.
> Anybody can help me to resolve that.
> Thank's.
> Ã?ric
I have a table with a header, footer and details. I add in my table a group
with a header and footer but without details. So the probleme i have is that
the last row of my table's detail is show on new page.
Anybody can help me to resolve that.
Thank's.
Ã?ricdid you find a solution to this. I have the same problem.
"show the last row of details on new page" wrote:
> Hi,
> I have a table with a header, footer and details. I add in my table a group
> with a header and footer but without details. So the probleme i have is that
> the last row of my table's detail is show on new page.
> Anybody can help me to resolve that.
> Thank's.
> Ã?ric
Friday, February 10, 2012
Border around group of textboxes
Hi- I'm trying to enclose a group of textboxes by a border, essentially a VB
groupbox or panel. I've tried using both a rectangle and text box object with
a border to accomplish this. When you preview it looks right; however, when
the report is rendered, the html generates a separate table with a border
then all the textboxes below it. How can I get the html to render properly?
ThanksHTML does not support overlapping reportitems, they will get pushed around.
It sounds like you don't want overlapping reportitems, but you want the
textboxes being contained inside the rectangle.
You can achieve this by using drag-and-drop in report designer to drop the
textboxes into the rectangle - rather than having them overlapping. If a
textbox is contained inside a rectangle and you try to move the textbox with
the mouse, you will notice that the rectangle determines the boundaries for
moving the textbox (unless you move the textbox completely out of the
rectangle).
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Tony Ballman" <TonyBallman@.discussions.microsoft.com> wrote in message
news:59DF8C12-2087-4BF1-9579-C44F6DAE738D@.microsoft.com...
> Hi- I'm trying to enclose a group of textboxes by a border, essentially a
VB
> groupbox or panel. I've tried using both a rectangle and text box object
with
> a border to accomplish this. When you preview it looks right; however,
when
> the report is rendered, the html generates a separate table with a border
> then all the textboxes below it. How can I get the html to render
properly?
> Thanks
>|||Thanks that worked. Now I see I made the mistake of placing a new rectangle
over-top the txtboxes I wanted enclosed, so the textboxes arenâ't referencing
the new parent rectangle.
"Robert Bruckner [MSFT]" wrote:
> HTML does not support overlapping reportitems, they will get pushed around.
> It sounds like you don't want overlapping reportitems, but you want the
> textboxes being contained inside the rectangle.
> You can achieve this by using drag-and-drop in report designer to drop the
> textboxes into the rectangle - rather than having them overlapping. If a
> textbox is contained inside a rectangle and you try to move the textbox with
> the mouse, you will notice that the rectangle determines the boundaries for
> moving the textbox (unless you move the textbox completely out of the
> rectangle).
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Tony Ballman" <TonyBallman@.discussions.microsoft.com> wrote in message
> news:59DF8C12-2087-4BF1-9579-C44F6DAE738D@.microsoft.com...
> > Hi- I'm trying to enclose a group of textboxes by a border, essentially a
> VB
> > groupbox or panel. I've tried using both a rectangle and text box object
> with
> > a border to accomplish this. When you preview it looks right; however,
> when
> > the report is rendered, the html generates a separate table with a border
> > then all the textboxes below it. How can I get the html to render
> properly?
> > Thanks
> >
>
>
groupbox or panel. I've tried using both a rectangle and text box object with
a border to accomplish this. When you preview it looks right; however, when
the report is rendered, the html generates a separate table with a border
then all the textboxes below it. How can I get the html to render properly?
ThanksHTML does not support overlapping reportitems, they will get pushed around.
It sounds like you don't want overlapping reportitems, but you want the
textboxes being contained inside the rectangle.
You can achieve this by using drag-and-drop in report designer to drop the
textboxes into the rectangle - rather than having them overlapping. If a
textbox is contained inside a rectangle and you try to move the textbox with
the mouse, you will notice that the rectangle determines the boundaries for
moving the textbox (unless you move the textbox completely out of the
rectangle).
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Tony Ballman" <TonyBallman@.discussions.microsoft.com> wrote in message
news:59DF8C12-2087-4BF1-9579-C44F6DAE738D@.microsoft.com...
> Hi- I'm trying to enclose a group of textboxes by a border, essentially a
VB
> groupbox or panel. I've tried using both a rectangle and text box object
with
> a border to accomplish this. When you preview it looks right; however,
when
> the report is rendered, the html generates a separate table with a border
> then all the textboxes below it. How can I get the html to render
properly?
> Thanks
>|||Thanks that worked. Now I see I made the mistake of placing a new rectangle
over-top the txtboxes I wanted enclosed, so the textboxes arenâ't referencing
the new parent rectangle.
"Robert Bruckner [MSFT]" wrote:
> HTML does not support overlapping reportitems, they will get pushed around.
> It sounds like you don't want overlapping reportitems, but you want the
> textboxes being contained inside the rectangle.
> You can achieve this by using drag-and-drop in report designer to drop the
> textboxes into the rectangle - rather than having them overlapping. If a
> textbox is contained inside a rectangle and you try to move the textbox with
> the mouse, you will notice that the rectangle determines the boundaries for
> moving the textbox (unless you move the textbox completely out of the
> rectangle).
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Tony Ballman" <TonyBallman@.discussions.microsoft.com> wrote in message
> news:59DF8C12-2087-4BF1-9579-C44F6DAE738D@.microsoft.com...
> > Hi- I'm trying to enclose a group of textboxes by a border, essentially a
> VB
> > groupbox or panel. I've tried using both a rectangle and text box object
> with
> > a border to accomplish this. When you preview it looks right; however,
> when
> > the report is rendered, the html generates a separate table with a border
> > then all the textboxes below it. How can I get the html to render
> properly?
> > Thanks
> >
>
>
Subscribe to:
Posts (Atom)