Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Export Multiple

Status
Not open for further replies.
katebrown5

katebrown5

Technical User
Feb 3, 2007
1
US
Hello - is there a way to export multiple pivots to one excel file with each pivot on different tabs. I was able to do this in MS Access and have not been able to figure out a way to do this in BRIO. I have been able to export multiple pivots to HTML by using:

Documents["TEST.bqy"].AddExportSection("COUNT_1")
Documents["TEST.bqy"].AddExportSection("COUNT_2")
Documents["TEST.bqy"].Export("C:\\Documents and Settings\\ME\\Desktop\\TEST_BRIO.html",bqExportFormatHTML,1)

I have tried changng the doc type to xls and the bqExport to bqExportFormatExcel5 but that didn't seem to work.

Thanks in advance for any help
 
Status
Not open for further replies.

Similar threads

cariengon
  • Locked
  • Question
Essbase 6.5 Export Level 0, but using a date range.
Replies
0
Views
97
cariengon
cariengon
donafran
  • Locked
  • Question
Is it possible Reuse a Reference Link to a Lookup stage for multiple fields?
Replies
2
Views
117
donafran
donafran
jakeir
  • Locked
  • Question
Trying to create an index based on multiple columns
Replies
1
Views
67
PDreyer
PDreyer
Aalph
  • Locked
  • Question
Primary Key with Multiple Values 1
Replies
6
Views
57
blom0344
blom0344
CoolFactor
  • Locked
  • Question
I want to export this Access query into Excel using a command button o
Replies
0
Views
31
CoolFactor
CoolFactor

Part and Inventory Search

Sponsor

Back
Top