How do you determine what version of Reporting Services is installed int the DB and Web server ( I have the DB on a different server than the Web server)
Thanks
Try typinghttp://localhost/Reportserver
Showing posts with label version. Show all posts
Showing posts with label version. Show all posts
Thursday, March 29, 2012
Determine what ver/SP is installed for Reporting Services
How can you tell what version of Reporting Services is installed?Just run the url http://localhost/ReportServer or
http://<hostname>/ReportServer|||That is where to look, however I didn't know what the numbers meant. I
found this in another thread:
base install = 743
sp1 = 878
sp2 = 1042|||If you run the url. at the bottom it will display the version information
like following
Microsoft SQL Server Reporting Services Version 8.00.1038.00sql
http://<hostname>/ReportServer|||That is where to look, however I didn't know what the numbers meant. I
found this in another thread:
base install = 743
sp1 = 878
sp2 = 1042|||If you run the url. at the bottom it will display the version information
like following
Microsoft SQL Server Reporting Services Version 8.00.1038.00sql
Determine table constraints for database upgrade/migration project
I have a project to update one of our program's database from one version to
another. Additionally, I will be migrating the data from one database to
another.
Here's an example:
mydb7.1
mydb8.0
Both databases exist in the same database server.
So mydb7.1 contains production data for an Online store. I need to migrate
this data in to the mydb8.0 database. The mydb8.0 database uses a newer
schema, so there will some work to convert the data to the newer layout.
Here's my problem mydb7.1 database contains hundeds of tables and foreign
key relationships. Is there some way or tool, that can help me determine
the table migration order? That way my code know's which tables to migrat
e
first, and still preserving the ref integrity.
Will it be easier to create the mydb8.0 database, just with tables, and then
migrate the data. After the data is migrated, then setup the foreign key
relations. That way, I will not need order the tables for migration? Jus
t
a thought.
ThanksRichard,
Just a thought...script out the table definitions...alter them...run and
create the tables in the new DB...transfer the data over...views or
dts...script out the PK and FK constraints then apply to the new tables in
the new DB.
HTH
Jerry
"Richard" <Richard@.discussions.microsoft.com> wrote in message
news:69ACA9B4-CB56-417B-8015-B3A168F82F36@.microsoft.com...
>I have a project to update one of our program's database from one version
>to
> another. Additionally, I will be migrating the data from one database to
> another.
> Here's an example:
> mydb7.1
> mydb8.0
> Both databases exist in the same database server.
> So mydb7.1 contains production data for an Online store. I need to
> migrate
> this data in to the mydb8.0 database. The mydb8.0 database uses a newer
> schema, so there will some work to convert the data to the newer layout.
> Here's my problem mydb7.1 database contains hundeds of tables and foreign
> key relationships. Is there some way or tool, that can help me determine
> the table migration order? That way my code know's which tables to
> migrate
> first, and still preserving the ref integrity.
> Will it be easier to create the mydb8.0 database, just with tables, and
> then
> migrate the data. After the data is migrated, then setup the foreign
> key
> relations. That way, I will not need order the tables for migration?
> Just
> a thought.
> Thanks
another. Additionally, I will be migrating the data from one database to
another.
Here's an example:
mydb7.1
mydb8.0
Both databases exist in the same database server.
So mydb7.1 contains production data for an Online store. I need to migrate
this data in to the mydb8.0 database. The mydb8.0 database uses a newer
schema, so there will some work to convert the data to the newer layout.
Here's my problem mydb7.1 database contains hundeds of tables and foreign
key relationships. Is there some way or tool, that can help me determine
the table migration order? That way my code know's which tables to migrat
e
first, and still preserving the ref integrity.
Will it be easier to create the mydb8.0 database, just with tables, and then
migrate the data. After the data is migrated, then setup the foreign key
relations. That way, I will not need order the tables for migration? Jus
t
a thought.
ThanksRichard,
Just a thought...script out the table definitions...alter them...run and
create the tables in the new DB...transfer the data over...views or
dts...script out the PK and FK constraints then apply to the new tables in
the new DB.
HTH
Jerry
"Richard" <Richard@.discussions.microsoft.com> wrote in message
news:69ACA9B4-CB56-417B-8015-B3A168F82F36@.microsoft.com...
>I have a project to update one of our program's database from one version
>to
> another. Additionally, I will be migrating the data from one database to
> another.
> Here's an example:
> mydb7.1
> mydb8.0
> Both databases exist in the same database server.
> So mydb7.1 contains production data for an Online store. I need to
> migrate
> this data in to the mydb8.0 database. The mydb8.0 database uses a newer
> schema, so there will some work to convert the data to the newer layout.
> Here's my problem mydb7.1 database contains hundeds of tables and foreign
> key relationships. Is there some way or tool, that can help me determine
> the table migration order? That way my code know's which tables to
> migrate
> first, and still preserving the ref integrity.
> Will it be easier to create the mydb8.0 database, just with tables, and
> then
> migrate the data. After the data is migrated, then setup the foreign
> key
> relations. That way, I will not need order the tables for migration?
> Just
> a thought.
> Thanks
Tuesday, March 27, 2012
Determine service pack version of Analysis Services using AMO
Hi,
Our product uses features that require Analysis Services SP2 to be installed. How can I tell if an Analysis Services server is running SP2 or higher using Analysis Services Management Objects (AMO)? I'm not concerned about the Operating System service pack edition, I'm concerned about the SP version of Analysis Services.
Thanks.
Figured it out. Use the Version property off the Server object.
Server svr = new Server();
svr.Connect(serverName);
Version minASVersion = new Version(MIN_AS_SERVICES_VERSION);
Version serverVersion = new Version(svr.Version);
if (serverVersion < minASVersion)
{
// error
}
|||You can get this using ADOMD too:
http://geekswithblogs.net/darrengosbell/archive/2007/07/14/SSAS-Detecting-the-version-of-SSAS-on-a-given-server.aspx
sqlWednesday, March 21, 2012
Detecting Circular References.
Greetings All, this is my first time dealing with this particular issue
so I figured I would solicit your expertise :)
Annoted Version of DDL:
Create Table Company
(
ParentId int null,
PrimaryId int not null primary key,
CompanyName nvarchar(200) not null
)
Facts:
1.) PrimaryId is the PK of the Company.
2.) ParentId is the identifier of the Parent company if one exists.
3.) If ParentId is null then PrimaryId is its own parent.
4.) A company can have only one parent (hierarchcial graph).
5.) There is no one master company for all PrimaryId's. This is to say
you can have more than one hierarchy represented in the Company table:
A D
/ \ / \
B C E F
Where A and D are there own parents.
Problem:
I need to make sure that there can never be the case where a company is
simultaneously both the child and parent of another company, e.g.)
A is parent of B
B is parent of C
C is parent of D
D is parent of A <= Violation
Any help would be greatly appreciated.
TFDThis technique should work:
SET NOCOUNT ON
-- DROP TABLE Company
GO
Create Table Company
(
ParentId int null,
PrimaryId int not null primary key,
CompanyName nvarchar(200) --not null
)
GO
INSERT Company (ParentId, PrimaryId)
SELECT NULL, 1
UNION
SELECT 1, 2
UNION
SELECT 2, 3
UNION
SELECT 2, 4
UNION
SELECT 3, 5
UPDATE Company
SET ParentID = 5
WHERE PrimaryID = 1
GO
SELECT ParentId --Ancestor
, PrimaryId --Descendant
INTO #Hierarchy
FROM Company
WHERE ParentId IS NOT NULL
DECLARE @.BadHierarchy CHAR(1)
SET @.BadHierarchy = 'N'
WHILE 1 = 1 BEGIN
INSERT #Hierarchy
SELECT DISTINCT
p.ParentId
, c.PrimaryId
FROM #Hierarchy p
INNER JOIN #Hierarchy c
ON p.PrimaryId = c.ParentId
WHERE NOT EXISTS (SELECT * FROM #Hierarchy WHERE ParentID =
p.ParentID AND PrimaryId = c.PrimaryId)
IF EXISTS (SELECT * FROM #Hierarchy a WHERE EXISTS (SELECT * FROM
#Hierarchy b WHERE a.PrimaryID = b.ParentID AND a.ParentID =
b.PrimaryID)) BEGIN
SET @.BadHierarchy = 'Y'
BREAK
END
IF @.@.ROWCOUNT = 0 BREAK
END
SELECT @.BadHierarchy
SELECT * FROM #Hierarchy
DROP TABLE #Hierarchy|||I goofed on that one. That @.@.ROWCOUNT needs to be assigned to a
variable before the IF EXISTS statement above it, and that variable
needs to be checked where I'm checking @.@.ROWCOUNT.
-Alansql
so I figured I would solicit your expertise :)
Annoted Version of DDL:
Create Table Company
(
ParentId int null,
PrimaryId int not null primary key,
CompanyName nvarchar(200) not null
)
Facts:
1.) PrimaryId is the PK of the Company.
2.) ParentId is the identifier of the Parent company if one exists.
3.) If ParentId is null then PrimaryId is its own parent.
4.) A company can have only one parent (hierarchcial graph).
5.) There is no one master company for all PrimaryId's. This is to say
you can have more than one hierarchy represented in the Company table:
A D
/ \ / \
B C E F
Where A and D are there own parents.
Problem:
I need to make sure that there can never be the case where a company is
simultaneously both the child and parent of another company, e.g.)
A is parent of B
B is parent of C
C is parent of D
D is parent of A <= Violation
Any help would be greatly appreciated.
TFDThis technique should work:
SET NOCOUNT ON
-- DROP TABLE Company
GO
Create Table Company
(
ParentId int null,
PrimaryId int not null primary key,
CompanyName nvarchar(200) --not null
)
GO
INSERT Company (ParentId, PrimaryId)
SELECT NULL, 1
UNION
SELECT 1, 2
UNION
SELECT 2, 3
UNION
SELECT 2, 4
UNION
SELECT 3, 5
UPDATE Company
SET ParentID = 5
WHERE PrimaryID = 1
GO
SELECT ParentId --Ancestor
, PrimaryId --Descendant
INTO #Hierarchy
FROM Company
WHERE ParentId IS NOT NULL
DECLARE @.BadHierarchy CHAR(1)
SET @.BadHierarchy = 'N'
WHILE 1 = 1 BEGIN
INSERT #Hierarchy
SELECT DISTINCT
p.ParentId
, c.PrimaryId
FROM #Hierarchy p
INNER JOIN #Hierarchy c
ON p.PrimaryId = c.ParentId
WHERE NOT EXISTS (SELECT * FROM #Hierarchy WHERE ParentID =
p.ParentID AND PrimaryId = c.PrimaryId)
IF EXISTS (SELECT * FROM #Hierarchy a WHERE EXISTS (SELECT * FROM
#Hierarchy b WHERE a.PrimaryID = b.ParentID AND a.ParentID =
b.PrimaryID)) BEGIN
SET @.BadHierarchy = 'Y'
BREAK
END
IF @.@.ROWCOUNT = 0 BREAK
END
SELECT @.BadHierarchy
SELECT * FROM #Hierarchy
DROP TABLE #Hierarchy|||I goofed on that one. That @.@.ROWCOUNT needs to be assigned to a
variable before the IF EXISTS statement above it, and that variable
needs to be checked where I'm checking @.@.ROWCOUNT.
-Alansql
Detect installed version?
Today I installed SQL Server 2005 developer edition on a test server. Afterwards I also installed the SP1. During the installation of SP1, the installation program said the server should be restarted afterwards, which I did.
Now when I look at the Add/Remove Programs dialog I have several items which mention SP1 on the SQL Server items.
But when I request the server properties in Managemnt Studio I see the version number 9.0.2047. Shouldn't this be 9.1.XXXX?
How can I be sure the SP1 is correcty insatlled?
Stievie
If you look on the download page under the Quick Details, the version number is listed as 9.00.2047
http://www.microsoft.com/downloads/details.aspx?familyid=cb6c71ea-d649-47ff-9176-e7cac58fd4bc&displaylang=en
|||Isn't that the same version number as before installing the SP?Is it possible to see which SP is installed inside the Management Studio?
|||Hi,
See more details here: http://www.aspfaq.com/sql2005/show.asp?id=20
HTH, jens Suessmeyer.
http://www.sqlserver2005.de
|||
StievieD wrote:
Isn't that the same version number as before installing the SP?
Before SP1, the version is 9.0.1399
|||The version for SP1 is 9.00.2047 and RTM 9.00.1399.06.|||Thanks guys, for all the help.Detect installed MSDE version
I'm building a setup program that needs to install an instance of SQL Server
if it's not already installed or if it's not up to date. What I need to know
is... how do I know if an instance of SQL Server is installed, and get it's
build version? I can get info about the default instance in the registry at
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MS
SQLServer\MSSQLServer\CurrentVersion
But what about a named instance? If I install an instance called "ABC",
where are settings stored in the registry?
Thanks in advance,
EtienneHi
You may want to cycle around instances in the subkeys of
HKLM\Software\Microsoft\Microsoft SQL Server\
John
"Etienne" <mysteryx93_nosspam@.hotmail.com> wrote in message
news:u$S7IX7jFHA.3144@.TK2MSFTNGP12.phx.gbl...
> I'm building a setup program that needs to install an instance of SQL
> Server if it's not already installed or if it's not up to date. What I
> need to know is... how do I know if an instance of SQL Server is
> installed, and get it's build version? I can get info about the default
> instance in the registry at
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MS
SQLServer\MSSQLServer\CurrentVersi
on
> But what about a named instance? If I install an instance called "ABC",
> where are settings stored in the registry?
> Thanks in advance,
> Etienne
>
if it's not already installed or if it's not up to date. What I need to know
is... how do I know if an instance of SQL Server is installed, and get it's
build version? I can get info about the default instance in the registry at
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MS
SQLServer\MSSQLServer\CurrentVersion
But what about a named instance? If I install an instance called "ABC",
where are settings stored in the registry?
Thanks in advance,
EtienneHi
You may want to cycle around instances in the subkeys of
HKLM\Software\Microsoft\Microsoft SQL Server\
John
"Etienne" <mysteryx93_nosspam@.hotmail.com> wrote in message
news:u$S7IX7jFHA.3144@.TK2MSFTNGP12.phx.gbl...
> I'm building a setup program that needs to install an instance of SQL
> Server if it's not already installed or if it's not up to date. What I
> need to know is... how do I know if an instance of SQL Server is
> installed, and get it's build version? I can get info about the default
> instance in the registry at
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MS
SQLServer\MSSQLServer\CurrentVersi
on
> But what about a named instance? If I install an instance called "ABC",
> where are settings stored in the registry?
> Thanks in advance,
> Etienne
>
Detect installed MSDE version
I'm building a setup program that needs to install an instance of SQL Server
if it's not already installed or if it's not up to date. What I need to know
is... how do I know if an instance of SQL Server is installed, and get it's
build version? I can get info about the default instance in the registry at
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\ MSSQLServer\CurrentVersion
But what about a named instance? If I install an instance called "ABC",
where are settings stored in the registry?
Thanks in advance,
Etienne
Hi
You may want to cycle around instances in the subkeys of
HKLM\Software\Microsoft\Microsoft SQL Server\
John
"Etienne" <mysteryx93_nosspam@.hotmail.com> wrote in message
news:u$S7IX7jFHA.3144@.TK2MSFTNGP12.phx.gbl...
> I'm building a setup program that needs to install an instance of SQL
> Server if it's not already installed or if it's not up to date. What I
> need to know is... how do I know if an instance of SQL Server is
> installed, and get it's build version? I can get info about the default
> instance in the registry at
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\ MSSQLServer\CurrentVersion
> But what about a named instance? If I install an instance called "ABC",
> where are settings stored in the registry?
> Thanks in advance,
> Etienne
>
if it's not already installed or if it's not up to date. What I need to know
is... how do I know if an instance of SQL Server is installed, and get it's
build version? I can get info about the default instance in the registry at
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\ MSSQLServer\CurrentVersion
But what about a named instance? If I install an instance called "ABC",
where are settings stored in the registry?
Thanks in advance,
Etienne
Hi
You may want to cycle around instances in the subkeys of
HKLM\Software\Microsoft\Microsoft SQL Server\
John
"Etienne" <mysteryx93_nosspam@.hotmail.com> wrote in message
news:u$S7IX7jFHA.3144@.TK2MSFTNGP12.phx.gbl...
> I'm building a setup program that needs to install an instance of SQL
> Server if it's not already installed or if it's not up to date. What I
> need to know is... how do I know if an instance of SQL Server is
> installed, and get it's build version? I can get info about the default
> instance in the registry at
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\ MSSQLServer\CurrentVersion
> But what about a named instance? If I install an instance called "ABC",
> where are settings stored in the registry?
> Thanks in advance,
> Etienne
>
Saturday, February 25, 2012
Designer changing report element sizes during a save
This is a repost using MSDN Subscription
Using SQL Server Reporting Services Designer Version 9.00.1399.00
I'm having trouble with a three column report with a page header the width
of the page. The designer is changing the width of elements when it is
saved. As long as you view the report in the designer, the report renders as
you would expect, but when it gets saved, some of the report elements get
changed.
Try this:
New empty Report Server Project
Add new empty report (Add -> New Item -> Select Report)
No datasource
Enable page header
Add a text box (textbox1) to page header. Make it begin at the left
margin/top margin and be almost the width of the page (6in).
Set the height of the page header to the height of the textbox1.
Insert five or six words in textbox1.
Make the report a 3 column report.
Reset the page header width to be 6.5in (1in right/left margins on 8.5in
paper) using the resizer in the page header.
The column width should be 1.83333in (1.83333 * 3 = 5.49999 + [column
spacing] 0.5in + 0.5in = 6.49999in)
Add a text box (textbox2) to the body (in column 1). Make it begin at the
left margin/top margin and be almost the width of the column (1.625in).
Insert a few words in textbox2.
View the report. Appears to be fine.
Save, Close the report, Reopen the report.
The width of the page header is now 6in (was 6.5in), column width is now
1.66667in (was 1.83333in)
Why did the width of the page header change?
Make the width of the page header and textbox1, 6.5in.
Save, Close the report, Reopen the report.
The page header is 6.499999in wide, but textbox1 is the same width as one of
the columns in the body (1.83333in)
Why did the width of the page header and textbox1 change?
Make textbox1 6in wide again.
Make the report 6.5in wide.
Add a new textbox (textbox3) in the page header to the right of textbox1
(starts at 6in, 0.5in wide), same height as the first one.
Insert a few letters in textbox3.
Save, Close the report, Reopen the report.
The report is now 6in wide (instead of 6.5in), columns are 1.66667in wide.
Textbox3 that was just added to the page header cannot be seen. It is at
the right edge of the page header, and has a negative width. It can only be
found using dropdown in the properties window.
Why did textbox3 disappear/get a negative width?
Are these known bugs? Are there any work arounds?Hello,
From your desscription, I tried to reproduce the issue to no avail. To
understand the issue better, will you please send the report project or
report to me? You could remove "online" in my displayed email address. I
know the report will be changed after saving, and reopen, however, you
report shall make me understanding your problem more directly. thank you!
Also, since you did not install SQL 2005 sp1, you may want to install it to
test the sitaution.
If you have other related information, please also let's know. We look
forward to your reply.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Im having the same error!! I have 2 reports that have mutliple columns. When
I save the report, it will change the text boxes in the header to negative
values. I have not found a work around for this error. Anyone have any
suggestions/Have run into the same problem as well?
-Theresa
"AOTX San Antonio" wrote:
> This is a repost using MSDN Subscription
> Using SQL Server Reporting Services Designer Version 9.00.1399.00
> I'm having trouble with a three column report with a page header the width
> of the page. The designer is changing the width of elements when it is
> saved. As long as you view the report in the designer, the report renders as
> you would expect, but when it gets saved, some of the report elements get
> changed.
> Try this:
> New empty Report Server Project
> Add new empty report (Add -> New Item -> Select Report)
> No datasource
> Enable page header
> Add a text box (textbox1) to page header. Make it begin at the left
> margin/top margin and be almost the width of the page (6in).
> Set the height of the page header to the height of the textbox1.
> Insert five or six words in textbox1.
> Make the report a 3 column report.
> Reset the page header width to be 6.5in (1in right/left margins on 8.5in
> paper) using the resizer in the page header.
> The column width should be 1.83333in (1.83333 * 3 = 5.49999 + [column
> spacing] 0.5in + 0.5in = 6.49999in)
> Add a text box (textbox2) to the body (in column 1). Make it begin at the
> left margin/top margin and be almost the width of the column (1.625in).
> Insert a few words in textbox2.
> View the report. Appears to be fine.
> Save, Close the report, Reopen the report.
> The width of the page header is now 6in (was 6.5in), column width is now
> 1.66667in (was 1.83333in)
> Why did the width of the page header change?
> Make the width of the page header and textbox1, 6.5in.
> Save, Close the report, Reopen the report.
> The page header is 6.499999in wide, but textbox1 is the same width as one of
> the columns in the body (1.83333in)
> Why did the width of the page header and textbox1 change?
> Make textbox1 6in wide again.
> Make the report 6.5in wide.
> Add a new textbox (textbox3) in the page header to the right of textbox1
> (starts at 6in, 0.5in wide), same height as the first one.
> Insert a few letters in textbox3.
> Save, Close the report, Reopen the report.
> The report is now 6in wide (instead of 6.5in), columns are 1.66667in wide.
> Textbox3 that was just added to the page header cannot be seen. It is at
> the right edge of the page header, and has a negative width. It can only be
> found using dropdown in the properties window.
> Why did textbox3 disappear/get a negative width?
> Are these known bugs? Are there any work arounds?|||Hello Theresa
,
I have reproduced the issue on my side. It seems that when adding textbox
or change textbox, it does not actually perform an optimization of the
report according to the algorithm that used when saving a report. I found
if I change the textbox1 width to 6 to 6.5, this size is not actually saved
to rdl and the width number is not stored at all. At this time, textbox1
actually has the 6.5 when rendering since it is aligned to the body width
1.83333 automatically.
Please rest assured your feedback is taken seriously this issue has been
reported to the product team. Product team may evaluate the business impact
and decide to fix this or not. If there is any update, we will let you
know.
You may manually edit rdl and set textbox in pageheader to the value it
should be to work around the issue. In the meantime, I also encourage you
submit your feedback on this issue via the link below
http://lab.msdn.microsoft.com/productfeedback/default.aspx
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================|||Hello Every One,
I came across this issue and found a good work around for this.
Whenever you have the textbox's right margin alligned with the right
margin of a rectangle in a Page Header, we see this behavour in a multi
column report.
Work around: We suggest to keep a minimal gap between the textbox right
edge and the container and make the container border as none. This
makes it retain the width attribute in the rdl file and we dont loose
its width after saving.
Best Regards,
Dipanjan Banik
SQL Developer Support
Peter Yang [MSFT] wrote:
> Hello Theresa
> ,
> I have reproduced the issue on my side. It seems that when adding textbox
> or change textbox, it does not actually perform an optimization of the
> report according to the algorithm that used when saving a report. I found
> if I change the textbox1 width to 6 to 6.5, this size is not actually saved
> to rdl and the width number is not stored at all. At this time, textbox1
> actually has the 6.5 when rendering since it is aligned to the body width
> 1.83333 automatically.
> Please rest assured your feedback is taken seriously this issue has been
> reported to the product team. Product team may evaluate the business impact
> and decide to fix this or not. If there is any update, we will let you
> know.
> You may manually edit rdl and set textbox in pageheader to the value it
> should be to work around the issue. In the meantime, I also encourage you
> submit your feedback on this issue via the link below
> http://lab.msdn.microsoft.com/productfeedback/default.aspx
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
>
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
> ======================================================
Using SQL Server Reporting Services Designer Version 9.00.1399.00
I'm having trouble with a three column report with a page header the width
of the page. The designer is changing the width of elements when it is
saved. As long as you view the report in the designer, the report renders as
you would expect, but when it gets saved, some of the report elements get
changed.
Try this:
New empty Report Server Project
Add new empty report (Add -> New Item -> Select Report)
No datasource
Enable page header
Add a text box (textbox1) to page header. Make it begin at the left
margin/top margin and be almost the width of the page (6in).
Set the height of the page header to the height of the textbox1.
Insert five or six words in textbox1.
Make the report a 3 column report.
Reset the page header width to be 6.5in (1in right/left margins on 8.5in
paper) using the resizer in the page header.
The column width should be 1.83333in (1.83333 * 3 = 5.49999 + [column
spacing] 0.5in + 0.5in = 6.49999in)
Add a text box (textbox2) to the body (in column 1). Make it begin at the
left margin/top margin and be almost the width of the column (1.625in).
Insert a few words in textbox2.
View the report. Appears to be fine.
Save, Close the report, Reopen the report.
The width of the page header is now 6in (was 6.5in), column width is now
1.66667in (was 1.83333in)
Why did the width of the page header change?
Make the width of the page header and textbox1, 6.5in.
Save, Close the report, Reopen the report.
The page header is 6.499999in wide, but textbox1 is the same width as one of
the columns in the body (1.83333in)
Why did the width of the page header and textbox1 change?
Make textbox1 6in wide again.
Make the report 6.5in wide.
Add a new textbox (textbox3) in the page header to the right of textbox1
(starts at 6in, 0.5in wide), same height as the first one.
Insert a few letters in textbox3.
Save, Close the report, Reopen the report.
The report is now 6in wide (instead of 6.5in), columns are 1.66667in wide.
Textbox3 that was just added to the page header cannot be seen. It is at
the right edge of the page header, and has a negative width. It can only be
found using dropdown in the properties window.
Why did textbox3 disappear/get a negative width?
Are these known bugs? Are there any work arounds?Hello,
From your desscription, I tried to reproduce the issue to no avail. To
understand the issue better, will you please send the report project or
report to me? You could remove "online" in my displayed email address. I
know the report will be changed after saving, and reopen, however, you
report shall make me understanding your problem more directly. thank you!
Also, since you did not install SQL 2005 sp1, you may want to install it to
test the sitaution.
If you have other related information, please also let's know. We look
forward to your reply.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Im having the same error!! I have 2 reports that have mutliple columns. When
I save the report, it will change the text boxes in the header to negative
values. I have not found a work around for this error. Anyone have any
suggestions/Have run into the same problem as well?
-Theresa
"AOTX San Antonio" wrote:
> This is a repost using MSDN Subscription
> Using SQL Server Reporting Services Designer Version 9.00.1399.00
> I'm having trouble with a three column report with a page header the width
> of the page. The designer is changing the width of elements when it is
> saved. As long as you view the report in the designer, the report renders as
> you would expect, but when it gets saved, some of the report elements get
> changed.
> Try this:
> New empty Report Server Project
> Add new empty report (Add -> New Item -> Select Report)
> No datasource
> Enable page header
> Add a text box (textbox1) to page header. Make it begin at the left
> margin/top margin and be almost the width of the page (6in).
> Set the height of the page header to the height of the textbox1.
> Insert five or six words in textbox1.
> Make the report a 3 column report.
> Reset the page header width to be 6.5in (1in right/left margins on 8.5in
> paper) using the resizer in the page header.
> The column width should be 1.83333in (1.83333 * 3 = 5.49999 + [column
> spacing] 0.5in + 0.5in = 6.49999in)
> Add a text box (textbox2) to the body (in column 1). Make it begin at the
> left margin/top margin and be almost the width of the column (1.625in).
> Insert a few words in textbox2.
> View the report. Appears to be fine.
> Save, Close the report, Reopen the report.
> The width of the page header is now 6in (was 6.5in), column width is now
> 1.66667in (was 1.83333in)
> Why did the width of the page header change?
> Make the width of the page header and textbox1, 6.5in.
> Save, Close the report, Reopen the report.
> The page header is 6.499999in wide, but textbox1 is the same width as one of
> the columns in the body (1.83333in)
> Why did the width of the page header and textbox1 change?
> Make textbox1 6in wide again.
> Make the report 6.5in wide.
> Add a new textbox (textbox3) in the page header to the right of textbox1
> (starts at 6in, 0.5in wide), same height as the first one.
> Insert a few letters in textbox3.
> Save, Close the report, Reopen the report.
> The report is now 6in wide (instead of 6.5in), columns are 1.66667in wide.
> Textbox3 that was just added to the page header cannot be seen. It is at
> the right edge of the page header, and has a negative width. It can only be
> found using dropdown in the properties window.
> Why did textbox3 disappear/get a negative width?
> Are these known bugs? Are there any work arounds?|||Hello Theresa
,
I have reproduced the issue on my side. It seems that when adding textbox
or change textbox, it does not actually perform an optimization of the
report according to the algorithm that used when saving a report. I found
if I change the textbox1 width to 6 to 6.5, this size is not actually saved
to rdl and the width number is not stored at all. At this time, textbox1
actually has the 6.5 when rendering since it is aligned to the body width
1.83333 automatically.
Please rest assured your feedback is taken seriously this issue has been
reported to the product team. Product team may evaluate the business impact
and decide to fix this or not. If there is any update, we will let you
know.
You may manually edit rdl and set textbox in pageheader to the value it
should be to work around the issue. In the meantime, I also encourage you
submit your feedback on this issue via the link below
http://lab.msdn.microsoft.com/productfeedback/default.aspx
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================|||Hello Every One,
I came across this issue and found a good work around for this.
Whenever you have the textbox's right margin alligned with the right
margin of a rectangle in a Page Header, we see this behavour in a multi
column report.
Work around: We suggest to keep a minimal gap between the textbox right
edge and the container and make the container border as none. This
makes it retain the width attribute in the rdl file and we dont loose
its width after saving.
Best Regards,
Dipanjan Banik
SQL Developer Support
Peter Yang [MSFT] wrote:
> Hello Theresa
> ,
> I have reproduced the issue on my side. It seems that when adding textbox
> or change textbox, it does not actually perform an optimization of the
> report according to the algorithm that used when saving a report. I found
> if I change the textbox1 width to 6 to 6.5, this size is not actually saved
> to rdl and the width number is not stored at all. At this time, textbox1
> actually has the 6.5 when rendering since it is aligned to the body width
> 1.83333 automatically.
> Please rest assured your feedback is taken seriously this issue has been
> reported to the product team. Product team may evaluate the business impact
> and decide to fix this or not. If there is any update, we will let you
> know.
> You may manually edit rdl and set textbox in pageheader to the value it
> should be to work around the issue. In the meantime, I also encourage you
> submit your feedback on this issue via the link below
> http://lab.msdn.microsoft.com/productfeedback/default.aspx
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
>
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
> ======================================================
Subscribe to:
Posts (Atom)