OLAP Client - your suggestions

Hello,

I am trying to Upgrade my AS 2000 to AS 2005 but end up hitting wall. Our clients is Excel 2002/2003 on Windows 2000 OS. I managed to convince group about advantage to moving AS 2005. At last I managed to convince advantage to moving Excel 2007 which added new project of upgrading office 2007 in selected workstations. Then I find out we can not install Excel 2007 in Windows 2000. Upgrading Clients workstations to XP is too much to ask for, so whole thing end up to ground zero. What you guys think what options I have. Is there any cheep out of box client/ or option of min. development which I can use in Windows 2000 workstations so that I can move on with AS 2005 migration.

I know I can still use excel 2002/2003 in client with AS 2005 but then all new features and measure groups are not coming ordered in Excel 2002/Excel2003.

Thanks for you advice,

-Ashok

This add-in can enhance ExcelXP and Excel2003 clients:

http://www.microsoft.com/downloads/details.aspx?FamilyId=DAE82128-9F21-475D-88A4-4B6E6C069FF0&displaylang=en

It is not as good as Excel 2007 but still better than the basic functionality in these clients.

HTH

Thomas Ivarsson

OLAP Client

Upgrading to Analysis Services 2005 has put me in difficult position because of lack of good client from Microsoft and using Excel 2002/2003.

We are small shop and use Excel (Pivot Table) big time as client tool. We upgraded to Analysis Services 2005 and we all know on server side it helped a lot.

BUT, I was expecting Excel 2002/2003 to work "at least same" even it can not use new stuff in 2005. What's killing now is Excel 2002/2003 Pivot Table client using Analysis Services 2005 on server "Not able to display Measure Names in alphabetical order" - Big problem for users.

Upgrading to Excel 2007 is not easy at least let me put this way Upgrading to Analysis Services 2005 and Excel 2007 same time is not possible. It's a very big project with big risk if you are in financial company. It worse for us because we still use windows 2000 so upgrade OS for what? cube access.

Now what. Think about buying new client with one of these companies BO/Crystal, ProClarity etc. is also hard choice because it's not Excel and hard to sell to business group to pay for it when you ask for ......

one of the big business guy asked me yesterday "Can we go back to Analysis Services 2000 because I don't know what you got in Server but it's not giving me what I had before...."

what you will do?

- Ashok

Hello. This add in for older versions of Excel(2002 and 2003) might help:

http://www.microsoft.com/downloads/details.aspx?familyid=DAE82128-9F21-475D-88A4-4B6E6C069FF0&displaylang=en

HTH

Thomas Ivarsson

|||

Hi Thomas,

As I was typing my question I knew this coming as first reply. This is not very helpful Add-in and just wandering any one using this in production let me know.

As you visit page first line you see this -

Microsoft does not provide any support for this solution accelerator and has no plans to release future versions. This add-in is not designed to work with with Office 2007.

That's ok

The number one reason to move to Analysis Services 2005 is to takeoff load from client. Remember when you run large query from client to Analysis Services 2000 your whole machine hang for some time. With excel "Cube Analysis" I don't know technologies behind but it's slow and uses client side memory. If you run large query and like to cancel (Esc key), you can not.

Interface is hard to use. Not looking for too much but mainly it's slow and using client memory.

One thing can help me if any one knows if this is possible. If it is possible to write VB code/macro which can run when excel file gets open and change the order in pivot table cube field list using Office APIs. Not looking for code just yes or no.

Thank you - Ashok

|||The Excel Add-in for Analysis Services is a good work around until you upgrade to Office 2007. There is no need for this tool in Office 2007 because PivotTable features in 2007 have been enhanced to include all the functionality that the Excel Add-In for Analysis Services includes. If you're thinking of using VB macros, I think it's a very bad road to take. You would be much better off using Reporting Services directly against the cube.|||

Thanks Martin. I understand using Add-in is good choice for now. Only issue I have with that it is taking client side memory and it will slow down not only cube query whole users box while they are using cube.

Reporting Services I can use what are the options we have in Reporting services to expose cube to end users? I know OLAP can be one data source to reporting services but then we need to design flat reports. Is there any control which allow users can drag drop fields and see data. I know about ReportBuilder.

Thanks again - Ashok

|||

Hi Ashok,

I wouldn't think that the Add-In would use more client-side memory than PivotTable services but I can't say I've done an exhaustive study either. ReportBuilder is another option but limited. If you have measure groups that are associated to dimensions at non-leaf levels, it likely won't be your solution. Additionally, users will only be able to construct reports using measures from a single measure group at a time so the produced reports are going to have to be simple. If your user's reporting requirements aren't complex, it's a good approach and very easy to implement and I'd recommend it.

|||

Thank's Martin for the comments.

Ashok, the add-in is a close you can get to the interface in Excel2007. It is not perfect but it works.

You can also choose to upgrade only the OLEDB-provider from 8 to 9 and use Excel2003 pivot tables. It will not look good but it will work.

If you choose to stay with older versions of clients you are left with that choice.

I have no advice of a cheap add-in for Excel that will solve your problem.

HTH

Thomas Ivarsson

|||

It may sound funny but it helped my cube users, when they really don't want any major change in the way they use current excel 2002/2003. so I had to find solution some thing they can accept.

I stored all my Analysis Services 2005 cubes measures from different measures groups in one xml file and created an excel form. Understanding all limitation in this way and giving some thing that can help cube users, trade off worked for this solution.

They have original Pivot table Field List to get Dimensions and for measures they open this excel form and get measures in much easy way. This is helping because we have over 200 measures.

Private Sub CommandButton1_Click()
'Try
For l = 1 To ListBox1.ListCount - 1
If ListBox1.Selected(l) = True Then
ActiveSheet.PivotTables("PivotTable1").AddDataField ActiveSheet.PivotTables( _
"PivotTable1").CubeFields("[Measures].[" & ListBox1.List(l) & "]"), ListBox1.List(l)
'MsgBox (ListBox1.List(l))
End If
Next l
'Catch ex As Exception
'MsgBox ("Error in getting records: " + ex.Message)

End Sub

Private Sub TextBox1_Change()
For l = 1 To ListBox1.ListCount - 1
If UCase(ListBox1.List(l)) = UCase(TextBox1.Text) Then
ListBox1.Selected(l) = True
Else
ListBox1.Selected(l) = False
End If
Next l
End Sub

Private Sub UserForm_Initialize()
Dim oXML As Object, oXSL As Object
Set oXML = CreateObject("MSXML.DOMDocument")
oXML.Load "T:\IT\Cubes\CubeMeasures.xml"
Dim t As String
For Counter = 1 To oXML.documentElement.childNodes.Length - 1
ListBox1.AddItem (oXML.documentElement.childNodes.Item(Counter).Text)
Next Counter
ListBox1.MultiSelect = fmMultiSelectExtended
End Sub

T:\IT\Cubes\CubeMeasures.xml File

<All>
<MeasureName>Measure 1</MeasureName>
<MeasureName>Measure 2</MeasureName>
<MeasureName>Measure 3</MeasureName>
<MeasureName>Measure 4</MeasureName>
</All>

OLAP Client

Upgrading to Analysis Services 2005 has put me in difficult position because of lack of good client from Microsoft and using Excel 2002/2003.

We are small shop and use Excel (Pivot Table) big time as client tool. We upgraded to Analysis Services 2005 and we all know on server side it helped a lot.

BUT, I was expecting Excel 2002/2003 to work "at least same" even it can not use new stuff in 2005. What's killing now is Excel 2002/2003 Pivot Table client using Analysis Services 2005 on server "Not able to display Measure Names in alphabetical order" - Big problem for users.

Upgrading to Excel 2007 is not easy at least let me put this way Upgrading to Analysis Services 2005 and Excel 2007 same time is not possible. It's a very big project with big risk if you are in financial company. It worse for us because we still use windows 2000 so upgrade OS for what? cube access.

Now what. Think about buying new client with one of these companies BO/Crystal, ProClarity etc. is also hard choice because it's not Excel and hard to sell to business group to pay for it when you ask for ......

one of the big business guy asked me yesterday "Can we go back to Analysis Services 2000 because I don't know what you got in Server but it's not giving me what I had before...."

what you will do?

- Ashok

Hello. This add in for older versions of Excel(2002 and 2003) might help:

http://www.microsoft.com/downloads/details.aspx?familyid=DAE82128-9F21-475D-88A4-4B6E6C069FF0&displaylang=en

HTH

Thomas Ivarsson

|||

Hi Thomas,

As I was typing my question I knew this coming as first reply. This is not very helpful Add-in and just wandering any one using this in production let me know.

As you visit page first line you see this -

Microsoft does not provide any support for this solution accelerator and has no plans to release future versions. This add-in is not designed to work with with Office 2007.

That's ok

The number one reason to move to Analysis Services 2005 is to takeoff load from client. Remember when you run large query from client to Analysis Services 2000 your whole machine hang for some time. With excel "Cube Analysis" I don't know technologies behind but it's slow and uses client side memory. If you run large query and like to cancel (Esc key), you can not.

Interface is hard to use. Not looking for too much but mainly it's slow and using client memory.

One thing can help me if any one knows if this is possible. If it is possible to write VB code/macro which can run when excel file gets open and change the order in pivot table cube field list using Office APIs. Not looking for code just yes or no.

Thank you - Ashok

|||The Excel Add-in for Analysis Services is a good work around until you upgrade to Office 2007. There is no need for this tool in Office 2007 because PivotTable features in 2007 have been enhanced to include all the functionality that the Excel Add-In for Analysis Services includes. If you're thinking of using VB macros, I think it's a very bad road to take. You would be much better off using Reporting Services directly against the cube.|||

Thanks Martin. I understand using Add-in is good choice for now. Only issue I have with that it is taking client side memory and it will slow down not only cube query whole users box while they are using cube.

Reporting Services I can use what are the options we have in Reporting services to expose cube to end users? I know OLAP can be one data source to reporting services but then we need to design flat reports. Is there any control which allow users can drag drop fields and see data. I know about ReportBuilder.

Thanks again - Ashok

|||

Hi Ashok,

I wouldn't think that the Add-In would use more client-side memory than PivotTable services but I can't say I've done an exhaustive study either. ReportBuilder is another option but limited. If you have measure groups that are associated to dimensions at non-leaf levels, it likely won't be your solution. Additionally, users will only be able to construct reports using measures from a single measure group at a time so the produced reports are going to have to be simple. If your user's reporting requirements aren't complex, it's a good approach and very easy to implement and I'd recommend it.

|||

Thank's Martin for the comments.

Ashok, the add-in is a close you can get to the interface in Excel2007. It is not perfect but it works.

You can also choose to upgrade only the OLEDB-provider from 8 to 9 and use Excel2003 pivot tables. It will not look good but it will work.

If you choose to stay with older versions of clients you are left with that choice.

I have no advice of a cheap add-in for Excel that will solve your problem.

HTH

Thomas Ivarsson

|||

It may sound funny but it helped my cube users, when they really don't want any major change in the way they use current excel 2002/2003. so I had to find solution some thing they can accept.

I stored all my Analysis Services 2005 cubes measures from different measures groups in one xml file and created an excel form. Understanding all limitation in this way and giving some thing that can help cube users, trade off worked for this solution.

They have original Pivot table Field List to get Dimensions and for measures they open this excel form and get measures in much easy way. This is helping because we have over 200 measures.

Private Sub CommandButton1_Click()
'Try
For l = 1 To ListBox1.ListCount - 1
If ListBox1.Selected(l) = True Then
ActiveSheet.PivotTables("PivotTable1").AddDataField ActiveSheet.PivotTables( _
"PivotTable1").CubeFields("[Measures].[" & ListBox1.List(l) & "]"), ListBox1.List(l)
'MsgBox (ListBox1.List(l))
End If
Next l
'Catch ex As Exception
'MsgBox ("Error in getting records: " + ex.Message)

End Sub

Private Sub TextBox1_Change()
For l = 1 To ListBox1.ListCount - 1
If UCase(ListBox1.List(l)) = UCase(TextBox1.Text) Then
ListBox1.Selected(l) = True
Else
ListBox1.Selected(l) = False
End If
Next l
End Sub

Private Sub UserForm_Initialize()
Dim oXML As Object, oXSL As Object
Set oXML = CreateObject("MSXML.DOMDocument")
oXML.Load "T:\IT\Cubes\CubeMeasures.xml"
Dim t As String
For Counter = 1 To oXML.documentElement.childNodes.Length - 1
ListBox1.AddItem (oXML.documentElement.childNodes.Item(Counter).Text)
Next Counter
ListBox1.MultiSelect = fmMultiSelectExtended
End Sub

T:\IT\Cubes\CubeMeasures.xml File

<All>
<MeasureName>Measure 1</MeasureName>
<MeasureName>Measure 2</MeasureName>
<MeasureName>Measure 3</MeasureName>
<MeasureName>Measure 4</MeasureName>
</All>

OLAP - EXCEL problem - urgent

Hello,

I have a dimension hierarchy with 2 levels, like this:

A - X

- Y

- Z

B - U

- V

- T

And I have a cube with the dimension above and one measure (sum).

The fact table of this cube has 2 columns (level2,sumvalue) and i have the values:

Level2 SumValue

X 1

Y 2

T 6

When I access this cube from Excel and use multiple selection weird stuff happends.

So, I create a Pivot table, in which i select only X,Y,U:

Level1

Level2

Total

A

X

1

Y

2

A Total

3

Grand Total

3

If i give a refersh to this pivot table i get :

SumValue

Level1

Level2

Total

A

X

1

Y

2

A Total

3

B

6

Grand Total

9

Why i see the B in the pivot table, if i selected only X,Y,U and U has no value in the fact table? I need an urgent answer because end-users use a lot the refresh option and in this case they see wrong values.

I'm using Microsoft Analysis Server build 9.00.2153 (SP1) and Microsoft Office Excel 2003 (11.6560.6568) SP2. I made the test with Microsoft Analysis Server SP2 and same version of Excel and i got the same result.

Any help will be appreciated.

Thanks,

Vulcano

A couple of things to check, that I can think of:

Is "Visual Totals" still enabled after refresh (ie. "Totals include Hidden Items" is disabled) - otherwise, these results would be expected?|||Thanks Deepak for your answer.

The property of the pivot table "Include hidden members in totals" is disable all the time. So no hidden members are included. In my dimension i don't have hidden members.

I run a Profiler and I discovered something strange:

For the first pivot table the query shown in the Profiler is :

SELECT NON EMPTY HIERARCHIZE(Except({AddCalculatedMembers(Except({AddCalculatedMembers({DrillDownMember({DrillDownLevel({[Dimension].[Hierarchy].[All]})}, {[Dimension].[Hierarchy].[Level1].[T] , [Dimension].[Hierarchy].[Level1].[ V ] })})}, {[Dimension].[Hierarchy].[Level2].[V], [Dimension].[Hierarchy].[Level2].[T], [Dimension].[Hierarchy].[Level2].[ Z ] }))}, {[Dimension].[Hierarchy].[Level2].[V], [Dimension].[Hierarchy].[Level2].[T], [Dimension].[Hierarchy].[Level2].[ Z ] })) DIMENSION PROPERTIES PARENT_UNIQUE_NAME ON COLUMNS FROM [TestWarTestSimple] WHERE ([Measures].[SumValue])

For the second pivot table when the refresh is done the query is:

SELECT NON EMPTY HIERARCHIZE(Except({AddCalculatedMembers(Except({AddCalculatedMembers({DrillDownMember({DrillDownLevel({[Dimension].[Hierarchy].[All]})}, {[Dimension].[Hierarchy].[Level1].[ T ] })})}, {[Dimension].[Hierarchy].[Level2].[V], [Dimension].[Hierarchy].[Level2].[T], [Dimension].[Hierarchy].[Level2].[ Z ] }))}, {[Dimension].[Hierarchy].[Level2].[V], [Dimension].[Hierarchy].[Level2].[T], [Dimension].[Hierarchy].[Level2].[ Z ] })) DIMENSION PROPERTIES PARENT_UNIQUE_NAME ON COLUMNS FROM [TestWarTestSimple] WHERE ([Measures].[SumValue])

Why the two queries are different? Why in the second query [Dimension].[Hierarchy].[Level1].[ B ] disappears?

Thanks,

Vulcano|||

The member which disappeared in the 2nd query is: [Dimension].[Hierarchy].[Level1].[ V ] , not [Dimension].[Hierarchy].[Level1].[ B ] (though maybe these are place-holder, not real, names?).

When you look at the drop-down list of members selected in the pivot table, do you find that this missing member is now selected? If so, this could be a side-effect of refreshing the pivot table (though I'm not sure why the refresh would change the selected members).

|||

My mistake Deepak, the queries are wrong, they are missing the A, B Members of the dimension. I post again the queries:

For the first pivot table the query shown in the Profiler is :

SELECT NON EMPTY HIERARCHIZE(Except({AddCalculatedMembers(Except({AddCalculatedMembers({DrillDownMember({DrillDownLevel({[Dimension].[Hierarchy].[All]})}, {[Dimension].[Hierarchy].[Level1].[ A ] , [Dimension].[Hierarchy].[Level1].[ B ] })})}, {[Dimension].[Hierarchy].[Level2].[V], [Dimension].[Hierarchy].[Level2].[T], [Dimension].[Hierarchy].[Level2].[ Z ] }))}, {[Dimension].[Hierarchy].[Level2].[V], [Dimension].[Hierarchy].[Level2].[T], [Dimension].[Hierarchy].[Level2].[ Z ] })) DIMENSION PROPERTIES PARENT_UNIQUE_NAME ON COLUMNS FROM [TestWarTestSimple] WHERE ([Measures].[SumValue])

For the second pivot table when the refresh is done the query is:

SELECT NON EMPTY HIERARCHIZE(Except({AddCalculatedMembers(Except({AddCalculatedMembers({DrillDownMember({DrillDownLevel({[Dimension].[Hierarchy].[All]})}, {[Dimension].[Hierarchy].[Level1].[ A ] })})}, {[Dimension].[Hierarchy].[Level2].[V], [Dimension].[Hierarchy].[Level2].[T], [Dimension].[Hierarchy].[Level2].[ Z ] }))}, {[Dimension].[Hierarchy].[Level2].[ V ], [Dimension].[Hierarchy].[Level2].[T], [Dimension].[Hierarchy].[Level2].[ Z ] })) DIMENSION PROPERTIES PARENT_UNIQUE_NAME ON COLUMNS FROM [TestWarTestSimple] WHERE ([Measures].[SumValue])

And you are right again: when the first pivot is created the X,Y,U members are selected, after the pivot is refresh the U member is not selected anymore ( so the member selected are X,Y,B). Is this the right behaviour, or maybe is a bug?

Thanks,Vulcano

OLAP

If I paste a dimension in excel (import data) per default all data is
selected.
How can I cange this default.Not 100% on your needs but you could create a view off the dimension and use
the view in your cube as a dimension that has the criteria you need.
Ray Higdon MCSE, MCDBA, CCNA
--
"Franz Chernjak" <f.ch@.gmx.at> wrote in message
news:OuwbWzF%23DHA.3428@.tk2msftngp13.phx.gbl...
> If I paste a dimension in excel (import data) per default all data is
> selected.
> How can I cange this default.
>
>

OLAP

If I paste a dimension in excel (import data) per default all data is
selected.
How can I cange this default.Not 100% on your needs but you could create a view off the dimension and use
the view in your cube as a dimension that has the criteria you need.
--
Ray Higdon MCSE, MCDBA, CCNA
--
"Franz Chernjak" <f.ch@.gmx.at> wrote in message
news:OuwbWzF%23DHA.3428@.tk2msftngp13.phx.gbl...
> If I paste a dimension in excel (import data) per default all data is
> selected.
> How can I cange this default.
>
>

Offline Capabilities

Hello All,

I have developed a solution where the user can generate pivot based reports using excel with Analysis Services in the background.

Now the requirement is that the user should also be able to go offline.

I want to understand how can this be done. Given the fact that the data in the cube is of financial nature so we need to have very secure solution.

(I read about local cubes, but how will I secure them? today the customer is generating excel sheets and protects it with windows DRM.... the problem with that solution is that we have too much data to put in excel).

Securing local cubes:

http://sqljunkies.com/WebLog/mosha/archive/2006/03/08/local_cube_password.aspx
|||

Passwords don't provide a good security solution because they can be shared, they are known to the person.

Let's say an employee who had the excel sheet is leaving the company, he takes it along to his new employer and uses it there because he has the password.

Is it possible to DRM (digital rights management) protect a local cube. So that everytime someone opens a cube it makes contact to the DRM server to decide what can be done and read/write to the cube?

As I said that our security requrirement is very critical because the cube contains a lot of financial data.

regards,

Abhishek.

|||There is no DRM integration with local cube files.

Office Interop Assemblies and SSIS

Hi guys,

I'm trying to write an SSIS script that will create an excel file and append data to it.

I downloaded the Office 2007 PIAs (Primary Interop Assemblies) and installed them on my desktop PC where i'm developing from.

However, and even though the assemblies are in the GAC, they don't appear when you look in "Add Reference" for your script task.

If i create a standard .NET web or windows app and try to "Add Reference" I can find them there.

Am I missing anything obvious?

Thanks for your help in advance

Mike

Do you have the Visual Studio Tools for Office 2007 installed?

Just curious, why create the excel file in the script task?

|||

Mike_Gaziotis wrote:

Hi guys,

I'm trying to write an SSIS script that will create an excel file and append data to it.

I downloaded the Office 2007 PIAs (Primary Interop Assemblies) and installed them on my desktop PC where i'm developing from.

However, and even though the assemblies are in the GAC, they don't appear when you look in "Add Reference" for your script task.

If i create a standard .NET web or windows app and try to "Add Reference" I can find them there.

Am I missing anything obvious?

Thanks for your help in advance

Mike

This should help.

VSA requires DLLs to be in the Microsoft.Net folder (but not all the time)

(http://blogs.conchango.com/jamiethomson/archive/2005/11/02/SSIS_3A00_-VSA-requires-DLLs-to-be-in-the-Microsoft.Net-folder-_2800_but-not-all-the-time_2900_.aspx)

-Jamie

|||

The VSA designer's "Add Reference" dialog does not look for assemblies in the GAC but only in the %ProgramFiles%\Microsoft SQL Server\90\SDK\Assemblies and %windir%\Microsoft.NET\Framework\v2.0.50727

We recomend that you copy them to the SQL server location pointed above for the "Add Reference" to work.

|||Thanks very much Jamie and Silviu!
Putting the DLLs in the .NET Folder seems to have done the trick.

In response to jwelch's question: I would have used the standard Data Flow task but it didn't seem to support some of the functionality i needed (ie dynamically building the file path and file name based on content etc)

Thanks again guys

Mike
|||

Actually, that sounds like a great opportunity to use variables or expressions. If you describe your scenario a little more, perhaps there might be some alternative approaches.

Not trying to change your mind on direction, just want to make sure you know what options are available.

|||Hi Jwelch,

Always keen to find out if there are more approaches that i haven't considered. Even if they're not used in this scenario it's good to know of the possibilites

Here are my SSIS job requirements:
- Execute (several) SQL queries which retrieve report data
- Insert the data in worksheets of several excel files
- Save the files by:
a: Putting a timestapt in their name (ie reportA_04072007)
b: storing them in different locations on the server based on the report
(ie %Reports%/ReportA/reportA_04072007.xls)
- Send mails with excel files attached

This is to be a scheduled job managed by the SQL server agent.

It's not a job of enormous complexity i must admit, but i somehow i found myself (perhaps because of me being a developer rather than a DBA by nature) more keen to write code than having to use loops, data flow tasks and all the rest. In fact when i first had the problem with the assemblies i half considered writing a windows app that would do that job and then run that from the sql server agent. And really, is there such a big difference between writing an app or a script-only SSIS job?

Thanks and sorry for the babble
Mike

Office and Adobe Compatibiiltly

SQL Server Reporting Services can export to Excel and Adobe. Which versions
of these products are supported?for rs 2005
pdf is 1.3
i have tested xls only on Offce 2003 and above
"Dave" wrote:
> SQL Server Reporting Services can export to Excel and Adobe. Which versions
> of these products are supported?|||Actually, the Adobe version supported is 4.x and above. For Excel, it's what
they call the 97-2003 .xls format in Excel 2007 (which works fine in Excel
2007, btw).
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.com
"Jimbo" <Jimbo@.discussions.microsoft.com> wrote in message
news:744AC534-34CF-4EC5-8518-95C41E29E617@.microsoft.com...
> for rs 2005
> pdf is 1.3
> i have tested xls only on Offce 2003 and above
>
>
>
> "Dave" wrote:
>> SQL Server Reporting Services can export to Excel and Adobe. Which
>> versions
>> of these products are supported?|||Hi Alain,
Yes, you are right. I just would like to clarify that although PDF 1.3 is
compatible with Adobe Acrobat 4, Reporting Services supports Adobe Acrobat
6 or later.
You can refer to:
Designing for PDF Output
http://msdn2.microsoft.com/en-us/library/ms159713.aspx
Exporting Reports (Reporting Services)
http://msdn2.microsoft.com/en-us/library/ms157153(SQL.100).aspx
Thank you and have a nice day!
Best regards,
Charles Wang
Microsoft Online Community Support
===========================================================Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg@.microsoft.com.
===========================================================Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
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.
=========================================================|||Great stuff. Thanks all!
"Charles Wang[MSFT]" wrote:
> Hi Alain,
> Yes, you are right. I just would like to clarify that although PDF 1.3 is
> compatible with Adobe Acrobat 4, Reporting Services supports Adobe Acrobat
> 6 or later.
> You can refer to:
> Designing for PDF Output
> http://msdn2.microsoft.com/en-us/library/ms159713.aspx
> Exporting Reports (Reporting Services)
> http://msdn2.microsoft.com/en-us/library/ms157153(SQL.100).aspx
> Thank you and have a nice day!
> Best regards,
> Charles Wang
> Microsoft Online Community Support
> ===========================================================> Delighting our customers is our #1 priority. We welcome your
> comments and suggestions about how we can improve the
> support we provide to you. Please feel free to let my manager
> know what you think of the level of service provided. You can
> send feedback directly to my manager at: msdnmg@.microsoft.com.
> ===========================================================> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications.
> 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.
> =========================================================>

ODBC/SQL M$ EXCEL 97 vs XP

Any ideas appreciated...
Users can export to Excel97 but cannot using ExcelXP. Get
error: "unknown token received from sql server"
Have patched SQL & OfficeXP locally to current M$ levels.
ODBC connects no problem.
I'm a tech, not a programmer, so any ideas really
appreciated.
JimmieDExport from what how? More details needed.
-- Mary
MCW Technologies
http://www.mcwtech.com
On Fri, 26 Dec 2003 05:55:00 -0800, "JimmieD"
<anonymous@.discussions.microsoft.com> wrote:

quote:

---

>Any ideas appreciated...
>Users can export to Excel97 but cannot using ExcelXP. Get
>error: "unknown token received from sql server"
>Have patched SQL & OfficeXP locally to current M$ levels.
>ODBC connects no problem.
>I'm a tech, not a programmer, so any ideas really
>appreciated.
>JimmieD

---

|||SQL Database using a macro. It appears to download the
info but it looks like right before it displays the data
in EXCELXP, the error appears.
Macro/export functions OK in EXCEL97.
Jim

quote:

---

>--Original Message--
>Export from what how? More details needed.
>-- Mary
>MCW Technologies
>http://www.mcwtech.com
>On Fri, 26 Dec 2003 05:55:00 -0800, "JimmieD"
><anonymous@.discussions.microsoft.com> wrote:
>
Get[QUOTE]
levels.[QUOTE]
>.
>

---

|||I think you're going to have a hard time with this one unless you get
a programmer to help you. If you're using an Excel macro, it's written
in VBA. A programmer can help you step through the code to see where
it's failing.
-- Mary
MCW Technologies
http://www.mcwtech.com
On Fri, 26 Dec 2003 08:33:06 -0800, "JimmieD"
<anonymous@.discussions.microsoft.com> wrote:
[QUOTE]
>SQL Database using a macro. It appears to download the
>info but it looks like right before it displays the data
>in EXCELXP, the error appears.
>Macro/export functions OK in EXCEL97.
>Jim
>Get
>levels.

ODBC, Excel, SQL Server

I have a user accessing SQL Server 2000 data through Excel
and MSQuery...we have used ODBC DSN with no probs. It is
only this user with an issue, so very specific to their
setup somehow.
Example databases called A and B.
User had ODBC DSN set up to default database A.
We want it to be B.
Edited DSN to have default database of B.
No prob. Saved, verified, successful. Just like in past.
HOWEVER, when creating a NEW Excel spreadsheet and NEW DB
Query using this DSN, it STILL points to database A for
some reason. There are no other DSNs with this name
(system, file, or user).
Any idea why it is pointing to the old db, and WHERE it is
getting this from? I have tried removing the DSN and
recreating it. I have tried using other people's logins
instead of his. This works fine on any other computer we
try it on.
Perplexed,
Sharon
I think this might be caused by using an Excel data source that points to
the old ODBC DSN. Excel builds its own wrapper for ODBC data sources and
typically stores them as .odc files. These are separate entries from the
ODBC data source that you build using the ODBC Administrator. Try opening
Excel, using the Data | Import External Data | Import Data option to display
the Select Data Source dialog. Then delete the old data source by right
clicking on it and selecting Delete from the pop-up menu. Once the old Excel
data source file is deleted build a new one by clicking the New Source
button and following the wizard dialogs.
Mike O.
"Sharon" <beall2@.llnl.gov> wrote in message
news:12e3201c411fc$714a9300$a301280a@.phx.gbl...
> I have a user accessing SQL Server 2000 data through Excel
> and MSQuery...we have used ODBC DSN with no probs. It is
> only this user with an issue, so very specific to their
> setup somehow.
> Example databases called A and B.
> User had ODBC DSN set up to default database A.
> We want it to be B.
> Edited DSN to have default database of B.
> No prob. Saved, verified, successful. Just like in past.
> HOWEVER, when creating a NEW Excel spreadsheet and NEW DB
> Query using this DSN, it STILL points to database A for
> some reason. There are no other DSNs with this name
> (system, file, or user).
> Any idea why it is pointing to the old db, and WHERE it is
> getting this from? I have tried removing the DSN and
> recreating it. I have tried using other people's logins
> instead of his. This works fine on any other computer we
> try it on.
> Perplexed,
> Sharon
>

ODBC, Excel, SQL Server

I have a user accessing SQL Server 2000 data through Excel
and MSQuery...we have used ODBC DSN with no probs. It is
only this user with an issue, so very specific to their
setup somehow.
Example databases called A and B.
User had ODBC DSN set up to default database A.
We want it to be B.
Edited DSN to have default database of B.
No prob. Saved, verified, successful. Just like in past.
HOWEVER, when creating a NEW Excel spreadsheet and NEW DB
Query using this DSN, it STILL points to database A for
some reason. There are no other DSNs with this name
(system, file, or user).
Any idea why it is pointing to the old db, and WHERE it is
getting this from? I have tried removing the DSN and
recreating it. I have tried using other people's logins
instead of his. This works fine on any other computer we
try it on.
Perplexed,
SharonI think this might be caused by using an Excel data source that points to
the old ODBC DSN. Excel builds its own wrapper for ODBC data sources and
typically stores them as .odc files. These are separate entries from the
ODBC data source that you build using the ODBC Administrator. Try opening
Excel, using the Data | Import External Data | Import Data option to display
the Select Data Source dialog. Then delete the old data source by right
clicking on it and selecting Delete from the pop-up menu. Once the old Excel
data source file is deleted build a new one by clicking the New Source
button and following the wizard dialogs.
Mike O.
"Sharon" <beall2@.llnl.gov> wrote in message
news:12e3201c411fc$714a9300$a301280a@.phx
.gbl...
> I have a user accessing SQL Server 2000 data through Excel
> and MSQuery...we have used ODBC DSN with no probs. It is
> only this user with an issue, so very specific to their
> setup somehow.
> Example databases called A and B.
> User had ODBC DSN set up to default database A.
> We want it to be B.
> Edited DSN to have default database of B.
> No prob. Saved, verified, successful. Just like in past.
> HOWEVER, when creating a NEW Excel spreadsheet and NEW DB
> Query using this DSN, it STILL points to database A for
> some reason. There are no other DSNs with this name
> (system, file, or user).
> Any idea why it is pointing to the old db, and WHERE it is
> getting this from? I have tried removing the DSN and
> recreating it. I have tried using other people's logins
> instead of his. This works fine on any other computer we
> try it on.
> Perplexed,
> Sharon
>