OraFAQ Forum: Forms » OLE2 PIVOT TABLE

Home » Developer & Programmer » Forms » OLE2 PIVOT TABLE (forms 6i, windows xp)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

OLE2 PIVOT TABLE [message #402218]

Fri, 08 May 2009 02:19

kris312566
Messages: 9
Registered: May 2009
Location: Mumbai

Junior Member

Hi,

i want to create an pivot table using forms 6i ole2, i know i can do the same with matrix report but i want it from ole2.

Thanks

Report message to a moderator

Re: OLE2 PIVOT TABLE [message #402858 is a reply to message #402218]

Tue, 12 May 2009 18:58

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Have you searched this forum for 'pivot'?

David

Report message to a moderator

Re: OLE2 PIVOT TABLE [message #402879 is a reply to message #402858]

Tue, 12 May 2009 23:20

kris312566
Messages: 9
Registered: May 2009
Location: Mumbai

Junior Member

yes i did but didnt find anything related to ole2 i want to do this in excel sheet using ole2 of forms 6i

Report message to a moderator

Re: OLE2 PIVOT TABLE [message #403640 is a reply to message #402879]

Sun, 17 May 2009 19:50

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Yes, it would appear that there isn't a 'pivot' thread in this Forum.

Do you know how to do a 'pivot' in Excel? Can you get it to work via a VB program? You need to take those Excel commands and place them in the 'ole2' command structure within your form.

David

Report message to a moderator

Re: OLE2 PIVOT TABLE [message #403661 is a reply to message #403640]

Sun, 17 May 2009 23:34

kris312566
Messages: 9
Registered: May 2009
Location: Mumbai

Junior Member

Here is the code for creating an Pivot Table From The existing data in vb i don't know how to pass these multiple parameter in same command so if u please give me sample code that will be real help.

Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select
ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _
"Sheet1!R1C1:R8C3", Version:=xlPivotTableVersion12).CreatePivotTable _
TableDestination:="Sheet1!R1C10", TableName:="PivotTable1", DefaultVersion _
:=xlPivotTableVersion12
Sheets("Sheet1").Select
Cells(1, 10).Select
With ActiveSheet.PivotTables("PivotTable1").PivotFields("Sport")
.Orientation = xlRowField
.Position = 1
End With
With ActiveSheet.PivotTables("PivotTable1").PivotFields("Quarter")
.Orientation = xlColumnField
.Position = 1
End With
ActiveSheet.PivotTables("PivotTable1").AddDataField ActiveSheet.PivotTables( _
"PivotTable1").PivotFields("Sales"), "Sum of Sales", xlSum

Report message to a moderator

Re: OLE2 PIVOT TABLE [message #404503 is a reply to message #403661]

Fri, 22 May 2009 00:47

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

The above post is one of the worst dogs' breakfast of a listing I have ever seen. USE SOME FORMATTING!!

I suggest you raise your question on a Microsoft forum and then bring their answer back.

David

Report message to a moderator

Re: OLE2 PIVOT TABLE [message #410734 is a reply to message #402218]

Tue, 30 June 2009 00:42

kris312566
Messages: 9
Registered: May 2009
Location: Mumbai

Junior Member

there is no reply from their side and i dont know wat to do with it can u help??

Report message to a moderator

Previous Topic:	Not Abel to regenerate Excel file in oracle forms 10g
Next Topic:	how to make schedule in forms

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 10 04:53:10 CST 2025