Showing posts with label details. Show all posts
Showing posts with label details. Show all posts

Friday, March 9, 2012

Keeping Sections together

I have a problem with the details of the report for a record going to the second page. I have set the format option in the report "Keep sections together". But still the data for the report goes to the second page.

What else has to be done for the report to be proper? Please let me know on this.
I have tried out the option of setting it through the code as well by the code

"CR1.sectionformat(0) = "DETAIL;X;X;X;T;X;X;X"Hi
what is the size of the record? If it is of large size having many characters you may face this problem

Madhivanan|||It is a Group by report and i want the records for the particular group to be on the same page and it should not go to the next page. what are the other possibilities which i can try out. I am using CR 4.6

Help|||in the grey area of your group right click - select "change group" and check the "keep group together" option

Wednesday, March 7, 2012

Keeping details together in pdf

My reports will keep data regions together with no problems in web reports
but once I export them to pdf I frequently get data split in silly places. Is
there a way to keep the data together in pdf without having to break after
every item?Can you define ‘Silly' places.. ?
nntp://news.microsoft.com/microsoft.public.sqlserver.reportingsvcs/<64A271C0-B0AD-4B87-8AAD-4403A7A33BD4@.microsoft.com>
My reports will keep data regions together with no problems in web reports
but once I export them to pdf I frequently get data split in silly places. Is
there a way to keep the data together in pdf without having to break after
every item?
[microsoft.public.sqlserver.reportingsvcs]|||I know exactly what your talking about. However Adobe over rides the page
breaking.
-rwiethorn
nospamsme-rwiethorn2002@.yahoo.com
"DTimmins" wrote:
> My reports will keep data regions together with no problems in web reports
> but once I export them to pdf I frequently get data split in silly places. Is
> there a way to keep the data together in pdf without having to break after
> every item?|||I have exactly the same problems The web report looks o.k. but when I export
to PDF page breaks are inserted in very unreasonable places. Some pages are
more than 50% empty! I tried everything (sub reports instead of grouping,
rectangles, keeping data fields close together) but PDF simply ignores that.
Klaus
"DTimmins" wrote:
> My reports will keep data regions together with no problems in web reports
> but once I export them to pdf I frequently get data split in silly places. Is
> there a way to keep the data together in pdf without having to break after
> every item?|||I am having this exact problem too. Has anyone solved it yet?
"DTimmins" wrote:
> My reports will keep data regions together with no problems in web reports
> but once I export them to pdf I frequently get data split in silly places. Is
> there a way to keep the data together in pdf without having to break after
> every item?|||I am having this same problem? Can anyone tell us how to fix it?
"DTimmins" wrote:
> My reports will keep data regions together with no problems in web reports
> but once I export them to pdf I frequently get data split in silly places. Is
> there a way to keep the data together in pdf without having to break after
> every item?

Friday, February 24, 2012

Keep group together

Is there any way to keep a group header and detail rows together so I don't get the header on the bottom of a page and the details orphaned at the top of the next page?

Table Keep Together property only works at the table level (though not sure how that works anyway). And I don't want a page break before each group.

Thanks in advance.

The only solution to this problem as of now is to repeat the group headers on new page.

Shyam

|||Any idea if this is going to be addressed in a future version?|||

Probably yes, but not sure.

Shyam

Monday, February 20, 2012

Keep Details belonging to a Group together on a page

Hi,
this is my problem:
I have a Table defined in some report (Reporting Services); the Table has a
grouping, and each Group has one or more detail rows. So far so good.
When details belonging to some group do not fit on the current page, they
move to the next page - and this is my problem. I would like to have a
"KeepTogether" property on the the Group level, but unfortunately, this
doesn't seem to exist; I can only say "KeepTogether" on the Table level,
which is of no use for the Group.
Does anyone have an idea how some Group can be kept together with the detail
rows belonging to it on one page, such that in cases where at least one of
the details would move to the next page, the whole Group would move, instead?
Thanks for any hint, Axel Hecker.
--
Axel HeckerOn Feb 28, 7:55 am, AxelHecker <AxelHec...@.discussions.microsoft.com>
wrote:
> Hi,
> this is my problem:
> I have a Table defined in some report (Reporting Services); the Table has a
> grouping, and each Group has one or more detail rows. So far so good.
> When details belonging to some group do not fit on the current page, they
> move to the next page - and this is my problem. I would like to have a
> "KeepTogether" property on the the Group level, but unfortunately, this
> doesn't seem to exist; I can only say "KeepTogether" on the Table level,
> which is of no use for the Group.
> Does anyone have an idea how some Group can be kept together with the detail
> rows belonging to it on one page, such that in cases where at least one of
> the details would move to the next page, the whole Group would move, instead?
> Thanks for any hint, Axel Hecker.
> --
> Axel Hecker
You might be able to accomplish this by putting the table in a list.
Otherwise, it might be quite difficult to accomplish this.
Regards,
Enrique Martinez
Sr. SQL Server Developer|||Enrique, thanks very much for your comment.
But I cannot really follow you: when I put the table into a list, anything I
define for the list might have effects on the table level, but not on the
group level, because, as far as I know, the list would not "see" the groups
anyway. Or is my thinking wrong somehow?
--
Axel Hecker
"EMartinez" wrote:
> On Feb 28, 7:55 am, AxelHecker <AxelHec...@.discussions.microsoft.com>
> wrote:
> > Hi,
> >
> > this is my problem:
> >
> > I have a Table defined in some report (Reporting Services); the Table has a
> > grouping, and each Group has one or more detail rows. So far so good.
> >
> > When details belonging to some group do not fit on the current page, they
> > move to the next page - and this is my problem. I would like to have a
> > "KeepTogether" property on the the Group level, but unfortunately, this
> > doesn't seem to exist; I can only say "KeepTogether" on the Table level,
> > which is of no use for the Group.
> >
> > Does anyone have an idea how some Group can be kept together with the detail
> > rows belonging to it on one page, such that in cases where at least one of
> > the details would move to the next page, the whole Group would move, instead?
> >
> > Thanks for any hint, Axel Hecker.
> >
> > --
> > Axel Hecker
> You might be able to accomplish this by putting the table in a list.
> Otherwise, it might be quite difficult to accomplish this.
> Regards,
> Enrique Martinez
> Sr. SQL Server Developer
>|||On Mar 1, 2:52 am, AxelHecker <AxelHec...@.discussions.microsoft.com>
wrote:
> Enrique, thanks very much for your comment.
> But I cannot really follow you: when I put the table into a list, anything I
> define for the list might have effects on the table level, but not on the
> group level, because, as far as I know, the list would not "see" the groups
> anyway. Or is my thinking wrong somehow?
> --
> Axel Hecker
> "EMartinez" wrote:
> > On Feb 28, 7:55 am, AxelHecker <AxelHec...@.discussions.microsoft.com>
> > wrote:
> > > Hi,
> > > this is my problem:
> > > I have a Table defined in some report (Reporting Services); the Table has a
> > > grouping, and each Group has one or more detail rows. So far so good.
> > > When details belonging to some group do not fit on the current page, they
> > > move to the next page - and this is my problem. I would like to have a
> > > "KeepTogether" property on the the Group level, but unfortunately, this
> > > doesn't seem to exist; I can only say "KeepTogether" on the Table level,
> > > which is of no use for the Group.
> > > Does anyone have an idea how some Group can be kept together with the detail
> > > rows belonging to it on one page, such that in cases where at least one of
> > > the details would move to the next page, the whole Group would move, instead?
> > > Thanks for any hint, Axel Hecker.
> > > --
> > > Axel Hecker
> > You might be able to accomplish this by putting the table in a list.
> > Otherwise, it might be quite difficult to accomplish this.
> > Regards,
> > Enrique Martinez
> > Sr. SQL Server Developer
Theoretically that is correct; however, sometimes in RS the list helps
restrict the table groups (atleast in some cases). The only other
suggestion I would have is to select the page break after group
functionality, which may not give the exact results you are looking
for, but may be the only other option. Ofcourse, adding an extra
column to the report query and specifying grouping on that might be
another way to go to control your format; but is not a guarantee.
Regards,
Enrique Martinez
Sr. SQL Server Developer