Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Report Design
Message Icon Topic: Running report authorisation box Post Reply Post New Topic
Author Message
jono1970
Newbie
Newbie


Joined: 11 Mar 2008
Online Status: Offline
Posts: 2
Quote jono1970 Replybullet Topic: Running report authorisation box
    Posted: 11 Mar 2008 at 4:52am
Hi,
 
I have designed a report using VS 2005 and dropped a viewer control on a webform. When I launch the webpage it keeps asking me for username and password to SQL DB. Is it possible to pass these credentials silently?
 
Also, when I run the report i notice that my dates are shown with time details. Is there a way to format the date so the time portion does not appear?
 
Cheers,
 
jono
 
IP IP Logged
jkwrpc
Senior Member
Senior Member


Joined: 19 Jun 2007
Location: United States
Online Status: Offline
Posts: 432
Quote jkwrpc Replybullet Posted: 22 Mar 2008 at 8:36am

I am thinking you likely have the answer. If not here are a couple of thoughts.  You should be able to pass the user id and password through your connection string. You can set your connection string in the web.config file and read it from there.  This assumes you are loading the report data from a dataset.

If you are using an odbc connection and pulling the data that way; then I believe under the advanced tab on the odbc configuration setup window password and user id.

Regards,

John W.
www.CustomReportWriters.net
IP IP Logged
jono1970
Newbie
Newbie


Joined: 11 Mar 2008
Online Status: Offline
Posts: 2
Quote jono1970 Replybullet Posted: 01 Apr 2008 at 12:41am
Hi,
 
I never did resolve this problem.
 
I do have my connection string and credentials in web config, but I do I point Crystal reports there?
 
I have configured my report and set up the DB connection during design time. In field explorer I add an OLE DB(ADO) and add the SQL server IP, password and query I want to populate the report with. Finally, I drop the fields from the query on to the form and when I click on main report preview I can see my report with populated fields.
When I select 'view in browser' a authentication box appears asking for a password to the SQL server.
 
being very new to VS2005 or programming for that matter I am not sure how to tell Crystal Reports to use the password from my web config file or pass the password via vb code.
 
Can you help me further?
 
Thanks in advance
 
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump 		You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.030 seconds.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2024 Brian Bischof. All Rights Reserved.