Save PivotChart View in Query  
Author Message
Celery





PostPosted: Wed Jan 26 21:35:34 CST 2005 Top

SQL Server >> Save PivotChart View in Query

I apologize if I am asking this question in the wrong area. If this is the
case, please let me know where a better place to ask it is.

When I try to save a PivotChart View in Access 2003 connecting to SQL Server
2000, I get this message:
Object is invalid. Extended properties are not permitted on 'dbo.queryname',
or the object does not exist.

Is there a way to save my chart based on my query, or do I need to re-make
it every time I want to view it?

Matthew

SQL Server159  
 
 
Sue





PostPosted: Wed Jan 26 21:35:34 CST 2005 Top

SQL Server >> Save PivotChart View in Query One of the Access newsgroups would probably be a better
place to post this - PivotChart views are an Access thing
and don't have anything to do with SQL Server.
I vaguely remember there is someway to prevent changes to
the view - from selecting the properties on the PivotChart
toolbar. Something like that and that's all I can remember.

-Sue

On Wed, 26 Jan 2005 10:17:38 -0500, "Matthew"


>I apologize if I am asking this question in the wrong area. If this is the
>case, please let me know where a better place to ask it is.
>
>When I try to save a PivotChart View in Access 2003 connecting to SQL Server
>2000, I get this message:
>Object is invalid. Extended properties are not permitted on 'dbo.queryname',
>or the object does not exist.
>
>Is there a way to save my chart based on my query, or do I need to re-make
>it every time I want to view it?
>
>Matthew
>

 
 
Matthew





PostPosted: Fri Jan 28 09:47:03 CST 2005 Top

SQL Server >> Save PivotChart View in Query Sue,

I'll ask the question over there. Sorry about that.

Matthew



> One of the Access newsgroups would probably be a better
> place to post this - PivotChart views are an Access thing
> and don't have anything to do with SQL Server.
> I vaguely remember there is someway to prevent changes to
> the view - from selecting the properties on the PivotChart
> toolbar. Something like that and that's all I can remember.
>
> -Sue
>
> On Wed, 26 Jan 2005 10:17:38 -0500, "Matthew"

>
>>I apologize if I am asking this question in the wrong area. If this is
>>the
>>case, please let me know where a better place to ask it is.
>>
>>When I try to save a PivotChart View in Access 2003 connecting to SQL
>>Server
>>2000, I get this message:
>>Object is invalid. Extended properties are not permitted on
>>'dbo.queryname',
>>or the object does not exist.
>>
>>Is there a way to save my chart based on my query, or do I need to re-make
>>it every time I want to view it?
>>
>>Matthew
>>
>