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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Build a "standard page" to display differnt kind of reports

Status
Not open for further replies.
gonsales

gonsales

Programmer
Oct 9, 2003
18
0
0
ES
Hi!.
We've got different kind of reports in a CE9 system: with parameters, with selection formula, without parameters...and I should do a single ASP page to see that reports in our intranet.
I've seen "simple" pages to see "simple" reports with Crystal viewers.
Where could I find a "standard page" to display all kind of reports?? (if exists)
thanks!!
 
Sort by date Sort by votes
Hi,
Using a combination of asp,javascript and csp you should
be able to create a 'generic' set of pages that can handle many variants - the ultimate goal is to pass sufficient info to viewrpt.cwr to properly ( and securely, if needed) call the desired report (e.g. the Report Id#, any parameters needed, the view type, the authentication info, etc)

How that gets passed is up to the custom designer...

I use somethng like the folowing JavaScript function and pass it the needed parameters - (Using CE 8.5):

Code: 
function RunRpt(p,m,f){
amper = &quot;<%=Server.UrlEncode(&quot;&&quot;) %>&quot;
var progid=&quot;CrystalEnterprise.Report&quot;
 if (f == 1) {
  var pstr = amper + &quot;promptex-EmpNbr=&quot; + p
 }
 if (f == 2) {
  var pstr = amper + &quot;promptex-jcode=&quot; + p
 }
  windowprops = &quot;fullscreen=no,location=no,scrollbars=no,menubars=no,toolbars=no,resizable=yes&quot;;
 var strUA = &quot;<%=Request.ServerVariables(&quot;HTTP_USER_AGENT&quot;) %>&quot;
 if (strUA.indexOf(&quot;IE&quot;) > 1) {
  istr = &quot;actx&quot;
 }
 else
 {
 istr = &quot;java&quot;
 }
  reportWindow = window.open(&quot;empviewerV3.csp?qid=&quot; + pstr + &quot;&progid=&quot; + progid + &quot;&rid=&quot; + m + &quot;&invr=&quot; + istr,&quot;rptWindow&quot;,windowprops);
}

That function calls the following csp page:

Code: 
<html>
<head>

<% @language=JavaScript codepage=65001%>
<!-- #include file=&quot;setcodepage.csp&quot; -->
<!-- #include file=&quot;helper_js.csp&quot; -->

<script language=Javascript>
function init()
{
	document.forms[&quot;redirForm&quot;].submit();
}
</script>
</head>

<body onload=init()>

<%
var action, tokenName;
var progid = Request.QueryString.Item(&quot;progid&quot;);

if(progid = &quot;CrystalEnterprise.Report&quot; )

{
                     
        action = &quot;viewrpt.cwr?id=&quot; + Request.QueryString.Item(&quot;rid&quot;) + Request.QueryString.Item(&quot;qid&quot;) + &quot;&init=&quot; + Request.QueryString.Item(&quot;invr&quot;) + Server.URLEncode(&quot;:connect&quot;);
        tokenName = &quot;apstoken&quot;;
	
	
        
}
else
{
	action = &quot;infoobject.cwr?id=&quot; +  Request.QueryString.Item(&quot;id&quot;) + &quot;&action=0&quot;;
	tokenName = &quot;WCSLOGONTOKEN&quot;;
}





Response.Write(&quot;<form name='redirForm' method='post' action='&quot; + action + &quot;'>\n&quot;);
Response.Write(&quot;<input type='hidden' name='&quot; + tokenName + &quot;' value=\&quot;&quot; + Server.HTMLEncode(GetCookie(&quot;logontoken&quot;)) + &quot;\&quot;>\n&quot;);
Response.Write(&quot;</form>\n&quot;);
%>

</body>
</html>

This is just one of many ways do this..
Our current approach ( still being refined) is to use csp queries and JavaScript functions to dynamically build a 'prompting' page based on the selected reports parameter list...

[profile]

 
Upvote 0 Downvote
Thanks, but...you're using &quot;URL Reporting&quot; and it's &quot;deprecated&quot; on CE 9...(unfortunately).
I should use &quot;Crystal COM Viewers&quot; to display reports. And it's more difficult than URL reporting (unfortunately, too)
 
Upvote 0 Downvote
Hi, Yes - the fact that one of the most flexible methods of calling a report is being gradually eliminated ( altho' it will still work in V9 ) is one of the reasons I may not recommend moving to v9 ( even tho' we have it)..

[profile]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

lavadan
  • Locked
  • Question
Export to excel with drop down data
Replies
2
Views
68
hilfy
hilfy
hpl2001
  • Locked
  • Question
BI4/Crystal 2016 upgrade issue with scheduled reports
Replies
1
Views
59
hilfy
hilfy
allyne
  • Locked
  • Question
RE: Sub Reports with parameters 1
Replies
3
Views
60
allyne
allyne
allyne
  • Locked
  • Question
Hello, I have a main report and a
Replies
1
Views
56
kray4660
kray4660
n2nuk
  • Locked
  • Question
Migrating reports from CR server 2013 to CR Server 2016
Replies
6
Views
89
n2nuk
n2nuk

Part and Inventory Search

Sponsor

Back
Top