473,749 Members | 2,665 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Crystal Report Login Prompt

I have an intermittent problem, when viewing a crystal report. This problem
only happens to some users and some report formats. When they try to view
the report in Microsoft Word format the system prompts them to login (User
name and Password). If they view it in PDF format they do not get the login
prompt. I do not get the login prompt at all. This problem occurs with
users on the Internet and our Intranet. I checked the web site and the
exported (from crystal reports) is in the directory. So Crystal Reports is
accessing the data, generating the report and exporting the report to MS Word
format.
Nov 19 '05 #1
1 3276
Hi there,

It seems you are exporting physical files. Actually you don’t have to create
these physical report files, unless you need to keep these files. You can
export stream and write stream content to page:

Response.Clear( );
Response.Charse t = string.Empty;
Response.Buffer = true;
Response.AddHea der("content-disposition", "inline; filename=fileNa me");
Response.Conten tType = "Applicatio n/pdf"; // "Applicatio n/msword"
// Create CrReport
MemoryStream memStream =
(MemoryStream)C rReport.ExportT oStream(ExportF ormatType.Porta bleDocFormat);
Response.Binary Write(memStream .ToArray());
memStream.Close ();
Response.End();

If you really need to do physical files, to check the security setting of
folder of generated files.

HTH

Elton Wang
el********@hotm ail.com
"CBKowitz" wrote:
I have an intermittent problem, when viewing a crystal report. This problem
only happens to some users and some report formats. When they try to view
the report in Microsoft Word format the system prompts them to login (User
name and Password). If they view it in PDF format they do not get the login
prompt. I do not get the login prompt at all. This problem occurs with
users on the Internet and our Intranet. I checked the web site and the
exported (from crystal reports) is in the directory. So Crystal Reports is
accessing the data, generating the report and exporting the report to MS Word
format.

Nov 19 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
1868
by: Bob Rosen | last post by:
Based on the information I have now, the answer would seem to be No. Does anyone have information to the contrary? Here's the problem. On my first attempt to display a report, Crystal displayed a login prompt even though the (Access) database was unsecured. According to http://www.experts-exchange.com/Databases/Crystal_Reports/Q_20544428.html, this is due to a problem that Crystal has when using a connection based on the OLEDB Jet...
1
7330
by: Kevin | last post by:
I'm at the end of my rope. We have been trying to deploy Crystal Reports over our website. We have tried every report configuration we can think of and cannot seem to resolve this issue. Here is the problem. We keep getting prompted for a database login when we try to view reports that connect to our SQL Server database. We have tried using every combination of connection strings and methods, all with the login information saved. We...
1
967
by: jeremylim2000 | last post by:
Hi! I try to preview a crystal report using asp, it prompt 'CRAXDRT error Occured on server. -2147189176 : logi failed' Details : IM002 : Data sourcename no found and no default driver specified'. This is wat I done in the Internet Server. 1. Install Crystal Report in Server.
0
1940
by: Meral Agceli via .NET 247 | last post by:
A crystal report is developed using Crystal 8.5 and a trustedconnection to a SQL Server database. I'm trying to display thisreport in Crystal Report Viewer using VB.NET. When theapplication is run, I get the Login prompt every time. I want tostop this from happening by setting this within the code. I canget it to work when the report is developed with a secureconnection (username/password). I can also get it to work whenthe report is developed...
0
1263
by: Chris | last post by:
Hello, I'm new to Crystal Reports and I am having a problem with a login box showing up when I try to view a report in the report viewer. I have found the following code, listed below, to bypass the login prompt however I am not sure how to apply this to the report. Thnak you Private Shared Function SetUserAndPassword(ByRef rp As
1
4670
by: codepuller | last post by:
Consider this approach: Embed the report in your project (add it to the project) Then put this code in the page that holds the viewer control 'Set the connection information crConnectionInfo.ServerName = "servername" crConnectionInfo.DatabaseName = "dbname"
12
14057
by: Murali via DotNetMonster.com | last post by:
Hi All I am new to .net, as i worked majorily on VB6.0 & Crystal reports, I have developed an Window application in VB.net/SQL Server2000 and using Crystal reports8.5, I have used the CRViewer in the form. Now my problem is when i try to open Crystal report thro VB.net, it will prompt for database login password, which i have already supplied in Crystal report and also thro the application.(I am using DSN based connection) Please help me...
4
1143
by: serge calderara | last post by:
Dear all I am not able to set the PAssword field of a tables logInfo structure ??? I do it as follow : For Each crTable In rptDoc.Database.Tables crReportTabeLoginfo = crTable.LogOnInfo crReportTabeLoginfo.ConnectionInfo = crConnectionInfo crReportTabeLoginfo.ConnectionInfo.Password = "admin"
0
935
by: dassubrata19976 | last post by:
Hi, I am writing an ASP.net application which uses Crystal Report XI.I am using SQL Server database as backend.In design time only I am providing the database login credentials while creating the report.But when I run the aspx page on which the CrystalReportViewer control is situated, for the first time database login prompt appears where I have to again specify the database login details.I need to suppress this at any cost.Is there any way...
0
8833
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9568
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9389
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
9335
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8257
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6801
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6079
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4709
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
3
2218
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.