Report window and 2-up labels

When I run a multi-column report like labels, the preview does not look like
the labels actually print. Is there a method/property or something that can
make the preview look similar to the actual printed output when printing a
multi-column report? Thanks.
DavidOn Nov 16, 9:47 am, "David C" <dlch...@.lifetimeinc.com> wrote:
> When I run a multi-column report like labels, the preview does not look like
> the labels actually print. Is there a method/property or something that can
> make the preview look similar to the actual printed output when printing a
> multi-column report? Thanks.
> David
I'm not sure if this will help; however, you could try placing the
controls that are being used into a single rectangle control or adjust
your column spacing (by right-clicking Column 2 and select
Properties). Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||On Nov 16, 10:47 am, "David C" <dlch...@.lifetimeinc.com> wrote:
> When I run a multi-column report like labels, the preview does not look like
> the labels actually print. Is there a method/property or something that can
> make the preview look similar to the actual printed output when printing a
> multi-column report? Thanks.
> David
David,
I don't think there's a way to get Preview to look like the printed
output straight-a-way as what you're seeing in preview is the HTML
rendering of the xml code. However, once you're in Preview you can
click on the Print Layout button (right next to the Print button) to
give you a rendering of the page as it will print. Once you change to
this view, it'll stay that way as you flip back and forth from Preview
to Layout.
HTH
toolman

Report Viewer - Export to PDF - Problem in strikethrough font

Hi,

I used a textbox with strikethrough font in my report. In preview, the report has that font and also in Print. But exporting to PDF has no strikethrough font. (Export to excel has this font). Can anybody help to resolve this.

Thanks in advance.

The PDF renderer does not currently support the strikethrough style on fonts.

Donovan

Report Timeout

I have designed a report that hits a large table of over a million rows. The report runs in the development environment as a preview. When deployed, the report runs about 1.5 hours and then returns an error. The report is set not to timeout. What could be causing this behavior?What error is being returned?
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"DJP" <DJP@.discussions.microsoft.com> wrote in message
news:D8468C56-4D72-47FB-AA76-9A82D8A9CDAC@.microsoft.com...
> I have designed a report that hits a large table of over a million rows.
The report runs in the development environment as a preview. When deployed,
the report runs about 1.5 hours and then returns an error. The report is
set not to timeout. What could be causing this behavior?|||The page displayed is: The page cannot be displayed
"Bruce Johnson [MSFT]" wrote:
> What error is being returned?
> --
> Bruce Johnson [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "DJP" <DJP@.discussions.microsoft.com> wrote in message
> news:D8468C56-4D72-47FB-AA76-9A82D8A9CDAC@.microsoft.com...
> > I have designed a report that hits a large table of over a million rows.
> The report runs in the development environment as a preview. When deployed,
> the report runs about 1.5 hours and then returns an error. The report is
> set not to timeout. What could be causing this behavior?
>
>

report starts processing immediately

Hello,
my report starts processing immediately when I switch to preview window in
VS (or click on it in the Web Browser).
I know it's because it has some string parameters (with list of available
values and default value defined) & 2 datetime parameters that allow null
values. When I remove default values or uncheck "allow null value" the
report waits untill I specify params. I suppose it is not convenient to work
with. Happily, my report calculates fast.
Are you going to fix this in the future releases?fix what?
This isn't desired behavior?
"Lesha Akulinin" <leshaakulinin@.mail.ru> wrote in message
news:ew9ITm$bEHA.2812@.TK2MSFTNGP11.phx.gbl...
> Hello,
> my report starts processing immediately when I switch to preview window in
> VS (or click on it in the Web Browser).
> I know it's because it has some string parameters (with list of available
> values and default value defined) & 2 datetime parameters that allow null
> values. When I remove default values or uncheck "allow null value" the
> report waits untill I specify params. I suppose it is not convenient to
work
> with. Happily, my report calculates fast.
> Are you going to fix this in the future releases?
>|||Ok, suppose, I want a report that can be for the last week, last month or
any other period that the user can specify (the fisrt two options is for
subscription). I'm creating 3 params: period type (last week, last month,
other) and two datetime parameters -- start date, end date (checking "allow
null value" to use them in subscriptions. Did I do anything wrong? May be
there is a better way?
"G" <brian.grant@.si-intl-kc.com> ñîîáùèë/ñîîáùèëà â íîâîñòÿõ ñëåäóþùåå:
news:OxrbQu$bEHA.808@.tk2msftngp13.phx.gbl...
> fix what?
> This isn't desired behavior?
>
> "Lesha Akulinin" <leshaakulinin@.mail.ru> wrote in message
> news:ew9ITm$bEHA.2812@.TK2MSFTNGP11.phx.gbl...
> > Hello,
> >
> > my report starts processing immediately when I switch to preview window
in
> > VS (or click on it in the Web Browser).
> >
> > I know it's because it has some string parameters (with list of
available
> > values and default value defined) & 2 datetime parameters that allow
null
> > values. When I remove default values or uncheck "allow null value" the
> > report waits untill I specify params. I suppose it is not convenient to
> work
> > with. Happily, my report calculates fast.
> >
> > Are you going to fix this in the future releases?
> >
> >
>|||I too have seen this behavior and agree that it is not the best. Just
because I have assigned defaults to the parameters does not mean I want it
to execute without any intervention on the users part. They should need to
click, hit enter. I.e. they should have to do the same thing they do after
selecting a parameter for the report to run. So, I did as you did. I leave
at least one report without a default so it waits for user interaction
before running.
Bruce L-C
"Lesha Akulinin" <leshaakulinin@.mail.ru> wrote in message
news:e0e%23mJAcEHA.3300@.TK2MSFTNGP09.phx.gbl...
> Ok, suppose, I want a report that can be for the last week, last month or
> any other period that the user can specify (the fisrt two options is for
> subscription). I'm creating 3 params: period type (last week, last month,
> other) and two datetime parameters -- start date, end date (checking
"allow
> null value" to use them in subscriptions. Did I do anything wrong? May be
> there is a better way?
> "G" <brian.grant@.si-intl-kc.com> ñîîáùèë/ñîîáùèëà â íîâîñòÿõ ñëåäóþùåå:
> news:OxrbQu$bEHA.808@.tk2msftngp13.phx.gbl...
> > fix what?
> >
> > This isn't desired behavior?
> >
> >
> > "Lesha Akulinin" <leshaakulinin@.mail.ru> wrote in message
> > news:ew9ITm$bEHA.2812@.TK2MSFTNGP11.phx.gbl...
> > > Hello,
> > >
> > > my report starts processing immediately when I switch to preview
window
> in
> > > VS (or click on it in the Web Browser).
> > >
> > > I know it's because it has some string parameters (with list of
> available
> > > values and default value defined) & 2 datetime parameters that allow
> null
> > > values. When I remove default values or uncheck "allow null value" the
> > > report waits untill I specify params. I suppose it is not convenient
to
> > work
> > > with. Happily, my report calculates fast.
> > >
> > > Are you going to fix this in the future releases?
> > >
> > >
> >
> >
>|||It would be good to have an option to execute the report automatically
or not when the parameters are all valid.
In my case - after the user has selected all the parameters, he still
has to click 'view report' in the browser. I wish I could set it that
any parameter he changes, as long they are valid... execute the query.
My queries are small.. and go to OLAP... so are very quick.
People like to see action without much effort!!
And of course - sometimes it is better to click the view report -
specially if the query is large...

Report shows fine on pop-up preview window yet gives error when viewed in report server

My Report shows fine on pop-up preview window yet gives error when
viewed in report server
I believe that the pop-up window simulates the report server , my
report is fine in th epop up window, yet it breaks in the report
server, my config files are all the same, i made sure they are all
alike.
My report uses a custom assembly that refernces a sharepoint.dll
the custom assembly is strong named and is already in the GAC
i have given the custom assembly permissions and put permissions in
method level
[permissionset(blah blah)]
public string function()
{}
I mean what's wrong in this world'
I even gave FullTrust on the AllMembershipCondition, yet it didn't
work.!!! what the heck'I have the same problem...did you get this working?
Thanks,
Gary
"third.kill@.gmail.com" wrote:
> My Report shows fine on pop-up preview window yet gives error when
> viewed in report server
>
> I believe that the pop-up window simulates the report server , my
> report is fine in th epop up window, yet it breaks in the report
> server, my config files are all the same, i made sure they are all
> alike.
> My report uses a custom assembly that refernces a sharepoint.dll
> the custom assembly is strong named and is already in the GAC
> i have given the custom assembly permissions and put permissions in
> method level
> [permissionset(blah blah)]
> public string function()
> {}
> I mean what's wrong in this world'
> I even gave FullTrust on the AllMembershipCondition, yet it didn't
> work.!!! what the heck'
>

Report show "#Error" on Pop Preview Window in Reporting Services (please reply me urge

i am using Assembly in RDL report. i add the reference of the assembly in report. and take a instance of assembly in report properties -> code tab.

and in text box expression in get the value from assembly.

when i click the report preview tab. its run fine and display my desired result.

but when i run the project for pressing the F5. it show "#Error" on Sepecified textbox.

i have assign rights to assembly for modify the two files "rssrvpolicy.config" and "rspreviewpolicy.config".

ihave write the code group in both files is written below:

<CodeGroup

class="UnionCodeGroup"

version="1"

PermissionSetName="FullTrust" Name="MyCustomCodeGroup"

Description="Code gorup for my custom extension">

<IMembershipCondition

class="UrlMembershipCondition"

version="1"

Url="\\great-t2\C$\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\bin\HudReport_Assembly.dll"

/>

</CodeGroup>

any one suggest me how can i preview my desired result from running the project.

please reply me a soon as possibly

Regards,

Ali Ahmad

aliahmad wrote:

:(( i am very disappointed that no one reply me on this problem. so i think i apply this problem on other forums.

i am using Assembly in RDL report. i add the reference of the assembly in report. and take a instance of assembly in report properties -> code tab.

and in text box expression in get the value from assembly.

when i click the report preview tab. its run fine and display my desired result.

but when i run the project for pressing the F5. it show "#Error" on Sepecified textbox.

i have assign rights to assembly for modify the two files "rssrvpolicy.config" and "rspreviewpolicy.config".

ihave write the code group in both files is written below:

<CodeGroup

class="UnionCodeGroup"

version="1"

PermissionSetName="FullTrust" Name="MyCustomCodeGroup"

Description="Code gorup for my custom extension">

<IMembershipCondition

class="UrlMembershipCondition"

version="1"

Url="\\great-t2\C$\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\bin\HudReport_Assembly.dll"

/>

</CodeGroup>

any one suggest me how can i preview my desired result from running the project.

please reply me a soon as possibly

Regards,

Ali Ahmad

Report show "#Error" on Pop Preview Window in Reporting Services (please reply me

i am using Assembly in RDL report. i add the reference of the assembly in report. and take a instance of assembly in report properties -> code tab.

and in text box expression in get the value from assembly.

when i click the report preview tab. its run fine and display my desired result.

but when i run the project for pressing the F5. it show "#Error" on Sepecified textbox.

i have assign rights to assembly for modify the two files "rssrvpolicy.config" and "rspreviewpolicy.config".

ihave write the code group in both files is written below:

<CodeGroup

class="UnionCodeGroup"

version="1"

PermissionSetName="FullTrust" Name="MyCustomCodeGroup"

Description="Code gorup for my custom extension">

<IMembershipCondition

class="UrlMembershipCondition"

version="1"

Url="\\great-t2\C$\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\bin\HudReport_Assembly.dll"

/>

</CodeGroup>

any one suggest me how can i preview my desired result from running the project.

please reply me a soon as possibly

Regards,

Ali Ahmad

aliahmad wrote:

:(( i am very disappointed that no one reply me on this problem. so i think i apply this problem on other forums.

i am using Assembly in RDL report. i add the reference of the assembly in report. and take a instance of assembly in report properties -> code tab.

and in text box expression in get the value from assembly.

when i click the report preview tab. its run fine and display my desired result.

but when i run the project for pressing the F5. it show "#Error" on Sepecified textbox.

i have assign rights to assembly for modify the two files "rssrvpolicy.config" and "rspreviewpolicy.config".

ihave write the code group in both files is written below:

<CodeGroup

class="UnionCodeGroup"

version="1"

PermissionSetName="FullTrust" Name="MyCustomCodeGroup"

Description="Code gorup for my custom extension">

<IMembershipCondition

class="UrlMembershipCondition"

version="1"

Url="\\great-t2\C$\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\bin\HudReport_Assembly.dll"

/>

</CodeGroup>

any one suggest me how can i preview my desired result from running the project.

please reply me a soon as possibly

Regards,

Ali Ahmad

Report server viewer renders incorrectly but exporting yields correct output!

I have a rather complicated report with lots and lots of textbox and line controls. When I preview the report on the Report Server the layout is all kinds of skewed and all kinds of stuff is out of place. But when I export the report to PDF or TIFF, the output reverts to it's proper form. Why is it doing this? Is there anything that I can do to not make it so ugly when previewing?

Does it seem like there are line feeds where there really shouldn't be? Try changing the width of your report.

|||

The line controls have been an issue for me. In my layout I have a couple of lines that extend past where they would logically go then when I previewed in VS the line would be well short of where I wanted, and then when I exported out to PDF it rendered fine. Now I am loading the reports onto a Report Server and getting an even crazier preview output.

Report Server problem

I am using SQL Server 2000 reporting services.I created a report in VS.net 2003.Report is showing in preview pane properly.But when i press start it gives a messege "No Reprot Server was found at http://localhost/ReprotServer".
Is reprot server required for the reprot.whats other alternative to show the report on web browser?

Hi,

By default, the reportserver's URL is http://localhost/reportserver.
When installing reporting services on a named instance this will be http://localhost/reportserver$instancename.

First check in your IIS what the exact name of the reportserver is. Also check that IIS is started. Try to open the reportservice.asmx file.

If this works, check the reportserver path in the Project Properties. Make sure it is the same as in your IIS.

Greetz,

Geert

Geert Verhoeven
Consultant @. Ausy Belgium

My Personal Blog

|||

Hi Geert,

Thanks! for your reply..

Here the problem is that report server component is not installed on my computer.Also

during installation this component is not showing in the list, only client component is showing and get

installed.Although I have IIS, SqlServer 2000 and framework 1.1 installed properly.I am unable to find how to install report server

and report manager.

pls help me out...

Thanks again!!

|||

Hi,

Wich Service Pack does your SQL Server has? In able to run Reporting Services on SQL Server 2000, you must at least have SP3 installed.

Also, the reporting server must be installed separately. Although, it is licensed with your existing SQL Server.

Greetz,

Geert

Geert Verhoeven
Consultant @. Ausy Belgium

My Personal Blog

|||

Hi Geert,

Thanks! for the support...

Now the server component is showing with report server.But after installation it gives error messege

'The ReportServer windows service can not start.You do not have sufficient privilege'. ans the it rollback the installation.

Although i am logged in as local system account.

i also read somewhere on net that Use of the Local Service account for the ReportServer Windows service is not supported.

i am not on any domain.pls suggest me what to do.

thanks

|||

Hi,

The account that you specified in the setup must have the rights to run a service (Logon as a service permission). This can be set in the windows policy. Maybe that this is not set. I know that for 2005, the setup gives the necessary permissions but for 2000 it can be that you need to do this manually.

Greetz,

Geert

Geert Verhoeven
Consultant @. Ausy Belgium

My Personal Blog

|||Thanks Geert!!.. its installed successfully...

Report runs in preview in VS.net 2003, but not on Report server

I have a report which I have published to my Report server (sql 2000 on
windows 2003). This report runs from my VS.net developers edition preview
page, but once I publish it to my Sql reporting services report server, it
will not run - there is a long delay, then I recieve repeated prompts for
username and password, and then failure.
I am logged in as the same user as on my vs.net.
I have a number of other reports that run correctly on both my development
system and on the report server. I just can not figure out what I have
different in this report or datasource that is causing this issue.
If anyone can help me figure out what permissions I have messed up. I would
appreciate it.
Fred ZilzWhen you run Report as preview in VS.NET, the Report Server is not involved.
So, the preview running fine means you do not have problem to get data (if
the database reeqires logging in).
Therefore, your problem could be that your account cannot log into report
server (do not confuse it with database server, although both may use the
same SQL Server). You could use Report Manager to go to the folder where the
report is deployed, click Properties->Security to see who is allowsed to
browse reports in that folder.
"Fredrick A. Zilz" <fzilz@.NOSPAM.interhealthusa.com> wrote in message
news:uaypGQvPFHA.2584@.TK2MSFTNGP15.phx.gbl...
> I have a report which I have published to my Report server (sql 2000 on
> windows 2003). This report runs from my VS.net developers edition preview
> page, but once I publish it to my Sql reporting services report server, it
> will not run - there is a long delay, then I recieve repeated prompts for
> username and password, and then failure.
> I am logged in as the same user as on my vs.net.
> I have a number of other reports that run correctly on both my development
> system and on the report server. I just can not figure out what I have
> different in this report or datasource that is causing this issue.
> If anyone can help me figure out what permissions I have messed up. I
would
> appreciate it.
> Fred Zilz
>|||I have found that the designer and the server handle credentials differently,
are you storing your credentials in the connection string by any chance?
"Fredrick A. Zilz" wrote:
> I have a report which I have published to my Report server (sql 2000 on
> windows 2003). This report runs from my VS.net developers edition preview
> page, but once I publish it to my Sql reporting services report server, it
> will not run - there is a long delay, then I recieve repeated prompts for
> username and password, and then failure.
> I am logged in as the same user as on my vs.net.
> I have a number of other reports that run correctly on both my development
> system and on the report server. I just can not figure out what I have
> different in this report or datasource that is causing this issue.
> If anyone can help me figure out what permissions I have messed up. I would
> appreciate it.
> Fred Zilz
>
>|||Yes, I am storing credentials in the connection string.
"Dan" <Dan@.discussions.microsoft.com> wrote in message
news:D2F58AB1-CB8D-4A6F-BCB2-1D5BF664D58F@.microsoft.com...
>I have found that the designer and the server handle credentials
>differently,
> are you storing your credentials in the connection string by any chance?
> "Fredrick A. Zilz" wrote:
>> I have a report which I have published to my Report server (sql 2000 on
>> windows 2003). This report runs from my VS.net developers edition
>> preview
>> page, but once I publish it to my Sql reporting services report server,
>> it
>> will not run - there is a long delay, then I recieve repeated prompts for
>> username and password, and then failure.
>> I am logged in as the same user as on my vs.net.
>> I have a number of other reports that run correctly on both my
>> development
>> system and on the report server. I just can not figure out what I have
>> different in this report or datasource that is causing this issue.
>> If anyone can help me figure out what permissions I have messed up. I
>> would
>> appreciate it.
>> Fred Zilz
>>|||For security reasons, the report designer will remove credentials from the
connection string (and therefore not store in the RDL connection string on
disk). Consequently, the published report on the server has no credentials
specified and you need to add them e.g. through report manager by updating
the data source information. Credentials specified there are stored
encrypted in the report server metadata database.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Fredrick A. Zilz" <fzilz@.NOSPAM.interhealthusa.com> wrote in message
news:ur1lQEGQFHA.1884@.TK2MSFTNGP15.phx.gbl...
> Yes, I am storing credentials in the connection string.
> "Dan" <Dan@.discussions.microsoft.com> wrote in message
> news:D2F58AB1-CB8D-4A6F-BCB2-1D5BF664D58F@.microsoft.com...
>>I have found that the designer and the server handle credentials
>>differently,
>> are you storing your credentials in the connection string by any chance?
>> "Fredrick A. Zilz" wrote:
>> I have a report which I have published to my Report server (sql 2000 on
>> windows 2003). This report runs from my VS.net developers edition
>> preview
>> page, but once I publish it to my Sql reporting services report server,
>> it
>> will not run - there is a long delay, then I recieve repeated prompts
>> for
>> username and password, and then failure.
>> I am logged in as the same user as on my vs.net.
>> I have a number of other reports that run correctly on both my
>> development
>> system and on the report server. I just can not figure out what I have
>> different in this report or datasource that is causing this issue.
>> If anyone can help me figure out what permissions I have messed up. I
>> would
>> appreciate it.
>> Fred Zilz
>>
>|||I have looked at the datasources of a report that works and one that does
not, both have the credentials stored in the metadata database both are
shared data sources, both use the same SQL credentials and both databases
are set with the credentials authorizing database permit and read
permissions. I double checked the security settings on the report server
and both shared data sources and both reports are set with the same security
settings (domain users with browser permissions)
I have tried deleting the reports and redeploying with the same results. I
just can not seem to find what is different between the reports that work
and the ones that don't. They are in fact both in the same report Solution
on my VS.net development station.
"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
news:ePJBfILQFHA.4020@.tk2msftngp13.phx.gbl...
> For security reasons, the report designer will remove credentials from the
> connection string (and therefore not store in the RDL connection string on
> disk). Consequently, the published report on the server has no credentials
> specified and you need to add them e.g. through report manager by updating
> the data source information. Credentials specified there are stored
> encrypted in the report server metadata database.
>
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Fredrick A. Zilz" <fzilz@.NOSPAM.interhealthusa.com> wrote in message
> news:ur1lQEGQFHA.1884@.TK2MSFTNGP15.phx.gbl...
>> Yes, I am storing credentials in the connection string.
>> "Dan" <Dan@.discussions.microsoft.com> wrote in message
>> news:D2F58AB1-CB8D-4A6F-BCB2-1D5BF664D58F@.microsoft.com...
>>I have found that the designer and the server handle credentials
>>differently,
>> are you storing your credentials in the connection string by any chance?
>> "Fredrick A. Zilz" wrote:
>> I have a report which I have published to my Report server (sql 2000 on
>> windows 2003). This report runs from my VS.net developers edition
>> preview
>> page, but once I publish it to my Sql reporting services report server,
>> it
>> will not run - there is a long delay, then I recieve repeated prompts
>> for
>> username and password, and then failure.
>> I am logged in as the same user as on my vs.net.
>> I have a number of other reports that run correctly on both my
>> development
>> system and on the report server. I just can not figure out what I have
>> different in this report or datasource that is causing this issue.
>> If anyone can help me figure out what permissions I have messed up. I
>> would
>> appreciate it.
>> Fred Zilz
>>
>>
>|||As a way of trouble shooting I created a new datasource in the same project
as the malfunctioning report. I created a simple report based on that data
source, but used the same connection credentials (SQL) and the same query
string. Deployed this and it works. I then set my malfunctioning report to
the new datasource redeployed and ran - same problem - long pause and then
request for credentials.
"Fredrick A. Zilz" <fzilz@.NOSPAM.interhealthusa.com> wrote in message
news:uKFtr1QQFHA.1096@.tk2msftngp13.phx.gbl...
>I have looked at the datasources of a report that works and one that does
>not, both have the credentials stored in the metadata database both are
>shared data sources, both use the same SQL credentials and both databases
>are set with the credentials authorizing database permit and read
>permissions. I double checked the security settings on the report server
>and both shared data sources and both reports are set with the same
>security settings (domain users with browser permissions)
> I have tried deleting the reports and redeploying with the same results.
> I just can not seem to find what is different between the reports that
> work and the ones that don't. They are in fact both in the same report
> Solution on my VS.net development station.
> "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
> news:ePJBfILQFHA.4020@.tk2msftngp13.phx.gbl...
>> For security reasons, the report designer will remove credentials from
>> the connection string (and therefore not store in the RDL connection
>> string on disk). Consequently, the published report on the server has no
>> credentials specified and you need to add them e.g. through report
>> manager by updating the data source information. Credentials specified
>> there are stored encrypted in the report server metadata database.
>>
>> -- Robert
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Fredrick A. Zilz" <fzilz@.NOSPAM.interhealthusa.com> wrote in message
>> news:ur1lQEGQFHA.1884@.TK2MSFTNGP15.phx.gbl...
>> Yes, I am storing credentials in the connection string.
>> "Dan" <Dan@.discussions.microsoft.com> wrote in message
>> news:D2F58AB1-CB8D-4A6F-BCB2-1D5BF664D58F@.microsoft.com...
>>I have found that the designer and the server handle credentials
>>differently,
>> are you storing your credentials in the connection string by any
>> chance?
>> "Fredrick A. Zilz" wrote:
>> I have a report which I have published to my Report server (sql 2000
>> on
>> windows 2003). This report runs from my VS.net developers edition
>> preview
>> page, but once I publish it to my Sql reporting services report
>> server, it
>> will not run - there is a long delay, then I recieve repeated prompts
>> for
>> username and password, and then failure.
>> I am logged in as the same user as on my vs.net.
>> I have a number of other reports that run correctly on both my
>> development
>> system and on the report server. I just can not figure out what I
>> have
>> different in this report or datasource that is causing this issue.
>> If anyone can help me figure out what permissions I have messed up. I
>> would
>> appreciate it.
>> Fred Zilz
>>
>>
>>
>

Report Rendering (II)

Hi,

I have been using the following code, (thanks to Shyam), to display address fields. This works great when using preview in BIDS, but the address shows on one continious line when the report is redered in Reporting Services.

=First(Fields!Name.Value) & IIf(First(Fields!Address1.Value) <> "", Chr(10) & Chr(13) & First(Fields!Address1.Value), "") &
IIf(First(Fields!Address2.Value) <> "", Chr(10) & Chr(13) & First(Fields!Address2.Value), "") &
IIf(First(Fields!Address3.Value) <> "", Chr(10) & Chr(13) & First(Fields!Address3.Value), "") &
IIf(First(Fields!Town.Value) <> "", Chr(10) & Chr(13) & First(Fields!Town.Value), "") &
IIf(First(Fields!County.Value) <> "", Chr(10) & Chr(13) & First(Fields!County.Value), "") &
IIf(First(Fields!Post_Code.Value) <> "", Chr(10) & Chr(13) & First(Fields!Post_Code.Value),

Any one any ideas?

Thanks

Did you try vbCRLF instead of chr(10) & 13?

http://blogs.infinite-x.net/category/dynamics-crm/reporting/

cheers,

Andrew