473,770 Members | 4,419 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Crystal Report Failure

Hi,

I'm using VB.NET 2002 and Access 2002 databases in my application. I
have also one Dataset for each report that I have. I doing my reports
with crystal reports and I use textobject to add some particular
information, like this:

Dim dbDataAdapter As OleDbDataAdapte r
Dim dbDataSet As New dsBalancete()
Dim frmCrystalRepor t As New frmCrystalRepor tViewer()
Dim ReportBalancete As New rptBalancete()

Dim SQL as String
Dim objTextObject As TextObject

' Opens the connection
Connection.Open ()

SQL = "SELECT * FROM qBalancete;"
dbDataAdapter = New OleDbDataAdapte r(SQL, dbConnection)
dbDataAdapter.F ill(dbDataSet, "qBalancete ")
ReportBalancete .SetDataSource( dbDataSet)

' Closes the connection
Connection.Clos e()

dblTotal = 5465464
objTextObject =
ReportBalancete .ReportDefiniti on.ReportObject s.Item("TextTot al")
objTextObject.T ext = Format(dblTotal , "Currency")

If Preview Then
frmCrystalRepor t.CrystalReport Viewer1.ReportS ource =
ReportBalancete
Else
ReportBalancete .PrintToPrinter (1, True, 1, 1000)
End If

objTextObject = Nothing
dbDataAdapter = Nothing
dbDataSet = Nothing

The problem is that when I print, with PrintToPrinter statement it
works just fine but when I try to preview it doesn't appear on then
screen.

What's happening ?

Tanks in advance,
Jorge

Nov 23 '05 #1
0 863

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

Similar topics

0
1703
by: Tim Jones | last post by:
Hey all, I am trying to try get a crytal report running properly. A "Hello World" report that does not add criteria to the record selection formula of the report (either in the development tool, or in the code) works fine. However, when I try to add any parameter through the record selection formula and/or the report parameters method, the report crashes. I have tried each of the methods:
0
2608
by: Max | last post by:
Hi wise people, Has anyone encountered the Crystal Reports problem I describe below? If so, how did you solve it? It seems that every article posted on google regarding CR and logon problems is still unanswered. I think I'm cursed. I originally created a crystal report which connects to a sql server server db on the same dev machine and it worked just fine. I tried to move it to another computer, but now I have to connect to an Oracle...
3
6036
by: Colin Graham | last post by:
I have recently created a report in crystal(10) linking to a dataset as the datasource. I notice however that the fields available in the report all have STRING format and therefore i cannot change format in crystal(10) e.g. I wish to change a date field to have the format dd/MM/yyyy. The main problem here is that the dataset seems to store data only as string. Is there anyway i can avoid this. Many thanks,
2
760
by: Tim Burda | last post by:
I posted this in another forum, but I'm adding it here to for more exposure.I am using Visual Studio 2003 and trying to get Crystal Reports to produce output. If you have any ideas, please let me know. This is a common problem, but nobody seems to have an answer for it. CrystalDecisions.CrystalReports.Engine.LogOnException: Logon failed. What does that mean, specifically? What logon is failing?
0
4899
by: Craig Faulkner | last post by:
I have been fighting through my first crystal report in VS2003.NET and have made some headway. Here is what I've done: 1. Created a crystal report in VS2003 from a SQL stored procedure with parameters through the GUI. 2. Finally got past the logon failure error to display the report using the viewer. I assume that default parameters are being used since it does display some data and the SP won't run without being passed some values.
0
1742
by: Atif | last post by:
Hi All My problem is not related with this group BUT i have got a clue from here that's why i am posting this question over here. I am using Crystal Reports 9 with MySQL and SQL Server. Situation: User can select anyone of these databases and the Report should work fine I am using following connection strings to connect with databases
0
1725
by: Timmy Jones | last post by:
Hey all, I am trying to try get a crytal report running properly. A "Hello World" report that does not add criteria to the record selection formula of the report (either in the development tool, or in the code) works fine. However, when I try to add any parameter through the record selection formula and/or the report parameters method, the report crashes. I have tried each of the methods:
1
1683
by: vipindev.s | last post by:
hi all i am not much expert in asp.net. i am using crystal rpt for report generation. is any other report generation method is available??? i use push method to creat report, and it is working fine, when i export that report to pdf or xls it generate an error like Logon failure. CrystalDecisions.CrystalReports.Engine.LogOnException: Logon failed.
0
971
by: =?Utf-8?B?QmFkaXM=?= | last post by:
Hi, I'm using this code to run a crystal report and export it to pdf, and when running it it in debug mode it working fine, but from the browser it's fails to run telling me that the Crystal report failed to Login!!? private void SetDBLogonForReport(ConnectionInfo connectionInfo, ReportDocument reportDocument) { Tables tables = reportDocument.Database.Tables;
3
10782
by: pratikkagda | last post by:
Hi all, My system contains Framework 3.5 with visual studio 2008 as well as 2005; here I have developed an application with crystal report with framework 2.0. It is working great in my system but when I upload this project into our production server (Production server only contains Framework 2.0 and IIS) and deployed the site to the production server with necessary assemblies, but it’s getting error as bellow. In my system I could not find...
0
9439
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
10237
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
10071
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
10017
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
6690
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
5326
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...
0
5467
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
3589
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2832
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.