Running reports in CE via a URL

[harwooddale]

Hi,
I have tried to run a report using a URL but to no avail.
I get prompted for the database username and password and then the report works. Is there any way to skip to database userid and password?
I am using the follwoing url

http://server/directory/report.rpt?...=guest&apspassword=&apsauthtype=secenterprise

 

[nithinn]

i feel the name of the password parameter is wrong.it should have been password0="passwd" rather than user&password0="passwd"

 

[harwooddale]

Yes, I have managed to fix this. Thanks
I how have a problem where I am creating a simple html web page that will have reports on it for the user to run.
I don't want the url to display the database username and password and I don't know how to do this.
Any Ideas?
Many Thanks.

 

[nithinn]

it would be better if u could make u'r requirement much more clearer.specify whether u will b passing the report name as a parameter or not.and other details

 

[harwooddale]

ok my link looks like this:
<A href=&quot;

http://server/directory/report.rpt?user0=username&password0=password

I dont want the username and password to be viewed by the user.

I have tried setting variables like

Vusr = username

and then replacing username with Vusr in the url
but this prompts me for the password when i get to the viewer.

I will not be passing the report name as a variable.

Hope this helps

Thanks

James

 

[nithinn]

instead of directly calling the report from the url u can pass all the parameter along with report name to another jsp page.inside that jsp open the report and set username and password in the DatabaseController object of report document.
then set the parameter fields with the parameters.
for more info read RAS sdk doc.
this is one way of doing it.
hope this helps

 

[lyanch]

If the report is managed by CE, and you have given the database name & pw there, use the reportID from CE instead of the report name and you will skip the DB logon.

Lisa

 

[harwooddale]

Hi,
I have tried that and it doesn't seem to work.
It now looks like
<A href=&quot;

http://inet/crystalreports/ASM

Customer Meetings.rpt?&quot; target=&quot;_self&quot;>ASM Customer Meetings</A><br>


ASM Customer Meetings is the report Title
When i was running it before it was running the following

<A href=&quot;

http://inet/crystalreports/74/574/9882de9c606ea4.rpt?user0=user&password0=password&quot;

target=&quot;_self&quot;>ASM Customer Meetings</A><br>


Is this what you mean?

 

[SurfingGecko]

What version of CR/CE are you using, what's the datasource and the connection method?

I also noticed in the original posting some conflict in the URL. There was a user0 and apsuser commands being passed in.

If the report being called is actually an .rpt file stored in a virtual directory, the report is not being managed by Enterprise so there is no need to log in to the APS.

In the last post it looks like you are calling a report that was scheduled or added to the Entperprise system. In which case it could be considered a managed report and should be called in the URL by ID using viewrpt.cwr (see the white paper) rather than explicitly.

(my suggestion) Before getting into the coding of .js files and the like you should first make sure you can get the URL working as it is. Nice and simple.

1. Start with

http://server/directory/report.rpt

How many db login prompts do you get?
Are you asked for more than user and password? (hope not)
Any parameters?

Once entered will the report preview? If yes, then refresh the report in the viewer. Does this work as well? If yes, then you know you have valid connectivity.

If not, then

2. make sure the Page Server is running as a Domain/admin account to ensure it has access to the reports data source.

Repeat #1


3. Now add the db login URL commands to align with what prompts you found in #1 above.

If using user0 and password0 do not work, try using the other approach --

User-<servername>.<databasename>& Password-
<servername>.<databasename>

where:
server name = system DSN
database name = dbName
user name = user
password = pass

Does this approach work?

Once this works, the only way to truly hide the user and password would be drop this is an .asp or .js file on the server and call it.

You could use the HIDDEN tag, but this will still expose the info in the HTML of the page.

Sounds kind of tedious to take baby steps, but URL reporting can be tricky (in my experience) and in some cases a non-starter.

Here are a couple of things you may find useful

Crystal KBase article -- c2005487

White Paper --

http://support.crystaldecisions.com/communityCS/TechnicalPapers/ce8_urlcommands.pdf

Sorry to go on so long. Hope it helps and does not confuse the issue.

Cheers,

SurfingGecko

http://www.surfinggeckosoftware.com

Home of Crystal Ease

 

[harwooddale]

Hi,

I sorted the problem by using the APS.
Example
<A href=&quot;

http://server/crystal/enterprise/ad...&apspassword=&apsauthtype=secEnterprise&quot;

target=&quot;_self&quot;>description</A><br>
Many thanks to all the users who contributed to this thread.

James

 

[SurfingGecko]

Excellent



Cheers,

SurfingGecko

http://www.surfinggeckosoftware.com

Home of Crystal Ease