Showing posts with label attention. Show all posts
Showing posts with label attention. Show all posts

Sunday, March 11, 2012

Crystal Report Prob

Thanx Andreas Masur.. But I couldn't solve my prob..Look at it please...

Attention Mr K Babu..Pl see my prob and give me a solution..

I have used the following in my project-
i) V B 6.0 as Front End Tool.
ii) Oracle 8 as RDBMS.
iii) Windows 2000 Advanced Server as Server O.S.
( The machine has dual O.S i.e Windows 98 SE also is there)
iv) Crystal Report 7.0 as Reporting Tool.

Now my problem is While calling a report from VB, I need to REFRESH and SAVE the report in Seagate Crystal Report, otherwise the latest data inserted does not show.

The part of coding used also given below-

RPT1.Selectionformula=Tablename.Fieldname
RPT1.Action=1
Some more points-
i) Another important point is I used DiscardSaveData property before Action property, even then it was not working.
ii) There is no Refresh method shows in the Property and Method List.
iii) Sometimes while saving the Report in Crustal Report I had to use Save As command as the report takes some other name having extension .TMP
iv) The error mostly I faced is "SQL Server could not found, Error 20599"- where as I did not use SQL Server and I used only Oracle 8..,

ThanxI use CrystalRyport. I want to print records in the same line in succession . How do i do?

Wednesday, March 7, 2012

Crystal Reoprt Connection

Attention Ashish Seth, Hyderabad...

I'm new in C/Reports..I'm developint a project using Orale 8i, VB 6.0 and C/Reports 7.0..So my paltform is almost same with U..As you found the error"server has not yet been open" I also am facing an error and I could not come out of that my error is
-Error number 20599 "SQL Server can not open"
As I'm not using SQL Server, why this error is then...Someone has told me that I've to connect to report by coding, which I didn't do..Can You just help me as your prob is a bit similar to mine...[Moved thread]|||I've come across similar problems where I get a SQL server error and my report doesn't connect to the database itself (I connect to the database in VB and pass the report a recordset). It turned out that it was a version incompatibility between some of my dlls. Check the version of all your dlls.|||You need to add following code into your preview window
'-----------------
'General Declaration
Dim crApplication As New CRAXDRT.Application

'Form Load
Set crApplication = CreateObject("CRYSTALRUNTIME.APPLICATION")
crApplication.LogOnServer "pdsmon.dll", "", sDatabase, sUid, sPwd

sdatabase = <databse name>
sUid = User Name
sPwd = Password

use pdsmon.dll when you created report via ado connection
use pdsodbc.dll when you created report via odbc connection

This will really help you

Sikander