Alan, not sure if it matters, but I usually do the
ADIS/LDAP calls more like this format... Check the
Linked Server also, for correct setup and security. Bruce
SELECT * FROM OPENQUERY( ADSI,'<LDAP://mydomain>;
((objectClass=User));distinguishedname,h
omePhone')
where distinguishedname like '%a%'
>--Original Message--
>I am trying to query our active directory for user
information, but even
>though I get the query to work I am getting no data
back. I have a linked
>server to the active directory from SQL Server 2000 and
I am running the
>query in the Query Analyzer.
>My query is as follows:
>select * from openquery(adsi, 'select name, homephone
from
>''ldap://DC=mydomain,DC=com'' where objectclass
= ''User'' ')
>This query will complete without error, but no data is
returned. I have
>seen one other question of this nature here, but I saw
no final resolution.
>What is wrong?
>Alan
>--
>Message posted via http://www.droptable.com
>.
>Bruce,
thanks for the response, but I tried what you suggested and still the query
returned no data. It completed without error just no data.
Thanks,
Alan
Message posted via http://www.droptable.com|||Alan, not sure why youre getting no data back then.
You're sure of the domain name? there's no special
security on your AD to prevent you from accessing? The
linked sever is setup correctly? like so..'
sp_addlinkedserver 'ADSI', 'Active Directory Service
Interfaces', 'ADSDSOObject', 'adsdatasource'
go
Are you sure the data sits in the User ObjectClass?
Might be somewhere else, check it.
There was a max 1000 row limit by default and we had to
have that kicked up to get more then 1000 rows returned.
These links talk about that...
http://support.novell.com/cgi-
bin/search/searchtid.cgi?/10081596.htm
http://www.ldapadministrator.com/fo...wtopic.php?t=14
>--Original Message--
>Bruce,
>thanks for the response, but I tried what you suggested
and still the query
>returned no data. It completed without error just no
data.
>Thanks,
>Alan
>--
>Message posted via http://www.droptable.com
>.
>|||Bruce,
I ran an export of the data in the user objects using ldifde and got back
exactly what I expected, but the same query in SQL Server Query Analyzer
comes back empty.
I guess it could be something with the link, but it was set up according to
the instructions I found on the web. The link was created in Enterprise
manager, but using the same settings that you specified in the
sp_addlinkedserver statement. It could also be a user security issue, but
I have tried logining in as the admin, SQL Sever admin and myself with no
data back.
Still playing around with it.
Alan
Message posted via http://www.droptable.com|||Finally, thanks Bruce. I was reading your posting and I was finally able to
pull data.
I'm trying to pull just users that are a member of a certain group, how can
I do that?
This is what I have but not working; however, I was able to used your query
just to get a start and that was a big help.
SELECT *
FROM OPENQUERY( ADSI,
'SELECT cn
FROM ''LDAP://internal/OU=Account
Executives,DC=internal,DC=homequest,DC=c
om''
WHERE objectClass = ''users''')
GO
"Bruce de Freitas" wrote:
> Alan, not sure if it matters, but I usually do the
> ADIS/LDAP calls more like this format... Check the
> Linked Server also, for correct setup and security. Bruce
>
> SELECT * FROM OPENQUERY( ADSI,'<LDAP://mydomain>;
> ((objectClass=User));distinguishedname,h
omePhone')
> where distinguishedname like '%a%'
>
>
> information, but even
> back. I have a linked
> I am running the
> from
> = ''User'' ')
> returned. I have
> no final resolution.
>|||Sonya, this query would list all the GROUPs.
SELECT * FROM OPENQUERY( adsi,'<ldap://mydomain>;
(&(objectCategory=GROUP)); distinguishedname,CN')
You'd then have to join all the Users to what groups they are in, if
that is what youre trying to do... Bruce
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!|||Thank you, after playing with it for awhile I was able to get it to work.
Do you know if there is a way to extract users' contact folder from the
server-level?
"Bruce de Freitas" wrote:
> Sonya, this query would list all the GROUPs.
> SELECT * FROM OPENQUERY( adsi,'<ldap://mydomain>;
> (&(objectCategory=GROUP)); distinguishedname,CN')
>
> You'd then have to join all the Users to what groups they are in, if
> that is what youre trying to do... Bruce
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!
>
Showing posts with label format. Show all posts
Showing posts with label format. Show all posts
Monday, March 26, 2012
Wednesday, March 7, 2012
newline in pdf lost
I'd like to format a textfield with newline. In Preview everything looks ok. After exporting to pdf all newlines are gone. I use the following text inside the textbox:
+++
=controlchars.Newline &
controlchars.Newline &
controlchars.Newline &
controlchars.Newline &
First(Fields!NameKunde.Value, "Absender") & vbnewline &
First(Fields!Ort.Value, "Absender") & vbnewline &
First(Fields!BenutzerAnmeldename.Value, "Absender") & vbnewline &
First(Fields!Vorname.Value, "Absender") & " " & First(Fields!Name.Value, "Absender") & vbnewline &
today
+++
As you see, I tried controlchars.Newline, vbnewline. No differenc in pdf.
Thanks for help
NickiThis looks like a bug. As a workaround you could handle the formatting
using a rectangle that contains a series of textboxes. The sample report at
the end of this posting demonstrates how to accomplish this.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Nicki" <Nicki@.discussions.microsoft.com> wrote in message
news:4AF42D93-C526-4235-80A7-DF83133A1A48@.microsoft.com...
> I'd like to format a textfield with newline. In Preview everything looks
ok. After exporting to pdf all newlines are gone. I use the following text
inside the textbox:
> +++
> =controlchars.Newline &
> controlchars.Newline &
> controlchars.Newline &
> controlchars.Newline &
> First(Fields!NameKunde.Value, "Absender") & vbnewline &
> First(Fields!Ort.Value, "Absender") & vbnewline &
> First(Fields!BenutzerAnmeldename.Value, "Absender") & vbnewline &
> First(Fields!Vorname.Value, "Absender") & " " & First(Fields!Name.Value,
"Absender") & vbnewline &
> today
> +++
> As you see, I tried controlchars.Newline, vbnewline. No differenc in pdf.
> Thanks for help
> Nicki
>
RectangleTextboxSampleReport.rdl
----
<?xml version="1.0" encoding="utf-8"?>
<Report
xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefini
tion"
xmlns:rd="">http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<RightMargin>1in</RightMargin>
<Body>
<ReportItems>
<Rectangle Name="rectangle1">
<ReportItems>
<Textbox Name="textbox4">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>3</ZIndex>
<Top>1.625in</Top>
<rd:DefaultName>textbox4</rd:DefaultName>
<Height>0.25in</Height>
<Width>1.875in</Width>
<CanGrow>true</CanGrow>
<Value>=today</Value>
<Left>0.125in</Left>
</Textbox>
<Textbox Name="textbox3">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>2</ZIndex>
<Top>1.125in</Top>
<rd:DefaultName>textbox3</rd:DefaultName>
<Height>0.25in</Height>
<Width>1.875in</Width>
<CanGrow>true</CanGrow>
<Value>Last line of text</Value>
<Left>0.125in</Left>
</Textbox>
<Textbox Name="textbox2">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>1</ZIndex>
<Top>0.625in</Top>
<rd:DefaultName>textbox2</rd:DefaultName>
<Height>0.25in</Height>
<Width>1.875in</Width>
<CanGrow>true</CanGrow>
<Value>Second line of text</Value>
<Left>0.125in</Left>
</Textbox>
<Textbox Name="textbox1">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<Top>0.375in</Top>
<rd:DefaultName>textbox1</rd:DefaultName>
<Height>0.25in</Height>
<Width>1.875in</Width>
<CanGrow>true</CanGrow>
<Value>First line of text</Value>
<Left>0.125in</Left>
</Textbox>
</ReportItems>
<Width>2.25in</Width>
<Style>
<BorderWidth>
<Default>1.5pt</Default>
</BorderWidth>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Rectangle>
</ReportItems>
<Style />
<Height>2in</Height>
</Body>
<TopMargin>1in</TopMargin>
<Width>6.5in</Width>
<LeftMargin>1in</LeftMargin>
<rd:SnapToGrid>true</rd:SnapToGrid>
<rd:DrawGrid>true</rd:DrawGrid>
<rd:ReportID>b77866c3-877c-45bc-a5dc-88760f336daf</rd:ReportID>
<BottomMargin>1in</BottomMargin>
<Language>en-US</Language>
</Report>
+++
=controlchars.Newline &
controlchars.Newline &
controlchars.Newline &
controlchars.Newline &
First(Fields!NameKunde.Value, "Absender") & vbnewline &
First(Fields!Ort.Value, "Absender") & vbnewline &
First(Fields!BenutzerAnmeldename.Value, "Absender") & vbnewline &
First(Fields!Vorname.Value, "Absender") & " " & First(Fields!Name.Value, "Absender") & vbnewline &
today
+++
As you see, I tried controlchars.Newline, vbnewline. No differenc in pdf.
Thanks for help
NickiThis looks like a bug. As a workaround you could handle the formatting
using a rectangle that contains a series of textboxes. The sample report at
the end of this posting demonstrates how to accomplish this.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Nicki" <Nicki@.discussions.microsoft.com> wrote in message
news:4AF42D93-C526-4235-80A7-DF83133A1A48@.microsoft.com...
> I'd like to format a textfield with newline. In Preview everything looks
ok. After exporting to pdf all newlines are gone. I use the following text
inside the textbox:
> +++
> =controlchars.Newline &
> controlchars.Newline &
> controlchars.Newline &
> controlchars.Newline &
> First(Fields!NameKunde.Value, "Absender") & vbnewline &
> First(Fields!Ort.Value, "Absender") & vbnewline &
> First(Fields!BenutzerAnmeldename.Value, "Absender") & vbnewline &
> First(Fields!Vorname.Value, "Absender") & " " & First(Fields!Name.Value,
"Absender") & vbnewline &
> today
> +++
> As you see, I tried controlchars.Newline, vbnewline. No differenc in pdf.
> Thanks for help
> Nicki
>
RectangleTextboxSampleReport.rdl
----
<?xml version="1.0" encoding="utf-8"?>
<Report
xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefini
tion"
xmlns:rd="">http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<RightMargin>1in</RightMargin>
<Body>
<ReportItems>
<Rectangle Name="rectangle1">
<ReportItems>
<Textbox Name="textbox4">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>3</ZIndex>
<Top>1.625in</Top>
<rd:DefaultName>textbox4</rd:DefaultName>
<Height>0.25in</Height>
<Width>1.875in</Width>
<CanGrow>true</CanGrow>
<Value>=today</Value>
<Left>0.125in</Left>
</Textbox>
<Textbox Name="textbox3">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>2</ZIndex>
<Top>1.125in</Top>
<rd:DefaultName>textbox3</rd:DefaultName>
<Height>0.25in</Height>
<Width>1.875in</Width>
<CanGrow>true</CanGrow>
<Value>Last line of text</Value>
<Left>0.125in</Left>
</Textbox>
<Textbox Name="textbox2">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>1</ZIndex>
<Top>0.625in</Top>
<rd:DefaultName>textbox2</rd:DefaultName>
<Height>0.25in</Height>
<Width>1.875in</Width>
<CanGrow>true</CanGrow>
<Value>Second line of text</Value>
<Left>0.125in</Left>
</Textbox>
<Textbox Name="textbox1">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<Top>0.375in</Top>
<rd:DefaultName>textbox1</rd:DefaultName>
<Height>0.25in</Height>
<Width>1.875in</Width>
<CanGrow>true</CanGrow>
<Value>First line of text</Value>
<Left>0.125in</Left>
</Textbox>
</ReportItems>
<Width>2.25in</Width>
<Style>
<BorderWidth>
<Default>1.5pt</Default>
</BorderWidth>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Rectangle>
</ReportItems>
<Style />
<Height>2in</Height>
</Body>
<TopMargin>1in</TopMargin>
<Width>6.5in</Width>
<LeftMargin>1in</LeftMargin>
<rd:SnapToGrid>true</rd:SnapToGrid>
<rd:DrawGrid>true</rd:DrawGrid>
<rd:ReportID>b77866c3-877c-45bc-a5dc-88760f336daf</rd:ReportID>
<BottomMargin>1in</BottomMargin>
<Language>en-US</Language>
</Report>
newline in format string
Can I insert a newline character within a reporting services format string?
I guess \n doesn't work since it is interpreted as a VisualBasic format
string...? Is there an alternative?
Thanks,
Michael CarrvbNewLine
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Michael Carr" <mcarr@.umich.edu> wrote in message
news:uOApiLweEHA.3200@.TK2MSFTNGP09.phx.gbl...
> Can I insert a newline character within a reporting services format
string?
> I guess \n doesn't work since it is interpreted as a VisualBasic format
> string...? Is there an alternative?
> Thanks,
> Michael Carr
>|||Hmm I think I may have located a bug...
1. If I use vbNewline in the FORMAT STRING, i.e. = "M/dd/yy" & vbNewline &
"h:mm tt", then the vbNewline gets rendered (using the HTML renderer, at
least) out to a linefeed in the HTML textfile which does NOT translate into
a linefeed in the browser.
2. On the other hand, if I use vbNewline in the VALUE itself, i.e. =Format(Fields!Date.Value, "M/dd/yy") & vbNewline & Format(Fields!Date.Value,
"h:mm tt"), then the vbNewline is rendered out as <br/>
This seems to be an inconsistency in the HTML renderer ... ?
Michael Carr
"Ravi Mumulla (Microsoft)" <ravimu@.online.microsoft.com> wrote in message
news:eXqVC9weEHA.3680@.TK2MSFTNGP11.phx.gbl...
> vbNewLine
> --
> Ravi Mumulla (Microsoft)
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Michael Carr" <mcarr@.umich.edu> wrote in message
> news:uOApiLweEHA.3200@.TK2MSFTNGP09.phx.gbl...
> > Can I insert a newline character within a reporting services format
> string?
> >
> > I guess \n doesn't work since it is interpreted as a VisualBasic format
> > string...? Is there an alternative?
> >
> > Thanks,
> > Michael Carr
> >
> >
>|||Please clarify the steps to reproduce. I tried the first expression on SP1
and I get <br/>. Here's the expression I used: ="1/1/2004" & vbNewLine &
"12:00:00".
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Michael Carr" <mcarr@.umich.edu> wrote in message
news:OhZEbx0eEHA.2604@.TK2MSFTNGP12.phx.gbl...
> Hmm I think I may have located a bug...
> 1. If I use vbNewline in the FORMAT STRING, i.e. = "M/dd/yy" & vbNewline &
> "h:mm tt", then the vbNewline gets rendered (using the HTML renderer, at
> least) out to a linefeed in the HTML textfile which does NOT translate
into
> a linefeed in the browser.
> 2. On the other hand, if I use vbNewline in the VALUE itself, i.e. => Format(Fields!Date.Value, "M/dd/yy") & vbNewline &
Format(Fields!Date.Value,
> "h:mm tt"), then the vbNewline is rendered out as <br/>
> This seems to be an inconsistency in the HTML renderer ... ?
> Michael Carr
>
> "Ravi Mumulla (Microsoft)" <ravimu@.online.microsoft.com> wrote in message
> news:eXqVC9weEHA.3680@.TK2MSFTNGP11.phx.gbl...
> > vbNewLine
> >
> > --
> > Ravi Mumulla (Microsoft)
> > SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > "Michael Carr" <mcarr@.umich.edu> wrote in message
> > news:uOApiLweEHA.3200@.TK2MSFTNGP09.phx.gbl...
> > > Can I insert a newline character within a reporting services format
> > string?
> > >
> > > I guess \n doesn't work since it is interpreted as a VisualBasic
format
> > > string...? Is there an alternative?
> > >
> > > Thanks,
> > > Michael Carr
> > >
> > >
> >
> >
>|||Ravi,
Please see the report below (and attached) for an example. Note that this
renders correctly in the Report Editor Preview, but does not render
correctly in the Report Manager.
<?xml version="1.0" encoding="utf-8"?>
<Report
xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefini
tion"
xmlns:rd="">http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<RightMargin>1in</RightMargin>
<Body>
<ReportItems>
<Table Name="table1">
<Height>0.75in</Height>
<Style />
<Header>
<TableRows>
<TableRow>
<Height>0.25in</Height>
<TableCells>
<TableCell>
<ReportItems>
�Textbox Name="textbox1">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<TextAlign>Left</TextAlign>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>5</ZIndex>
<rd:DefaultName>textbox1</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>Date</Value>
�/Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
�Textbox Name="textbox2">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<TextAlign>Left</TextAlign>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>4</ZIndex>
<rd:DefaultName>textbox2</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>Date</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
</TableRows>
</Header>
<Details>
<TableRows>
<TableRow>
<Height>0.25in</Height>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="Date">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<Format>= "M/d/yyyy" & vbNewline & "h:mm tt"</Format>
<TextAlign>Left</TextAlign>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>1</ZIndex>
<rd:DefaultName>Date</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>=Fields!Date.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="Date_1">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<TextAlign>Left</TextAlign>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<rd:DefaultName>Date_1</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>=Format(Fields!Date.Value, "M/d/yyyy") & vbNewline &
Format(Fields!Date.Value, "h:mm tt")</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
</TableRows>
</Details>
<DataSetName>DataSet1</DataSetName>
<Top>0.5in</Top>
<Width>4.33333in</Width>
<Footer>
<TableRows>
<TableRow>
<Height>0.25in</Height>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox7">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>3</ZIndex>
<rd:DefaultName>textbox7</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox8">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>2</ZIndex>
<rd:DefaultName>textbox8</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
</TableRows>
</Footer>
<Left>1.125in</Left>
<TableColumns>
<TableColumn>
<Width>2.16667in</Width>
</TableColumn>
<TableColumn>
<Width>2.16667in</Width>
</TableColumn>
</TableColumns>
</Table>
</ReportItems>
<Style />
<Height>2in</Height>
</Body>
<TopMargin>1in</TopMargin>
<DataSources>
<DataSource Name="SkyScheduler">
<rd:DataSourceID>6617abfe-bebd-49ae-a365-417ab349c748</rd:DataSourceID>
<DataSourceReference>SkyScheduler</DataSourceReference>
</DataSource>
</DataSources>
<Width>6.5in</Width>
<DataSets>
<DataSet Name="DataSet1">
<Fields>
<Field Name="Date">
<DataField>Date</DataField>
<rd:TypeName>System.DateTime</rd:TypeName>
</Field>
</Fields>
<Query>
<DataSourceName>SkyScheduler</DataSourceName>
<CommandText>SELECT CONVERT(smalldatetime, '1/1/2000 3:00pm') AS
Date</CommandText>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
</Query>
</DataSet>
</DataSets>
<LeftMargin>1in</LeftMargin>
<rd:SnapToGrid>true</rd:SnapToGrid>
<rd:DrawGrid>true</rd:DrawGrid>
<rd:ReportID>6c9977cc-7283-416b-a107-65d98a0c8dd2</rd:ReportID>
<BottomMargin>1in</BottomMargin>
<Language>en-US</Language>
</Report>
"Ravi Mumulla (Microsoft)" <ravimu@.online.microsoft.com> wrote in message
news:ODeNfFnfEHA.708@.TK2MSFTNGP09.phx.gbl...
> Please clarify the steps to reproduce. I tried the first expression on SP1
> and I get <br/>. Here's the expression I used: ="1/1/2004" & vbNewLine &
> "12:00:00".
begin 666 BRExample.rdl
M/#]X;6P@.=F5R<VEO;CTB,2XP(B!E;F-O9&EN9STB=71F+3@.B/SX-"CQ297!O
M<G0@.>&UL;G,](FAT=' Z+R]S8VAE;6%S+FUI8W)O<V]F="YC;VTO<W%L<V5R
M=F5R+W)E<&]R=&EN9R\R,# S+S$P+W)E<&]R=&1E9FEN:71I;VXB('AM;&YS
M.G)D/2)H='1P.B\O<V-H96UA<RYM:6-R;W-O9G0N8V]M+U-13%-E<G9E<B]R
M97!O<G1I;F<O<F5P;W)T9&5S:6=N97(B/@.T*(" \4FEG:'1-87)G:6X^,6EN
M/"]2:6=H=$UA<F=I;CX-"B @./$)O9'D^#0H@.(" @./%)E<&]R=$ET96US/@.T*
M(" @.(" @./%1A8FQE($YA;64](G1A8FQE,2(^#0H@.(" @.(" @.(#Q(96EG:'0^
M,"XW-6EN/"](96EG:'0^#0H@.(" @.(" @.(#Q3='EL92 O/@.T*(" @.(" @.(" \
M2&5A9&5R/@.T*(" @.(" @.(" @.(#Q486)L95)O=W,^#0H@.(" @.(" @.(" @.(" \
M5&%B;&52;W<^#0H@.(" @.(" @.(" @.(" @.(#Q(96EG:'0^,"XR-6EN/"](96EG
M:'0^#0H@.(" @.(" @.(" @.(" @.(#Q486)L94-E;&QS/@.T*(" @.(" @.(" @.(" @.
M(" @.(#Q486)L94-E;&P^#0H@.(" @.(" @.(" @.(" @.(" @.(" \4F5P;W)T271E
M;7,^#0H@.(" @.(" @.(" @.(" @.(" @.(" @.(#Q497AT8F]X($YA;64](G1E>'1B
M;W@.Q(CX-"B @.(" @.(" @.(" @.(" @.(" @.(" @.(" \4W1Y;&4^#0H@.(" @.(" @.
M(" @.(" @.(" @.(" @.(" @.(" \4&%D9&EN9TQE9G0^,G!T/"]0861D:6YG3&5F
M=#X-"B @.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(#Q497AT06QI9VX^3&5F=#PO
M5&5X=$%L:6=N/@.T*(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" @./%!A9&1I;F="
M;W1T;VT^,G!T/"]0861D:6YG0F]T=&]M/@.T*(" @.(" @.(" @.(" @.(" @.(" @.
M(" @.(" @./%!A9&1I;F=4;W ^,G!T/"]0861D:6YG5&]P/@.T*(" @.(" @.(" @.
M(" @.(" @.(" @.(" @.(" @./%!A9&1I;F=2:6=H=#XR<'0\+U!A9&1I;F=2:6=H
M=#X-"B @.(" @.(" @.(" @.(" @.(" @.(" @.(" \+U-T>6QE/@.T*(" @.(" @.(" @.
M(" @.(" @.(" @.(" @.(#Q:26YD97@.^-3PO6DEN9&5X/@.T*(" @.(" @.(" @.(" @.
M(" @.(" @.(" @.(#QR9#I$969A=6QT3F%M93YT97AT8F]X,3PO<F0Z1&5F875L
M=$YA;64^#0H@.(" @.(" @.(" @.(" @.(" @.(" @.(" @./$-A;D=R;W<^=')U93PO
M0V%N1W)O=SX-"B @.(" @.(" @.(" @.(" @.(" @.(" @.(" \5F%L=64^1&%T93PO
M5F%L=64^#0H@.(" @.(" @.(" @.(" @.(" @.(" @.(#PO5&5X=&)O>#X-"B @.(" @.
M(" @.(" @.(" @.(" @.(#PO4F5P;W)T271E;7,^#0H@.(" @.(" @.(" @.(" @.(" @.
M/"]486)L94-E;&P^#0H@.(" @.(" @.(" @.(" @.(" @./%1A8FQE0V5L;#X-"B @.
M(" @.(" @.(" @.(" @.(" @.(#Q297!O<G1)=&5M<SX-"B @.(" @.(" @.(" @.(" @.
M(" @.(" @./%1E>'1B;W@.@.3F%M93TB=&5X=&)O>#(B/@.T*(" @.(" @.(" @.(" @.
M(" @.(" @.(" @.(#Q3='EL93X-"B @.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(#Q0
M861D:6YG3&5F=#XR<'0\+U!A9&1I;F=,969T/@.T*(" @.(" @.(" @.(" @.(" @.
M(" @.(" @.(" @./%1E>'1!;&EG;CY,969T/"]497AT06QI9VX^#0H@.(" @.(" @.
M(" @.(" @.(" @.(" @.(" @.(" \4&%D9&EN9T)O='1O;3XR<'0\+U!A9&1I;F="
M;W1T;VT^#0H@.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" \4&%D9&EN9U1O<#XR
M<'0\+U!A9&1I;F=4;W ^#0H@.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" \4&%D
M9&EN9U)I9VAT/C)P=#PO4&%D9&EN9U)I9VAT/@.T*(" @.(" @.(" @.(" @.(" @.
M(" @.(" @.(#PO4W1Y;&4^#0H@.(" @.(" @.(" @.(" @.(" @.(" @.(" @./%I);F1E
M>#XT/"]:26YD97@.^#0H@.(" @.(" @.(" @.(" @.(" @.(" @.(" @./')D.D1E9F%U
M;'1.86UE/G1E>'1B;W@.R/"]R9#I$969A=6QT3F%M93X-"B @.(" @.(" @.(" @.
M(" @.(" @.(" @.(" \0V%N1W)O=SYT<G5E/"]#86Y'<F]W/@.T*(" @.(" @.(" @.
M(" @.(" @.(" @.(" @.(#Q686QU93Y$871E/"]686QU93X-"B @.(" @.(" @.(" @.
M(" @.(" @.(" @./"]497AT8F]X/@.T*(" @.(" @.(" @.(" @.(" @.(" @./"]297!O
M<G1)=&5M<SX-"B @.(" @.(" @.(" @.(" @.(" \+U1A8FQE0V5L;#X-"B @.(" @.
M(" @.(" @.(" @./"]486)L94-E;&QS/@.T*(" @.(" @.(" @.(" @./"]486)L95)O
M=SX-"B @.(" @.(" @.(" \+U1A8FQE4F]W<SX-"B @.(" @.(" @./"](96%D97(^
M#0H@.(" @.(" @.(#Q$971A:6QS/@.T*(" @.(" @.(" @.(#Q486)L95)O=W,^#0H@.
M(" @.(" @.(" @.(" \5&%B;&52;W<^#0H@.(" @.(" @.(" @.(" @.(#Q(96EG:'0^
M,"XR-6EN/"](96EG:'0^#0H@.(" @.(" @.(" @.(" @.(#Q486)L94-E;&QS/@.T*
M(" @.(" @.(" @.(" @.(" @.(#Q486)L94-E;&P^#0H@.(" @.(" @.(" @.(" @.(" @.
M(" \4F5P;W)T271E;7,^#0H@.(" @.(" @.(" @.(" @.(" @.(" @.(#Q497AT8F]X
M($YA;64](D1A=&4B/@.T*(" @.(" @.(" @.(" @.(" @.(" @.(" @.(#Q3='EL93X-
M"B @.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(#Q0861D:6YG3&5F=#XR<'0\+U!A
M9&1I;F=,969T/@.T*(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" @./$9O<FUA=#X]
M(")-+V0O>7EY>2(@.)F%M<#L@.=F).97=L:6YE("9A;7 [(")H.FUM('1T(CPO
M1F]R;6%T/@.T*(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" @./%1E>'1!;&EG;CY,
M969T/"]497AT06QI9VX^#0H@.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" \4&%D
M9&EN9T)O='1O;3XR<'0\+U!A9&1I;F=";W1T;VT^#0H@.(" @.(" @.(" @.(" @.
M(" @.(" @.(" @.(" \4&%D9&EN9U1O<#XR<'0\+U!A9&1I;F=4;W ^#0H@.(" @.
M(" @.(" @.(" @.(" @.(" @.(" @.(" \4&%D9&EN9U)I9VAT/C)P=#PO4&%D9&EN
M9U)I9VAT/@.T*(" @.(" @.(" @.(" @.(" @.(" @.(" @.(#PO4W1Y;&4^#0H@.(" @.
M(" @.(" @.(" @.(" @.(" @.(" @./%I);F1E>#XQ/"]:26YD97@.^#0H@.(" @.(" @.
M(" @.(" @.(" @.(" @.(" @./')D.D1E9F%U;'1.86UE/D1A=&4\+W)D.D1E9F%U
M;'1.86UE/@.T*(" @.(" @.(" @.(" @.(" @.(" @.(" @.(#Q#86Y'<F]W/G1R=64\
M+T-A;D=R;W<^#0H@.(" @.(" @.(" @.(" @.(" @.(" @.(" @./%9A;'5E/CU&:65L
M9',A1&%T92Y686QU93PO5F%L=64^#0H@.(" @.(" @.(" @.(" @.(" @.(" @.(#PO
M5&5X=&)O>#X-"B @.(" @.(" @.(" @.(" @.(" @.(#PO4F5P;W)T271E;7,^#0H@.
M(" @.(" @.(" @.(" @.(" @./"]486)L94-E;&P^#0H@.(" @.(" @.(" @.(" @.(" @.
M/%1A8FQE0V5L;#X-"B @.(" @.(" @.(" @.(" @.(" @.(#Q297!O<G1)=&5M<SX-
M"B @.(" @.(" @.(" @.(" @.(" @.(" @./%1E>'1B;W@.@.3F%M93TB1&%T95\Q(CX-
M"B @.(" @.(" @.(" @.(" @.(" @.(" @.(" \4W1Y;&4^#0H@.(" @.(" @.(" @.(" @.
M(" @.(" @.(" @.(" \4&%D9&EN9TQE9G0^,G!T/"]0861D:6YG3&5F=#X-"B @.
M(" @.(" @.(" @.(" @.(" @.(" @.(" @.(#Q497AT06QI9VX^3&5F=#PO5&5X=$%L
M:6=N/@.T*(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" @./%!A9&1I;F=";W1T;VT^
M,G!T/"]0861D:6YG0F]T=&]M/@.T*(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" @.
M/%!A9&1I;F=4;W ^,G!T/"]0861D:6YG5&]P/@.T*(" @.(" @.(" @.(" @.(" @.
M(" @.(" @.(" @./%!A9&1I;F=2:6=H=#XR<'0\+U!A9&1I;F=2:6=H=#X-"B @.
M(" @.(" @.(" @.(" @.(" @.(" @.(" \+U-T>6QE/@.T*(" @.(" @.(" @.(" @.(" @.
M(" @.(" @.(#QR9#I$969A=6QT3F%M93Y$871E7S$\+W)D.D1E9F%U;'1.86UE
M/@.T*(" @.(" @.(" @.(" @.(" @.(" @.(" @.(#Q#86Y'<F]W/G1R=64\+T-A;D=R
M;W<^#0H@.(" @.(" @.(" @.(" @.(" @.(" @.(" @./%9A;'5E/CU&;W)M870H1FEE
M;&1S(41A=&4N5F%L=64L(")-+V0O>7EY>2(I("9A;7 [('9B3F5W;&EN92 F
M86UP.R!&;W)M870H1FEE;&1S(41A=&4N5F%L=64L(")H.FUM('1T(BD\+U9A
M;'5E/@.T*(" @.(" @.(" @.(" @.(" @.(" @.(" \+U1E>'1B;W@.^#0H@.(" @.(" @.
M(" @.(" @.(" @.(" \+U)E<&]R=$ET96US/@.T*(" @.(" @.(" @.(" @.(" @.(#PO
M5&%B;&5#96QL/@.T*(" @.(" @.(" @.(" @.(" \+U1A8FQE0V5L;',^#0H@.(" @.
M(" @.(" @.(" \+U1A8FQE4F]W/@.T*(" @.(" @.(" @.(#PO5&%B;&52;W=S/@.T*
M(" @.(" @.(" \+T1E=&%I;',^#0H@.(" @.(" @.(#Q$871A4V5T3F%M93Y$871A
M4V5T,3PO1&%T85-E=$YA;64^#0H@.(" @.(" @.(#Q4;W ^,"XU:6X\+U1O<#X-
M"B @.(" @.(" @./%=I9'1H/C0N,S,S,S-I;CPO5VED=&@.^#0H@.(" @.(" @.(#Q&
M;V]T97(^#0H@.(" @.(" @.(" @./%1A8FQE4F]W<SX-"B @.(" @.(" @.(" @.(#Q4
M86)L95)O=SX-"B @.(" @.(" @.(" @.(" @./$AE:6=H=#XP+C(U:6X\+TAE:6=H
M=#X-"B @.(" @.(" @.(" @.(" @./%1A8FQE0V5L;',^#0H@.(" @.(" @.(" @.(" @.
M(" @./%1A8FQE0V5L;#X-"B @.(" @.(" @.(" @.(" @.(" @.(#Q297!O<G1)=&5M
M<SX-"B @.(" @.(" @.(" @.(" @.(" @.(" @./%1E>'1B;W@.@.3F%M93TB=&5X=&)O
M>#<B/@.T*(" @.(" @.(" @.(" @.(" @.(" @.(" @.(#Q3='EL93X-"B @.(" @.(" @.
M(" @.(" @.(" @.(" @.(" @.(#Q0861D:6YG3&5F=#XR<'0\+U!A9&1I;F=,969T
M/@.T*(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" @./%!A9&1I;F=";W1T;VT^,G!T
M/"]0861D:6YG0F]T=&]M/@.T*(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" @./%!A
M9&1I;F=4;W ^,G!T/"]0861D:6YG5&]P/@.T*(" @.(" @.(" @.(" @.(" @.(" @.
M(" @.(" @./%!A9&1I;F=2:6=H=#XR<'0\+U!A9&1I;F=2:6=H=#X-"B @.(" @.
M(" @.(" @.(" @.(" @.(" @.(" \+U-T>6QE/@.T*(" @.(" @.(" @.(" @.(" @.(" @.
M(" @.(#Q:26YD97@.^,SPO6DEN9&5X/@.T*(" @.(" @.(" @.(" @.(" @.(" @.(" @.
M(#QR9#I$969A=6QT3F%M93YT97AT8F]X-SPO<F0Z1&5F875L=$YA;64^#0H@.
M(" @.(" @.(" @.(" @.(" @.(" @.(" @./$-A;D=R;W<^=')U93PO0V%N1W)O=SX-
M"B @.(" @.(" @.(" @.(" @.(" @.(" @.(" \5F%L=64@.+SX-"B @.(" @.(" @.(" @.
M(" @.(" @.(" @./"]497AT8F]X/@.T*(" @.(" @.(" @.(" @.(" @.(" @./"]297!O
M<G1)=&5M<SX-"B @.(" @.(" @.(" @.(" @.(" \+U1A8FQE0V5L;#X-"B @.(" @.
M(" @.(" @.(" @.(" \5&%B;&5#96QL/@.T*(" @.(" @.(" @.(" @.(" @.(" @./%)E
M<&]R=$ET96US/@.T*(" @.(" @.(" @.(" @.(" @.(" @.(" \5&5X=&)O>"!.86UE
M/2)T97AT8F]X."(^#0H@.(" @.(" @.(" @.(" @.(" @.(" @.(" @./%-T>6QE/@.T*
M(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" @./%!A9&1I;F=,969T/C)P=#PO4&%D
M9&EN9TQE9G0^#0H@.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" \4&%D9&EN9T)O
M='1O;3XR<'0\+U!A9&1I;F=";W1T;VT^#0H@.(" @.(" @.(" @.(" @.(" @.(" @.
M(" @.(" \4&%D9&EN9U1O<#XR<'0\+U!A9&1I;F=4;W ^#0H@.(" @.(" @.(" @.
M(" @.(" @.(" @.(" @.(" \4&%D9&EN9U)I9VAT/C)P=#PO4&%D9&EN9U)I9VAT
M/@.T*(" @.(" @.(" @.(" @.(" @.(" @.(" @.(#PO4W1Y;&4^#0H@.(" @.(" @.(" @.
M(" @.(" @.(" @.(" @./%I);F1E>#XR/"]:26YD97@.^#0H@.(" @.(" @.(" @.(" @.
M(" @.(" @.(" @./')D.D1E9F%U;'1.86UE/G1E>'1B;W@.X/"]R9#I$969A=6QT
M3F%M93X-"B @.(" @.(" @.(" @.(" @.(" @.(" @.(" \0V%N1W)O=SYT<G5E/"]#
M86Y'<F]W/@.T*(" @.(" @.(" @.(" @.(" @.(" @.(" @.(#Q686QU92 O/@.T*(" @.
M(" @.(" @.(" @.(" @.(" @.(" \+U1E>'1B;W@.^#0H@.(" @.(" @.(" @.(" @.(" @.
M(" \+U)E<&]R=$ET96US/@.T*(" @.(" @.(" @.(" @.(" @.(#PO5&%B;&5#96QL
M/@.T*(" @.(" @.(" @.(" @.(" \+U1A8FQE0V5L;',^#0H@.(" @.(" @.(" @.(" \
M+U1A8FQE4F]W/@.T*(" @.(" @.(" @.(#PO5&%B;&52;W=S/@.T*(" @.(" @.(" \
M+T9O;W1E<CX-"B @.(" @.(" @./$QE9G0^,2XQ,C5I;CPO3&5F=#X-"B @.(" @.
M(" @./%1A8FQE0V]L=6UN<SX-"B @.(" @.(" @.(" \5&%B;&5#;VQU;6X^#0H@.
M(" @.(" @.(" @.(" \5VED=&@.^,BXQ-C8V-VEN/"]7:61T:#X-"B @.(" @.(" @.
M(" \+U1A8FQE0V]L=6UN/@.T*(" @.(" @.(" @.(#Q486)L94-O;'5M;CX-"B @.
M(" @.(" @.(" @.(#Q7:61T:#XR+C$V-C8W:6X\+U=I9'1H/@.T*(" @.(" @.(" @.
M(#PO5&%B;&5#;VQU;6X^#0H@.(" @.(" @.(#PO5&%B;&5#;VQU;6YS/@.T*(" @.
M(" @./"]486)L93X-"B @.(" \+U)E<&]R=$ET96US/@.T*(" @.(#Q3='EL92 O
M/@.T*(" @.(#Q(96EG:'0^,FEN/"](96EG:'0^#0H@.(#PO0F]D>3X-"B @./%1O
M<$UA<F=I;CXQ:6X\+U1O<$UA<F=I;CX-"B @./$1A=&%3;W5R8V5S/@.T*(" @.
M(#Q$871A4V]U<F-E($YA;64](E-K>5-C:&5D=6QE<B(^#0H@.(" @.(" \<F0Z
M1&%T85-O=7)C94E$/C8V,3=A8F9E+6)E8F0M-#EA92UA,S8U+30Q-V%B,S0Y
M8S<T.#PO<F0Z1&%T85-O=7)C94E$/@.T*(" @.(" @./$1A=&%3;W5R8V52969E
M<F5N8V4^4VMY4V-H961U;&5R/"]$871A4V]U<F-E4F5F97)E;F-E/@.T*(" @.
M(#PO1&%T85-O=7)C93X-"B @./"]$871A4V]U<F-E<SX-"B @./%=I9'1H/C8N
M-6EN/"]7:61T:#X-"B @./$1A=&%3971S/@.T*(" @.(#Q$871A4V5T($YA;64]
M(D1A=&%3970Q(CX-"B @.(" @.(#Q&:65L9',^#0H@.(" @.(" @.(#Q&:65L9"!.
M86UE/2)$871E(CX-"B @.(" @.(" @.(" \1&%T849I96QD/D1A=&4\+T1A=&%&
M:65L9#X-"B @.(" @.(" @.(" \<F0Z5'EP94YA;64^4WES=&5M+D1A=&54:6UE
M/"]R9#I4>7!E3F%M93X-"B @.(" @.(" @./"]&:65L9#X-"B @.(" @.(#PO1FEE
M;&1S/@.T*(" @.(" @./%%U97)Y/@.T*(" @.(" @.(" \1&%T85-O=7)C94YA;64^
M4VMY4V-H961U;&5R/"]$871A4V]U<F-E3F%M93X-"B @.(" @.(" @./$-O;6UA
M;F1497AT/E-%3$5#5"!#3TY615)4*'-M86QL9&%T971I;64L("<Q+S$O,C P
M," S.C P<&TG*2!!4R!$871E/"]#;VUM86YD5&5X=#X-"B @.(" @.(" @./')D
M.E5S94=E;F5R:6-$97-I9VYE<CYT<G5E/"]R9#I5<V5'96YE<FEC1&5S:6=N
M97(^#0H@.(" @.(" \+U%U97)Y/@.T*(" @.(#PO1&%T85-E=#X-"B @./"]$871A
M4V5T<SX-"B @./$QE9G1-87)G:6X^,6EN/"],969T36%R9VEN/@.T*(" \<F0Z
M4VYA<%1O1W)I9#YT<G5E/"]R9#I3;F%P5&]'<FED/@.T*(" \<F0Z1')A=T=R
M:60^=')U93PO<F0Z1')A=T=R:60^#0H@.(#QR9#I297!O<G1)1#XV8SDY-S=C
M8RTW,C@.S+30Q-F(M83$P-RTV-60Y.&$P8SAD9#(\+W)D.E)E<&]R=$E$/@.T*
M(" \0F]T=&]M36%R9VEN/C%I;CPO0F]T=&]M36%R9VEN/@.T*(" \3&%N9W5A
>9V4^96XM55,\+TQA;F=U86=E/@.T*/"]297!O<G0^
`
end|||Ravi,
Did you get a chance to look at the example I posted?
Michael Carr
"Michael Carr" <mcarr@.umich.edu> wrote in message
news:uBDHDenfEHA.3676@.TK2MSFTNGP12.phx.gbl...
> Ravi,
> Please see the report below (and attached) for an example. Note that this
> renders correctly in the Report Editor Preview, but does not render
> correctly in the Report Manager.|||I will look into this today.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Michael Carr" <mcarr@.umich.edu> wrote in message
news:eOjzh9ShEHA.3864@.TK2MSFTNGP10.phx.gbl...
> Ravi,
> Did you get a chance to look at the example I posted?
> Michael Carr
> "Michael Carr" <mcarr@.umich.edu> wrote in message
> news:uBDHDenfEHA.3676@.TK2MSFTNGP12.phx.gbl...
> > Ravi,
> >
> > Please see the report below (and attached) for an example. Note that
this
> > renders correctly in the Report Editor Preview, but does not render
> > correctly in the Report Manager.
>|||I have logged this as a bug in HTML renderer which may be fixed in a future
release. Thanks for reporting this issue.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ravi Mumulla (Microsoft)" <ravimu@.online.microsoft.com> wrote in message
news:OXh8fEThEHA.3916@.TK2MSFTNGP11.phx.gbl...
> I will look into this today.
> --
> Ravi Mumulla (Microsoft)
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Michael Carr" <mcarr@.umich.edu> wrote in message
> news:eOjzh9ShEHA.3864@.TK2MSFTNGP10.phx.gbl...
> > Ravi,
> >
> > Did you get a chance to look at the example I posted?
> >
> > Michael Carr
> >
> > "Michael Carr" <mcarr@.umich.edu> wrote in message
> > news:uBDHDenfEHA.3676@.TK2MSFTNGP12.phx.gbl...
> > > Ravi,
> > >
> > > Please see the report below (and attached) for an example. Note that
> this
> > > renders correctly in the Report Editor Preview, but does not render
> > > correctly in the Report Manager.
> >
> >
>
I guess \n doesn't work since it is interpreted as a VisualBasic format
string...? Is there an alternative?
Thanks,
Michael CarrvbNewLine
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Michael Carr" <mcarr@.umich.edu> wrote in message
news:uOApiLweEHA.3200@.TK2MSFTNGP09.phx.gbl...
> Can I insert a newline character within a reporting services format
string?
> I guess \n doesn't work since it is interpreted as a VisualBasic format
> string...? Is there an alternative?
> Thanks,
> Michael Carr
>|||Hmm I think I may have located a bug...
1. If I use vbNewline in the FORMAT STRING, i.e. = "M/dd/yy" & vbNewline &
"h:mm tt", then the vbNewline gets rendered (using the HTML renderer, at
least) out to a linefeed in the HTML textfile which does NOT translate into
a linefeed in the browser.
2. On the other hand, if I use vbNewline in the VALUE itself, i.e. =Format(Fields!Date.Value, "M/dd/yy") & vbNewline & Format(Fields!Date.Value,
"h:mm tt"), then the vbNewline is rendered out as <br/>
This seems to be an inconsistency in the HTML renderer ... ?
Michael Carr
"Ravi Mumulla (Microsoft)" <ravimu@.online.microsoft.com> wrote in message
news:eXqVC9weEHA.3680@.TK2MSFTNGP11.phx.gbl...
> vbNewLine
> --
> Ravi Mumulla (Microsoft)
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Michael Carr" <mcarr@.umich.edu> wrote in message
> news:uOApiLweEHA.3200@.TK2MSFTNGP09.phx.gbl...
> > Can I insert a newline character within a reporting services format
> string?
> >
> > I guess \n doesn't work since it is interpreted as a VisualBasic format
> > string...? Is there an alternative?
> >
> > Thanks,
> > Michael Carr
> >
> >
>|||Please clarify the steps to reproduce. I tried the first expression on SP1
and I get <br/>. Here's the expression I used: ="1/1/2004" & vbNewLine &
"12:00:00".
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Michael Carr" <mcarr@.umich.edu> wrote in message
news:OhZEbx0eEHA.2604@.TK2MSFTNGP12.phx.gbl...
> Hmm I think I may have located a bug...
> 1. If I use vbNewline in the FORMAT STRING, i.e. = "M/dd/yy" & vbNewline &
> "h:mm tt", then the vbNewline gets rendered (using the HTML renderer, at
> least) out to a linefeed in the HTML textfile which does NOT translate
into
> a linefeed in the browser.
> 2. On the other hand, if I use vbNewline in the VALUE itself, i.e. => Format(Fields!Date.Value, "M/dd/yy") & vbNewline &
Format(Fields!Date.Value,
> "h:mm tt"), then the vbNewline is rendered out as <br/>
> This seems to be an inconsistency in the HTML renderer ... ?
> Michael Carr
>
> "Ravi Mumulla (Microsoft)" <ravimu@.online.microsoft.com> wrote in message
> news:eXqVC9weEHA.3680@.TK2MSFTNGP11.phx.gbl...
> > vbNewLine
> >
> > --
> > Ravi Mumulla (Microsoft)
> > SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > "Michael Carr" <mcarr@.umich.edu> wrote in message
> > news:uOApiLweEHA.3200@.TK2MSFTNGP09.phx.gbl...
> > > Can I insert a newline character within a reporting services format
> > string?
> > >
> > > I guess \n doesn't work since it is interpreted as a VisualBasic
format
> > > string...? Is there an alternative?
> > >
> > > Thanks,
> > > Michael Carr
> > >
> > >
> >
> >
>|||Ravi,
Please see the report below (and attached) for an example. Note that this
renders correctly in the Report Editor Preview, but does not render
correctly in the Report Manager.
<?xml version="1.0" encoding="utf-8"?>
<Report
xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefini
tion"
xmlns:rd="">http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<RightMargin>1in</RightMargin>
<Body>
<ReportItems>
<Table Name="table1">
<Height>0.75in</Height>
<Style />
<Header>
<TableRows>
<TableRow>
<Height>0.25in</Height>
<TableCells>
<TableCell>
<ReportItems>
�Textbox Name="textbox1">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<TextAlign>Left</TextAlign>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>5</ZIndex>
<rd:DefaultName>textbox1</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>Date</Value>
�/Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
�Textbox Name="textbox2">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<TextAlign>Left</TextAlign>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>4</ZIndex>
<rd:DefaultName>textbox2</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>Date</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
</TableRows>
</Header>
<Details>
<TableRows>
<TableRow>
<Height>0.25in</Height>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="Date">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<Format>= "M/d/yyyy" & vbNewline & "h:mm tt"</Format>
<TextAlign>Left</TextAlign>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>1</ZIndex>
<rd:DefaultName>Date</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>=Fields!Date.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="Date_1">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<TextAlign>Left</TextAlign>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<rd:DefaultName>Date_1</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>=Format(Fields!Date.Value, "M/d/yyyy") & vbNewline &
Format(Fields!Date.Value, "h:mm tt")</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
</TableRows>
</Details>
<DataSetName>DataSet1</DataSetName>
<Top>0.5in</Top>
<Width>4.33333in</Width>
<Footer>
<TableRows>
<TableRow>
<Height>0.25in</Height>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox7">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>3</ZIndex>
<rd:DefaultName>textbox7</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox8">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>2</ZIndex>
<rd:DefaultName>textbox8</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
</TableRows>
</Footer>
<Left>1.125in</Left>
<TableColumns>
<TableColumn>
<Width>2.16667in</Width>
</TableColumn>
<TableColumn>
<Width>2.16667in</Width>
</TableColumn>
</TableColumns>
</Table>
</ReportItems>
<Style />
<Height>2in</Height>
</Body>
<TopMargin>1in</TopMargin>
<DataSources>
<DataSource Name="SkyScheduler">
<rd:DataSourceID>6617abfe-bebd-49ae-a365-417ab349c748</rd:DataSourceID>
<DataSourceReference>SkyScheduler</DataSourceReference>
</DataSource>
</DataSources>
<Width>6.5in</Width>
<DataSets>
<DataSet Name="DataSet1">
<Fields>
<Field Name="Date">
<DataField>Date</DataField>
<rd:TypeName>System.DateTime</rd:TypeName>
</Field>
</Fields>
<Query>
<DataSourceName>SkyScheduler</DataSourceName>
<CommandText>SELECT CONVERT(smalldatetime, '1/1/2000 3:00pm') AS
Date</CommandText>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
</Query>
</DataSet>
</DataSets>
<LeftMargin>1in</LeftMargin>
<rd:SnapToGrid>true</rd:SnapToGrid>
<rd:DrawGrid>true</rd:DrawGrid>
<rd:ReportID>6c9977cc-7283-416b-a107-65d98a0c8dd2</rd:ReportID>
<BottomMargin>1in</BottomMargin>
<Language>en-US</Language>
</Report>
"Ravi Mumulla (Microsoft)" <ravimu@.online.microsoft.com> wrote in message
news:ODeNfFnfEHA.708@.TK2MSFTNGP09.phx.gbl...
> Please clarify the steps to reproduce. I tried the first expression on SP1
> and I get <br/>. Here's the expression I used: ="1/1/2004" & vbNewLine &
> "12:00:00".
begin 666 BRExample.rdl
M/#]X;6P@.=F5R<VEO;CTB,2XP(B!E;F-O9&EN9STB=71F+3@.B/SX-"CQ297!O
M<G0@.>&UL;G,](FAT=' Z+R]S8VAE;6%S+FUI8W)O<V]F="YC;VTO<W%L<V5R
M=F5R+W)E<&]R=&EN9R\R,# S+S$P+W)E<&]R=&1E9FEN:71I;VXB('AM;&YS
M.G)D/2)H='1P.B\O<V-H96UA<RYM:6-R;W-O9G0N8V]M+U-13%-E<G9E<B]R
M97!O<G1I;F<O<F5P;W)T9&5S:6=N97(B/@.T*(" \4FEG:'1-87)G:6X^,6EN
M/"]2:6=H=$UA<F=I;CX-"B @./$)O9'D^#0H@.(" @./%)E<&]R=$ET96US/@.T*
M(" @.(" @./%1A8FQE($YA;64](G1A8FQE,2(^#0H@.(" @.(" @.(#Q(96EG:'0^
M,"XW-6EN/"](96EG:'0^#0H@.(" @.(" @.(#Q3='EL92 O/@.T*(" @.(" @.(" \
M2&5A9&5R/@.T*(" @.(" @.(" @.(#Q486)L95)O=W,^#0H@.(" @.(" @.(" @.(" \
M5&%B;&52;W<^#0H@.(" @.(" @.(" @.(" @.(#Q(96EG:'0^,"XR-6EN/"](96EG
M:'0^#0H@.(" @.(" @.(" @.(" @.(#Q486)L94-E;&QS/@.T*(" @.(" @.(" @.(" @.
M(" @.(#Q486)L94-E;&P^#0H@.(" @.(" @.(" @.(" @.(" @.(" \4F5P;W)T271E
M;7,^#0H@.(" @.(" @.(" @.(" @.(" @.(" @.(#Q497AT8F]X($YA;64](G1E>'1B
M;W@.Q(CX-"B @.(" @.(" @.(" @.(" @.(" @.(" @.(" \4W1Y;&4^#0H@.(" @.(" @.
M(" @.(" @.(" @.(" @.(" @.(" \4&%D9&EN9TQE9G0^,G!T/"]0861D:6YG3&5F
M=#X-"B @.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(#Q497AT06QI9VX^3&5F=#PO
M5&5X=$%L:6=N/@.T*(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" @./%!A9&1I;F="
M;W1T;VT^,G!T/"]0861D:6YG0F]T=&]M/@.T*(" @.(" @.(" @.(" @.(" @.(" @.
M(" @.(" @./%!A9&1I;F=4;W ^,G!T/"]0861D:6YG5&]P/@.T*(" @.(" @.(" @.
M(" @.(" @.(" @.(" @.(" @./%!A9&1I;F=2:6=H=#XR<'0\+U!A9&1I;F=2:6=H
M=#X-"B @.(" @.(" @.(" @.(" @.(" @.(" @.(" \+U-T>6QE/@.T*(" @.(" @.(" @.
M(" @.(" @.(" @.(" @.(#Q:26YD97@.^-3PO6DEN9&5X/@.T*(" @.(" @.(" @.(" @.
M(" @.(" @.(" @.(#QR9#I$969A=6QT3F%M93YT97AT8F]X,3PO<F0Z1&5F875L
M=$YA;64^#0H@.(" @.(" @.(" @.(" @.(" @.(" @.(" @./$-A;D=R;W<^=')U93PO
M0V%N1W)O=SX-"B @.(" @.(" @.(" @.(" @.(" @.(" @.(" \5F%L=64^1&%T93PO
M5F%L=64^#0H@.(" @.(" @.(" @.(" @.(" @.(" @.(#PO5&5X=&)O>#X-"B @.(" @.
M(" @.(" @.(" @.(" @.(#PO4F5P;W)T271E;7,^#0H@.(" @.(" @.(" @.(" @.(" @.
M/"]486)L94-E;&P^#0H@.(" @.(" @.(" @.(" @.(" @./%1A8FQE0V5L;#X-"B @.
M(" @.(" @.(" @.(" @.(" @.(#Q297!O<G1)=&5M<SX-"B @.(" @.(" @.(" @.(" @.
M(" @.(" @./%1E>'1B;W@.@.3F%M93TB=&5X=&)O>#(B/@.T*(" @.(" @.(" @.(" @.
M(" @.(" @.(" @.(#Q3='EL93X-"B @.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(#Q0
M861D:6YG3&5F=#XR<'0\+U!A9&1I;F=,969T/@.T*(" @.(" @.(" @.(" @.(" @.
M(" @.(" @.(" @./%1E>'1!;&EG;CY,969T/"]497AT06QI9VX^#0H@.(" @.(" @.
M(" @.(" @.(" @.(" @.(" @.(" \4&%D9&EN9T)O='1O;3XR<'0\+U!A9&1I;F="
M;W1T;VT^#0H@.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" \4&%D9&EN9U1O<#XR
M<'0\+U!A9&1I;F=4;W ^#0H@.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" \4&%D
M9&EN9U)I9VAT/C)P=#PO4&%D9&EN9U)I9VAT/@.T*(" @.(" @.(" @.(" @.(" @.
M(" @.(" @.(#PO4W1Y;&4^#0H@.(" @.(" @.(" @.(" @.(" @.(" @.(" @./%I);F1E
M>#XT/"]:26YD97@.^#0H@.(" @.(" @.(" @.(" @.(" @.(" @.(" @./')D.D1E9F%U
M;'1.86UE/G1E>'1B;W@.R/"]R9#I$969A=6QT3F%M93X-"B @.(" @.(" @.(" @.
M(" @.(" @.(" @.(" \0V%N1W)O=SYT<G5E/"]#86Y'<F]W/@.T*(" @.(" @.(" @.
M(" @.(" @.(" @.(" @.(#Q686QU93Y$871E/"]686QU93X-"B @.(" @.(" @.(" @.
M(" @.(" @.(" @./"]497AT8F]X/@.T*(" @.(" @.(" @.(" @.(" @.(" @./"]297!O
M<G1)=&5M<SX-"B @.(" @.(" @.(" @.(" @.(" \+U1A8FQE0V5L;#X-"B @.(" @.
M(" @.(" @.(" @./"]486)L94-E;&QS/@.T*(" @.(" @.(" @.(" @./"]486)L95)O
M=SX-"B @.(" @.(" @.(" \+U1A8FQE4F]W<SX-"B @.(" @.(" @./"](96%D97(^
M#0H@.(" @.(" @.(#Q$971A:6QS/@.T*(" @.(" @.(" @.(#Q486)L95)O=W,^#0H@.
M(" @.(" @.(" @.(" \5&%B;&52;W<^#0H@.(" @.(" @.(" @.(" @.(#Q(96EG:'0^
M,"XR-6EN/"](96EG:'0^#0H@.(" @.(" @.(" @.(" @.(#Q486)L94-E;&QS/@.T*
M(" @.(" @.(" @.(" @.(" @.(#Q486)L94-E;&P^#0H@.(" @.(" @.(" @.(" @.(" @.
M(" \4F5P;W)T271E;7,^#0H@.(" @.(" @.(" @.(" @.(" @.(" @.(#Q497AT8F]X
M($YA;64](D1A=&4B/@.T*(" @.(" @.(" @.(" @.(" @.(" @.(" @.(#Q3='EL93X-
M"B @.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(#Q0861D:6YG3&5F=#XR<'0\+U!A
M9&1I;F=,969T/@.T*(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" @./$9O<FUA=#X]
M(")-+V0O>7EY>2(@.)F%M<#L@.=F).97=L:6YE("9A;7 [(")H.FUM('1T(CPO
M1F]R;6%T/@.T*(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" @./%1E>'1!;&EG;CY,
M969T/"]497AT06QI9VX^#0H@.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" \4&%D
M9&EN9T)O='1O;3XR<'0\+U!A9&1I;F=";W1T;VT^#0H@.(" @.(" @.(" @.(" @.
M(" @.(" @.(" @.(" \4&%D9&EN9U1O<#XR<'0\+U!A9&1I;F=4;W ^#0H@.(" @.
M(" @.(" @.(" @.(" @.(" @.(" @.(" \4&%D9&EN9U)I9VAT/C)P=#PO4&%D9&EN
M9U)I9VAT/@.T*(" @.(" @.(" @.(" @.(" @.(" @.(" @.(#PO4W1Y;&4^#0H@.(" @.
M(" @.(" @.(" @.(" @.(" @.(" @./%I);F1E>#XQ/"]:26YD97@.^#0H@.(" @.(" @.
M(" @.(" @.(" @.(" @.(" @./')D.D1E9F%U;'1.86UE/D1A=&4\+W)D.D1E9F%U
M;'1.86UE/@.T*(" @.(" @.(" @.(" @.(" @.(" @.(" @.(#Q#86Y'<F]W/G1R=64\
M+T-A;D=R;W<^#0H@.(" @.(" @.(" @.(" @.(" @.(" @.(" @./%9A;'5E/CU&:65L
M9',A1&%T92Y686QU93PO5F%L=64^#0H@.(" @.(" @.(" @.(" @.(" @.(" @.(#PO
M5&5X=&)O>#X-"B @.(" @.(" @.(" @.(" @.(" @.(#PO4F5P;W)T271E;7,^#0H@.
M(" @.(" @.(" @.(" @.(" @./"]486)L94-E;&P^#0H@.(" @.(" @.(" @.(" @.(" @.
M/%1A8FQE0V5L;#X-"B @.(" @.(" @.(" @.(" @.(" @.(#Q297!O<G1)=&5M<SX-
M"B @.(" @.(" @.(" @.(" @.(" @.(" @./%1E>'1B;W@.@.3F%M93TB1&%T95\Q(CX-
M"B @.(" @.(" @.(" @.(" @.(" @.(" @.(" \4W1Y;&4^#0H@.(" @.(" @.(" @.(" @.
M(" @.(" @.(" @.(" \4&%D9&EN9TQE9G0^,G!T/"]0861D:6YG3&5F=#X-"B @.
M(" @.(" @.(" @.(" @.(" @.(" @.(" @.(#Q497AT06QI9VX^3&5F=#PO5&5X=$%L
M:6=N/@.T*(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" @./%!A9&1I;F=";W1T;VT^
M,G!T/"]0861D:6YG0F]T=&]M/@.T*(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" @.
M/%!A9&1I;F=4;W ^,G!T/"]0861D:6YG5&]P/@.T*(" @.(" @.(" @.(" @.(" @.
M(" @.(" @.(" @./%!A9&1I;F=2:6=H=#XR<'0\+U!A9&1I;F=2:6=H=#X-"B @.
M(" @.(" @.(" @.(" @.(" @.(" @.(" \+U-T>6QE/@.T*(" @.(" @.(" @.(" @.(" @.
M(" @.(" @.(#QR9#I$969A=6QT3F%M93Y$871E7S$\+W)D.D1E9F%U;'1.86UE
M/@.T*(" @.(" @.(" @.(" @.(" @.(" @.(" @.(#Q#86Y'<F]W/G1R=64\+T-A;D=R
M;W<^#0H@.(" @.(" @.(" @.(" @.(" @.(" @.(" @./%9A;'5E/CU&;W)M870H1FEE
M;&1S(41A=&4N5F%L=64L(")-+V0O>7EY>2(I("9A;7 [('9B3F5W;&EN92 F
M86UP.R!&;W)M870H1FEE;&1S(41A=&4N5F%L=64L(")H.FUM('1T(BD\+U9A
M;'5E/@.T*(" @.(" @.(" @.(" @.(" @.(" @.(" \+U1E>'1B;W@.^#0H@.(" @.(" @.
M(" @.(" @.(" @.(" \+U)E<&]R=$ET96US/@.T*(" @.(" @.(" @.(" @.(" @.(#PO
M5&%B;&5#96QL/@.T*(" @.(" @.(" @.(" @.(" \+U1A8FQE0V5L;',^#0H@.(" @.
M(" @.(" @.(" \+U1A8FQE4F]W/@.T*(" @.(" @.(" @.(#PO5&%B;&52;W=S/@.T*
M(" @.(" @.(" \+T1E=&%I;',^#0H@.(" @.(" @.(#Q$871A4V5T3F%M93Y$871A
M4V5T,3PO1&%T85-E=$YA;64^#0H@.(" @.(" @.(#Q4;W ^,"XU:6X\+U1O<#X-
M"B @.(" @.(" @./%=I9'1H/C0N,S,S,S-I;CPO5VED=&@.^#0H@.(" @.(" @.(#Q&
M;V]T97(^#0H@.(" @.(" @.(" @./%1A8FQE4F]W<SX-"B @.(" @.(" @.(" @.(#Q4
M86)L95)O=SX-"B @.(" @.(" @.(" @.(" @./$AE:6=H=#XP+C(U:6X\+TAE:6=H
M=#X-"B @.(" @.(" @.(" @.(" @./%1A8FQE0V5L;',^#0H@.(" @.(" @.(" @.(" @.
M(" @./%1A8FQE0V5L;#X-"B @.(" @.(" @.(" @.(" @.(" @.(#Q297!O<G1)=&5M
M<SX-"B @.(" @.(" @.(" @.(" @.(" @.(" @./%1E>'1B;W@.@.3F%M93TB=&5X=&)O
M>#<B/@.T*(" @.(" @.(" @.(" @.(" @.(" @.(" @.(#Q3='EL93X-"B @.(" @.(" @.
M(" @.(" @.(" @.(" @.(" @.(#Q0861D:6YG3&5F=#XR<'0\+U!A9&1I;F=,969T
M/@.T*(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" @./%!A9&1I;F=";W1T;VT^,G!T
M/"]0861D:6YG0F]T=&]M/@.T*(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" @./%!A
M9&1I;F=4;W ^,G!T/"]0861D:6YG5&]P/@.T*(" @.(" @.(" @.(" @.(" @.(" @.
M(" @.(" @./%!A9&1I;F=2:6=H=#XR<'0\+U!A9&1I;F=2:6=H=#X-"B @.(" @.
M(" @.(" @.(" @.(" @.(" @.(" \+U-T>6QE/@.T*(" @.(" @.(" @.(" @.(" @.(" @.
M(" @.(#Q:26YD97@.^,SPO6DEN9&5X/@.T*(" @.(" @.(" @.(" @.(" @.(" @.(" @.
M(#QR9#I$969A=6QT3F%M93YT97AT8F]X-SPO<F0Z1&5F875L=$YA;64^#0H@.
M(" @.(" @.(" @.(" @.(" @.(" @.(" @./$-A;D=R;W<^=')U93PO0V%N1W)O=SX-
M"B @.(" @.(" @.(" @.(" @.(" @.(" @.(" \5F%L=64@.+SX-"B @.(" @.(" @.(" @.
M(" @.(" @.(" @./"]497AT8F]X/@.T*(" @.(" @.(" @.(" @.(" @.(" @./"]297!O
M<G1)=&5M<SX-"B @.(" @.(" @.(" @.(" @.(" \+U1A8FQE0V5L;#X-"B @.(" @.
M(" @.(" @.(" @.(" \5&%B;&5#96QL/@.T*(" @.(" @.(" @.(" @.(" @.(" @./%)E
M<&]R=$ET96US/@.T*(" @.(" @.(" @.(" @.(" @.(" @.(" \5&5X=&)O>"!.86UE
M/2)T97AT8F]X."(^#0H@.(" @.(" @.(" @.(" @.(" @.(" @.(" @./%-T>6QE/@.T*
M(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" @./%!A9&1I;F=,969T/C)P=#PO4&%D
M9&EN9TQE9G0^#0H@.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" \4&%D9&EN9T)O
M='1O;3XR<'0\+U!A9&1I;F=";W1T;VT^#0H@.(" @.(" @.(" @.(" @.(" @.(" @.
M(" @.(" \4&%D9&EN9U1O<#XR<'0\+U!A9&1I;F=4;W ^#0H@.(" @.(" @.(" @.
M(" @.(" @.(" @.(" @.(" \4&%D9&EN9U)I9VAT/C)P=#PO4&%D9&EN9U)I9VAT
M/@.T*(" @.(" @.(" @.(" @.(" @.(" @.(" @.(#PO4W1Y;&4^#0H@.(" @.(" @.(" @.
M(" @.(" @.(" @.(" @./%I);F1E>#XR/"]:26YD97@.^#0H@.(" @.(" @.(" @.(" @.
M(" @.(" @.(" @./')D.D1E9F%U;'1.86UE/G1E>'1B;W@.X/"]R9#I$969A=6QT
M3F%M93X-"B @.(" @.(" @.(" @.(" @.(" @.(" @.(" \0V%N1W)O=SYT<G5E/"]#
M86Y'<F]W/@.T*(" @.(" @.(" @.(" @.(" @.(" @.(" @.(#Q686QU92 O/@.T*(" @.
M(" @.(" @.(" @.(" @.(" @.(" \+U1E>'1B;W@.^#0H@.(" @.(" @.(" @.(" @.(" @.
M(" \+U)E<&]R=$ET96US/@.T*(" @.(" @.(" @.(" @.(" @.(#PO5&%B;&5#96QL
M/@.T*(" @.(" @.(" @.(" @.(" \+U1A8FQE0V5L;',^#0H@.(" @.(" @.(" @.(" \
M+U1A8FQE4F]W/@.T*(" @.(" @.(" @.(#PO5&%B;&52;W=S/@.T*(" @.(" @.(" \
M+T9O;W1E<CX-"B @.(" @.(" @./$QE9G0^,2XQ,C5I;CPO3&5F=#X-"B @.(" @.
M(" @./%1A8FQE0V]L=6UN<SX-"B @.(" @.(" @.(" \5&%B;&5#;VQU;6X^#0H@.
M(" @.(" @.(" @.(" \5VED=&@.^,BXQ-C8V-VEN/"]7:61T:#X-"B @.(" @.(" @.
M(" \+U1A8FQE0V]L=6UN/@.T*(" @.(" @.(" @.(#Q486)L94-O;'5M;CX-"B @.
M(" @.(" @.(" @.(#Q7:61T:#XR+C$V-C8W:6X\+U=I9'1H/@.T*(" @.(" @.(" @.
M(#PO5&%B;&5#;VQU;6X^#0H@.(" @.(" @.(#PO5&%B;&5#;VQU;6YS/@.T*(" @.
M(" @./"]486)L93X-"B @.(" \+U)E<&]R=$ET96US/@.T*(" @.(#Q3='EL92 O
M/@.T*(" @.(#Q(96EG:'0^,FEN/"](96EG:'0^#0H@.(#PO0F]D>3X-"B @./%1O
M<$UA<F=I;CXQ:6X\+U1O<$UA<F=I;CX-"B @./$1A=&%3;W5R8V5S/@.T*(" @.
M(#Q$871A4V]U<F-E($YA;64](E-K>5-C:&5D=6QE<B(^#0H@.(" @.(" \<F0Z
M1&%T85-O=7)C94E$/C8V,3=A8F9E+6)E8F0M-#EA92UA,S8U+30Q-V%B,S0Y
M8S<T.#PO<F0Z1&%T85-O=7)C94E$/@.T*(" @.(" @./$1A=&%3;W5R8V52969E
M<F5N8V4^4VMY4V-H961U;&5R/"]$871A4V]U<F-E4F5F97)E;F-E/@.T*(" @.
M(#PO1&%T85-O=7)C93X-"B @./"]$871A4V]U<F-E<SX-"B @./%=I9'1H/C8N
M-6EN/"]7:61T:#X-"B @./$1A=&%3971S/@.T*(" @.(#Q$871A4V5T($YA;64]
M(D1A=&%3970Q(CX-"B @.(" @.(#Q&:65L9',^#0H@.(" @.(" @.(#Q&:65L9"!.
M86UE/2)$871E(CX-"B @.(" @.(" @.(" \1&%T849I96QD/D1A=&4\+T1A=&%&
M:65L9#X-"B @.(" @.(" @.(" \<F0Z5'EP94YA;64^4WES=&5M+D1A=&54:6UE
M/"]R9#I4>7!E3F%M93X-"B @.(" @.(" @./"]&:65L9#X-"B @.(" @.(#PO1FEE
M;&1S/@.T*(" @.(" @./%%U97)Y/@.T*(" @.(" @.(" \1&%T85-O=7)C94YA;64^
M4VMY4V-H961U;&5R/"]$871A4V]U<F-E3F%M93X-"B @.(" @.(" @./$-O;6UA
M;F1497AT/E-%3$5#5"!#3TY615)4*'-M86QL9&%T971I;64L("<Q+S$O,C P
M," S.C P<&TG*2!!4R!$871E/"]#;VUM86YD5&5X=#X-"B @.(" @.(" @./')D
M.E5S94=E;F5R:6-$97-I9VYE<CYT<G5E/"]R9#I5<V5'96YE<FEC1&5S:6=N
M97(^#0H@.(" @.(" \+U%U97)Y/@.T*(" @.(#PO1&%T85-E=#X-"B @./"]$871A
M4V5T<SX-"B @./$QE9G1-87)G:6X^,6EN/"],969T36%R9VEN/@.T*(" \<F0Z
M4VYA<%1O1W)I9#YT<G5E/"]R9#I3;F%P5&]'<FED/@.T*(" \<F0Z1')A=T=R
M:60^=')U93PO<F0Z1')A=T=R:60^#0H@.(#QR9#I297!O<G1)1#XV8SDY-S=C
M8RTW,C@.S+30Q-F(M83$P-RTV-60Y.&$P8SAD9#(\+W)D.E)E<&]R=$E$/@.T*
M(" \0F]T=&]M36%R9VEN/C%I;CPO0F]T=&]M36%R9VEN/@.T*(" \3&%N9W5A
>9V4^96XM55,\+TQA;F=U86=E/@.T*/"]297!O<G0^
`
end|||Ravi,
Did you get a chance to look at the example I posted?
Michael Carr
"Michael Carr" <mcarr@.umich.edu> wrote in message
news:uBDHDenfEHA.3676@.TK2MSFTNGP12.phx.gbl...
> Ravi,
> Please see the report below (and attached) for an example. Note that this
> renders correctly in the Report Editor Preview, but does not render
> correctly in the Report Manager.|||I will look into this today.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Michael Carr" <mcarr@.umich.edu> wrote in message
news:eOjzh9ShEHA.3864@.TK2MSFTNGP10.phx.gbl...
> Ravi,
> Did you get a chance to look at the example I posted?
> Michael Carr
> "Michael Carr" <mcarr@.umich.edu> wrote in message
> news:uBDHDenfEHA.3676@.TK2MSFTNGP12.phx.gbl...
> > Ravi,
> >
> > Please see the report below (and attached) for an example. Note that
this
> > renders correctly in the Report Editor Preview, but does not render
> > correctly in the Report Manager.
>|||I have logged this as a bug in HTML renderer which may be fixed in a future
release. Thanks for reporting this issue.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ravi Mumulla (Microsoft)" <ravimu@.online.microsoft.com> wrote in message
news:OXh8fEThEHA.3916@.TK2MSFTNGP11.phx.gbl...
> I will look into this today.
> --
> Ravi Mumulla (Microsoft)
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Michael Carr" <mcarr@.umich.edu> wrote in message
> news:eOjzh9ShEHA.3864@.TK2MSFTNGP10.phx.gbl...
> > Ravi,
> >
> > Did you get a chance to look at the example I posted?
> >
> > Michael Carr
> >
> > "Michael Carr" <mcarr@.umich.edu> wrote in message
> > news:uBDHDenfEHA.3676@.TK2MSFTNGP12.phx.gbl...
> > > Ravi,
> > >
> > > Please see the report below (and attached) for an example. Note that
> this
> > > renders correctly in the Report Editor Preview, but does not render
> > > correctly in the Report Manager.
> >
> >
>
NewLine and Carriage return issue in PDF format
If I insert the following expression in a textbox it will display
correctly in HTML format but not in PDF format. Can anyone show me how
to accomplish the same thing so that it will display correctly in both
HTML and and PDF format.
vbCrLf & vbCrLf & vbCrLf & "My Text"
In HTML format, it will display "My Text" on the 4th "row". Whereas in
PDF format, it displays "My Text" on the first row of the textbox.This has to be an issue (bug) with PDF and how it formats initial blank
space before the literal text. I am not sure if this is addressed in a
service pack for 2000 or in 2005 (I am using 2000 to test this) but here is
a workaround that I found that places an ASCII record seperator in the first
position before the CRLF's as:
=CHR(30)&vbCrLf & vbCrLf & vbCrLf & "My Text"
That should work.
Rodney Landrum
<Nergock@.gmail.com> wrote in message
news:1143588675.322590.215140@.u72g2000cwu.googlegroups.com...
> If I insert the following expression in a textbox it will display
> correctly in HTML format but not in PDF format. Can anyone show me how
> to accomplish the same thing so that it will display correctly in both
> HTML and and PDF format.
> vbCrLf & vbCrLf & vbCrLf & "My Text"
> In HTML format, it will display "My Text" on the 4th "row". Whereas in
> PDF format, it displays "My Text" on the first row of the textbox.
>
correctly in HTML format but not in PDF format. Can anyone show me how
to accomplish the same thing so that it will display correctly in both
HTML and and PDF format.
vbCrLf & vbCrLf & vbCrLf & "My Text"
In HTML format, it will display "My Text" on the 4th "row". Whereas in
PDF format, it displays "My Text" on the first row of the textbox.This has to be an issue (bug) with PDF and how it formats initial blank
space before the literal text. I am not sure if this is addressed in a
service pack for 2000 or in 2005 (I am using 2000 to test this) but here is
a workaround that I found that places an ASCII record seperator in the first
position before the CRLF's as:
=CHR(30)&vbCrLf & vbCrLf & vbCrLf & "My Text"
That should work.
Rodney Landrum
<Nergock@.gmail.com> wrote in message
news:1143588675.322590.215140@.u72g2000cwu.googlegroups.com...
> If I insert the following expression in a textbox it will display
> correctly in HTML format but not in PDF format. Can anyone show me how
> to accomplish the same thing so that it will display correctly in both
> HTML and and PDF format.
> vbCrLf & vbCrLf & vbCrLf & "My Text"
> In HTML format, it will display "My Text" on the 4th "row". Whereas in
> PDF format, it displays "My Text" on the first row of the textbox.
>
Subscribe to:
Posts (Atom)