putting subscriptions and other SSRS things in SourceSafe?

There are things configured/setup in Report Manager that we would like to
version in Visual SourceSafe... the setup of data-driven subscriptions, for
instance. Has anyone done this? Does anyone know of a third-party product
that assists with this?
I'm currently thinking of writing some code to take a
ReportServer.dbo.Subscriptions record and format it as an XML file that we
can put in VSS. Can anyone think up a better idea?You have to be careful with messing with rows of the database. We may
change the database at anytime and when you try and return it to the DB it
might not be the same anymore.
You could extract the information via the SOAP interface and then create a
script that would create the subscriptions. You could then save off these
scripts and use them against any RS server.
Also, is there a reason that backing up the DB is not good enough?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"FurmanGG" <FurmanGG@.discussions.microsoft.com> wrote in message
news:E05AB1EE-5671-4106-885D-627DDB28293A@.microsoft.com...
> There are things configured/setup in Report Manager that we would like to
> version in Visual SourceSafe... the setup of data-driven subscriptions,
> for
> instance. Has anyone done this? Does anyone know of a third-party product
> that assists with this?
> I'm currently thinking of writing some code to take a
> ReportServer.dbo.Subscriptions record and format it as an XML file that we
> can put in VSS. Can anyone think up a better idea?|||Daniel-
Sorry I wasn't clear. Our intention isn't to use the XML files that we
version in SourceSafe in order to ever restore or write anything back to the
database... it's just for versioning purposes... as in "what changed when we
deployed the Apr 12 release?" and doing a diff on the March and the April 12
file versions would tell us that. If we ever had to go back... or if anyone
accidentally deleted a report (which kills all its subscriptions)... we could
open up the XML and use it as a guide for reconstructing the recipients and
query of the data driven subscription... manually and through the Report
Manager interface.
So I take it nobody has any good suggestions for third-party software or
good processes for handling this? Does anyone else have similar needs?
"Daniel Reib (MSFT)" wrote:
> You have to be careful with messing with rows of the database. We may
> change the database at anytime and when you try and return it to the DB it
> might not be the same anymore.
> You could extract the information via the SOAP interface and then create a
> script that would create the subscriptions. You could then save off these
> scripts and use them against any RS server.
> Also, is there a reason that backing up the DB is not good enough?
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "FurmanGG" <FurmanGG@.discussions.microsoft.com> wrote in message
> news:E05AB1EE-5671-4106-885D-627DDB28293A@.microsoft.com...
> > There are things configured/setup in Report Manager that we would like to
> > version in Visual SourceSafe... the setup of data-driven subscriptions,
> > for
> > instance. Has anyone done this? Does anyone know of a third-party product
> > that assists with this?
> >
> > I'm currently thinking of writing some code to take a
> > ReportServer.dbo.Subscriptions record and format it as an XML file that we
> > can put in VSS. Can anyone think up a better idea?
>
>

Push Subscription Wizard

Hello,
I am trying to setup a push subscription between two SQL 2000 Servers using
the Push Subscription Wizard through Enterprise Manager. After clicking
"Finish" at the end of the wizard, Enterprise Manager hangs at the first
step "Enabling this server as a subscriber". Can anyone help me identify
the problem, I can't see anything in the logs.
Thanks,
Ben Gibson
Ben,
additionally, you could use sp_who2 and dbcc inputbuffer(spid) as per usual
to get some more info.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Push subscription failing

SQL Server Enterprise Manager encountered errors creating push subscriptions
for the following Subscribers:
JANUS: Error 208: Invalid object name 'sysextendedarticlesview'.
The error above shows up each time that I attempt to push the subscription.
THe view sysextendedarticlesview exist in the publisher database. DOes
anybody know how to fix this thing? THanks
issue this on the subscriber in the subscription database.
create view dbo.sysextendedarticlesview
as
select * from sysarticles
union all
select artid, NULL, creation_script, NULL, description,
dest_object, NULL, NULL, NULL, name, objid, pubid,
pre_creation_cmd, status, NULL, type, NULL,
schema_option, dest_owner from sysschemaarticles
go
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Pete Ocasio" <pete.ocasio@.execupay.com> wrote in message
news:OKRoJYKsEHA.2788@.TK2MSFTNGP09.phx.gbl...
> SQL Server Enterprise Manager encountered errors creating push
subscriptions
> for the following Subscribers:
> JANUS: Error 208: Invalid object name 'sysextendedarticlesview'.
> The error above shows up each time that I attempt to push the
subscription.
> THe view sysextendedarticlesview exist in the publisher database. DOes
> anybody know how to fix this thing? THanks
>
sql

Push pdf to Report Manager from vb script

Hi.

Does anyone know how to push a pdf file to the Report Manager from a vb macro?

Basically, I want to run a vb macro and have it put the pdf file into a folder in Report Manager. Is this possible?

Greatly appreciated!

Thanks.

Any ideas?

Purging Transaction Log

I am trying to purge the logfile (ldf) for our database.
I thought I had done it in the past through Enterprise
Manager by clicking the database, selecting
AllTasks/Shrink Database and then reducing the size of the
transaction log to its minimum. The logfile is currently
150 MB. I specified to shrink it to the minimum (8 MB).
It told me that it succeeded but the size is not changing.
Is this the appropriate way to reduce the log size?
THanks,
-RobYou must back up the log if you are in Full Recovery Mode prior to
shrinking...
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Rob C" <robnocspam@.ctnosoftwarespam.com> wrote in message
news:0a4701c3bf26$c8d635d0$a401280a@.phx.gbl...
> I am trying to purge the logfile (ldf) for our database.
> I thought I had done it in the past through Enterprise
> Manager by clicking the database, selecting
> AllTasks/Shrink Database and then reducing the size of the
> transaction log to its minimum. The logfile is currently
> 150 MB. I specified to shrink it to the minimum (8 MB).
> It told me that it succeeded but the size is not changing.
> Is this the appropriate way to reduce the log size?
> THanks,
> -Rob|||Hi Rob,
Thank you for using MSDN Newsgroup! It's my pleasure to assist you with
your issue.
Our MVP, Wayne had provided a good explanation of how to shrink the log
file.
I just want to add some more information of this part.
When SQL Server finishes backing up the transaction log, it automatically
truncates the inactive portion of the transaction log. This inactive
portion contains completed transactions and so is no longer used during the
recovery process. Conversely, the active portion of the transaction log
contains transactions that are still running and have not yet completed.
SQL Server reuses this truncated, inactive space in the transaction log
instead of allowing the transaction log to continue to grow and use more
space. That is why although you use Enterprise Manager to set the log file
size, but it remains the same. You shoud backup it first to let it become
inactive.
Although the transaction log may be truncated manually, it is strongly
recommended that you do not do this, as it breaks the log backup chain.
Until a full database backup is created, the database is not protected from
media failure. Use manual log truncation only in very special
circumstances, and create a full database backup as soon as practical.
The ending point of the inactive portion of the transaction log, and hence
the truncation point, is the earliest of the following events:
1)The most recent checkpoint.
2)The start of the oldest active transaction, which is a transaction that
has not yet been committed or rolled back.
This represents the earliest point to which SQL Server would have to roll
back transactions during recovery.
3)The start of the oldest transaction that involves objects published for
replication whose changes have not been replicated yet. This represents the
earliest point that SQL Server still has to replicate.
You can refer to SQL Server Books on Line (BOL) for more information for
active portion and inactive portion of log files and some DBCC commands to
carry out log truncation by searching :
"Truncating the Transaction Log" in the BOL
I hope will be helpful to resolve your question. If you still have any
questions, please feel free to post any new message here, I am ready to
offer you further help.
Best regards
Baisong Wei
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.|||Thank you both fo you replies.
I was able to successfully shrink the log once I ran the
backup process on the transaction logfile.
I also appreciated the explanation behind it.
Regards,
-Rob
>--Original Message--
>Hi Rob,
>Thank you for using MSDN Newsgroup! It's my pleasure to
assist you with
>your issue.
>Our MVP, Wayne had provided a good explanation of how to
shrink the log
>file.
>I just want to add some more information of this part.
>When SQL Server finishes backing up the transaction log,
it automatically
>truncates the inactive portion of the transaction log.
This inactive
>portion contains completed transactions and so is no
longer used during the
>recovery process. Conversely, the active portion of the
transaction log
>contains transactions that are still running and have not
yet completed.
>SQL Server reuses this truncated, inactive space in the
transaction log
>instead of allowing the transaction log to continue to
grow and use more
>space. That is why although you use Enterprise Manager to
set the log file
>size, but it remains the same. You shoud backup it first
to let it become
>inactive.
>Although the transaction log may be truncated manually,
it is strongly
>recommended that you do not do this, as it breaks the log
backup chain.
>Until a full database backup is created, the database is
not protected from
>media failure. Use manual log truncation only in very
special
>circumstances, and create a full database backup as soon
as practical.
>The ending point of the inactive portion of the
transaction log, and hence
>the truncation point, is the earliest of the following
events:
>1)The most recent checkpoint.
>2)The start of the oldest active transaction, which is a
transaction that
>has not yet been committed or rolled back.
>This represents the earliest point to which SQL Server
would have to roll
>back transactions during recovery.
>3)The start of the oldest transaction that involves
objects published for
>replication whose changes have not been replicated yet.
This represents the
>earliest point that SQL Server still has to replicate.
>You can refer to SQL Server Books on Line (BOL) for
more information for
>active portion and inactive portion of log files and some
DBCC commands to
>carry out log truncation by searching :
>"Truncating the Transaction Log" in the BOL
>I hope will be helpful to resolve your question. If you
still have any
>questions, please feel free to post any new message here,
I am ready to
>offer you further help.
>Best regards
>Baisong Wei
>Microsoft Online Support
>----
>Get Secure! - www.microsoft.com/security
>This posting is provided "as is" with no warranties and
confers no rights.
>Please reply to newsgroups only. Thanks.
>.
>|||How does one manually truncate a transaction log?|||Hi Gayle,
Thank you for using MSDN Newsgroup!
You can manually truncate the trasaction log. Please refer to the following
article for detailed information:
http://support.microsoft.com/?id=272318
If you still have question, please post new message here and I am ready to
help!
Best regards
Baisong Wei
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.|||Thank you for replying! The drive where the transaction log resides -
drive L - ran out of space (the transaction log is 97GB). This has,
naturally, made it to where we cannot access our databases through
Enterprise Manager. When we try to open Query Analyzer, it times out
but then still shows a query window with the Master database selected,
but we cannot change from the Master to any of our application's
databases. We tried to do the following via Query Analyzer anyway:
backup database (to the S drive, which had space)
backup log with truncate_only
dbcc shrinkfile on the log file
backup database
We let it run ("Processing query batch") for an hour before we stopped
it. We assume that it didn't work because it was trying to write to
the transaction log but couldn't. Is that correct? Does SQL write
administrative queries (like backup statements) to the transaction
log? We know now what we need to do to prevent the transaction log
from outgrowing its space and we're going to try to set up an alert so
that SQL will page us when the log gets too big.
I guess what I'd like to know is, should our preventive measures fail
and the log's drive fill up again, what is the best approach to take?
Thank you for any info you can share.sql

Pull subscription creation error

Upon creating a new Pull Subscription on a Subscriber, I kept on getting
the error message "SQL Server enterprise Manager could not create a pull
subscription to publication 'XXXX' Error 14234: The specified '@.server' is
invalid(valid values are returned by sp_helpserver). Where did I go wrong
and what is the problem? Thanks.
Georgi,
you could check that the server names haven't been altered:
Use Master
go
Select @.@.Servername
This should return your current server name but if it
returns NULL then try:
Use Master
go
Sp_DropServer 'OldName'
GO
Use Master
go
Sp_Addserver 'NewName', 'local'
GO
Stop and Start SQL Services
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Thank you. I checked but both publisher and subscriber have server names
other than NULL ...
Let me explain more my situation.
I want to make replication of database over internet, i want to use VPN. I
already setuped the VPN service so it gives IP-s that are not within the
range of the local network and are fixed for the server and for the
connections.
I was trying to make push subscription because it seemed to me that it's
easier to implement. So the subscription was successefuly added , the
snapshot agent generated snapshot but then this snapshot was not
automatically applied on Subscriber and the distributor agent cried out that
"objects are missing at subscriber". I don't know how to apply the
subscription manually, i tried to change it's path via Alternate
subscription location but it didn't helped. So i abandoned the push
subscription and now i'm trying to make pull subscription. I don't know if
i'm not missing someting of the security privilegies of the logins used, or
maybe must declare the servers in Remote Servers?
I'm quite confused with all this Replication stuff, i'm still new to it.
I've looked to the Replication section in SQL Server online but i can't find
solutions of this delicate problems (maybe it's written somewhere i'm still
reading ). Can you give me link(s) to some other comprehensive sources of
information, maybe good HOWTOS?
Thank you in advance
Georgi Peshterski
"Paul Ibison" <Paul.Ibison@.pygmalion.com> wrote in message
news:eRZf%23mUjFHA.3300@.TK2MSFTNGP15.phx.gbl...
> Georgi,
> you could check that the server names haven't been altered:
> Use Master
> go
> Select @.@.Servername
> This should return your current server name but if it
> returns NULL then try:
> Use Master
> go
> Sp_DropServer 'OldName'
> GO
> Use Master
> go
> Sp_Addserver 'NewName', 'local'
> GO
> Stop and Start SQL Services
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>

Pull data from Two tables

I am new to SQL, as old as it is. I am not new to programming I
normally just use Access.

I have two tables for a little project manager I made. After updates I
sent an email to the user. I need to populate the user based on the
"Assigned To" field I use, but I only log the username and not the
email address. Is there a way to associate the "Assigned To" to the
User's account in the "User" table so that I can pull thier email
address through code?

Thanks
ChuckPlease post DDL, so that people do not have to guess what the keys,
constraints, Declarative Referential Integrity, data types, etc. in
your schema are. Sample data is also a good idea, along with clear
specifications. It is very hard to debug code when you do not let us
see it.|||Thank you for the feedback, obviously your a genius, but I do not know
what to post since I already stated I am new to this. My question was
of a theory nature, as I do not know what DRI and contraints are.

I will try to simply my question even more...

1. I have a database with two tables Case and Users
2. When I finish updating a case I want to send an email to the
currently assigned users.
3. The email address is not stated in the Case table, so I would like
to know if there is a way when I guery the database I can also pull
data from another Table.|||Hey Chuck,

What you're talking about is the guts of SQL: the JOIN. A newsgroup is
really not the best place to learn how to write SQL (from the ground
up), because it's gonna take some practice (and some background
knowledge) before you're really ready to even ask a question. There's
a couple of really good books on basic SQL out there; I'd recommend Be
Forta's Sams Teach Yourself SQL in 10 Minutes as a good primer on the
language.

Anyway, I think you might be looking at something like the following:

SELECT * --* is bad in production
FROM [CASE] c JOIN [Users] u ON c.[Assigned to] ON u.[UserName]

--note that case is a reserved word in SQL. Also, column names without
spaces are easier to manage.

Anyway, good luck on your quest.

Stu|||Ok, thought what I was thinking was more simple, but I understand that
its more of a loaded question.

Thanks for the feedback and suggestions, I will start reading up.

Chuck|||"cvillard" <cvillard@.gmail.com> wrote in message
news:1124752154.644452.160570@.f14g2000cwb.googlegr oups.com...
> Thank you for the feedback, obviously your a genius, but I do not know
> what to post since I already stated I am new to this. My question was
> of a theory nature, as I do not know what DRI and contraints are.

DRI=Data Referential Integrity.

The important part is DDL - Data Definition Language.

What we need is the script to create your tables.

Something lie

CREATE TABLE cases (
case varchar(30),
case_id int
)

CREATE TABLE email (
case_id int,
case_email varchar(30)
)

DRI would include keys to make sure you can't have a case_id in email table
that doesn't exist in table cases, that case_email has a valid form, etc.

So, now

sounds like you want something like

select e.case_email from email as e inner join cases as c on
e.case_id=c.cases_id where e.case_id = 5

> I will try to simply my question even more...
> 1. I have a database with two tables Case and Users
> 2. When I finish updating a case I want to send an email to the
> currently assigned users.
> 3. The email address is not stated in the Case table, so I would like
> to know if there is a way when I guery the database I can also pull
> data from another Table.

Puchasing only Enterprise Manager

hello!
I am interested in purchasing sql server.
Is it possible to purchase a Enterprise Manager only? So
I do not have to buy complete SQL server?
thanks,
DanielThe only thing you can DO with EM is connect and manage an existing instance
of SQL Server. This presupposes that you have already purchased a SQL
Server license. If you have a license for SQL Server you can install the
client tools (Query Analyzer, Enterprise Manager, etc...) on any number of
computers without additional licensing fees.
"Daniel Kim" <daekim_2000@.netzero.net> wrote in message
news:108901c3820b$9bcf6fa0$a001280a@.phx.gbl...
> hello!
> I am interested in purchasing sql server.
> Is it possible to purchase a Enterprise Manager only? So
> I do not have to buy complete SQL server?
> thanks,
> Daniel|||I believe this depends on if the existing license is per-processor or
per-seat.
One option would be to buy the Developer edition for $49, which comes with
the client tools.
Kevin3NF
"Don Peterson" <no1@.nunya.com> wrote in message
news:Otab9zggDHA.3616@.TK2MSFTNGP11.phx.gbl...
> The only thing you can DO with EM is connect and manage an existing
instance
> of SQL Server. This presupposes that you have already purchased a SQL
> Server license. If you have a license for SQL Server you can install the
> client tools (Query Analyzer, Enterprise Manager, etc...) on any number of
> computers without additional licensing fees.
> "Daniel Kim" <daekim_2000@.netzero.net> wrote in message
> news:108901c3820b$9bcf6fa0$a001280a@.phx.gbl...
> > hello!
> >
> > I am interested in purchasing sql server.
> > Is it possible to purchase a Enterprise Manager only? So
> > I do not have to buy complete SQL server?
> >
> > thanks,
> >
> > Daniel
>

Publishing to a remote SSL server

I've set up SQL Reports in 'https://www.projects.com/reports' and added a
reports project to a solution. I used the reports manager to add a folder in
which to deploy the reports, but can't figure out where it is on the server.
When I try to deploy a report to 'https://www.projects.com/reportserver' I
get the following error: 'A connection can not be made to the report server
https://www.projects.com/ReportServer'. Any help to do the following:
1. Set up a folder on the server to deploy the datasource and reports so I
can xcopy
2. Be able to make a connection when I attempt to deploy a report from
VS.NET.
Would be appreciated.
Thanks.
DanI resolved this problem by first installing the data source then the report.
The report runs on the local server, but any attempt to run the report or
sample reports over the internet gives the error: 'Cannot find server or DNS
Error'. I'm publishing behind ISA 2004. Any suggestions?
Thanks.
Dan
"Dan Slaby" <dls@.newsgroup.nospam> wrote in message
news:ucM%23rdOjFHA.3568@.tk2msftngp13.phx.gbl...
> I've set up SQL Reports in 'https://www.projects.com/reports' and added a
> reports project to a solution. I used the reports manager to add a folder
> in which to deploy the reports, but can't figure out where it is on the
> server. When I try to deploy a report to
> 'https://www.projects.com/reportserver' I get the following error: 'A
> connection can not be made to the report server
> https://www.projects.com/ReportServer'. Any help to do the following:
> 1. Set up a folder on the server to deploy the datasource and reports so I
> can xcopy
> 2. Be able to make a connection when I attempt to deploy a report from
> VS.NET.
> Would be appreciated.
> Thanks.
> Dan
>|||Hello,
I'd like to confirm that both report server and SQL server are behind ISA
2004.
Please note that Windows authentication is not supported via Internet
because Kerbose/NTLM authentication need open too many ports via firewall
which is not proper for security purpose.
If you want to run the report over the internet, you may need to enable
anonymous access. You need to configure via report manager to enable
Iusr_<computername> account to have the proper permission to the proper
roles such as browser/content manager etc.
I suggest that you perform the following steps to narrow down the issue:
1. Run the report internally from another client computer with anonymous
access.
If the user can run the report internally successfully with anonymous
access, you may need to check the configuration of the ISA server.
To enable Anonymous Access to work with SQL Server Reporting Services,
enable Anonymous Access under Directory Security in IIS and set the default
account to IWAM_machinename
NOTE: By default SQL Server Reporting Services uses the IWAM_machinename
account to connect.
I hope the information is helpful.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
=====================================================When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.

Publisher configuration problem

I am trying to configure a MS SQL Server 2000 named \\MSSQL_NEW as a
publisher but I keep getting this
error:
SQL Server Enterprise Manager can not configure 'MSSQL_NEW' as the
distributor for 'MSSQL_NEW'
Error 18483:
Could not connect to server 'MSSQL_NEW' because 'distributor_admin' is not
defined as a remote login at
the server.
I've verified that 'distributor_admin' exists and has sysadmin rights on the
server (MSSQL_NEW).
I noticed that when I execute, 'select @.@.servername', in QA, I get,
'MSSQL_OLD'. But my machine name is, 'MSSQL_NEW'
and name registered in EM is 'MSSQL_NEW'. Tried replacing the registration
'MSSQL_NEW' to 'MSSQL_OLD' but I get a
server does not exist or access denied error.
Will updating @.@.servername to 'MSSQL_NEW' solve my problem? How?
Any comments or suggestions will be highly appreciated. Thanks in advance.
...
Carlo,
please try this...
Use Master
go
Sp_DropServer 'MSSQL_OLD'
GO
Use Master
go
Sp_Addserver 'MSSQL_NEW', 'local'
GO
Stop and Start SQL Services
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||This is a tricky problem to solve.
I normally solve it by issuing a
sp_adddistributor and an sp_adddistributiondb procs.
These should work. Then when you go to replicate it will bomb. So disable
replication, and then re-enable it. It should work this time.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"CarloVino" <CarloVino@.discussions.microsoft.com> wrote in message
news:77815079-C1A6-477C-9794-391828479E38@.microsoft.com...
> I am trying to configure a MS SQL Server 2000 named \\MSSQL_NEW as a
> publisher but I keep getting this
> error:
> SQL Server Enterprise Manager can not configure 'MSSQL_NEW' as the
> distributor for 'MSSQL_NEW'
> Error 18483:
> Could not connect to server 'MSSQL_NEW' because 'distributor_admin' is not
> defined as a remote login at
> the server.
> I've verified that 'distributor_admin' exists and has sysadmin rights on
the
> server (MSSQL_NEW).
> I noticed that when I execute, 'select @.@.servername', in QA, I get,
> 'MSSQL_OLD'. But my machine name is, 'MSSQL_NEW'
> and name registered in EM is 'MSSQL_NEW'. Tried replacing the
registration
> 'MSSQL_NEW' to 'MSSQL_OLD' but I get a
> server does not exist or access denied error.
> Will updating @.@.servername to 'MSSQL_NEW' solve my problem? How?
> Any comments or suggestions will be highly appreciated. Thanks in
advance.
> --
> ...

Published Report Not Showing Correctly in Report Manager webpage

have a report that in the designer in Visual Studio it displays correctly on
the preview tab.
The report has 5 subreports and one of the subreports is a matrix.
On the report I have a parameter for the user to choose rather to see the
matrix subreport or not.
When I view the report in the report manager web page and the user select to
yes to view the matrix sub report, the main report is missing fields and
formatted incorrectly, if you select no on the parameter for viewing the
matrix sub report, the fields return on the main report but are still not
alligned correctly. None of the missing fields have any expressions to
control the visible property , only the matrix sub report. The matrix
subreport is several inches away from any of the fields that end up missing.
The fields that are missing are unbound textboxes used as labels.
I tried to delete the report from the report server and re-deploy but still
the same effect.
Why is the report manager different than the Visual Studio preview and
causing this bug?What version are you on? In RS 2000 the report designer had its own
renderer. In RS 2005 it uses the same rendering engine as the server does.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"RBS" <RBS@.discussions.microsoft.com> wrote in message
news:831D8D9D-B3C2-485D-8B16-089A6DC76563@.microsoft.com...
> have a report that in the designer in Visual Studio it displays correctly
> on
> the preview tab.
> The report has 5 subreports and one of the subreports is a matrix.
> On the report I have a parameter for the user to choose rather to see the
> matrix subreport or not.
>
> When I view the report in the report manager web page and the user select
> to
> yes to view the matrix sub report, the main report is missing fields and
> formatted incorrectly, if you select no on the parameter for viewing the
> matrix sub report, the fields return on the main report but are still not
> alligned correctly. None of the missing fields have any expressions to
> control the visible property , only the matrix sub report. The matrix
> subreport is several inches away from any of the fields that end up
> missing.
> The fields that are missing are unbound textboxes used as labels.
>
> I tried to delete the report from the report server and re-deploy but
> still
> the same effect.
>
> Why is the report manager different than the Visual Studio preview and
> causing this bug?
>