Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
 
  HOME    TRACKER    Visual Basic




Crystal Report &"Memory Full&" Error


hi,
I am using Crystal Reports 8.0 . When I try to print 2 reports one after the other from VB 6 i get the error "Memory Full" . I then have to close the form and load it again to print the other report.
What is the problem ?

Thanks




View Complete Forum Thread with Replies

See Related Forum Messages: Follow the Links Below to View Complete Thread
&"Memory Full&" Error
hi everyone,
    I am trying to display a report created in crystal report on my vb interface (using crystal report viewer).  I am surprised to see the behaviour of my application. When i call the procedure to display the report for the first time, it works good.  but when i call the same procedure second time it gives me "Memory Full" error. Following is the code which i am trying

CODE    Set CRViewer1.ReportSource = Nothing
    CRViewer1.CloseView (CRViewer1.ActiveViewIndex)    
    Me.CRViewer1.ReportSource = rptReport
    Me.CRViewer1.Visible = True
    Me.CRViewer1.ShowFirstPage
    Me.CRViewer1.ViewReport

I Am Reciveing This Error &"20525 Unable To Load Report&" Crystal Report Does Not Show
i am reciveing this error "20525 unable to load report"
i can't view crystal report i designed and saved as *.rpt
in vb6
"report.ReportTitle = title
report.DataFiles(0) = App.Path + "mydb.mdb"
report.ReportFileName = App.Path + "report1.rpt"
report.Action = 1"
is the error in the line "report.Action = 1"
i want to know why the report dos not show up

&"File Not Found&" Error Involving Crystal Report Viewer
Hello.

I have a DB2 table loading VB 6 application that on a couple of forms has crystal reports that it is using for viewing reports. I am supposed to change the crystal reports that is bundled with VB 6 to a crystal report viewer which is a .dll and add to a new form and use the existing reports to view them. Which that all went fine until I tried to run the executable. When I try to view the report it just gives me a pop up box that says "File not found" and in the caption of the pop up box has Crystal Report Viewer at the top.

As a side note: The report is located in the same location as the application. When I try this with the crystal report that is bundled with VB 6 is works fine. Also, I have tried and typed the whole path in the Application.OpenReport line and that didn't work either. The variable RptstrFileType is just the name of the report being used and that is getting populated correctly.

Here is the code I am using:

Private Sub Form_Load()
    Dim Application As CRAXDRT.Application
    Dim Report As CRAXDRT.Report
    
    Set Application = New CRAXDRT.Application
    
    Set Report = Application.OpenReport(App.Path & "" & RptstrFileType & ".rpt")
    
    Me.CRViewer1.ReportSource = Report
    Me.CRViewer1.ViewReport
    
    Set Application = Nothing
    Set Report = Nothing
End Sub

Thanks in advance for any advice!

VB/Crystal Report Error&" Physical Database Not Found&"
Hi all,
I have a VB 6.0 front end application that uses Crystal Report 8.5 and a text file as my database.

I am trying to run this application on a non-developer machine (that doesn't have MS Visual Studio, or Crystal Report).

I have setup the ODBC DSN for the text file (MS Text Driver) on the client PC,and also used Visual Studio Installer to run the VB executable from the client PC.

I placed all the dependent DLL's,MSM's and OCX's on that machine, but I get an error: "PHYSICIAL DATABASE NOT FOUND" although the VB form opens up.The crystal report doesn't open up.

Can someone please help, or let me know what I'm missing?

Thanks.

Crystal Report Opening Error "Server Not Yet Opened"
HI GURUS,
I am using VB6 , CrstalReport8.0, SqlServer Version 7.0 for my application. I am using Crystal Report Designer in my project. When I am connecting to the server using Crystal Report Designer Wizard, i am able to create one designer file. When i tried to run this designer using my form file i am not able to run.
The follwing error occured. Error is "Server not yet opened"and no help message is coming. But my server is still running. Sqlserver agent is also started. Please can you give any solution for this. What could be the reason for this.
Thanking you,
V.K.GNANESWARAN

&"Server Not Found&" Error On Setting Crystal Report Datasource At Runtime.
Hi! Guys

In one of my projects, I'm adding the database to a crystal report design from inside VB through ado & oledb connectivity.

While calling the report I'm setting the datasource of this report to an ADO recordset but it gives runtime error "Server not found". Here is the code:

Option Explicit
Dim Report As New crptMatter
Dim txtobj As CRAXDRT.TextObject
Dim strData As String
Public strTitleId As String
Public strChoice As String
Dim rsTemp As New ADODB.Recordset
Dim rstemp1 As New ADODB.Recordset

Private Sub Form_Load()
Screen.MousePointer = vbHourglass
CloseRs rsTemp

If strChoice = "1" Then
    rsTemp.Open "select * from Library_Master where Classification_ID_Auto='"     & strTitleId & "' ORDER BY TitleCode,Title", conDatabase, adOpenDynamic,     adLockOptimistic
ElseIf strChoice = "2" Then
    rsTemp.Open "select * from Library_Master where Title_ID_Auto='" & strTitleId & "'     ORDER BY TitleCode,Title", conDatabase, adOpenDynamic, adLockOptimistic
End If

If Not (rsTemp.EOF And rsTemp.BOF) Then
        rsTemp.MoveFirst
                
        Report.Database.SetDataSource rsTemp
End If

CRViewer1.ReportSource = Report
CRViewer1.Zoom 2
CRViewer1.ViewReport
Screen.MousePointer = vbDefault

strData = ""
Set rsTemp = Nothing
CloseRs rsTemp

End Sub

Error In Crystal Report &"Server Has Not Been Open Yet&"
I have a problem. I have my database in a server and i connect to the database with a odbc driver. All my connections in my program are ok, but when i try to open a report in crystal reports the next error appears.

"Server has not been open yet"

Anyone knows what i need to do?

Error In Crystal Report - &"server Has Not Yet Been Open&"
hi experts,
I am building reports using crystal report 8 in my VB application. the datasource is Oracle 8i(8.1.6).
When i built a report using the report expert in Crystal report it has successfully created the report.
But when i ran the application i throws an error (ORA01005) saying - "null password was given; logon denied" and "server has not been yet started"

i have not written any code, i just used the wizard(report expert) and i have give the correct user name and password.

secondly,
also i did the same thing without wizard, using code. the code which i have written is in the follwoing lines.
''''''''''''''''''''''

Const ConString = "Provider=MSDAORA.1;User ID=gtsc;password=gtsc;Data Source=portal1;Persist Security Info=False"

Private Sub Report_Initialize()
Dim con As ADODB.Connection
Set con = New ADODB.Connection
con.ConnectionString = ConString

Dim rs As ADODB.Recordset

Set rs = New ADODB.Recordset
con.Open
rs.Open "Select * from emp", con, 3, 2, 1


Database.SetDataSource rs
End Sub

'''''''''''''''''''''''


so any body can help me on this issue.
immediate help is required.
thanks in advance.

Ashish

Error In Crystal Report - &"server Has Not Yet Been Open&"
hi all,
I am building reports using crystal report 8 in my VB application. the datasource is Oracle 8i(8.1.6).
When i built a report using the report expert in Crystal report it has successfully created the report.
But when i ran the application i throws an error (ORA01005) saying - "null password was given; logon denied" and "server has not been yet started"

i have not written any code, i just used the wizard(report expert) and i have give the correct user name and password.

so any body can help me on this issue.
immediate help is required.
thanks in advance.
Ashish

Solution> Error: &"&"&"&"&H8007007E (-2147024770) The Specified Module Cannot Be Found&"&"&"
Hello

This is the error what i am getting after installing a package of one of my module on user testing machine.
The same module being working fine on others.


What can be the reason for this and what can be the probable solution for this?

Sandeep

&"Error During Loading&",&"Out Of Memory&" :O(
I programmed my graduation project by visual basic and after 6 months of work ,suddenly the program didn't run

i got a massege saying "Errors during load .refer to 'D:......form1.log' for details" ,after clicking ok another message appears saying "out of memory" ,then nothing happened and the program didn't run.........
the program was working well, all what have been changed is that i installed a fresh copy of windows xp, then the problem happened........
does anyone can help ,my graduation project test is in the coming 3 weeks, i am in a very difficult attitude.............

&"Disk Full&" ---- BUT ITS NOT! Error Saving Word Doc W/in VB
I'm using vb with a Word reference to edit and save a word document.

When I try to save the word document I get an error

"Disk is Full...close programs... etc" . . . but it is not full...

Anyone know what is going on here?

Here is some code:


VB Code:
Dim wdApp As Object    Dim myDoc As Object     Set wdApp = CreateObject("Word.Application")     FileCopy PATH + "template.doc", "edit.doc"     Set myDoc = wdApp.Documents.Open(fileName:="edit.doc", ReadOnly:=False) 'This updates some bookmarks w/the doc    myDoc.Bookmarks("Date").Range.InsertAfter _        CStr(Date)    myDoc.Bookmarks("To").Range.InsertAfter _        StrConv(name, vbProperCase)      myDoc.Save 'THIS IS WHERE GET THE ERROR     myDoc.Close    wdApp.Quit

Show The Cookie &"Privacy Report&" And &"Security Report&" Forms For The Web Browser
hi people..

how do i show the cookie privacy report and the security forms from within the ie webbrowser control?

i know how to show the icons stating if impacts are made etc, but with no luck in finding how to show the forms, im at a loose end.

can any one help help me with showing the forms as in the image below please?

i have looked all thru the MSDN library and PSC, and searched here, with no luck

Thanks ppl.

Terminal Em To Embedded Device, Runtime Error 7 &"Out Of Memory&"
All,

I've had to get a terminal emulator together for work, supporting an embedded device. I've got everything working, but keep getting a "Runtime Errror 7, Out of Memory" any time I "stress test" the terminal or the terminal is left running for a long time. My stress test involves repeatedly sending a string from an embedded device at a high rate.

To start, I grabbed the example terminal emulator code from the VB6 pro examples section and modified it to my needs. As I run and stress test the program, I get the Out of Memmory error in the MSComm comEvReceive. Here is my code in this case statement.

**********************************************************
Select Case MSComm1.CommEvent
' Event messages.
Case comEvReceive
Dim Buffer As Variant

Do While MSComm1.InBufferCount > 0

Buffer = MSComm1.Input
error here ===>> ShowData txtTerm, (StrConv(Buffer, vbUnicode))


If LCase((StrConv(Buffer, vbUnicode))) = "b" Then trapsig = True
If trapsig Then
bootmsg = bootmsg & Buffer
charcnt = charcnt + 1
End If

If charcnt > 4 Then
If LCase((StrConv(bootmsg, vbUnicode))) = "boot" Then
Call bootbuddy
trapsig = False
bootmsg = ""
Command1.Caption = "BootLoader Trap Disabled"
Else
bootmsg = ""
Command1.Caption = "BootLoader Trap Disabled"
End If
End If
Loop

**********************************************************

I've tried a variety of things to inclued:

1. Install the ActiveX Control Pad for FM20.DLL(SP?) problem.
2. Initialized the common controls on form load. (InitCommonControls)
Private Declare Sub InitCommonControls Lib comctl32.dll"()
3. Used PDW to install executable locally.
4. Compiled the executable to PCode and Native

Any help will be greatly appreciated and I will post more code on request.

Steve

Error Message &"Memory Cannot Be Read&" After Run Macros In Word.
Hi,
I have a word template which is composed of a series of macros to create documents with standard format. However, after I execute those macros, I will get error message about memory allocation problem such as "The instruction at xxxxx referenced memory at xxxxx. The memory could not be read. Click OK to terminate the program. " in windows 2000 or page fault error in windows 98.
I would like to know how I can solve this problem by (maybe) redoing the macro or by other solution. I don't have a clue where should I start. Please could somebody help me? Thank you.

I Use HOVERBUTTONS And On RUN TIME MODE, There Are Times Where An Error,&"OUT OF MEMORY!&"..
Hi, I'm new here and a newbie on programming VB ver 6.0 ... i am from the philippines and on my way to understanding the basic foundation of VB ... I am currently programming a system ... with this, I am using a HOVERBUTTON as one of my object tool ... whenever I run the program , while on RUN MODE/RUN TIME, there are instances that the compiler gives a message,"OUT OF MEMORY", can you tell me what's the main problem ? ... On my form, I use BITMAP pictures as my background .. and on the part of my COMMAND BUTTON TOOLBARS, I always insert a PICTURE BITMAP on each of them. Attached is an OUTPUT FORM of my system ...

&"Out Of Memory - Too Many Global Symbols , Constant And Variables &" Error In VB 3.0
I am facing some problem in Compiling a VB 3.0 project . When I try compliling the project then I am getting the following error -

"Out of Memory - too many global symbols"


Apart from this , another error that I am getting that says -
"The *.FRM files cannot add any more lines of code" . ( the exact words may be wrong - but this was the intent of the Message )


I have observed that I get these error if I try to add some EVENT HANDLERS , SUBROUTINES or FUNCTIONS to a *.FRM file .


I have never faced these problems while working on small sized VB 3.0 projects but for large sized projects as this particular one ( 4.25 MB - 28 FRM files & 25 BAS files) this problem is easily reproducable ( is it that in VB3.0 there is a limit to the size of code that we can add in *.FRM files for large sized projects )

I was building my project by keeping all the source files ( FRM , FRX , BAS ) and the MAK file directly under c:/ ( Root directory ) - but still I am facing this problem .
Even Restarting the System , trying it out in different machines & different O.S ( WIN 95 , WIN NT & WIN 2000 ) gives the same problem.


Can someone help me ...........

&"Out Of Memory&" Error Using Excel Sheet Component
I'm getting an "Out of Memory" error when trying to access an Excel object. I've added a reference to "ExcelCtl Type Library" which adds an Excel component to the Toolbox. I add this component to my form. Now any time I try to access the componenet via code (i.e. Ole1.object) I get the "Out of Memory" error. Any help with this is greatly appreciated.

HELP: &"Out Of Memory&" Error (and More) When Starting Visual Basic 6.0
Let me first start by saying that I am using WinXP and have been working with Visual Basic 6.0 for a few weeks now without any problems. Everytime I am done with it, I save the project and close the Visual Basic 6.0 window.

I wanted to work on my project last night, so I double-clicked on my desktop icon for Visual Basic V6.0 to open it up which I always did before) but this time I get the following errors (shown in order as they come up):

Error 1) Out of Memory : Continue? (I click YES button)
Error 2) Object Variable or With Block Variable Not Set: Continue? (I click YES button)
Error 3) Object Variable or With Block Variable Not Set: Continue? (I click YES button)
Error 4) Object Variable or With Block Variable Not Set: Continue? (I click YES button)
Error 5) Automation Error Catastrophic Failure (I click OK button)
Error 6) Object Variable or With Block Variable Not Set: Continue? (I click YES button)

After error (6), the Visual Basic 6.0 window does come up and I can open my project, edit the project, click RUN to test/debug my project and save my project.

Can someone please tell me what in the world is going on? Why do I have these errors all of sudden on opening up the application and what should I do to correct the problems?


Also, there were two other things I noticed:

- I tried to access the MSDN Library for Visual Basic 6.0 (via the Help menu) but discovered that the help library has disappeared. The other MSDN libraries (Visual C++ , etc..) were still there, but the Visual Basic 6.0 one was gone. A window gets displayed telling me to reinstall the library from disc

- When I first started my project, I added some controls via the Components menu option. Two of these controls(RICHTX32.OCX and COMDLG32.OCX) I added but never used yet. I decided to use a richTextBox last night and realized that the richTextBox icon in the control window (or is it called the component window), as well as the Common Dialog icon, were changed to a plain white folder icon. Usually these icons would be seen as image icons. Anyway, I tried to drag a richTextBox in the Form and was told that it could not found (or something like that).








Edited by - uncletr on 6/19/2004 3:41:59 PM

How To Show &"Select Printer&" Dialog Before Printing A Crystal Report?
Hi everyone.
I use Crystal Reports 8.5
In my code I always call the: mycrviewer.ViewReport command. When the report shows up if I press print button it only shows me a dialog with the default printer to set number of copies and pages to print.
I would like to show up a dialog which let me select the printer and adjust other printer settings (like paper size, etc.) like DataReport does.
How can I do this?

Thanks for your time and help!

How To Show &"Select Printer&" Dialog Before Printing A Crystal Report?
Hi everyone.
I use Crystal Reports 8.5
In my code I always call the: mycrviewer.ViewReport command. When the report shows up if I press print button it only shows me a dialog with the default printer to set number of copies and pages to print.
I would like to show up a dialog which let me select the printer and adjust other printer settings (like paper size, etc.) like DataReport does.
How can I do this?

Thanks for your time and help!

If I Use "SaveSetting App.Title, "Settings", "Font", "001122"" - Save Date In The Registry, Where Ca
If i use "SaveSetting App.Title, "Settings", "Font", "001122"" - save date in the registry, where can i find the value saved in the registry? Thanks

Setup Not Working On "Vista" VB6 And Crystal Report
Hi
We have a package using Vb6 and crsytal reports 8.0 running perfectly on 98/XP/ME/2000. But when we try to install this on Vista, Package gets installed but when we try using Rport it says "Server has not yet been opened". All oher functionality is working like saving database etc.
Setup is made using Installshield.I have tried using installation as "Run as Administrator mode" and tried differen paths in installation too.

Regards,
Amit

Crystal Report Problem - Group &"Page N Of M&"
crystal report problem
i need to print invoice from Number 10000 to 10010.
But i need to print Page N of M
i use group to group invoice. but how to make Group in "Page N of M"

anyone know it ?

Corrupt Variables And &"memory Error&"
Hi People

I would REALLY like comments on the following, even if no one can give me a solution!

Further to my other post about Word corrupting variables, I have modified the code, but not changed anything to do with variables i.e. I still use:

ActiveDocument.Variables.Add name:="xxx", Value:=yyy
(where yyy is a value generated by the code)

The new code gives slightly different results i.e. Word crashes with the following message:

Winword.EXE Application Error

The instruction at “0x308e05a0” referenced memory at “0x0182a27a”. The memory could not be “written”. Click OK to terminate etc.

Note this is NOT my code, it is Word. I understand this message appears when Word tries to access a memory area where it is not allowed i.e. Word wants to save my variables where it shouldn’t. My previous post’s error description ties up with this, as it is obvious that Word is not sorting the variables out properly.

Sorry, I should have said this only occurs at work on 4 computers, using XP, NT4, Win2000. Three computers at home (XP, Me) are all fine.

Some more interesting things:

I transferred the dot file with the code to a work’s machine, double clicked on it, Word opened. Even if I don’t run the code (or even touch any key!) when I close Word I get the above error message. I close Word, but the computer is stuffed and I have to restart (so much for Win 2000 stable memory management!).

With great difficulty (this long post would be much worse if I went into all that!) I have added my code to two of the work’s computers. I did this by commenting out the “variable add name lines”, opening the dot file, going in to VBA and copying over the code/form to the normal.dot template. Save VBA, close Word. Open Word, remove comments from variable line, save VBA. Code works fine (yes, it all works perfectly). Opening documents I have made on other machines reveals the correctly stored variables!

Thus, the mere presence of the “add variable lines” will cause a crash (i.e. without compiling or running), unless they are “made” in the machine that then runs the code.

The only differences between work and home is home has Office 2000 SP3 and I think work SP1. Work is also networked.

Someone commented that similar problems occurred with Office 97, but surely 2000 (all versions) has it sorted??

I don’t fancy personally visiting all the computers I was hoping this would be used on to carefully integrate the code!!!

Skeletal

Excel VBA Error &"memory Could Not Be Read&"
Dear friends,
I have the simplest of the forms I created using VBA in excel. The file is attached for reference.
It works fine. The problem arises when I close the file after I have run the form 6-7 times.
I get the error "The instruction 0x0202a877 referenced memory at 0x0202a877. The memory could not be read"
Please suggest what I should do to get rid of this error.
Thanks a bunch

Clipboard.GetData Gets &"Out Of Memory&" Error
To All:

I have a program which captures a graphic image currently in the clipboard and saves it to a file. Most of the time it works perfectly. Occasionally, the image which has been copied to the clipboard is quite large. When the image is large, I sometimes get an "Out Of Memory" error. The statement having the problem is:

imgSave.Picture = Clipboard.GetData(vbCFBitmap)

I've isolated the problem further to just:

Clipboard.GetData(vbCFBitmap)

What is causing the problem? I can manually paste the image into word, etc., so I know that it is sitting in the clipboard (in fact, my program checks to make sure the clipboard is containing an image)

On a couple instances where it failed, I rebooted the system and it worked, but I have one example where no matter what I do, it still has the "Out Of Memory" problem ...

FWIW: I have 1.5GB of swap, 1GB of memory and not a lot going on with the machine and I still sometimes get the error.

Any help would be greatly appreciated.

Thanks in advance,

Jim

How To Trace VB6 Error &"memory Could Not Be Read&".
From a few (not all) of my clients, I'm getting the old:

The instruction as "0x..." referenced memory at "0x00000000". The memory could not be "read".

This is an OS trapped error and not a trapable error in my VB6 app. Which usually indicates some dependancy (DLL) along the way is not installed or registered correctly on the client machine and/or that DLL has crashed and failed. I'm not able to reproduce in my dev environment so I'm certain this is a deployment/install problem -- aka DLL Hell.

Is there any tool I can install on my client PC to help me trace more specifically what the trigger is for this error? About the only other option I can think of is to hard code a trace option that logs every method function that is entered to a file (a huge file at that).

If someone knows of any tools that can help with situations like this, please let me know.

Thanks, Rob.

MS Word App, Memory &"read&" Error
I was commissioned to write a VB6 App that takes an ASCII data file, parses it then create a MS Word file.
I got it working perfectly with the help of some people here.

I sent a demo to by the buyer who says it works in his comp.
But when he sent it to his users they report this error:

Code:
TidesToMSWord.exe Application Error
The instruction at "0x00000000" referenced memory at "0x0000000". The memory
could not be "read"
Click on Ok to terminate the program
Click on Cancel to debug the program


Checking on this type of error I've found these possibilities:
1. Users comp has a bad memory stick
2. Users comp has a virus
3. Users OS is corrupt
4. A required component is missing.

Could there be more causes?

I'm looking at the only one I can do anything about, number 4.

Could they be getting this error because they don't have the needed VB6 files?

I'm programming on WinXP with OfficeXP.
The buyer says that he and his users have Win2k and Office2K.

The application is using the Microsoft Word 10.0 Object Library.
Is that lib compatible with Office2K?

If it isn't, my only other choice is to recompile on a comp running Word97 with the Word 8.0 Object Library.
And I've already found problems converting the code.

Would the Word 8.0 Object Library work with Office2K?
Should I fight my way through changing the app or have the buy check his comps for the 1st three possibilities first?

Any info/ suggestions are welcome.

&"REferenced Memory Can Not Be Read&" Error
Can anybody tell me what this error eans and how I can debug it?

Compile Error &"Out Of Memory&" *Resolved*
When I try to compile my project it goes fine until it get's to the "Writing EXE" pahse and it says "Out of Memory". I think this is because I have alot of images in my project. Does anyone know how I can get around this?



Edited by - msg555 on 5/10/2004 12:30:16 PM

ExcelCtl Object - &"Out Of Memory&" Error
I'm getting an "Out of Memory" error when trying to access an Excel object. I've added a reference to "ExcelCtl Type Library" which adds an Excel component to the Toolbox. I add this component to my form. Now any time I try to access the componenet via code (i.e. Ole1.object) I get the "Out of Memory" error. Any help with this is greatly appreciated.

Getting "Out Of Memory" Error With Database Operations...
After I Add a record, populate it with a string, and Update it, and when I click on my new record in my DataList, I get an error saying "Out of Memory". I have two tables that are linked by an AutoNumber field. Can anyone figure out why I am getting this error? It is not my computer that is out of memory, just an error within VB. Thanks!

I Can't &"show Sql Query&" - Crystal Report 8.5
Hey Guys, all fine ?

I created a report and using 3 tables( or more) with joins, group and etc. And this report calls a subreport. Well, the report is perfect, no problems! But, i can't see your sql definition(In crystal report, menu database,Show sql query) and, in Visual Basic i need to set a similar sql of report, only changing the where clause, by filter controls in VB.

In old times, i have used crystal report 8, and can show sql query.

In VB, how i can input a sql string in report, after execute it ?

How i can show sql query in CR?

Please, i need this help with urgency! The rope is in my neck! =(]

Thanks a lot!

A Link To Install &"crystal Report &" ?
pease be with you

dear friend

can i have a link to install crystal reprot ( 8 or 9 or 10 )

thanks

Crystal Report &"Underline&" Syntax
Peeps help me pls... How can I format the database field (like underline/ bold) in runtime?

What is the syntax in the formula editor? Thanks...

&"Type Mismatch&" (Crystal Report 7)
I am using the Crystal report component in VB6. Whenever I call the form containing the CRViewer to show the print preview I get the error "Type mismatch" I have to clear the error box and then I can print. The report is always fine but the user has to clear the error box. Can anyone help me avaoid the error?


Here the code that calls the viewer for print preview.

Dim Report As New CrystalReport2

CRViewer1.ReportSource = Report
CRViewer1.ViewReport
CRViewer1.Zoom 100


Thanks

Crystal Report &"server Not Yet Connected&"
Crytal report 8.5(RDC)
Problem with (Add databaseTo Report)
Platform vc++

 
 

Given programatically as
pDatabase->AddOLEDBSource(bstrAccessConnect, table_name);

By fetching the table names of the DB through
OpenSchema (..) method

This shows the all the tables of db in the tree view
But if i save this report MORE THAN ONCE OR TWICE and view it in the crviewer it gives
"SERVER NOT YET CONNECTED"

Is there any othere method for (Add databaseTo Report)
Db is off ms access, oledb,.....
I got only two functions

1)AddADOCommand (table name is not shown)
2)AddOLEDBSource
---------------

 I refered to this

Crystal Knowledge Base

which gives the following

"" Note that a report (.rpt) file already stores the physical server/data source name (DSN), and the user id (UID) used to create the report. If these values remain unchanged at runtime, then these parameters are not needed. The values stored in the report file will be used at runtime""


As mentioned above i have connected while creating the report
and saved But still the error occurs


But the error is due to the
pDatabase->AddOLEDBSource(bstrAccessConnect, table_name);

If i pass the above through loop for eg 2 table names
Database error doesn't come
But if the tables are more than 2 or 3
this error occurs

If I open the same rpt in design time after saving once in runtime
And try to saveas this rpt with diff name or same name in design time , AND OPEN IT ,THE SAME ERROR COMES IN THE PREVIEW

&"cannot Open Sql Server&" Vb-crystal Report 7.1
Hello !
i'm a bigginer to crystal report 7.1 working with vb6 and sql2000.

i' have created a report in crystal report 7.1 and want to call from vb form.

when i tried this with the following coding using crystal report control i'was getting the error message

"cannot open sql server"

what should i do ? do i need to give the connection string ?
if so show me sample.

With crcontrol
.ReportFileName = App.Path + "
eportsranch_sales.rpt"
.ParameterFields(0) = "pbcode;" & txtbcode.Text & ";true;"
.WindowState = crptMaximized
.Action = 1
End With

thanks in advance.
kalmazz

Weird &"out Of Memory&" Error
When I run the game I am working on in the VB environment everything goes well. However when I compile it and then try to run it as an EXE it gives me the error: "Run-time error '-2147024882 (8007000e)' Out of memory"

How do I go about fixing this?

The Memory Could Not Be &"written&" Error
I have used VB to create a COM Addin. The VB generate a dll file, and registered to Word.

Recently, whenever I close Word, i got the following error: The instruction at "0x016181bf" referenced memory at "0x06df3051". The memory could not be "written".

I have found out that it is related to the size of the dll file. If it's small than <1024K, the error won't appear. However, since the size of the project is increasing, the size of the dll is increasing also. Then,the error appears.

Does anyone know how to handle this? I don't think i can reduce the size of the dll quite a lot.........

Please Help!!!

&"out Of Memory&" Error When Making Exe
Well first let me say that I am new to vb. Anytime I go to make my first program an exe I get "out of memory" error. I`m not quite sure what 'memory' they mean (like if it ment to save the program, which I have deffinatly enough space left). My program is a very simple byte to mb converter and I would really like to figure this out as it is my first one. I will post the source code below.
--------------------------------------------------------------------------
Private Sub Command1_Click()
Text2.Text = Text1.Text / 1048576
End Sub
--------------------------------------------------------------------------
The only componets in my program are a Command Button, and two Text Box`s. This is really making me go crazy as I cannot figure this out. Any help is greatly appreciated and I hope I explained everything clearly, Thank you.

&"out Of Memory&" Error When Making Exe
Well first let me say that I am new to vb. Anytime I go to make my first program an exe I get "out of memory" error. I`m not quite sure what 'memory' they mean (like if it ment to save the program, which I have deffinatly enough space left). My program is a very simple byte to mb converter and I would really like to figure this out as it is my first one. I will post the source code below.
--------------------------------------------------------------------------
Private Sub Command1_Click()
Text2.Text = Text1.Text / 1048576
End Sub
--------------------------------------------------------------------------
The only componets in my program are a Command Button, and two Text Box`s. This is really making me go crazy as I cannot figure this out. Any help is greatly appreciated and I hope I explained everything clearly, Thank you.

The Memory Could Not Be &"read&" - Error
Hello
I'm writing some VB code in outlook VB editor.
I've added one simple thread to the project, and it sometimes couses an error:

The instruction at "0x.." referenced memory as "0x..". The memory could not be "read".
Click on OK to terminate the program
Cancel to debug..


The error doesn't occur all the time i try to run the thread, but some times...

What can be the reason?

Thanks,
anastacia

Error &"Out Of Memory&" (RAM 128Mb)
Hi Guru, this is the first time that I use vb6 and CR 8.5 to develop a system. Everything is all right until at the implementation, I always got error “Out Of Memory”.
My ram is 128 MB. Finally I found that every time I open a form, it increase memory usage. When I close that form it just decrease (release memory) a little. Especially Crviewer, it increases memory usage almost 10Mb and when it close only decreases approximately 2 Mb.
Then I use this .. to clean the variable :

Private Sub TabPrint()
Dim gcrReport As CRAXDRT.Report
Dim crDB As CRAXDRT.Database
Dim crTB As CRAXDRT.DatabaseTable

Dim showreport As New frmViewer
Set gcrReport = New rptSalesReport

Set crDB = gcrReport.Database
For Each crTB In crDB.Tables
crTB.SetLogOnInfo vDNSName, "", vDNSUser, vDNSPwd
Next

Set showreport.Report = gcrReport
showreport.CRViewer1.ReportSource = gcrReport
showreport.CRViewer1.ViewReport
showreport.CRViewer1.Zoom 1
showreport.Show

Set Showreport = nothing -->
Set gcrReport = nothing--> clear variable
Set crDB = nothing-->

End Sub

But it seems useless.

Is there a memory management is VB6. What should I do to solve this problem.
Please help me. Thx
Jay

CrystaL Report &"Invalid TLV&"
Help

My reports are perfect on my own machine, but when they transfer over to the test machines i get the error "Invalid TLV record"
I am aware that this only occurs on reports with a chart.

I also get a type mismatch error, on EVERY report.
it stil works fine but is somewhat annoying
I tested this second error by creating a basically blank report (1 string field)
and I still recieved the error


Any thoughts???
Direction???

Crystal Report &"LogOnServer&"
Hello,

   I dont like the Crystal Reports. But there are times when I have to use it (No other way).

   At this time, I am facing problem in opening a report. Here is the detail.

   I created a report in report designer of Crystal Reports and tried to call that report in VB 6. It worked fine, no error, Everyone was happy. But when we changed the Computer name, it just refused to open the report.

   Well, I noted that if I change the database name or server name then report fail to be called. Here is the little code to call the report.


Code: cr.ReportFileName = App.Path & "ReportsGeneral
epFarwarderList.rpt"
    cr.WindowState = crptMaximized
    cr.LogOnServer "p2ssql.dll", "localhost", "hkaLahore", "sa", ""
    cr.Action = 1

   Where cr is the Crystal Report Control. It tries to show the report but after a long wait, it just disappears with no error or with message "Database Not Found"

   Note that when the report was created, there was a different database and server name and now its different.

   In short, I want to specify the Server and database and user and password at runtime to the Crystal Report. how can I?

   Thanks,

   Sameers

A Stupid Problem: &"Error Accessing The System Registry&" (&"Solved&") Thank You
This is a very silly problem. I tried to have a look of References from Project dropdown menu, it returned a critical error:

"Error Accessing the system registry".

I reinstalled VB6 but it seems that the problem still exists. Anybody please tell me how to solve the problem.

thanks in advance





Edited by - kenyiwei on 5/6/2004 2:07:51 AM

I Am Reciveing This Error &"20525 Unable To Load Report&"
i am reciveing this error "20525 unable to load report"
i can't view crystal report i designed and saved as *.rpt
in vb6
"report.ReportTitle = title
report.DataFiles(0) = App.Path + "mydb.mdb"
report.ReportFileName = App.Path + "report1.rpt"
report.Action = 1"
is the error in the line "report.Action = 1"
i want to know why the report dos not show up

Copyright © 2005-08 www.BigResource.com, All rights reserved