Wednesday, March 28, 2012
Is it possible to make a report to fit in 1 page?
Is is possible, when exporting to PDF, to make the report to fit in 1 page?
Thanks
Jaimeset the Report PageSize same as your template PageSize.
This should solve the problem.
"Jaime Stuardo" wrote:
> Hi all..
> Is is possible, when exporting to PDF, to make the report to fit in 1 page?
> Thanks
> Jaime|||In report properties, I set 11 in height.
When you talk about template page size, you mean:
header height + body height + footer height?
If that is the case, that sum results 8,73229 in. Do I need to increase body
size so that that sum equal 11 in?
Jaime
"Hari" wrote:
> set the Report PageSize same as your template PageSize.
> This should solve the problem.
> "Jaime Stuardo" wrote:
> > Hi all..
> >
> > Is is possible, when exporting to PDF, to make the report to fit in 1 page?
> >
> > Thanks
> > Jaime|||In Report Designer, make sure to use the following:
(Report.PageWidth - Report.LeftMargin - Report.RightMargin) >= Body.Width.
Thanks!
"Jaime Stuardo" wrote:
> In report properties, I set 11 in height.
> When you talk about template page size, you mean:
> header height + body height + footer height?
> If that is the case, that sum results 8,73229 in. Do I need to increase body
> size so that that sum equal 11 in?
> Jaime
> "Hari" wrote:
> > set the Report PageSize same as your template PageSize.
> >
> > This should solve the problem.
> >
> > "Jaime Stuardo" wrote:
> >
> > > Hi all..
> > >
> > > Is is possible, when exporting to PDF, to make the report to fit in 1 page?
> > >
> > > Thanks
> > > Jaimesql
Monday, March 12, 2012
Is it possible not to keep together textfields?
Hi,
This all appears when exporting a report to PDF:
I've a report with a label and textfield in the upper third, below the textfield there are some other controls. My problem is, that all works fine as long as the text for the textfield is short enough to fit the page. If the text gets to long I get a nearly blank page with only the label on it and the textfield on the next page. I found no property to change this behaviour. I want my textfield to split up to multiple pages, just as Access does it!
I want to see the first part of the content on the first page and then page footer, page header and then the second part on the next page.
I tried a list-control and a table-control with a rect in it -> same problem.
I found a very ....uncommon... way to do it, I made a subreport with just a textfield on it which has the value "Parameters!Text" (add the report parameter "Text") and put this subreport into my report and passing the long text as a parameter to the subreport ;)
But I think that's not exactly brilliant..
Any other hints?
Benni
|||Okay,
very similar problem, if I have a report header(rectangle with some labels in it) with a list below it. As long as the record in the list contains few data all looks fine. If the content reaches a specific length the whole record is keept together on the next page (there is no report header, so a bit more space). If the content gets even larger its okay again (some parts on the first page, the rest on the next page)!
I've NOT set KeepTogether vor any control. I also tried the subreport trick, but it doesn't work ;(
Why does Microsoft add so many rarely needed extra features (e.g. multiple datasets side by side) and loose sight of the basic features? If I don't get this running I'll have to choose a different product, because no user wants to have this strange reports.. Even Access 2000 (I've no older version available) has better keeptogether options ;(
|||Benni,
Did really the textfield "nokeeptogether" work using a subreport?
It doesn't work for me, perhaps your text was more than one page long? Did you do any other settings to make it work?
/Dan
|||The official MS workaround is to make a few Textfields under each other and split the text right into them. We've made a service request at microsoft and they told us, that they could rise a DCR (Design Change Request). We'll see if they fix it..Is it possible not to keep together textfields?
Hi,
This all appears when exporting a report to PDF:
I've a report with a label and textfield in the upper third, below the textfield there are some other controls. My problem is, that all works fine as long as the text for the textfield is short enough to fit the page. If the text gets to long I get a nearly blank page with only the label on it and the textfield on the next page. I found no property to change this behaviour. I want my textfield to split up to multiple pages, just as Access does it!
I want to see the first part of the content on the first page and then page footer, page header and then the second part on the next page.
I tried a list-control and a table-control with a rect in it -> same problem.
I found a very ....uncommon... way to do it, I made a subreport with just a textfield on it which has the value "Parameters!Text" (add the report parameter "Text") and put this subreport into my report and passing the long text as a parameter to the subreport ;)
But I think that's not exactly brilliant..
Any other hints?
Benni
|||Okay,
very similar problem, if I have a report header(rectangle with some labels in it) with a list below it. As long as the record in the list contains few data all looks fine. If the content reaches a specific length the whole record is keept together on the next page (there is no report header, so a bit more space). If the content gets even larger its okay again (some parts on the first page, the rest on the next page)!
I've NOT set KeepTogether vor any control. I also tried the subreport trick, but it doesn't work ;(
Why does Microsoft add so many rarely needed extra features (e.g. multiple datasets side by side) and loose sight of the basic features? If I don't get this running I'll have to choose a different product, because no user wants to have this strange reports.. Even Access 2000 (I've no older version available) has better keeptogether options ;(
|||Benni,
Did really the textfield "nokeeptogether" work using a subreport?
It doesn't work for me, perhaps your text was more than one page long? Did you do any other settings to make it work?
/Dan
|||The official MS workaround is to make a few Textfields under each other and split the text right into them. We've made a service request at microsoft and they told us, that they could rise a DCR (Design Change Request). We'll see if they fix it..