PDF Textbox/Hyperlink Issue

Hello -
Long time listener, first time caller...
I'm having trouble with something that I haven't seen posted, and I'm
wondering if this is a known issue, or if not, if there is any
possible solution.
When I create a textbox and do not set the "Navigation/JumpToURL"
property, then run the report and export to PDF Format the textbox
renders correctly.
If I do set a value in the "Navigation/JumpToURL" and then render the
report to PDF, the textbox renders correctly but the hyperlink extends
well below the bottom of the text (almost as if a LF was inserted).
There seems to be no way to adjust this behavior.
It's worth mentioning that any other rendering format works properly -
but my users want the smooth, familiar PDF interface. The MHTML
format would work ok if IE didn't chop it up into multiple pages, and
Excel will do if there is no other way, but my first choice is PDF.
I have tried setting all the properties I can think of, including line
height, textbox height, font size, table spacing, etc. to no avail.
Any ideas?
Thanks,
~ScottI'm not seeing this. If you stick a border on the textbox, does the
hyperlink go beyond the border of the textbox?
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Scott" <petersonscott@.aasd.k12.wi.us> wrote in message
news:4955c3e2.0409251012.659cfe54@.posting.google.com...
> Hello -
> Long time listener, first time caller...
> I'm having trouble with something that I haven't seen posted, and I'm
> wondering if this is a known issue, or if not, if there is any
> possible solution.
> When I create a textbox and do not set the "Navigation/JumpToURL"
> property, then run the report and export to PDF Format the textbox
> renders correctly.
> If I do set a value in the "Navigation/JumpToURL" and then render the
> report to PDF, the textbox renders correctly but the hyperlink extends
> well below the bottom of the text (almost as if a LF was inserted).
> There seems to be no way to adjust this behavior.
> It's worth mentioning that any other rendering format works properly -
> but my users want the smooth, familiar PDF interface. The MHTML
> format would work ok if IE didn't chop it up into multiple pages, and
> Excel will do if there is no other way, but my first choice is PDF.
> I have tried setting all the properties I can think of, including line
> height, textbox height, font size, table spacing, etc. to no avail.
> Any ideas?
> Thanks,
> ~Scott|||Hi Brian -
Yes, actually, it does - not on the right or left, or even the top - it's
always on the bottom. This has caused a lot of confusion as users click on a
student name and are taken to a different student's record.
After reading your reply, I decided to go in and play around with things to
see if I could get it to display properly. What I eventually discovered is
that the padding of the textbox can be adjusted in such a way that makes it
appear nearly normal - previously, it had been set to 2,0,2,0 (left, right,
top, bottom, respectively), and the settings that made it work were 2,2,3,6.
Now, it doesn't overlap anymore, but it does increase the white space of the
report.
We're running Reporting Services SP1, using Adobe Reader 6.0.1, though all
versions of Adobe I've tried seem to display the same thing.
Does that help?
Thanks,
~Scott
"Brian Welcker [MSFT]" wrote:
> I'm not seeing this. If you stick a border on the textbox, does the
> hyperlink go beyond the border of the textbox?
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Scott" <petersonscott@.aasd.k12.wi.us> wrote in message
> news:4955c3e2.0409251012.659cfe54@.posting.google.com...
> > Hello -
> >
> > Long time listener, first time caller...
> >
> > I'm having trouble with something that I haven't seen posted, and I'm
> > wondering if this is a known issue, or if not, if there is any
> > possible solution.
> >
> > When I create a textbox and do not set the "Navigation/JumpToURL"
> > property, then run the report and export to PDF Format the textbox
> > renders correctly.
> >
> > If I do set a value in the "Navigation/JumpToURL" and then render the
> > report to PDF, the textbox renders correctly but the hyperlink extends
> > well below the bottom of the text (almost as if a LF was inserted).
> > There seems to be no way to adjust this behavior.
> >
> > It's worth mentioning that any other rendering format works properly -
> > but my users want the smooth, familiar PDF interface. The MHTML
> > format would work ok if IE didn't chop it up into multiple pages, and
> > Excel will do if there is no other way, but my first choice is PDF.
> >
> > I have tried setting all the properties I can think of, including line
> > height, textbox height, font size, table spacing, etc. to no avail.
> >
> > Any ideas?
> >
> > Thanks,
> >
> > ~Scott
>
>

PDF file is not in right format

HI,

When I preview the report it is in correct format but when I save it in PDF form it is not coming in the right format.

There is a textbox on 1st page.If the value of that textbox is large it prints the text on 2nd page and leaves a blank

space on 1st page.Why this is happening.Please Help me.

May

Try couple of things:

1) make your textbox multiline. There is property MultiLine so set that to true.

2) Check your report page margins. Keep it according to your page size.

Let me know if this helps

Lav

|||

I have set the page margin to 0.3 and also body size is 6.8in.Still it is shifting the whole text to next page.

Text is a big paragraph .I could not find the multiline property of textbox.

Thanks in Advance.

May

|||

What is your page size??

I assume 6.8in is your width.

For Multiline i meant Can grow property. Make sure its set to True.

|||also make sure your page size must be greater than your width + left margin + right margin|||

Page Size is 8.5in-11in.Can Grow property is True already.

Is there any property like Keep Together.Because it is trying to keep the whole text together thats why

it is shifting it onto the next page.I tried to put textbox in a rectangle..still not working.

May

|||

Is there anything else on that page? Explain me the layout of the page.

If possible add an image of report layout.

|||

I don't know how to add the image from here.Layout is like this:

CustomerName: !First(FieldCustname.value) DateEntered: Fielddate.value

Contact (subreport)

Reason: !First(FieldReason.value)

Action: !First(FieldAction.value)

Reason textbox is giving trouble.After printing the name,date n contact the rest of the page is blank.

reason text is on 2nd page.

|||

I have the same problem with a table which the report try to display on the next page when it fit, butKeepTogether is set toflase and there is noPageBreakBefore.

But it behave like if KeepTogether was set to True.

Any idea ?

PDF Export

Hi,
Currently the PDF Export Feature only exports the data that is shown in the
screen.
For Ex. I have a textbox and made its property "Can increase to accomdate
contents " to be false. When the report is renderd it shows 10 characters and
when exported to excel it shows all the 20 characters. but when exported to
PDF it shows only those 10 characters.
How can we make the PDF to show all the 20 characters
Thanks
EOn Jul 12, 2:02 pm, ERS Developer
<ERSDevelo...@.discussions.microsoft.com> wrote:
> Hi,
> Currently the PDF Export Feature only exports the data that is shown in the
> screen.
> For Ex. I have a textbox and made its property "Can increase to accomdate
> contents " to be false. When the report is renderd it shows 10 characters and
> when exported to excel it shows all the 20 characters. but when exported to
> PDF it shows only those 10 characters.
> How can we make the PDF to show all the 20 characters
> Thanks
Are you sure that the remaining 10 characters are not wrapping onto
another page? If they are, you can put the textbox control into a
rectangle control. If this doesn't help, you can either try setting
Increase to accommodate contents to true -or- I would suggest checking
for product updates for Adobe Reader and if you are using SQL Server
2005, make sure that you have SP2 installed as well. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant

passing the value of the Name property from a textbox to a parameter ?

Hi All,
I'd like to pass the name or label of a textbox to a parameter but I
am not sure of how to get it done.
I have a table (the PK is on Language and Field)
Language(PK)
Field (PK)
FieldName
and a data set query:
"SELECT * from table
WHERE Language = @.Language AND Field = @.Field"
The parameter @.LanguageCode is based on user input and I want the
parameter @.Field to be based on the Name of a textbox (or eq. object
in the report)
(@.Field=Fields!Field.Name, "table")
The Value of the textbox should be set to the appropriate fieldname
based on the users choice of language and the identifier of the
textbox...
...something like:
=IIF(Parameters!Language.Value = 1, Fields!FieldName.Value, "table",
IIF(Parameters!Language.Value = 2, Fields!FieldName.Value, "table",
'Not Translated!'))
Anyone got any ideas?
Thanks a million in advance!
Regards NickWell...
I dynamically transposed the data in the table in order to use the
First() function in RS, problem solved.
Still I wonder how do you use labels and such from the report to
filter data in the data set?
/n|||You'd have to use parameters or fields from a dataset. Report items cannot
be used in filter expressions.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Niklas W" <niklas.westerholm@.intellibis.se> wrote in message
news:655bff8b.0408130442.754cd47f@.posting.google.com...
> Well...
> I dynamically transposed the data in the table in order to use the
> First() function in RS, problem solved.
> Still I wonder how do you use labels and such from the report to
> filter data in the data set?
> /n