Thank you very much to John, Varden Morris and
lukeybs!!
It works after installing Ms Office at the server :D
A very happy new year to you all,
Regards,
kamtt
--- axapta axapta123 <[EMAIL PROTECTED]> wrote:
> hi kamtt
>
> Check the following
> Pivot table services
>
> Navision Axapta uses the ActiveX control from
> Microsoft Excel 2000 web
> components, so this needs to be installed on each
> client in order to avail
> of the pivot table service. Make sure that you
> include Microsoft Query in
> the installation.
>
> To check that the Microsoft Query is installed,
> follow the procedure below:
>
> 1.
>
> Open Microsoft Excel.
> 2.
>
> Click Data, PivotTable, PivotChartReport.
> 3.
>
> Choose External data source, Get Data.
> 4.
>
> On the Choose Data Source, click OLAP Cubes.
> You now need to create a new datasource. There
> are four important
> fields.
> Here is a suggestion:
>
> 1.
>
> Name of source: My data source
> 2.
>
> OLAP Provider: MS OLE DB Provider for OLAP
> Services
> 3.
>
> Under Connect, write the name of your server
> and choose the name
> of the database.
> (You can use *FoodMart*, the Demo database
> from Microsoft.)
> 4.
>
> Select Sales.
>
> 5.
>
> Click OK, and Finish to produce a valid Pivot
> table.
>
> If Microsoft Query is not installed correctly, you
> will experience problems
> with step number 3 or 4.
> As soon as there are cubes created within Axapta,
> the system will
> automatically check if the pivot table services are
> available. If they are
> not, an error is displayed.
>
> John
>
> On 12/28/05, kamtt <[EMAIL PROTECTED]> wrote:
> >
> > Hello,
> > I have problem to generate 'Pivot Table'. e.g.
> when i go to
> > Administrator->Enquires->UserLog Form's 'Pivot
> Table' icon, it gives
> > me InfoLog message saying just 'Pivot Table not
> available'.
> >
> > Also when i try to use OLAP, I can create tubes
> and process it until
> > viewing 'Pivot Table'.
> >
> > I have also selected all configuration.
> >
> > I am using Axapta SP3 with SQL2000 server SP4 with
> 2-tier connection.
> >
> > Can anyone suggest me?
> > Thanks in advance :)
> > kamtt
> >
> >
> >
> >
> >
> >
> > Sharing the knowledge on Axapta.
> > Visit www.frappr.com/axapta for axapta friends.
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
> >
> >
>
__________________________________________
Yahoo! DSL Something to write home about.
Just $16.99/mo. or less.
dsl.yahoo.com
------------------------ Yahoo! Groups Sponsor --------------------~-->
Help the victims of the Pakistan/India earthquake rebuild their lives.
http://us.click.yahoo.com/.cYGuB/leGMAA/cosFAA/kGEolB/TM
--------------------------------------------------------------------~->
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/Axapta-Knowledge-Village/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
