Hi everyone,
This might be a tough one, I don't know if this is doable.
Basically I want to create a stored procedure to return estimated size of a
table.
because I don't know how many rows it will have in the future, I want to
calcuate how much disk space it takes to have one row,
then multiply by number of rows I specified. (space calculation for index is
not necessary).
EXEC GetEstimateTableSize @.TableName='Table1', @.NumberOfRows ='3000000'
it'll return value in KBs after I execute proc. possible?If you run :
EXEC dbo.sp_spaceused table_name
You get the current space usage. Divide it by the current number of rows,
and multiply by the projected one.
If the table is completely empty or you'd rather calculate theoretical size,
there are formulas you can use from BOL, or better yet, a lengthy discussion
on internal structures and row sizes in Inside SQL Server 2000.
BG, SQL Server MVP
www.SolidQualityLearning.com
"Britney" <britneychen_2001@.yahoo.com> wrote in message
news:uWKIMMBpFHA.3936@.TK2MSFTNGP10.phx.gbl...
> Hi everyone,
> This might be a tough one, I don't know if this is doable.
> Basically I want to create a stored procedure to return estimated size of
> a table.
> because I don't know how many rows it will have in the future, I want to
> calcuate how much disk space it takes to have one row,
> then multiply by number of rows I specified. (space calculation for index
> is not necessary).
>
> EXEC GetEstimateTableSize @.TableName='Table1', @.NumberOfRows ='3000000'
>
> it'll return value in KBs after I execute proc. possible?
>
>
>
>
>
>|||Have you looked in the Books Online for sp_spaceused? It'll get you
part of the way there because it returns the rows used and the current
size of the table. Here's a quick and dirty stab at it; obviously
it'll need polishing:
This is actually a pretty useful idea; I'm planning on using this
myself.
Stu
DECLARE @.Table varchar(255)
DECLARE @.NumberOfRows int
SET @.Table = 'Splat'
SET @.NumberOfRows = 1
CREATE TABLE #t (name varchar(255),
rows int,
reserved varchar(100),
data varchar(100),
index_size varchar(100),
unused varchar(100))
--how big is the table now?
exec sp_spaceused @.Table
INSERT INTO #t
exec sp_spaceused @.Table
--strip off the ' KB' from the data column
--convert data and rows to decimal, and
--divide data by number of rows and multiply by number of anticipated
rows
SELECT rows, data, (data/rows) * @.NumberOfRows
FROM ( SELECT rows = CONVERT(decimal(32,3), rows),
data = CONVERT(decimal(32,3), LEFT(data, LEN(data)-3))
FROM #t) x
DROP TABLE #t
HTH,
Stu|||The following may help:
http://www.microsoft.com/downloads/...&displaylang=en
If you need it in a SP, try to understand the formulas used in the
spreadsheet and translate them in T-SQL (using the data from syscolumns
and other system tables).
Razvan|||I see 4 columns called reserved , index_size, unused, data
I guess I need to add 4 columns to get the total size, then divide by number
of row to find out how much disk space per row?
then disk space per row * estimate number of rows to find out estimate size?
"Itzik Ben-Gan" <itzik@.REMOVETHIS.SolidQualityLearning.com> wrote in message
news:etjHceBpFHA.2888@.TK2MSFTNGP10.phx.gbl...
> If you run :
> EXEC dbo.sp_spaceused table_name
> You get the current space usage. Divide it by the current number of rows,
> and multiply by the projected one.
> If the table is completely empty or you'd rather calculate theoretical
> size, there are formulas you can use from BOL, or better yet, a lengthy
> discussion on internal structures and row sizes in Inside SQL Server 2000.
> --
> BG, SQL Server MVP
> www.SolidQualityLearning.com
>
> "Britney" <britneychen_2001@.yahoo.com> wrote in message
> news:uWKIMMBpFHA.3936@.TK2MSFTNGP10.phx.gbl...
>|||You need the data + index_size.
Reserved includes: data + index_size + unused.
BG, SQL Server MVP
www.SolidQualityLearning.com
"Britney" wrote:
> I see 4 columns called reserved , index_size, unused, data
> I guess I need to add 4 columns to get the total size, then divide by numb
er
> of row to find out how much disk space per row?
> then disk space per row * estimate number of rows to find out estimate siz
e?
> "Itzik Ben-Gan" <itzik@.REMOVETHIS.SolidQualityLearning.com> wrote in messa
ge
> news:etjHceBpFHA.2888@.TK2MSFTNGP10.phx.gbl...
>
>|||but I have a NTEXT column,
I don't think it can calculate NTEXT.
"Razvan Socol" <rsocol@.gmail.com> wrote in message
news:1124386169.690259.289640@.z14g2000cwz.googlegroups.com...
> The following may help:
> http://www.microsoft.com/downloads/...&displaylang=en
> If you need it in a SP, try to understand the formulas used in the
> spreadsheet and translate them in T-SQL (using the data from syscolumns
> and other system tables).
> Razvan
>|||Indeed, ntext columns are not covered by the spreadsheed.
In the DataSizer.doc file, they wrote:
The tool does not include the formula to estimate the size of a table
that has Text columns. Not NULL text values consume 16 bytes in the
data row and have a minimum size of 84 bytes on the text page. Text
values are packed onto text pages with the same algorithm as data
rows so it should be possible to estimate the size of text data
storage using the HEAP table spreadsheet if you know the average size
of your text values.
Razvan|||if I use sp_spaceused 'tablename' command,
if that table has a few NText Columns,
I think it will calculate total spaces including disk spaces for NTEXT
column, correct?
"Razvan Socol" <rsocol@.gmail.com> wrote in message
news:1124483366.622335.202490@.g49g2000cwa.googlegroups.com...
> Indeed, ntext columns are not covered by the spreadsheed.
> In the DataSizer.doc file, they wrote:
> The tool does not include the formula to estimate the size of a table
> that has Text columns. Not NULL text values consume 16 bytes in the
> data row and have a minimum size of 84 bytes on the text page. Text
> values are packed onto text pages with the same algorithm as data
> rows so it should be possible to estimate the size of text data
> storage using the HEAP table spreadsheet if you know the average size
> of your text values.
> Razvan
>
Showing posts with label based. Show all posts
Showing posts with label based. Show all posts
Tuesday, March 27, 2012
Estimate DB Size: how to calculate clustered and non-clustered ind
I am doing an estimation on db size based on this link:
http://msdn.microsoft.com/library/en...asp?frame=true
How can I check which tables have clustered index and non-clustered index
fastly?
Thank you!
In addition, noting the sentence "Total Table Size = Data Space Used +
Nonclustered Index + Clustered Index + ...n"
What are the other "...n" factors and how significant (can measure to %?)
are these factors affecting the result?
Many thanks!
|||Get the script I posted at the following link.
http://www.sqlservercentral.com/colu...xdetection.asp
"Jackie Chow" wrote:
> I am doing an estimation on db size based on this link:
> http://msdn.microsoft.com/library/en...asp?frame=true
> How can I check which tables have clustered index and non-clustered index
> fastly?
> Thank you!
|||Check for fragmentation using DBCC SHOWCONTIG.
I will send you a document explaining the use and the Excel Document.
Regards
Andre
"Jackie Chow" wrote:
> I am doing an estimation on db size based on this link:
> http://msdn.microsoft.com/library/en...asp?frame=true
> How can I check which tables have clustered index and non-clustered index
> fastly?
> Thank you!
http://msdn.microsoft.com/library/en...asp?frame=true
How can I check which tables have clustered index and non-clustered index
fastly?
Thank you!
In addition, noting the sentence "Total Table Size = Data Space Used +
Nonclustered Index + Clustered Index + ...n"
What are the other "...n" factors and how significant (can measure to %?)
are these factors affecting the result?
Many thanks!
|||Get the script I posted at the following link.
http://www.sqlservercentral.com/colu...xdetection.asp
"Jackie Chow" wrote:
> I am doing an estimation on db size based on this link:
> http://msdn.microsoft.com/library/en...asp?frame=true
> How can I check which tables have clustered index and non-clustered index
> fastly?
> Thank you!
|||Check for fragmentation using DBCC SHOWCONTIG.
I will send you a document explaining the use and the Excel Document.
Regards
Andre
"Jackie Chow" wrote:
> I am doing an estimation on db size based on this link:
> http://msdn.microsoft.com/library/en...asp?frame=true
> How can I check which tables have clustered index and non-clustered index
> fastly?
> Thank you!
Wednesday, March 21, 2012
Errors using report designer with ssas based report model
I have created a report model based on an SSAS database. It is usable without
errors with Report Builder as far as I can tell. However with Report
Designer, the layout displays the cube elements but errors on preview as
follows:
"The 'PerspectiveId' custom property for the 'query' perspective is either
not set or is not set to the string data type."
This is an error that has cropped up before but I'm not aware of a bug
report for it. The forum and blog guidance I have for fixing it is to:
- Create a report builder report and save it to file
- Copy the customproperties xml subtree and paste it into the Report
Designer report
I have done this but unfortunately this also errors on reopening the report
as follows:
"A connection cannot be made to the database. Set and test the connection
string. Additional information: TODO - change code to use RsProxy object
(Microsoft.ReportingServices.QueryDesigners)"
Notwithstanding the slightly disconcerting TODO comment lingering in the
code, can anyone advise cause and resolution/workaround?
Thanks in advance
David
using:
- SQL Server 2005 Analysis Services 9.0.3042
- Windows XP Pro SP2
- Visual Studio 2005 SP1
-- report designer rdl follows
--
<?xml version="1.0" encoding="utf-8"?>
<Report
xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition"
xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<DataSources>
<DataSource Name="dataSource1">
<DataSourceReference>dataSource1</DataSourceReference>
<rd:DataSourceID>6d24178d-90d5-486e-a311-a4d939b769ea</rd:DataSourceID>
</DataSource>
</DataSources>
<BottomMargin>2.5cm</BottomMargin>
<RightMargin>2.5cm</RightMargin>
<PageWidth>21cm</PageWidth>
<rd:DrawGrid>true</rd:DrawGrid>
<InteractiveWidth>21cm</InteractiveWidth>
<rd:GridSpacing>0.25cm</rd:GridSpacing>
<rd:SnapToGrid>true</rd:SnapToGrid>
<Body>
<ColumnSpacing>1cm</ColumnSpacing>
<Height>5cm</Height>
</Body>
<rd:ReportID>cdfcad95-4a03-4a8d-82a6-048cac98eb26</rd:ReportID>
<LeftMargin>2.5cm</LeftMargin>
<DataSets>
<DataSet Name="DataSet1">
<Query>
<CommandText><SemanticQuery
xmlns="http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:qd="http://schemas.microsoft.com/sqlserver/2004/11/semanticquerydesign"
xmlns:rb="http://schemas.microsoft.com/sqlserver/2004/11/reportbuilder">
<Hierarchies>
<Hierarchy>
<BaseEntity>
<!--DimGeneric-->
<EntityID
xmlns:np="http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling">np:Entity_Dimension_DimGeneric</EntityID>
</BaseEntity>
<Groupings>
<Grouping Name="Generic Description">
<Expression Name="Generic Description">
<AttributeRef>
<!--Generic Description-->
<AttributeID
xmlns:np="http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling">np:Attribute_Hierarchy_Generic.Generic_Description</AttributeID>
</AttributeRef>
</Expression>
</Grouping>
</Groupings>
</Hierarchy>
</Hierarchies>
--start of report builder sourced subtree
<CustomProperties>
<CustomProperty Name="qd:PerspectiveID">
<Value
xsi:type="xsd:string">http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling:Perspective_Cube_CubeGeneric</Value>
</CustomProperty>
</CustomProperties>
--end of report builder sourced subtree
</SemanticQuery></CommandText>
<DataSourceName>dataSource1</DataSourceName>
</Query>
<Fields>
<Field Name="Generic_Description">
<rd:TypeName>System.String</rd:TypeName>
<DataField>Generic Description</DataField>
</Field>
</Fields>
</DataSet>
</DataSets>
<Width>16cm</Width>
<InteractiveHeight>29.7cm</InteractiveHeight>
<Language>en-US</Language>
<TopMargin>2.5cm</TopMargin>
<PageHeight>29.7cm</PageHeight>
</Report>I have also noticed that if I open a Report Builder report in Report Designer
and change the data source guid to match the data source in the report server
project, the preview displays the expected results and the generic query
designer view also works as expected, but the "query could not be loaded"
message still appears when attempting to use the data tab without the query
designer.
"David Norman" wrote:
> I have created a report model based on an SSAS database. It is usable without
> errors with Report Builder as far as I can tell. However with Report
> Designer, the layout displays the cube elements but errors on preview as
> follows:
> "The 'PerspectiveId' custom property for the 'query' perspective is either
> not set or is not set to the string data type."
> This is an error that has cropped up before but I'm not aware of a bug
> report for it. The forum and blog guidance I have for fixing it is to:
> - Create a report builder report and save it to file
> - Copy the customproperties xml subtree and paste it into the Report
> Designer report
> I have done this but unfortunately this also errors on reopening the report
> as follows:
> "A connection cannot be made to the database. Set and test the connection
> string. Additional information: TODO - change code to use RsProxy object
> (Microsoft.ReportingServices.QueryDesigners)"
> Notwithstanding the slightly disconcerting TODO comment lingering in the
> code, can anyone advise cause and resolution/workaround?
> Thanks in advance
> David
> using:
> - SQL Server 2005 Analysis Services 9.0.3042
> - Windows XP Pro SP2
> - Visual Studio 2005 SP1
> -- report designer rdl follows
> --
> <?xml version="1.0" encoding="utf-8"?>
> <Report
> xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition"
> xmlns:rd="">http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
> <DataSources>
> <DataSource Name="dataSource1">
> <DataSourceReference>dataSource1</DataSourceReference>
> <rd:DataSourceID>6d24178d-90d5-486e-a311-a4d939b769ea</rd:DataSourceID>
> </DataSource>
> </DataSources>
> <BottomMargin>2.5cm</BottomMargin>
> <RightMargin>2.5cm</RightMargin>
> <PageWidth>21cm</PageWidth>
> <rd:DrawGrid>true</rd:DrawGrid>
> <InteractiveWidth>21cm</InteractiveWidth>
> <rd:GridSpacing>0.25cm</rd:GridSpacing>
> <rd:SnapToGrid>true</rd:SnapToGrid>
> <Body>
> <ColumnSpacing>1cm</ColumnSpacing>
> <Height>5cm</Height>
> </Body>
> <rd:ReportID>cdfcad95-4a03-4a8d-82a6-048cac98eb26</rd:ReportID>
> <LeftMargin>2.5cm</LeftMargin>
> <DataSets>
> <DataSet Name="DataSet1">
> <Query>
> <CommandText><SemanticQuery
> xmlns="http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling"
> xmlns:xsd="http://www.w3.org/2001/XMLSchema"
> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
> xmlns:qd="http://schemas.microsoft.com/sqlserver/2004/11/semanticquerydesign"
> xmlns:rb="">http://schemas.microsoft.com/sqlserver/2004/11/reportbuilder">
> <Hierarchies>
> <Hierarchy>
> <BaseEntity>
> <!--DimGeneric-->
> <EntityID
> xmlns:np="np:Entity_Dimension_DimGeneric</EntityID>">http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling">np:Entity_Dimension_DimGeneric</EntityID>
> </BaseEntity>
> <Groupings>
> <Grouping Name="Generic Description">
> <Expression Name="Generic Description">
> <AttributeRef>
> <!--Generic Description-->
> <AttributeID
> xmlns:np="np:Attribute_Hierarchy_Generic.Generic_Description</AttributeID>">http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling">np:Attribute_Hierarchy_Generic.Generic_Description</AttributeID>
> </AttributeRef>
> </Expression>
> </Grouping>
> </Groupings>
> </Hierarchy>
> </Hierarchies>
> --start of report builder sourced subtree
> <CustomProperties>
> <CustomProperty Name="qd:PerspectiveID">
> <Value
> xsi:type="xsd:string">http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling:Perspective_Cube_CubeGeneric</Value>
> </CustomProperty>
> </CustomProperties>
> --end of report builder sourced subtree
> </SemanticQuery></CommandText>
> <DataSourceName>dataSource1</DataSourceName>
> </Query>
> <Fields>
> <Field Name="Generic_Description">
> <rd:TypeName>System.String</rd:TypeName>
> <DataField>Generic Description</DataField>
> </Field>
> </Fields>
> </DataSet>
> </DataSets>
> <Width>16cm</Width>
> <InteractiveHeight>29.7cm</InteractiveHeight>
> <Language>en-US</Language>
> <TopMargin>2.5cm</TopMargin>
> <PageHeight>29.7cm</PageHeight>
> </Report>|||It appears this error does not occur for the same report model on a PC which
doesn't have VS2005 SP1 installed!
"David Norman" wrote:
> I have also noticed that if I open a Report Builder report in Report Designer
> and change the data source guid to match the data source in the report server
> project, the preview displays the expected results and the generic query
> designer view also works as expected, but the "query could not be loaded"
> message still appears when attempting to use the data tab without the query
> designer.
> "David Norman" wrote:
> > I have created a report model based on an SSAS database. It is usable without
> > errors with Report Builder as far as I can tell. However with Report
> > Designer, the layout displays the cube elements but errors on preview as
> > follows:
> >
> > "The 'PerspectiveId' custom property for the 'query' perspective is either
> > not set or is not set to the string data type."
> >
> > This is an error that has cropped up before but I'm not aware of a bug
> > report for it. The forum and blog guidance I have for fixing it is to:
> >
> > - Create a report builder report and save it to file
> > - Copy the customproperties xml subtree and paste it into the Report
> > Designer report
> >
> > I have done this but unfortunately this also errors on reopening the report
> > as follows:
> >
> > "A connection cannot be made to the database. Set and test the connection
> > string. Additional information: TODO - change code to use RsProxy object
> > (Microsoft.ReportingServices.QueryDesigners)"
> >
> > Notwithstanding the slightly disconcerting TODO comment lingering in the
> > code, can anyone advise cause and resolution/workaround?
> >
> > Thanks in advance
> > David
> >
> > using:
> > - SQL Server 2005 Analysis Services 9.0.3042
> > - Windows XP Pro SP2
> > - Visual Studio 2005 SP1
> >
> > -- report designer rdl follows
> > --
> >
> > <?xml version="1.0" encoding="utf-8"?>
> > <Report
> > xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition"
> > xmlns:rd="">http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
> > <DataSources>
> > <DataSource Name="dataSource1">
> > <DataSourceReference>dataSource1</DataSourceReference>
> > <rd:DataSourceID>6d24178d-90d5-486e-a311-a4d939b769ea</rd:DataSourceID>
> > </DataSource>
> > </DataSources>
> > <BottomMargin>2.5cm</BottomMargin>
> > <RightMargin>2.5cm</RightMargin>
> > <PageWidth>21cm</PageWidth>
> > <rd:DrawGrid>true</rd:DrawGrid>
> > <InteractiveWidth>21cm</InteractiveWidth>
> > <rd:GridSpacing>0.25cm</rd:GridSpacing>
> > <rd:SnapToGrid>true</rd:SnapToGrid>
> > <Body>
> > <ColumnSpacing>1cm</ColumnSpacing>
> > <Height>5cm</Height>
> > </Body>
> > <rd:ReportID>cdfcad95-4a03-4a8d-82a6-048cac98eb26</rd:ReportID>
> > <LeftMargin>2.5cm</LeftMargin>
> > <DataSets>
> > <DataSet Name="DataSet1">
> > <Query>
> > <CommandText><SemanticQuery
> > xmlns="http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling"
> > xmlns:xsd="http://www.w3.org/2001/XMLSchema"
> > xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
> > xmlns:qd="http://schemas.microsoft.com/sqlserver/2004/11/semanticquerydesign"
> > xmlns:rb="">http://schemas.microsoft.com/sqlserver/2004/11/reportbuilder">
> > <Hierarchies>
> > <Hierarchy>
> > <BaseEntity>
> > <!--DimGeneric-->
> > <EntityID
> > xmlns:np="np:Entity_Dimension_DimGeneric</EntityID>">http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling">np:Entity_Dimension_DimGeneric</EntityID>
> > </BaseEntity>
> > <Groupings>
> > <Grouping Name="Generic Description">
> > <Expression Name="Generic Description">
> > <AttributeRef>
> > <!--Generic Description-->
> > <AttributeID
> > xmlns:np="np:Attribute_Hierarchy_Generic.Generic_Description</AttributeID>">http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling">np:Attribute_Hierarchy_Generic.Generic_Description</AttributeID>
> > </AttributeRef>
> > </Expression>
> > </Grouping>
> > </Groupings>
> > </Hierarchy>
> > </Hierarchies>
> >
> > --start of report builder sourced subtree
> >
> > <CustomProperties>
> > <CustomProperty Name="qd:PerspectiveID">
> > <Value
> > xsi:type="xsd:string">http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling:Perspective_Cube_CubeGeneric</Value>
> > </CustomProperty>
> > </CustomProperties>
> >
> > --end of report builder sourced subtree
> >
> > </SemanticQuery></CommandText>
> > <DataSourceName>dataSource1</DataSourceName>
> > </Query>
> > <Fields>
> > <Field Name="Generic_Description">
> > <rd:TypeName>System.String</rd:TypeName>
> > <DataField>Generic Description</DataField>
> > </Field>
> > </Fields>
> > </DataSet>
> > </DataSets>
> > <Width>16cm</Width>
> > <InteractiveHeight>29.7cm</InteractiveHeight>
> > <Language>en-US</Language>
> > <TopMargin>2.5cm</TopMargin>
> > <PageHeight>29.7cm</PageHeight>
> > </Report>|||I finally found a bug report on Connect for SQL Server 2005 SP2 (Client Tools)
http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=260746
Microsoft will "consider fixing it in a future release". There is no
workaround listed, and I have found nothing better than selectively removing
and adding the customproperties subtree to enable different parts of the
report designer (which of course is a big nuisance).
BTW thanks world for not replying to my posts!
"David Norman" wrote:
> It appears this error does not occur for the same report model on a PC which
> doesn't have VS2005 SP1 installed!
> "David Norman" wrote:
> > I have also noticed that if I open a Report Builder report in Report Designer
> > and change the data source guid to match the data source in the report server
> > project, the preview displays the expected results and the generic query
> > designer view also works as expected, but the "query could not be loaded"
> > message still appears when attempting to use the data tab without the query
> > designer.
> >
> > "David Norman" wrote:
> >
> > > I have created a report model based on an SSAS database. It is usable without
> > > errors with Report Builder as far as I can tell. However with Report
> > > Designer, the layout displays the cube elements but errors on preview as
> > > follows:
> > >
> > > "The 'PerspectiveId' custom property for the 'query' perspective is either
> > > not set or is not set to the string data type."
> > >
> > > This is an error that has cropped up before but I'm not aware of a bug
> > > report for it. The forum and blog guidance I have for fixing it is to:
> > >
> > > - Create a report builder report and save it to file
> > > - Copy the customproperties xml subtree and paste it into the Report
> > > Designer report
> > >
> > > I have done this but unfortunately this also errors on reopening the report
> > > as follows:
> > >
> > > "A connection cannot be made to the database. Set and test the connection
> > > string. Additional information: TODO - change code to use RsProxy object
> > > (Microsoft.ReportingServices.QueryDesigners)"
> > >
> > > Notwithstanding the slightly disconcerting TODO comment lingering in the
> > > code, can anyone advise cause and resolution/workaround?
> > >
> > > Thanks in advance
> > > David
> > >
> > > using:
> > > - SQL Server 2005 Analysis Services 9.0.3042
> > > - Windows XP Pro SP2
> > > - Visual Studio 2005 SP1
> > >
> > > -- report designer rdl follows
> > > --
> > >
> > > <?xml version="1.0" encoding="utf-8"?>
> > > <Report
> > > xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition"
> > > xmlns:rd="">http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
> > > <DataSources>
> > > <DataSource Name="dataSource1">
> > > <DataSourceReference>dataSource1</DataSourceReference>
> > > <rd:DataSourceID>6d24178d-90d5-486e-a311-a4d939b769ea</rd:DataSourceID>
> > > </DataSource>
> > > </DataSources>
> > > <BottomMargin>2.5cm</BottomMargin>
> > > <RightMargin>2.5cm</RightMargin>
> > > <PageWidth>21cm</PageWidth>
> > > <rd:DrawGrid>true</rd:DrawGrid>
> > > <InteractiveWidth>21cm</InteractiveWidth>
> > > <rd:GridSpacing>0.25cm</rd:GridSpacing>
> > > <rd:SnapToGrid>true</rd:SnapToGrid>
> > > <Body>
> > > <ColumnSpacing>1cm</ColumnSpacing>
> > > <Height>5cm</Height>
> > > </Body>
> > > <rd:ReportID>cdfcad95-4a03-4a8d-82a6-048cac98eb26</rd:ReportID>
> > > <LeftMargin>2.5cm</LeftMargin>
> > > <DataSets>
> > > <DataSet Name="DataSet1">
> > > <Query>
> > > <CommandText><SemanticQuery
> > > xmlns="http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling"
> > > xmlns:xsd="http://www.w3.org/2001/XMLSchema"
> > > xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
> > > xmlns:qd="http://schemas.microsoft.com/sqlserver/2004/11/semanticquerydesign"
> > > xmlns:rb="">http://schemas.microsoft.com/sqlserver/2004/11/reportbuilder">
> > > <Hierarchies>
> > > <Hierarchy>
> > > <BaseEntity>
> > > <!--DimGeneric-->
> > > <EntityID
> > > xmlns:np="np:Entity_Dimension_DimGeneric</EntityID>">http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling">np:Entity_Dimension_DimGeneric</EntityID>
> > > </BaseEntity>
> > > <Groupings>
> > > <Grouping Name="Generic Description">
> > > <Expression Name="Generic Description">
> > > <AttributeRef>
> > > <!--Generic Description-->
> > > <AttributeID
> > > xmlns:np="np:Attribute_Hierarchy_Generic.Generic_Description</AttributeID>">http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling">np:Attribute_Hierarchy_Generic.Generic_Description</AttributeID>
> > > </AttributeRef>
> > > </Expression>
> > > </Grouping>
> > > </Groupings>
> > > </Hierarchy>
> > > </Hierarchies>
> > >
> > > --start of report builder sourced subtree
> > >
> > > <CustomProperties>
> > > <CustomProperty Name="qd:PerspectiveID">
> > > <Value
> > > xsi:type="xsd:string">http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling:Perspective_Cube_CubeGeneric</Value>
> > > </CustomProperty>
> > > </CustomProperties>
> > >
> > > --end of report builder sourced subtree
> > >
> > > </SemanticQuery></CommandText>
> > > <DataSourceName>dataSource1</DataSourceName>
> > > </Query>
> > > <Fields>
> > > <Field Name="Generic_Description">
> > > <rd:TypeName>System.String</rd:TypeName>
> > > <DataField>Generic Description</DataField>
> > > </Field>
> > > </Fields>
> > > </DataSet>
> > > </DataSets>
> > > <Width>16cm</Width>
> > > <InteractiveHeight>29.7cm</InteractiveHeight>
> > > <Language>en-US</Language>
> > > <TopMargin>2.5cm</TopMargin>
> > > <PageHeight>29.7cm</PageHeight>
> > > </Report>|||This is peer supported. Plus, MS people do not tend to be here. Although if
you have MSDN subscription you can do a managed newsgroup where you register
an alias and they guarantee I believe an answer in two days.
The fact no one answered means that people doing this for no pay and just
because they want to help did not jump in because they did not know an
answer.
In the future if you do not get an answer here you might try the web forums.
Different people hang out there and also more MS people hang out there.
http://forums.microsoft.com/msdn/showforum.aspx?forumid=82&siteid=1
Oh, by the way. I assume at some point you might want help in the future.
Being hostile is a great way to get someone to help.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"David Norman" <DavidNorman@.discussions.microsoft.com> wrote in message
news:EEE6DAE4-46BB-4D6F-9E98-790176EBC0F9@.microsoft.com...
>I finally found a bug report on Connect for SQL Server 2005 SP2 (Client
>Tools)
> http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=260746
> Microsoft will "consider fixing it in a future release". There is no
> workaround listed, and I have found nothing better than selectively
> removing
> and adding the customproperties subtree to enable different parts of the
> report designer (which of course is a big nuisance).
> BTW thanks world for not replying to my posts!
> "David Norman" wrote:
>> It appears this error does not occur for the same report model on a PC
>> which
>> doesn't have VS2005 SP1 installed!
>> "David Norman" wrote:
>> > I have also noticed that if I open a Report Builder report in Report
>> > Designer
>> > and change the data source guid to match the data source in the report
>> > server
>> > project, the preview displays the expected results and the generic
>> > query
>> > designer view also works as expected, but the "query could not be
>> > loaded"
>> > message still appears when attempting to use the data tab without the
>> > query
>> > designer.
>> >
>> > "David Norman" wrote:
>> >
>> > > I have created a report model based on an SSAS database. It is usable
>> > > without
>> > > errors with Report Builder as far as I can tell. However with Report
>> > > Designer, the layout displays the cube elements but errors on preview
>> > > as
>> > > follows:
>> > >
>> > > "The 'PerspectiveId' custom property for the 'query' perspective is
>> > > either
>> > > not set or is not set to the string data type."
>> > >
>> > > This is an error that has cropped up before but I'm not aware of a
>> > > bug
>> > > report for it. The forum and blog guidance I have for fixing it is
>> > > to:
>> > >
>> > > - Create a report builder report and save it to file
>> > > - Copy the customproperties xml subtree and paste it into the Report
>> > > Designer report
>> > >
>> > > I have done this but unfortunately this also errors on reopening the
>> > > report
>> > > as follows:
>> > >
>> > > "A connection cannot be made to the database. Set and test the
>> > > connection
>> > > string. Additional information: TODO - change code to use RsProxy
>> > > object
>> > > (Microsoft.ReportingServices.QueryDesigners)"
>> > >
>> > > Notwithstanding the slightly disconcerting TODO comment lingering in
>> > > the
>> > > code, can anyone advise cause and resolution/workaround?
>> > >
>> > > Thanks in advance
>> > > David
>> > >
>> > > using:
>> > > - SQL Server 2005 Analysis Services 9.0.3042
>> > > - Windows XP Pro SP2
>> > > - Visual Studio 2005 SP1
>> > >
>> > > -- report designer rdl follows
>> > > --
>> > >
>> > > <?xml version="1.0" encoding="utf-8"?>
>> > > <Report
>> > > xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition"
>> > > xmlns:rd="">http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
>> > > <DataSources>
>> > > <DataSource Name="dataSource1">
>> > > <DataSourceReference>dataSource1</DataSourceReference>
>> > >
>> > > <rd:DataSourceID>6d24178d-90d5-486e-a311-a4d939b769ea</rd:DataSourceID>
>> > > </DataSource>
>> > > </DataSources>
>> > > <BottomMargin>2.5cm</BottomMargin>
>> > > <RightMargin>2.5cm</RightMargin>
>> > > <PageWidth>21cm</PageWidth>
>> > > <rd:DrawGrid>true</rd:DrawGrid>
>> > > <InteractiveWidth>21cm</InteractiveWidth>
>> > > <rd:GridSpacing>0.25cm</rd:GridSpacing>
>> > > <rd:SnapToGrid>true</rd:SnapToGrid>
>> > > <Body>
>> > > <ColumnSpacing>1cm</ColumnSpacing>
>> > > <Height>5cm</Height>
>> > > </Body>
>> > > <rd:ReportID>cdfcad95-4a03-4a8d-82a6-048cac98eb26</rd:ReportID>
>> > > <LeftMargin>2.5cm</LeftMargin>
>> > > <DataSets>
>> > > <DataSet Name="DataSet1">
>> > > <Query>
>> > > <CommandText><SemanticQuery
>> > > xmlns="http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling"
>> > > xmlns:xsd="http://www.w3.org/2001/XMLSchema"
>> > > xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
>> > > xmlns:qd="http://schemas.microsoft.com/sqlserver/2004/11/semanticquerydesign"
>> > > xmlns:rb="">http://schemas.microsoft.com/sqlserver/2004/11/reportbuilder">
>> > > <Hierarchies>
>> > > <Hierarchy>
>> > > <BaseEntity>
>> > > <!--DimGeneric-->
>> > > <EntityID
>> > > xmlns:np="np:Entity_Dimension_DimGeneric</EntityID>">http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling">np:Entity_Dimension_DimGeneric</EntityID>
>> > > </BaseEntity>
>> > > <Groupings>
>> > > <Grouping Name="Generic Description">
>> > > <Expression Name="Generic Description">
>> > > <AttributeRef>
>> > > <!--Generic Description-->
>> > > <AttributeID
>> > > xmlns:np="np:Attribute_Hierarchy_Generic.Generic_Description</AttributeID>">http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling">np:Attribute_Hierarchy_Generic.Generic_Description</AttributeID>
>> > > </AttributeRef>
>> > > </Expression>
>> > > </Grouping>
>> > > </Groupings>
>> > > </Hierarchy>
>> > > </Hierarchies>
>> > >
>> > > --start of report builder sourced subtree
>> > >
>> > > <CustomProperties>
>> > > <CustomProperty Name="qd:PerspectiveID">
>> > > <Value
>> > > xsi:type="xsd:string">http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling:Perspective_Cube_CubeGeneric</Value>
>> > > </CustomProperty>
>> > > </CustomProperties>
>> > >
>> > > --end of report builder sourced subtree
>> > >
>> > > </SemanticQuery></CommandText>
>> > > <DataSourceName>dataSource1</DataSourceName>
>> > > </Query>
>> > > <Fields>
>> > > <Field Name="Generic_Description">
>> > > <rd:TypeName>System.String</rd:TypeName>
>> > > <DataField>Generic Description</DataField>
>> > > </Field>
>> > > </Fields>
>> > > </DataSet>
>> > > </DataSets>
>> > > <Width>16cm</Width>
>> > > <InteractiveHeight>29.7cm</InteractiveHeight>
>> > > <Language>en-US</Language>
>> > > <TopMargin>2.5cm</TopMargin>
>> > > <PageHeight>29.7cm</PageHeight>
>> > > </Report>|||Didn't intend to be hostile, sorry it came across that way. Hope someone gets
some benefit from my investigations.
"Bruce L-C [MVP]" wrote:
> This is peer supported. Plus, MS people do not tend to be here. Although if
> you have MSDN subscription you can do a managed newsgroup where you register
> an alias and they guarantee I believe an answer in two days.
> The fact no one answered means that people doing this for no pay and just
> because they want to help did not jump in because they did not know an
> answer.
> In the future if you do not get an answer here you might try the web forums.
> Different people hang out there and also more MS people hang out there.
> http://forums.microsoft.com/msdn/showforum.aspx?forumid=82&siteid=1
> Oh, by the way. I assume at some point you might want help in the future.
> Being hostile is a great way to get someone to help.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "David Norman" <DavidNorman@.discussions.microsoft.com> wrote in message
> news:EEE6DAE4-46BB-4D6F-9E98-790176EBC0F9@.microsoft.com...
> >I finally found a bug report on Connect for SQL Server 2005 SP2 (Client
> >Tools)
> >
> > http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=260746
> >
> > Microsoft will "consider fixing it in a future release". There is no
> > workaround listed, and I have found nothing better than selectively
> > removing
> > and adding the customproperties subtree to enable different parts of the
> > report designer (which of course is a big nuisance).
> >
> > BTW thanks world for not replying to my posts!
> >
> > "David Norman" wrote:
> >
> >> It appears this error does not occur for the same report model on a PC
> >> which
> >> doesn't have VS2005 SP1 installed!
> >>
> >> "David Norman" wrote:
> >>
> >> > I have also noticed that if I open a Report Builder report in Report
> >> > Designer
> >> > and change the data source guid to match the data source in the report
> >> > server
> >> > project, the preview displays the expected results and the generic
> >> > query
> >> > designer view also works as expected, but the "query could not be
> >> > loaded"
> >> > message still appears when attempting to use the data tab without the
> >> > query
> >> > designer.
> >> >
> >> > "David Norman" wrote:
> >> >
> >> > > I have created a report model based on an SSAS database. It is usable
> >> > > without
> >> > > errors with Report Builder as far as I can tell. However with Report
> >> > > Designer, the layout displays the cube elements but errors on preview
> >> > > as
> >> > > follows:
> >> > >
> >> > > "The 'PerspectiveId' custom property for the 'query' perspective is
> >> > > either
> >> > > not set or is not set to the string data type."
> >> > >
> >> > > This is an error that has cropped up before but I'm not aware of a
> >> > > bug
> >> > > report for it. The forum and blog guidance I have for fixing it is
> >> > > to:
> >> > >
> >> > > - Create a report builder report and save it to file
> >> > > - Copy the customproperties xml subtree and paste it into the Report
> >> > > Designer report
> >> > >
> >> > > I have done this but unfortunately this also errors on reopening the
> >> > > report
> >> > > as follows:
> >> > >
> >> > > "A connection cannot be made to the database. Set and test the
> >> > > connection
> >> > > string. Additional information: TODO - change code to use RsProxy
> >> > > object
> >> > > (Microsoft.ReportingServices.QueryDesigners)"
> >> > >
> >> > > Notwithstanding the slightly disconcerting TODO comment lingering in
> >> > > the
> >> > > code, can anyone advise cause and resolution/workaround?
> >> > >
> >> > > Thanks in advance
> >> > > David
> >> > >
> >> > > using:
> >> > > - SQL Server 2005 Analysis Services 9.0.3042
> >> > > - Windows XP Pro SP2
> >> > > - Visual Studio 2005 SP1
> >> > >
> >> > > -- report designer rdl follows
> >> > > --
> >> > >
> >> > > <?xml version="1.0" encoding="utf-8"?>
> >> > > <Report
> >> > > xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition"
> >> > > xmlns:rd="">http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
> >> > > <DataSources>
> >> > > <DataSource Name="dataSource1">
> >> > > <DataSourceReference>dataSource1</DataSourceReference>
> >> > >
> >> > > <rd:DataSourceID>6d24178d-90d5-486e-a311-a4d939b769ea</rd:DataSourceID>
> >> > > </DataSource>
> >> > > </DataSources>
> >> > > <BottomMargin>2.5cm</BottomMargin>
> >> > > <RightMargin>2.5cm</RightMargin>
> >> > > <PageWidth>21cm</PageWidth>
> >> > > <rd:DrawGrid>true</rd:DrawGrid>
> >> > > <InteractiveWidth>21cm</InteractiveWidth>
> >> > > <rd:GridSpacing>0.25cm</rd:GridSpacing>
> >> > > <rd:SnapToGrid>true</rd:SnapToGrid>
> >> > > <Body>
> >> > > <ColumnSpacing>1cm</ColumnSpacing>
> >> > > <Height>5cm</Height>
> >> > > </Body>
> >> > > <rd:ReportID>cdfcad95-4a03-4a8d-82a6-048cac98eb26</rd:ReportID>
> >> > > <LeftMargin>2.5cm</LeftMargin>
> >> > > <DataSets>
> >> > > <DataSet Name="DataSet1">
> >> > > <Query>
> >> > > <CommandText><SemanticQuery
> >> > > xmlns="http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling"
> >> > > xmlns:xsd="http://www.w3.org/2001/XMLSchema"
> >> > > xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
> >> > > xmlns:qd="http://schemas.microsoft.com/sqlserver/2004/11/semanticquerydesign"
> >> > > xmlns:rb="">http://schemas.microsoft.com/sqlserver/2004/11/reportbuilder">
> >> > > <Hierarchies>
> >> > > <Hierarchy>
> >> > > <BaseEntity>
> >> > > <!--DimGeneric-->
> >> > > <EntityID
> >> > > xmlns:np="np:Entity_Dimension_DimGeneric</EntityID>">http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling">np:Entity_Dimension_DimGeneric</EntityID>
> >> > > </BaseEntity>
> >> > > <Groupings>
> >> > > <Grouping Name="Generic Description">
> >> > > <Expression Name="Generic Description">
> >> > > <AttributeRef>
> >> > > <!--Generic Description-->
> >> > > <AttributeID
> >> > > xmlns:np="np:Attribute_Hierarchy_Generic.Generic_Description</AttributeID>">http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling">np:Attribute_Hierarchy_Generic.Generic_Description</AttributeID>
> >> > > </AttributeRef>
> >> > > </Expression>
> >> > > </Grouping>
> >> > > </Groupings>
> >> > > </Hierarchy>
> >> > > </Hierarchies>
> >> > >
> >> > > --start of report builder sourced subtree
> >> > >
> >> > > <CustomProperties>
> >> > > <CustomProperty Name="qd:PerspectiveID">
> >> > > <Value
> >> > > xsi:type="xsd:string">http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling:Perspective_Cube_CubeGeneric</Value>
> >> > > </CustomProperty>
> >> > > </CustomProperties>
> >> > >
> >> > > --end of report builder sourced subtree
> >> > >
> >> > > </SemanticQuery></CommandText>
> >> > > <DataSourceName>dataSource1</DataSourceName>
> >> > > </Query>
> >> > > <Fields>
> >> > > <Field Name="Generic_Description">
> >> > > <rd:TypeName>System.String</rd:TypeName>
> >> > > <DataField>Generic Description</DataField>
> >> > > </Field>
> >> > > </Fields>
> >> > > </DataSet>
> >> > > </DataSets>
> >> > > <Width>16cm</Width>
> >> > > <InteractiveHeight>29.7cm</InteractiveHeight>
> >> > > <Language>en-US</Language>
> >> > > <TopMargin>2.5cm</TopMargin>
> >> > > <PageHeight>29.7cm</PageHeight>
> >> > > </Report>
>
>sql
errors with Report Builder as far as I can tell. However with Report
Designer, the layout displays the cube elements but errors on preview as
follows:
"The 'PerspectiveId' custom property for the 'query' perspective is either
not set or is not set to the string data type."
This is an error that has cropped up before but I'm not aware of a bug
report for it. The forum and blog guidance I have for fixing it is to:
- Create a report builder report and save it to file
- Copy the customproperties xml subtree and paste it into the Report
Designer report
I have done this but unfortunately this also errors on reopening the report
as follows:
"A connection cannot be made to the database. Set and test the connection
string. Additional information: TODO - change code to use RsProxy object
(Microsoft.ReportingServices.QueryDesigners)"
Notwithstanding the slightly disconcerting TODO comment lingering in the
code, can anyone advise cause and resolution/workaround?
Thanks in advance
David
using:
- SQL Server 2005 Analysis Services 9.0.3042
- Windows XP Pro SP2
- Visual Studio 2005 SP1
-- report designer rdl follows
--
<?xml version="1.0" encoding="utf-8"?>
<Report
xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition"
xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<DataSources>
<DataSource Name="dataSource1">
<DataSourceReference>dataSource1</DataSourceReference>
<rd:DataSourceID>6d24178d-90d5-486e-a311-a4d939b769ea</rd:DataSourceID>
</DataSource>
</DataSources>
<BottomMargin>2.5cm</BottomMargin>
<RightMargin>2.5cm</RightMargin>
<PageWidth>21cm</PageWidth>
<rd:DrawGrid>true</rd:DrawGrid>
<InteractiveWidth>21cm</InteractiveWidth>
<rd:GridSpacing>0.25cm</rd:GridSpacing>
<rd:SnapToGrid>true</rd:SnapToGrid>
<Body>
<ColumnSpacing>1cm</ColumnSpacing>
<Height>5cm</Height>
</Body>
<rd:ReportID>cdfcad95-4a03-4a8d-82a6-048cac98eb26</rd:ReportID>
<LeftMargin>2.5cm</LeftMargin>
<DataSets>
<DataSet Name="DataSet1">
<Query>
<CommandText><SemanticQuery
xmlns="http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:qd="http://schemas.microsoft.com/sqlserver/2004/11/semanticquerydesign"
xmlns:rb="http://schemas.microsoft.com/sqlserver/2004/11/reportbuilder">
<Hierarchies>
<Hierarchy>
<BaseEntity>
<!--DimGeneric-->
<EntityID
xmlns:np="http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling">np:Entity_Dimension_DimGeneric</EntityID>
</BaseEntity>
<Groupings>
<Grouping Name="Generic Description">
<Expression Name="Generic Description">
<AttributeRef>
<!--Generic Description-->
<AttributeID
xmlns:np="http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling">np:Attribute_Hierarchy_Generic.Generic_Description</AttributeID>
</AttributeRef>
</Expression>
</Grouping>
</Groupings>
</Hierarchy>
</Hierarchies>
--start of report builder sourced subtree
<CustomProperties>
<CustomProperty Name="qd:PerspectiveID">
<Value
xsi:type="xsd:string">http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling:Perspective_Cube_CubeGeneric</Value>
</CustomProperty>
</CustomProperties>
--end of report builder sourced subtree
</SemanticQuery></CommandText>
<DataSourceName>dataSource1</DataSourceName>
</Query>
<Fields>
<Field Name="Generic_Description">
<rd:TypeName>System.String</rd:TypeName>
<DataField>Generic Description</DataField>
</Field>
</Fields>
</DataSet>
</DataSets>
<Width>16cm</Width>
<InteractiveHeight>29.7cm</InteractiveHeight>
<Language>en-US</Language>
<TopMargin>2.5cm</TopMargin>
<PageHeight>29.7cm</PageHeight>
</Report>I have also noticed that if I open a Report Builder report in Report Designer
and change the data source guid to match the data source in the report server
project, the preview displays the expected results and the generic query
designer view also works as expected, but the "query could not be loaded"
message still appears when attempting to use the data tab without the query
designer.
"David Norman" wrote:
> I have created a report model based on an SSAS database. It is usable without
> errors with Report Builder as far as I can tell. However with Report
> Designer, the layout displays the cube elements but errors on preview as
> follows:
> "The 'PerspectiveId' custom property for the 'query' perspective is either
> not set or is not set to the string data type."
> This is an error that has cropped up before but I'm not aware of a bug
> report for it. The forum and blog guidance I have for fixing it is to:
> - Create a report builder report and save it to file
> - Copy the customproperties xml subtree and paste it into the Report
> Designer report
> I have done this but unfortunately this also errors on reopening the report
> as follows:
> "A connection cannot be made to the database. Set and test the connection
> string. Additional information: TODO - change code to use RsProxy object
> (Microsoft.ReportingServices.QueryDesigners)"
> Notwithstanding the slightly disconcerting TODO comment lingering in the
> code, can anyone advise cause and resolution/workaround?
> Thanks in advance
> David
> using:
> - SQL Server 2005 Analysis Services 9.0.3042
> - Windows XP Pro SP2
> - Visual Studio 2005 SP1
> -- report designer rdl follows
> --
> <?xml version="1.0" encoding="utf-8"?>
> <Report
> xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition"
> xmlns:rd="">http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
> <DataSources>
> <DataSource Name="dataSource1">
> <DataSourceReference>dataSource1</DataSourceReference>
> <rd:DataSourceID>6d24178d-90d5-486e-a311-a4d939b769ea</rd:DataSourceID>
> </DataSource>
> </DataSources>
> <BottomMargin>2.5cm</BottomMargin>
> <RightMargin>2.5cm</RightMargin>
> <PageWidth>21cm</PageWidth>
> <rd:DrawGrid>true</rd:DrawGrid>
> <InteractiveWidth>21cm</InteractiveWidth>
> <rd:GridSpacing>0.25cm</rd:GridSpacing>
> <rd:SnapToGrid>true</rd:SnapToGrid>
> <Body>
> <ColumnSpacing>1cm</ColumnSpacing>
> <Height>5cm</Height>
> </Body>
> <rd:ReportID>cdfcad95-4a03-4a8d-82a6-048cac98eb26</rd:ReportID>
> <LeftMargin>2.5cm</LeftMargin>
> <DataSets>
> <DataSet Name="DataSet1">
> <Query>
> <CommandText><SemanticQuery
> xmlns="http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling"
> xmlns:xsd="http://www.w3.org/2001/XMLSchema"
> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
> xmlns:qd="http://schemas.microsoft.com/sqlserver/2004/11/semanticquerydesign"
> xmlns:rb="">http://schemas.microsoft.com/sqlserver/2004/11/reportbuilder">
> <Hierarchies>
> <Hierarchy>
> <BaseEntity>
> <!--DimGeneric-->
> <EntityID
> xmlns:np="np:Entity_Dimension_DimGeneric</EntityID>">http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling">np:Entity_Dimension_DimGeneric</EntityID>
> </BaseEntity>
> <Groupings>
> <Grouping Name="Generic Description">
> <Expression Name="Generic Description">
> <AttributeRef>
> <!--Generic Description-->
> <AttributeID
> xmlns:np="np:Attribute_Hierarchy_Generic.Generic_Description</AttributeID>">http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling">np:Attribute_Hierarchy_Generic.Generic_Description</AttributeID>
> </AttributeRef>
> </Expression>
> </Grouping>
> </Groupings>
> </Hierarchy>
> </Hierarchies>
> --start of report builder sourced subtree
> <CustomProperties>
> <CustomProperty Name="qd:PerspectiveID">
> <Value
> xsi:type="xsd:string">http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling:Perspective_Cube_CubeGeneric</Value>
> </CustomProperty>
> </CustomProperties>
> --end of report builder sourced subtree
> </SemanticQuery></CommandText>
> <DataSourceName>dataSource1</DataSourceName>
> </Query>
> <Fields>
> <Field Name="Generic_Description">
> <rd:TypeName>System.String</rd:TypeName>
> <DataField>Generic Description</DataField>
> </Field>
> </Fields>
> </DataSet>
> </DataSets>
> <Width>16cm</Width>
> <InteractiveHeight>29.7cm</InteractiveHeight>
> <Language>en-US</Language>
> <TopMargin>2.5cm</TopMargin>
> <PageHeight>29.7cm</PageHeight>
> </Report>|||It appears this error does not occur for the same report model on a PC which
doesn't have VS2005 SP1 installed!
"David Norman" wrote:
> I have also noticed that if I open a Report Builder report in Report Designer
> and change the data source guid to match the data source in the report server
> project, the preview displays the expected results and the generic query
> designer view also works as expected, but the "query could not be loaded"
> message still appears when attempting to use the data tab without the query
> designer.
> "David Norman" wrote:
> > I have created a report model based on an SSAS database. It is usable without
> > errors with Report Builder as far as I can tell. However with Report
> > Designer, the layout displays the cube elements but errors on preview as
> > follows:
> >
> > "The 'PerspectiveId' custom property for the 'query' perspective is either
> > not set or is not set to the string data type."
> >
> > This is an error that has cropped up before but I'm not aware of a bug
> > report for it. The forum and blog guidance I have for fixing it is to:
> >
> > - Create a report builder report and save it to file
> > - Copy the customproperties xml subtree and paste it into the Report
> > Designer report
> >
> > I have done this but unfortunately this also errors on reopening the report
> > as follows:
> >
> > "A connection cannot be made to the database. Set and test the connection
> > string. Additional information: TODO - change code to use RsProxy object
> > (Microsoft.ReportingServices.QueryDesigners)"
> >
> > Notwithstanding the slightly disconcerting TODO comment lingering in the
> > code, can anyone advise cause and resolution/workaround?
> >
> > Thanks in advance
> > David
> >
> > using:
> > - SQL Server 2005 Analysis Services 9.0.3042
> > - Windows XP Pro SP2
> > - Visual Studio 2005 SP1
> >
> > -- report designer rdl follows
> > --
> >
> > <?xml version="1.0" encoding="utf-8"?>
> > <Report
> > xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition"
> > xmlns:rd="">http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
> > <DataSources>
> > <DataSource Name="dataSource1">
> > <DataSourceReference>dataSource1</DataSourceReference>
> > <rd:DataSourceID>6d24178d-90d5-486e-a311-a4d939b769ea</rd:DataSourceID>
> > </DataSource>
> > </DataSources>
> > <BottomMargin>2.5cm</BottomMargin>
> > <RightMargin>2.5cm</RightMargin>
> > <PageWidth>21cm</PageWidth>
> > <rd:DrawGrid>true</rd:DrawGrid>
> > <InteractiveWidth>21cm</InteractiveWidth>
> > <rd:GridSpacing>0.25cm</rd:GridSpacing>
> > <rd:SnapToGrid>true</rd:SnapToGrid>
> > <Body>
> > <ColumnSpacing>1cm</ColumnSpacing>
> > <Height>5cm</Height>
> > </Body>
> > <rd:ReportID>cdfcad95-4a03-4a8d-82a6-048cac98eb26</rd:ReportID>
> > <LeftMargin>2.5cm</LeftMargin>
> > <DataSets>
> > <DataSet Name="DataSet1">
> > <Query>
> > <CommandText><SemanticQuery
> > xmlns="http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling"
> > xmlns:xsd="http://www.w3.org/2001/XMLSchema"
> > xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
> > xmlns:qd="http://schemas.microsoft.com/sqlserver/2004/11/semanticquerydesign"
> > xmlns:rb="">http://schemas.microsoft.com/sqlserver/2004/11/reportbuilder">
> > <Hierarchies>
> > <Hierarchy>
> > <BaseEntity>
> > <!--DimGeneric-->
> > <EntityID
> > xmlns:np="np:Entity_Dimension_DimGeneric</EntityID>">http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling">np:Entity_Dimension_DimGeneric</EntityID>
> > </BaseEntity>
> > <Groupings>
> > <Grouping Name="Generic Description">
> > <Expression Name="Generic Description">
> > <AttributeRef>
> > <!--Generic Description-->
> > <AttributeID
> > xmlns:np="np:Attribute_Hierarchy_Generic.Generic_Description</AttributeID>">http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling">np:Attribute_Hierarchy_Generic.Generic_Description</AttributeID>
> > </AttributeRef>
> > </Expression>
> > </Grouping>
> > </Groupings>
> > </Hierarchy>
> > </Hierarchies>
> >
> > --start of report builder sourced subtree
> >
> > <CustomProperties>
> > <CustomProperty Name="qd:PerspectiveID">
> > <Value
> > xsi:type="xsd:string">http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling:Perspective_Cube_CubeGeneric</Value>
> > </CustomProperty>
> > </CustomProperties>
> >
> > --end of report builder sourced subtree
> >
> > </SemanticQuery></CommandText>
> > <DataSourceName>dataSource1</DataSourceName>
> > </Query>
> > <Fields>
> > <Field Name="Generic_Description">
> > <rd:TypeName>System.String</rd:TypeName>
> > <DataField>Generic Description</DataField>
> > </Field>
> > </Fields>
> > </DataSet>
> > </DataSets>
> > <Width>16cm</Width>
> > <InteractiveHeight>29.7cm</InteractiveHeight>
> > <Language>en-US</Language>
> > <TopMargin>2.5cm</TopMargin>
> > <PageHeight>29.7cm</PageHeight>
> > </Report>|||I finally found a bug report on Connect for SQL Server 2005 SP2 (Client Tools)
http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=260746
Microsoft will "consider fixing it in a future release". There is no
workaround listed, and I have found nothing better than selectively removing
and adding the customproperties subtree to enable different parts of the
report designer (which of course is a big nuisance).
BTW thanks world for not replying to my posts!
"David Norman" wrote:
> It appears this error does not occur for the same report model on a PC which
> doesn't have VS2005 SP1 installed!
> "David Norman" wrote:
> > I have also noticed that if I open a Report Builder report in Report Designer
> > and change the data source guid to match the data source in the report server
> > project, the preview displays the expected results and the generic query
> > designer view also works as expected, but the "query could not be loaded"
> > message still appears when attempting to use the data tab without the query
> > designer.
> >
> > "David Norman" wrote:
> >
> > > I have created a report model based on an SSAS database. It is usable without
> > > errors with Report Builder as far as I can tell. However with Report
> > > Designer, the layout displays the cube elements but errors on preview as
> > > follows:
> > >
> > > "The 'PerspectiveId' custom property for the 'query' perspective is either
> > > not set or is not set to the string data type."
> > >
> > > This is an error that has cropped up before but I'm not aware of a bug
> > > report for it. The forum and blog guidance I have for fixing it is to:
> > >
> > > - Create a report builder report and save it to file
> > > - Copy the customproperties xml subtree and paste it into the Report
> > > Designer report
> > >
> > > I have done this but unfortunately this also errors on reopening the report
> > > as follows:
> > >
> > > "A connection cannot be made to the database. Set and test the connection
> > > string. Additional information: TODO - change code to use RsProxy object
> > > (Microsoft.ReportingServices.QueryDesigners)"
> > >
> > > Notwithstanding the slightly disconcerting TODO comment lingering in the
> > > code, can anyone advise cause and resolution/workaround?
> > >
> > > Thanks in advance
> > > David
> > >
> > > using:
> > > - SQL Server 2005 Analysis Services 9.0.3042
> > > - Windows XP Pro SP2
> > > - Visual Studio 2005 SP1
> > >
> > > -- report designer rdl follows
> > > --
> > >
> > > <?xml version="1.0" encoding="utf-8"?>
> > > <Report
> > > xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition"
> > > xmlns:rd="">http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
> > > <DataSources>
> > > <DataSource Name="dataSource1">
> > > <DataSourceReference>dataSource1</DataSourceReference>
> > > <rd:DataSourceID>6d24178d-90d5-486e-a311-a4d939b769ea</rd:DataSourceID>
> > > </DataSource>
> > > </DataSources>
> > > <BottomMargin>2.5cm</BottomMargin>
> > > <RightMargin>2.5cm</RightMargin>
> > > <PageWidth>21cm</PageWidth>
> > > <rd:DrawGrid>true</rd:DrawGrid>
> > > <InteractiveWidth>21cm</InteractiveWidth>
> > > <rd:GridSpacing>0.25cm</rd:GridSpacing>
> > > <rd:SnapToGrid>true</rd:SnapToGrid>
> > > <Body>
> > > <ColumnSpacing>1cm</ColumnSpacing>
> > > <Height>5cm</Height>
> > > </Body>
> > > <rd:ReportID>cdfcad95-4a03-4a8d-82a6-048cac98eb26</rd:ReportID>
> > > <LeftMargin>2.5cm</LeftMargin>
> > > <DataSets>
> > > <DataSet Name="DataSet1">
> > > <Query>
> > > <CommandText><SemanticQuery
> > > xmlns="http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling"
> > > xmlns:xsd="http://www.w3.org/2001/XMLSchema"
> > > xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
> > > xmlns:qd="http://schemas.microsoft.com/sqlserver/2004/11/semanticquerydesign"
> > > xmlns:rb="">http://schemas.microsoft.com/sqlserver/2004/11/reportbuilder">
> > > <Hierarchies>
> > > <Hierarchy>
> > > <BaseEntity>
> > > <!--DimGeneric-->
> > > <EntityID
> > > xmlns:np="np:Entity_Dimension_DimGeneric</EntityID>">http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling">np:Entity_Dimension_DimGeneric</EntityID>
> > > </BaseEntity>
> > > <Groupings>
> > > <Grouping Name="Generic Description">
> > > <Expression Name="Generic Description">
> > > <AttributeRef>
> > > <!--Generic Description-->
> > > <AttributeID
> > > xmlns:np="np:Attribute_Hierarchy_Generic.Generic_Description</AttributeID>">http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling">np:Attribute_Hierarchy_Generic.Generic_Description</AttributeID>
> > > </AttributeRef>
> > > </Expression>
> > > </Grouping>
> > > </Groupings>
> > > </Hierarchy>
> > > </Hierarchies>
> > >
> > > --start of report builder sourced subtree
> > >
> > > <CustomProperties>
> > > <CustomProperty Name="qd:PerspectiveID">
> > > <Value
> > > xsi:type="xsd:string">http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling:Perspective_Cube_CubeGeneric</Value>
> > > </CustomProperty>
> > > </CustomProperties>
> > >
> > > --end of report builder sourced subtree
> > >
> > > </SemanticQuery></CommandText>
> > > <DataSourceName>dataSource1</DataSourceName>
> > > </Query>
> > > <Fields>
> > > <Field Name="Generic_Description">
> > > <rd:TypeName>System.String</rd:TypeName>
> > > <DataField>Generic Description</DataField>
> > > </Field>
> > > </Fields>
> > > </DataSet>
> > > </DataSets>
> > > <Width>16cm</Width>
> > > <InteractiveHeight>29.7cm</InteractiveHeight>
> > > <Language>en-US</Language>
> > > <TopMargin>2.5cm</TopMargin>
> > > <PageHeight>29.7cm</PageHeight>
> > > </Report>|||This is peer supported. Plus, MS people do not tend to be here. Although if
you have MSDN subscription you can do a managed newsgroup where you register
an alias and they guarantee I believe an answer in two days.
The fact no one answered means that people doing this for no pay and just
because they want to help did not jump in because they did not know an
answer.
In the future if you do not get an answer here you might try the web forums.
Different people hang out there and also more MS people hang out there.
http://forums.microsoft.com/msdn/showforum.aspx?forumid=82&siteid=1
Oh, by the way. I assume at some point you might want help in the future.
Being hostile is a great way to get someone to help.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"David Norman" <DavidNorman@.discussions.microsoft.com> wrote in message
news:EEE6DAE4-46BB-4D6F-9E98-790176EBC0F9@.microsoft.com...
>I finally found a bug report on Connect for SQL Server 2005 SP2 (Client
>Tools)
> http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=260746
> Microsoft will "consider fixing it in a future release". There is no
> workaround listed, and I have found nothing better than selectively
> removing
> and adding the customproperties subtree to enable different parts of the
> report designer (which of course is a big nuisance).
> BTW thanks world for not replying to my posts!
> "David Norman" wrote:
>> It appears this error does not occur for the same report model on a PC
>> which
>> doesn't have VS2005 SP1 installed!
>> "David Norman" wrote:
>> > I have also noticed that if I open a Report Builder report in Report
>> > Designer
>> > and change the data source guid to match the data source in the report
>> > server
>> > project, the preview displays the expected results and the generic
>> > query
>> > designer view also works as expected, but the "query could not be
>> > loaded"
>> > message still appears when attempting to use the data tab without the
>> > query
>> > designer.
>> >
>> > "David Norman" wrote:
>> >
>> > > I have created a report model based on an SSAS database. It is usable
>> > > without
>> > > errors with Report Builder as far as I can tell. However with Report
>> > > Designer, the layout displays the cube elements but errors on preview
>> > > as
>> > > follows:
>> > >
>> > > "The 'PerspectiveId' custom property for the 'query' perspective is
>> > > either
>> > > not set or is not set to the string data type."
>> > >
>> > > This is an error that has cropped up before but I'm not aware of a
>> > > bug
>> > > report for it. The forum and blog guidance I have for fixing it is
>> > > to:
>> > >
>> > > - Create a report builder report and save it to file
>> > > - Copy the customproperties xml subtree and paste it into the Report
>> > > Designer report
>> > >
>> > > I have done this but unfortunately this also errors on reopening the
>> > > report
>> > > as follows:
>> > >
>> > > "A connection cannot be made to the database. Set and test the
>> > > connection
>> > > string. Additional information: TODO - change code to use RsProxy
>> > > object
>> > > (Microsoft.ReportingServices.QueryDesigners)"
>> > >
>> > > Notwithstanding the slightly disconcerting TODO comment lingering in
>> > > the
>> > > code, can anyone advise cause and resolution/workaround?
>> > >
>> > > Thanks in advance
>> > > David
>> > >
>> > > using:
>> > > - SQL Server 2005 Analysis Services 9.0.3042
>> > > - Windows XP Pro SP2
>> > > - Visual Studio 2005 SP1
>> > >
>> > > -- report designer rdl follows
>> > > --
>> > >
>> > > <?xml version="1.0" encoding="utf-8"?>
>> > > <Report
>> > > xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition"
>> > > xmlns:rd="">http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
>> > > <DataSources>
>> > > <DataSource Name="dataSource1">
>> > > <DataSourceReference>dataSource1</DataSourceReference>
>> > >
>> > > <rd:DataSourceID>6d24178d-90d5-486e-a311-a4d939b769ea</rd:DataSourceID>
>> > > </DataSource>
>> > > </DataSources>
>> > > <BottomMargin>2.5cm</BottomMargin>
>> > > <RightMargin>2.5cm</RightMargin>
>> > > <PageWidth>21cm</PageWidth>
>> > > <rd:DrawGrid>true</rd:DrawGrid>
>> > > <InteractiveWidth>21cm</InteractiveWidth>
>> > > <rd:GridSpacing>0.25cm</rd:GridSpacing>
>> > > <rd:SnapToGrid>true</rd:SnapToGrid>
>> > > <Body>
>> > > <ColumnSpacing>1cm</ColumnSpacing>
>> > > <Height>5cm</Height>
>> > > </Body>
>> > > <rd:ReportID>cdfcad95-4a03-4a8d-82a6-048cac98eb26</rd:ReportID>
>> > > <LeftMargin>2.5cm</LeftMargin>
>> > > <DataSets>
>> > > <DataSet Name="DataSet1">
>> > > <Query>
>> > > <CommandText><SemanticQuery
>> > > xmlns="http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling"
>> > > xmlns:xsd="http://www.w3.org/2001/XMLSchema"
>> > > xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
>> > > xmlns:qd="http://schemas.microsoft.com/sqlserver/2004/11/semanticquerydesign"
>> > > xmlns:rb="">http://schemas.microsoft.com/sqlserver/2004/11/reportbuilder">
>> > > <Hierarchies>
>> > > <Hierarchy>
>> > > <BaseEntity>
>> > > <!--DimGeneric-->
>> > > <EntityID
>> > > xmlns:np="np:Entity_Dimension_DimGeneric</EntityID>">http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling">np:Entity_Dimension_DimGeneric</EntityID>
>> > > </BaseEntity>
>> > > <Groupings>
>> > > <Grouping Name="Generic Description">
>> > > <Expression Name="Generic Description">
>> > > <AttributeRef>
>> > > <!--Generic Description-->
>> > > <AttributeID
>> > > xmlns:np="np:Attribute_Hierarchy_Generic.Generic_Description</AttributeID>">http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling">np:Attribute_Hierarchy_Generic.Generic_Description</AttributeID>
>> > > </AttributeRef>
>> > > </Expression>
>> > > </Grouping>
>> > > </Groupings>
>> > > </Hierarchy>
>> > > </Hierarchies>
>> > >
>> > > --start of report builder sourced subtree
>> > >
>> > > <CustomProperties>
>> > > <CustomProperty Name="qd:PerspectiveID">
>> > > <Value
>> > > xsi:type="xsd:string">http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling:Perspective_Cube_CubeGeneric</Value>
>> > > </CustomProperty>
>> > > </CustomProperties>
>> > >
>> > > --end of report builder sourced subtree
>> > >
>> > > </SemanticQuery></CommandText>
>> > > <DataSourceName>dataSource1</DataSourceName>
>> > > </Query>
>> > > <Fields>
>> > > <Field Name="Generic_Description">
>> > > <rd:TypeName>System.String</rd:TypeName>
>> > > <DataField>Generic Description</DataField>
>> > > </Field>
>> > > </Fields>
>> > > </DataSet>
>> > > </DataSets>
>> > > <Width>16cm</Width>
>> > > <InteractiveHeight>29.7cm</InteractiveHeight>
>> > > <Language>en-US</Language>
>> > > <TopMargin>2.5cm</TopMargin>
>> > > <PageHeight>29.7cm</PageHeight>
>> > > </Report>|||Didn't intend to be hostile, sorry it came across that way. Hope someone gets
some benefit from my investigations.
"Bruce L-C [MVP]" wrote:
> This is peer supported. Plus, MS people do not tend to be here. Although if
> you have MSDN subscription you can do a managed newsgroup where you register
> an alias and they guarantee I believe an answer in two days.
> The fact no one answered means that people doing this for no pay and just
> because they want to help did not jump in because they did not know an
> answer.
> In the future if you do not get an answer here you might try the web forums.
> Different people hang out there and also more MS people hang out there.
> http://forums.microsoft.com/msdn/showforum.aspx?forumid=82&siteid=1
> Oh, by the way. I assume at some point you might want help in the future.
> Being hostile is a great way to get someone to help.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "David Norman" <DavidNorman@.discussions.microsoft.com> wrote in message
> news:EEE6DAE4-46BB-4D6F-9E98-790176EBC0F9@.microsoft.com...
> >I finally found a bug report on Connect for SQL Server 2005 SP2 (Client
> >Tools)
> >
> > http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=260746
> >
> > Microsoft will "consider fixing it in a future release". There is no
> > workaround listed, and I have found nothing better than selectively
> > removing
> > and adding the customproperties subtree to enable different parts of the
> > report designer (which of course is a big nuisance).
> >
> > BTW thanks world for not replying to my posts!
> >
> > "David Norman" wrote:
> >
> >> It appears this error does not occur for the same report model on a PC
> >> which
> >> doesn't have VS2005 SP1 installed!
> >>
> >> "David Norman" wrote:
> >>
> >> > I have also noticed that if I open a Report Builder report in Report
> >> > Designer
> >> > and change the data source guid to match the data source in the report
> >> > server
> >> > project, the preview displays the expected results and the generic
> >> > query
> >> > designer view also works as expected, but the "query could not be
> >> > loaded"
> >> > message still appears when attempting to use the data tab without the
> >> > query
> >> > designer.
> >> >
> >> > "David Norman" wrote:
> >> >
> >> > > I have created a report model based on an SSAS database. It is usable
> >> > > without
> >> > > errors with Report Builder as far as I can tell. However with Report
> >> > > Designer, the layout displays the cube elements but errors on preview
> >> > > as
> >> > > follows:
> >> > >
> >> > > "The 'PerspectiveId' custom property for the 'query' perspective is
> >> > > either
> >> > > not set or is not set to the string data type."
> >> > >
> >> > > This is an error that has cropped up before but I'm not aware of a
> >> > > bug
> >> > > report for it. The forum and blog guidance I have for fixing it is
> >> > > to:
> >> > >
> >> > > - Create a report builder report and save it to file
> >> > > - Copy the customproperties xml subtree and paste it into the Report
> >> > > Designer report
> >> > >
> >> > > I have done this but unfortunately this also errors on reopening the
> >> > > report
> >> > > as follows:
> >> > >
> >> > > "A connection cannot be made to the database. Set and test the
> >> > > connection
> >> > > string. Additional information: TODO - change code to use RsProxy
> >> > > object
> >> > > (Microsoft.ReportingServices.QueryDesigners)"
> >> > >
> >> > > Notwithstanding the slightly disconcerting TODO comment lingering in
> >> > > the
> >> > > code, can anyone advise cause and resolution/workaround?
> >> > >
> >> > > Thanks in advance
> >> > > David
> >> > >
> >> > > using:
> >> > > - SQL Server 2005 Analysis Services 9.0.3042
> >> > > - Windows XP Pro SP2
> >> > > - Visual Studio 2005 SP1
> >> > >
> >> > > -- report designer rdl follows
> >> > > --
> >> > >
> >> > > <?xml version="1.0" encoding="utf-8"?>
> >> > > <Report
> >> > > xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition"
> >> > > xmlns:rd="">http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
> >> > > <DataSources>
> >> > > <DataSource Name="dataSource1">
> >> > > <DataSourceReference>dataSource1</DataSourceReference>
> >> > >
> >> > > <rd:DataSourceID>6d24178d-90d5-486e-a311-a4d939b769ea</rd:DataSourceID>
> >> > > </DataSource>
> >> > > </DataSources>
> >> > > <BottomMargin>2.5cm</BottomMargin>
> >> > > <RightMargin>2.5cm</RightMargin>
> >> > > <PageWidth>21cm</PageWidth>
> >> > > <rd:DrawGrid>true</rd:DrawGrid>
> >> > > <InteractiveWidth>21cm</InteractiveWidth>
> >> > > <rd:GridSpacing>0.25cm</rd:GridSpacing>
> >> > > <rd:SnapToGrid>true</rd:SnapToGrid>
> >> > > <Body>
> >> > > <ColumnSpacing>1cm</ColumnSpacing>
> >> > > <Height>5cm</Height>
> >> > > </Body>
> >> > > <rd:ReportID>cdfcad95-4a03-4a8d-82a6-048cac98eb26</rd:ReportID>
> >> > > <LeftMargin>2.5cm</LeftMargin>
> >> > > <DataSets>
> >> > > <DataSet Name="DataSet1">
> >> > > <Query>
> >> > > <CommandText><SemanticQuery
> >> > > xmlns="http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling"
> >> > > xmlns:xsd="http://www.w3.org/2001/XMLSchema"
> >> > > xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
> >> > > xmlns:qd="http://schemas.microsoft.com/sqlserver/2004/11/semanticquerydesign"
> >> > > xmlns:rb="">http://schemas.microsoft.com/sqlserver/2004/11/reportbuilder">
> >> > > <Hierarchies>
> >> > > <Hierarchy>
> >> > > <BaseEntity>
> >> > > <!--DimGeneric-->
> >> > > <EntityID
> >> > > xmlns:np="np:Entity_Dimension_DimGeneric</EntityID>">http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling">np:Entity_Dimension_DimGeneric</EntityID>
> >> > > </BaseEntity>
> >> > > <Groupings>
> >> > > <Grouping Name="Generic Description">
> >> > > <Expression Name="Generic Description">
> >> > > <AttributeRef>
> >> > > <!--Generic Description-->
> >> > > <AttributeID
> >> > > xmlns:np="np:Attribute_Hierarchy_Generic.Generic_Description</AttributeID>">http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling">np:Attribute_Hierarchy_Generic.Generic_Description</AttributeID>
> >> > > </AttributeRef>
> >> > > </Expression>
> >> > > </Grouping>
> >> > > </Groupings>
> >> > > </Hierarchy>
> >> > > </Hierarchies>
> >> > >
> >> > > --start of report builder sourced subtree
> >> > >
> >> > > <CustomProperties>
> >> > > <CustomProperty Name="qd:PerspectiveID">
> >> > > <Value
> >> > > xsi:type="xsd:string">http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling/udmmodeling:Perspective_Cube_CubeGeneric</Value>
> >> > > </CustomProperty>
> >> > > </CustomProperties>
> >> > >
> >> > > --end of report builder sourced subtree
> >> > >
> >> > > </SemanticQuery></CommandText>
> >> > > <DataSourceName>dataSource1</DataSourceName>
> >> > > </Query>
> >> > > <Fields>
> >> > > <Field Name="Generic_Description">
> >> > > <rd:TypeName>System.String</rd:TypeName>
> >> > > <DataField>Generic Description</DataField>
> >> > > </Field>
> >> > > </Fields>
> >> > > </DataSet>
> >> > > </DataSets>
> >> > > <Width>16cm</Width>
> >> > > <InteractiveHeight>29.7cm</InteractiveHeight>
> >> > > <Language>en-US</Language>
> >> > > <TopMargin>2.5cm</TopMargin>
> >> > > <PageHeight>29.7cm</PageHeight>
> >> > > </Report>
>
>sql
Subscribe to:
Posts (Atom)