Edit C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86\odbc\7.0.1\help\userguide\salesforce.27.15.html
<?xml version="1.0" encoding="utf-8"?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xml:lang="en" lang="en" xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html;charset=utf-8" /> <meta http-equiv="Content-Style-Type" content="text/css" /> <!-- MOTW-DISABLED saved from url=(0014)about:internet --> <title>Reports</title> <link rel="StyleSheet" href="css/salesforce.css" type="text/css" media="all" /> <link rel="StyleSheet" href="css/webworks.css" type="text/css" media="all" /> <script type="text/javascript" language="JavaScript1.2" src="wwhdata/common/context.js"></script> <script type="text/javascript" language="JavaScript1.2" src="wwhdata/common/towwhdir.js"></script> <script type="text/javascript" language="JavaScript1.2" src="wwhdata/common/wwhpagef.js"></script> <script type="text/javascript" language="JavaScript1.2"> <!-- var WebWorksRootPath = ""; // --> </script> <script type="text/javascript" language="JavaScript1.2"> <!-- // Set reference to top level help frame // var WWHFrame = WWHGetWWHFrame("", true); // --> </script> <script type="text/javascript" language="JavaScript1.2" src="scripts/expand.js"></script> </head> <body class="" style="background-color: #FFFFEE;" onload="WWHUpdate();" onunload="WWHUnload();" onkeydown="WWHHandleKeyDown((document.all||document.getElementById||document.layers)?event:null);" onkeypress="WWHHandleKeyPress((document.all||document.getElementById||document.layers)?event:null);" onkeyup="WWHHandleKeyUp((document.all||document.getElementById||document.layers)?event:null);"> <br /> <div class="WebWorks_Breadcrumbs" style="text-align: left;"> <a class="WebWorks_Breadcrumb_Link" href="salesforce.27.01.html#1100771">21 The Salesforce Driver</a> : Reports</div> <hr align="left" /> <blockquote> <div class="head_1"><a name="1100771">Reports</a></div> <div class="Body"><a name="1100925">The Salesforce driver exposes reports defined on a Salesforce instance as stored </a>procedures. An application can obtain a list of the reports defined on a Salesforce instance by calling the SQLProcedures catalog function. The names of the reports that can be invoked through the driver are listed in the PROCEDURE_NAME name column of the SQLProcedures results.</div> <div class="Body"><a name="1100927">Salesforce organizes reports into folders. The Salesforce driver incorporates the folder </a>name and report name into the procedure name reported by SQLProcedures. The driver creates the reported procedure name by prepending the folder name to the report name using an underscore to join them. Additionally, any spaces in the report or folder names are replaced with an underscore character. Like all identifier name metadata returned by the driver, the procedure name is uppercase. For example, if a report named Opportunity Pipeline is in the folder Opportunity Reports, it would be rendered as:</div> <div class="Body"><a name="1100929">OPPORTUNITY_REPORTS_OPPORTUNITY_PIPELINE</a></div> <div class="Body"><a name="1100931">An application invokes a report using the standard Call escape syntax, </a><span class="Syntax">{call </span><span class="EquationVariables">report </span><span class="EquationVariables">name</span><span class="Syntax">}</span>, and ODBC mechanisms for calling a stored procedure that returns a resultset. The following example shows one way to invoke the Opportunity Pipeline report:</div> <div class="syntax_first"><a name="1346599">SQLRETURN</a> retVal;</div> <div class="syntax"><a name="1346600">HSTMT</a> hStmt = NULL;</div> <div class="syntax"><a name="1346601">SQLWCHAR*</a> sql;</div> <div class="syntax"><a name="1346602"> </a></div> <div class="syntax"><a name="1346603">sql = L"{call OPPORTUNITY_REPORTS_OPPORTUNITY_PIPELINE}";</a></div> <div class="syntax"><a name="1346604">retVal = SQLExecDirect(hStmt, sql, SQL_NTS);</a></div> <div class="syntax"><a name="1346605">if (SQL_SUCCESS == retVal) {</a></div> <div class="syntax"><a name="1346607"> </a> // process results</div> <div class="syntax"><a name="1346608">}</a></div> <div class="Body"><a name="1211862">NOTES: </a></div> <div class="list_bulleted_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_inner"><a name="1211942">The API used by the driver to obtain the list of reports and execute the reports is not an </a>API that is documented by Salesforce. This API may change or may not be supported in the future.</div> </td> </tr> </table> </div> <div class="list_bulleted_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_inner"><a name="1211970">When passing parameters to stored procedures, reports are not supported.</a></div> </td> </tr> </table> </div> <script type="text/javascript" language="JavaScript1.2"> <!-- // Clear related topics // WWHClearRelatedTopics(); document.writeln(WWHRelatedTopicsInlineHTML()); // --> </script> </blockquote> <script type="text/javascript" language="JavaScript1.2"> <!-- document.write(WWHRelatedTopicsDivTag() + WWHPopupDivTag() + WWHALinksDivTag()); // --> </script> </body> </html>
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de