Monday, March 26, 2012
PDF Export
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
Friday, March 9, 2012
Password Property in ConnectionManager
we're facing the same problem, but haven't found any helpful information about it.
This post doesn't really help with the issue not displaying pwds as plain text.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=887558&SiteID=1
Hope you guys can help.
F.|||I believe you need to implement a UITypeEditor (http://msdn2.microsoft.com/en-us/library/system.drawing.design.uitypeeditor(VS.71).aspx) to handle this type of functionality.
Password Property in ConnectionManager
we're facing the same problem, but haven't found any helpful information about it.
This post doesn't really help with the issue not displaying pwds as plain text.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=887558&SiteID=1
Hope you guys can help.
F.
|||I believe you need to implement a UITypeEditor (http://msdn2.microsoft.com/en-us/library/system.drawing.design.uitypeeditor(VS.71).aspx) to handle this type of functionality.
Saturday, February 25, 2012
passing the value of the Name property from a textbox to a parameter ?
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