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

Automatically logon to the default folder via URL

Status
Not open for further replies.
synapsevampire

synapsevampire

Programmer
Mar 23, 2002
20,180
US
How could I bypass the logon and just show the default folder for a given user?

I understand how to open a report, I need to bypass this for testing purposes and just display the folder.

-k kai@informeddatadecisions.com
 
Sort by date Sort by votes
The only way I know to do this is to use the NT single logon feature. Without using that you would have to somehow provide a name and pw to the system. For non secured reports we use a guest account with pw to access the report via URL. For everything else, including eportfolio, they have to log on or use the "guest" account(we can't get single log on to work yet because of a bug)

Lisa
 
Upvote 0 Downvote
I have been able to use URL command line to logon to the CMC without any problems. However, what is the URL command line syntax for logging onto ePortfolio? I have tried a few combinations of URL command lines, but nothing seems to working. Any ideas?
 
Upvote 0 Downvote
ePortfolio is a Crystal Enterprise technology built on the same platform that is open to web developers. Basically ePortfolio is a handy way of doing stuff you can already code on your own. Because of that all of its source code is available for you to look at and use. What you want to end up sending is:
<form method=POST action=&quot;logon.csp?action=logoff&quot;>
<input name=aps><input name=usr><input name=pwd><select name=aut></form>
That's ugly and hacked down, but those are the fields that need to be sent to the logon.csp page. Once it receives those every thing should be go smoothly from there. You can use a little bit of JavaScript to build a simple .htm page which will use hidden html form elements to hold the data and auto-submit the data upon page load.

 
Upvote 0 Downvote
and it might help if i just sort of wrote that out eh?
<%@Language=VBScript%>
<html>
<head>
<script language=&quot;javascript&quot;>
function doSubmit() {
document.SubmitForm.Submit();
};
</script>
</head>
<body onLoad=&quot;doSubmit()&quot;>
<form name=&quot;SubmitForm&quot; action=&quot;logon.csp?actcion=logoff&quot; method=POST><input type=&quot;hidden&quot; name=&quot;usr&quot; name=&quot;guest&quot;><input type=&quot;hidden&quot; name=&quot;pwd&quot; value=&quot;&quot;><input type=&quot;hidden&quot; name=&quot;aps&quot; value=&quot;<%=Request.ServerVariables(&quot;WCS_NAME_SERVER&quot;)%>&quot;><input type=&quot;hidden&quot; name=&quot;aut&quot; value=&quot;secEnterprise&quot;></form></body></html>


That should work if you call the file *.csp and then simply hyperlink to it ..... not sure though cuz i didnt test the code ;)
 
Upvote 0 Downvote
Here is a different approach. I have Crystal Enterprise loaded on a server outside of our corporate intranet. I store the logon name in a global.asa as an application variable on the corporate intranet. When I jump to the Crystal Enterprise server, I pass the logon name in a query to logon.csp since CSP does not support application variables.

The CE password is stored in the server side code in logon.csp.

The logon and password is generic as I am able to control which folders the authenticated users sees. I have a homegrown security solution on the corporate intranet side that I use to control who can get to the site with the link to Crystal Enterprise.

kwarner
kent@tdcs.com

 
Upvote 0 Downvote
The best stuff comes right with CE. The documentation shows all the functionality of the CSP commands and provides some examples through the tutorial. The section on ePortfolio documents which file does what in ePortfolio - allowing you to look at the source code and see how the programmers at Seagate did things.
The url for the help should be:
The &quot;Tutorial&quot;, &quot;understanding ePortfolio&quot; and &quot;CSP reference&quot; sections are the most useful.
 
Upvote 0 Downvote
Thanks, I've already raided that ;)

I just wondered if anyone had set up a site with additional CSP.

One of the things I'm trying to do is update picklists in parameters, as you probably know, this is fairly complicated.

I can use text files (one per parameter per report - uuugh), or perhaps there's a means by which to use the RDC from an external application.

I need to both limit the picklists based on users, and I need to query a database to update picklists for the Master reports.

Appreciate any thoughts along these lines.

-k kai@informeddatadecisions.com
 
Upvote 0 Downvote
In both cases I would make hidden formula fields to contain the picklist data. To limit by user, I would have the formula field find out who the user is (however you do that!) and then process through the database extracting the data you want for your picklist. And the same to update picklists based on fields from a database ... as long as you're using ODBC for all your databases you should be able to just add that database into the report, only taking the field you need.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

lavadan
  • Locked
  • Question
Export to excel with drop down data
Replies
2
Views
203
hilfy
hilfy
smmaruf82
  • Locked
  • Question
How to Fixed 4 Column in Crystal Report Crosstab
Replies
1
Views
193
lbass
lbass
zigstick
  • Locked
  • Question
BOXI Enterprise / Link to a file in a folder 1
Replies
2
Views
187
zigstick
zigstick
DanEvansJr
  • Locked
  • Question
Crystal Report to Adobe pdf - font issue
Replies
1
Views
231
DanEvansJr
DanEvansJr
n2nuk
  • Locked
  • Question
Migrating reports from CR server 2013 to CR Server 2016
Replies
6
Views
361
n2nuk
n2nuk

Part and Inventory Search

Sponsor

Back
Top