Run report from ASP

Posted By CRMWingman over 6 years ago

Hi,

I've got this code in my ASP page:

myBlock.AddButton(strCallASPButton);
var sReportTarget = "/CRM/eware.dll/Do?SID=" + Request.QueryString("SID") + "&Act=1410&Mode=1&CLk=T&&Key0=41&Key4=" + CRM.GetContextInfo("user","user_userid") + "&Key41=186&Key62=151";
myBlock.AddButton(CRM.Button("Find Previously Purchased Items", "new.gif", sReportTarget, "Requisition", "EDIT"));

When a user opens the summary page, there is a button created by the above code. It runs a very specific report. How can I get this to appear in a pop up? It loads the page with the search parameters which is perfect, but I just want it to appear in a pop up. I tried PopUpWin=Y in the URL but it doesn't seem to do anything.

Thanks

0 Sage CRM over 6 years ago

Try this

var intReportAction = 1411;

var strDestination = "Screen";

//Allowed values for strDestination are "Screen", "Adobe", "CSV", "Excel"

var strSummaryReportButton = CRM.Button("Run Report", "executesummaryreport.gif", CRM.URL(intReportAction)+"&Key41=31&FlgNewWindow=True&Destination="+strDestination+"&PageSize=210x297&Orientation=Landscape", "", "", "EWARE_HELP")

myBlock.AddButton(strSummaryReportButton)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 CRMWingman over 6 years ago

That'll do nicely. Thanks Jeff. If they need to alter the search parameters, I'll direct them to the main report.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage CRM

Run report from ASP

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING