Home » Developer & Programmer » Forms » OLE2 PIVOT TABLE (forms 6i, windows xp)
OLE2 PIVOT TABLE [message #402218] Fri, 08 May 2009 02:19 Go to next message
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
Re: OLE2 PIVOT TABLE [message #402858 is a reply to message #402218] Tue, 12 May 2009 18:58 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have you searched this forum for 'pivot'?

David
Re: OLE2 PIVOT TABLE [message #402879 is a reply to message #402858] Tue, 12 May 2009 23:20 Go to previous messageGo to next message
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
Re: OLE2 PIVOT TABLE [message #403640 is a reply to message #402879] Sun, 17 May 2009 19:50 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
Re: OLE2 PIVOT TABLE [message #403661 is a reply to message #403640] Sun, 17 May 2009 23:34 Go to previous messageGo to next message
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
Re: OLE2 PIVOT TABLE [message #404503 is a reply to message #403661] Fri, 22 May 2009 00:47 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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

Re: OLE2 PIVOT TABLE [message #410734 is a reply to message #402218] Tue, 30 June 2009 00:42 Go to previous message
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??
Previous Topic: Not Abel to regenerate Excel file in oracle forms 10g
Next Topic: how to make schedule in forms
Goto Forum:
  


Current Time: Tue Dec 06 10:16:09 CST 2016

Total time taken to generate the page: 0.05569 seconds