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!

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

Automation export to excel with power play web

Status
Not open for further replies.

firdana

MIS
Apr 23, 2012
4
0
0
ID
I have used the power play web for reporting to user. I want to create a schedule for export reports into excel format, the same format with export via the power play web manually. I have tried through PPR and PPX format then save as. But, the result is not eye catching and user more convenient with excel power play web format. Can you help to me to export to excel automation with powerplay web ???
 
I have this javascript on a custom button to save the report as an Excel document if it would assist
Code:
	var fh = topparent.getXtabFrame().document.fhidden;
	topparent.getXtabFrame()._fhchanged = true;
		topparent.getXtabFrame()._fhtarget = fh.target;
		topparent.getXtabFrame()._fhaction = fh.action;
		topparent.getXtabFrame()._fhRA = fh.RA.value;
	{
		FTok = false;
		fh.RA.value = 11;		
		var targetWindow = topparent;
		if( ! targetWindow.name || targetWindow.length == 0 )
			targetWindow.name = "PPESTarget";
		fh.target = targetWindow.name;

		fh.action += "?MIME=.XLS";
		fh.CNCT.value = 24;
		fh.submit();
	}

soi là, soi carré
 
@drlex
how to put your code into scheduler, it is not posible. can anyone help ??
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top