Crystal Report

hallo...K.Babu..

any idea how to solve my problem, descr as below;

I want to run a report ( Crystal Report 7.0) from my program
(code in VB 6.0).
But when I click a print button this error msg was appear ;
errMsg "Invalid report file name"

This are code of my program ;
Private Sub cmdPrint_Click()

On Error GoTo EmpPerDeterr
Cr.Action = 1

Cr.Reset
Cr.ReportTitle = "Catatan Aduan Pegawai MPSJ"
Cr.WindowState = crptMaximized
Cr.WindowTitle = "Catatan Aduan Pegawai MPSJ"
Cr.WindowShowGroupTree = True


Cr.Datafile(0) = App.Path & "\aswa.mdb"
Cr.ReportFileName = App.Path & "\Reports\Aduan.rpt"
Cr.Destination = crptToWindow
Cr.WindowShowRefreshBtn = True
Cr.WindowShowPrintBtn = True

Exit Sub

EmpPerDeterr:
MsgBox Err.Description, vbOKOnly, "OASYS"

End Sub

Hi,

action property should be at last line of all the cr.{properties}

cr.action = 1

yours friendly,
K.Babu

Quote:

---

Originally posted by pianme
hallo...K.Babu..

any idea how to solve my problem, descr as below;

I want to run a report ( Crystal Report 7.0) from my program
(code in VB 6.0).
But when I click a print button this error msg was appear ;
errMsg "Invalid report file name"

This are code of my program ;
Private Sub cmdPrint_Click()

On Error GoTo EmpPerDeterr
Cr.Action = 1

Cr.Reset
Cr.ReportTitle = "Catatan Aduan Pegawai MPSJ"
Cr.WindowState = crptMaximized
Cr.WindowTitle = "Catatan Aduan Pegawai MPSJ"
Cr.WindowShowGroupTree = True


Cr.Datafile(0) = App.Path & "\aswa.mdb"
Cr.ReportFileName = App.Path & "\Reports\Aduan.rpt"
Cr.Destination = crptToWindow
Cr.WindowShowRefreshBtn = True
Cr.WindowShowPrintBtn = True

Exit Sub

EmpPerDeterr:
MsgBox Err.Description, vbOKOnly, "OASYS"

End Sub

---

Managed to solve my problem. Certain aspects of Crystal objects are not enabled, you can determine which ones they are by using the Crystal Object browser (CrystalExplorer.exe) located in your /sample/xtreme/browser directory.

You can change the currency format of the report at run-time by calling the SetLocaleInfo API just before the report is opened.

Code:

---


'// APIs
    Private Declare Function GetLocaleInfo Lib "kernel32" Alias "GetLocaleInfoA" _
                (ByVal Locale As Long, _
                ByVal LCType As Long, _
                ByVal lpLCData As String, _
                ByVal cchData As Long) As Long

    Private Declare Function SetLocaleInfo Lib "kernel32" Alias "SetLocaleInfoA" _
                (ByVal Locale As Long, _
                ByVal LCType As Long, _
                ByVal lpLCData As String) As Long
               
    Private Declare Function GetSystemDefaultLCID Lib "kernel32" () As Long

    Private Const LOCALE_SCURRENCY          As Long = &H14


Private Function GetUserLocaleInfo(ByVal dwLocaleID As Long, _
                                  ByVal dwLCType As Long) As String
   
    On Error GoTo Fail

    Dim sReturn        As String
    Dim nSize          As Long
   
'// call the function passing the Locale type
'// variable to retrieve the required size of
'// the string buffer needed
    nSize = GetLocaleInfo(dwLocaleID, _
                          dwLCType, _
                          sReturn, _
                          Len(sReturn))
   
'// if successful..
    If nSize Then

        sReturn = Space$(nSize)
        nSize = GetLocaleInfo(dwLocaleID, _
                              dwLCType, _
                              sReturn, _
                              Len(sReturn))
        If nSize Then
            GetUserLocaleInfo = Left$(sReturn, _
                                      nSize - 1)
        End If
       
    End If

    Exit Function
Fail:

End Function

Private Sub ChangeCurrencyFormat(NewFormat As String)

    Dim LCID As Long
    Dim lResult As Long
       
'// Change the currency format in the LOCALE settings
    LCID = GetSystemDefaultLCID()
    lResult = SetLocaleInfo(LCID, _
                            LOCALE_SCURRENCY, _
                            NewFormat)

End Sub

Private Property Get LocaleCurrency() As String

    On Error GoTo Fail

    Dim LCID As Long
    LCID = GetSystemDefaultLCID()
    LocaleCurrency = GetUserLocaleInfo(LCID, LOCALE_SCURRENCY)

    Exit Property
Fail:

End Property

---

So, you can query the current setting with the LocaleCurrency property, change to the required setting using ChangeCurrencyFormat with the desired format e.g. ChangeCurrencyFormat("£") or ChangeCurrencyFormat("€"), open your report, then change back to previous currency format.

Any fields in the report defined with 'Use System Default Format' will now pick up the correct currency from Locale!

Hello K.babu and dear friends all around the world! Please help me to solve my problem. I want to format the rounding properties of a field number. For an example, I have this field [smallest_point] and another field number
[ Price ] and I set the rounding properties of field [Price] by this formula (Crystal Syntax) - in Customize number formatting menu :

IF {smallest_point} = 0.0001 THEN
0.0001
ELSE IF {smallest_point} = 0.01 THEN
0.01
ELSE IF {smallest_point} = 1 THEN
1

So why did the report send me this message : "Bad Formula Result" ?

I have to set the decimal number by the smallest_point. Let's say if the smallest point is 0.01, then the rounding must be 0.01 and decimal properties must be 1.00, if smallest point = 0.0001 then the rounding must be 0.0001 and decimal properties must be 1.0000.

How to solve this error ?

Please note that I've changed the Decimal Properties of the field to with this formula :

IF {smallest_point} = 0.0001 THEN
1.0000
ELSE IF {smallest_point} = 0.01 THEN
1.00
ELSE IF {smallest_point} = 1 THEN
1

THANKS TO ANYONE HELP ME! :wave:

:rolleyes:

Why don't they open a Crystal Report Forum?

It would be really very useful!!

Quote:

---

Why don't they open a Crystal Report Forum?

It would be really very useful!!

---

sounds good. Let me suggest it to Brad
:cool:

HELLO, IF ANYBODY READ THIS MESSAGE NOW, WOUL DYOU PLEASE ANSWER ME QUICKLY...

HOW TO PASS A SUMMARY FIELD IN SUBREPORT TO MAIN REPORT ? I NEED TO CALCULATE THE GRAND TOTAL OF SUMMARIZE FIELD IN SUB REPORT, AND SHOW IT TO MAIN REPORT!

PLEASE NOTE THAT THE RECORD HAVE EACH GROUP. FIRST I WANT TO TOTAL THE SUM OF DETAIL IN SUB REPORT OF EACH GROUP, AFTER THAT THE GRAND TOTAL....

THE SUM OF EACH GROUP AND THE GRAND TOTAL MUST BE ABLE TO BE VIEWED ON MAIN REPORT.....

IT'S EASY TO LINK FROM MAIN REPORT TO SUB REPORT, BUT TO THE OPPOSITE....HOW TO PASS IT FROM SUB REPORT TO MAIN REPORT, IN CRYSTAL, NOT FROM VB... THANKS IN ADVANCE

i am having a problem with a crystal report that at one point would run and now is giving me an error
odbc error:canada][pvx odbc driver][fileio] table is not accesible
after you hit ok on that
the second error is
error detected by database dll
what i am trying to run is a crystal report from a mas90 database with an access table. if anyone can shed some light it would be greatly appreciated.
thanks ralph

Hi All,

This is my 1st time on this forum page.
I really hope K.Babu or somebody could help me with crosstab reports.

I've completed creating my crosstab reports but the only problem is how do i create column labels for my crosstab report.
My report looks like this

Job1 Job2 Job3 Total
1 Anne 8 4 2 14
240.00 120.00 60.00 420.00
2 Joe 2 2 2 6
60.00 60.00 60.00 180.00

How do i create a label for 1 & Anne as "Emp No" & "Name".
The total field is a summarized field so the word total is automatically generated, so how do i change it to "Total Hr & Total S$"

I'm really looking forward to suggestion and help from anybody here.
Thanks in advance.

this single topic here is 1000 times better than the CrystalDecisions *support* forum . :D

Hi,

After deploying a VB.NET windows project with a CrystalReportViewer on the client's machine I'm getting the following error:

"Cannot Find keycodev2.dll, or invalid keycode"

Any help will be appreciated,

thanks.
mzainal

Quote:

---

Originally posted by mzainal
Hi,

After deploying a VB.NET windows project with a CrystalReportViewer on the client's machine I'm getting the following error:

"Cannot Find keycodev2.dll, or invalid keycode"

Any help will be appreciated,

thanks.
mzainal

---

take a look at this solution. I have the same problem as you, but it's your lucky day, I spend half a day to get it working after hunting for solution in the crystaldecisions support site.

http://support.businessobjects.com/l...s/c2010681.asp

Hi,
I've a stupid question:
How insert to string formula a NEW LINE?

I tested Basic's

"something" & vbCrLf & "something"

C's backslash+n and I loooooooking foooor... and nothing...

Specification:
I've UnboundString field, where i need insert to EditFormula this:

If {myTable.col1}="" then
{myTable.col2}
else
{myTable.col2} + (damned new line) + {myTable.col1}
...

Thanks
Dusan

Hi,
Is there any way to export .rpt files as text files. I am using crystal reports 9.0 and .Net framework..
I want to export them dynamically in the code.
I could able to export to pdf,doc and html..But not to text.

Thanks,
Ramesh

ramesh_cr:

You should post your questions in the main Crystal Reports forum instead of in this huge thread (the forum was created because of it). It's easier for someone to find your question and help you if they don't have to look through 500+ posts. It also makes it easier to find the answer to your question before you post.

That said, here's my best shot at an answer for you:

In CR 8.5, each export type has it's own dll that needs to be deployed with the program. From my experience, just putting that dll in the correct location will populate the Export box on the report. In order to see the export box on the report, use the following line in your VB app:

crReport.PrintWindowOptions.HasExportButton = True

I'm not sure if CR 9 is the same, but it's a start. CR 8.5 includes a file called runtime.hlp that lists all the files you need to deploy your app. You can also search on Crystals website (http://support.businessobjects.com/search/advsearch.asp) or on another search engine such as www.google.com.

Hope that helps!

Using multiple tables and 1 group
Hi everyone.....

I am using Crystal reports embedded in VS .NET but I am actually having problems with my principal report

I´ve 2 DB, one DB is MySQL and the another is Access.

I have a table in my access database called "TblSpot", this table contains spot info (its columns are spotName, productName,ClientName, spotURL, spotVersion,spotDurationn) actually this table contains only 17 data rows.

I have a table in MySQL database called "TblSpotReproduction", it contains spot reproduction info (its columns are spotName. playerName, reproductionTime) also it has 150000 data rows.

I tried to make a report grouped by SpotName with only TblSpotReproduction:

SpotName <------ Init Group Header
---------------------------------------------
playerName reproduction Time
---------------------------------------------------
<---------End Group Header

ALL DATA
..
.
.
.
.

----------------------------
Group Foot

Next group etc etc etc


This report works perfectly. It shows the solution delayed but it works perfectly.

But my client ask me to make a better report that include spot information. For that i´d to include the Access database. My new report must be like this:

SpotName <------ Init Group Header
spotURL
spotVersion
Client
Product
spotDuration
---------------------------------------------
playerName reproduction Time
---------------------------------------------------
<---------End Group Header

ALL DATA
..
.
.
.
.

----------------------------
Group Foot

Next group etc etc etc

My problem is that this reports never open, i think that the combination of 2 databases causes CR crash, maybe the combination between 150000 rows with 17 rows make a impossible JOIN. Friends told me I have to use sub-reports but i have no idea how to use them on the fly. :confused:

P.D. Sorry for my really bad english.


Thanks for advance-----

Keylen

Thanks i got the solution, i change the link in Visual Link Assistant

Ba bye people

Stupid question, stupid answer... :-)

chr(10), obviously...

Hi Babu,

i have a question about a runtime error that appears with the activeXviewer when i want to run a report through the browser.

My Report has a subreport on it. The Report has an SQL-Stament as a datasource. The statement has a paremater-value in its where clause. Before running the report i set the value of the parameter-field depending on the selections i made. These selection are like filters.

Now when i make some specific combinations of selections the following error occurs:

Error occured on Server. -2147482963:
Error in File c:\winnt\temp\{2824C0F2-A23B-4BA7-9239-D75C53D838A}.rpt
The request could not be submitted for background processing.

With some other combinations of selection the report works fine. I tested the database and the complet sql-statements but they were all ok. I have no idea anymore how i can solve the problem. Have you got an idea?

hi babu

pls pls help me......

where to write the code lines given by you to run crystal reports using a password protected database.

i am using a database which is password protected. i am creating a DSN for Crystal Reports. If i do not give password while creating DSN, it asks for it while running the reports.

can u help me in any way.... waiting anxiously for ur reply
bye

Hi curio11,

I am not sure as to what platform you are working on. I am using VS.Net 2003 and using C#. Here is what I did to solve this issue:

Right before I set the dataSource for my report. I did this:

myReport report = new myReport();
string login = "UserID";
string passWd = "Password";
report.SetDatabaseLogon(login,passWd);

crystalReportViewer1.ReportSource = report;

This did it for me. I hope this helps.

Take care.

Adios!
Salmaan.

I have the following code :
select {?TroubleType}
case "All Types":
{tbl_tickets.CustomerAcctNumber} <> '0' and
{tbl_tickets.OpenDate} >= {?BeginDate} and
{tbl_tickets.OpenDate} <= {?EndDate} and
{tbl_tickets.CustomerAcctNumber} <> '184114' and
{tbl_tickets.TroubleType} <> ""
case {?TroubleType}:
{tbl_tickets.TroubleID}<> 0 and
{tbl_tickets.OpenDate}>= {?BeginDate} and
{tbl_tickets.OpenDate}<= {?EndDate} and
{tbl_tickets.CustomerAcctNumber}<> '184114' and
{tbl_tickets.TroubleType}= {?TroubleType}

and I need to duplicate it for 3 other parameter fields. Is there a way to nest the case statements - I continually get an error everytime I try add just one other case statement to a new parameter....

Hi

I am working with VB.net 2002 and MS-Access(password protected). Have created a DSN to work with Crystal Reports. Now the problem is that it does not accept the following line code

CrystalReportViewer1.LogOnInfo(0) = "DSN = ABC;UID = ;PWD = XYZ;DSQ = "

have searched the whole thread, the only solution i found is this piece of code but it does not work et all...

do i require to import any files?? i am importing CrystalDecisions.CrystalReports.Engine and CrystalDecisions.Shared

my code is:
Dim rptTransporter As New rptTransporterCostingRpt()

CrystalReportViewer1.LogOnInfo(0) = "DSN = ABC;UID = ;PWD = XYZ;DSQ = "

CrystalReportViewer1.ReportSource = rptTransporter
CrystalReportViewer1.Show()

Thanks in advance
Bye

How do i dynamically through MFC/VC++ add and remove fields in the crystal report?

Hi,

I have the databse (Oracle) in Unicode (UTF8 encoding) and using reports 4.5. So I am not able to get the strings in the report. First of all, Does crystal report 9.0 works fine with UTF8 encoding backend? (now i get the string as UTF8 characters)

Now, to escape from upgrading to reports 9.0, I have another way. I can convert the Unicode characters to ASCII and use my own font to display and print. (The conversion and fonts are working properly.)

I want to call my converter while reading database (for every string value of every records). The front-end is VB6 and the coverters are functions written in VB6 (also used other dlls).

Can you guys help me to get a solution?

Thanx in advance.

Regards,
Mahesh

I am reading a record grouped by name and then by project name from Sql server DB. The database has records based on year of week. But the report should be based on pay period(dates). I have the logic to filter the data based on input pay period range. I used array to stretch the 3 rows from DB to 1 report row using

if({TimeSheet.Week} = {@beginWk}) then
populate week1 array;
else if({TimeSheet.Week} = {@endWk}) then
populate week3 array;
else
populate week2 array;

TimeSheet.Week - is the databasew field

Then I form the finalHrarray by stretching week1, week2 and week3 based on the pay period range. But in the report under the detail section it displays 3 rows from the DB for the project
like
projectA 0 1 2 3 4 5 0 0 0 0 0 0 0 0 0
projectA 0 1 2 3 4 5 0 0 0 0 0 0 0 0 0
projectA 0 1 2 3 4 5 0 0 0 0 0 0 0 0 1

Somehow it reads only 1 and 3 row and in some case 1 and 2 row. But I want
projectA 0 1 2 3 4 5 0 5 6 7 2 3 0 0 1 All three weeks in 1 row

Please help Babu:

For a couple days I've been battling with writing a report that has to tables linked by a left outer join. The left table simply holds all possible hours of the day (00 - 23). The right table holds all of my data.

My report groups on the hour of the day and it needs to show every hour of the day regardless of whether there is data there or not. I tried a bunch of things but I finally came to the conclusion that crystal was creating my sql syntax incorrectly.

I think I found a work around. I'm using an access database. If I write my own sql command I got it to work. Apparently, crystal was creating the wrong syntax for my sql statement when I used the select expert.

Crystal was creating the following query:

SELECT holdertable_hours.startingtimehours, recordcontrolnumber
FROM holdertable_hours LEFT OUTER JOIN Master ON HolderTable_Hours.StartingTimeHours=Master.StartingTimeHours
Where Master.GroupUsed='083';

If I create a sql command and put the where clause in the join statement it worked:

SELECT HolderTable_Hours.StartingTimeHours, RecordControlNumber
FROM HolderTable_Hours LEFT JOIN [Select * From Master Where GroupUsed='083']. AS Master ON HolderTable_Hours.StartingTimeHours=Master.StartingTimeHours;

I have two questions though:
1) Is it possible to change the sql that crystal generates without writing my own sql command?

2) If I have to write my own sql command, is it possible to create a drop down list for my parameter field, Master.GroupUsed? Originally I was not writing my own command and I had a parameter field where I could select my value for GroupUsed from a drop down list. Now that I have my parameter field as part of my command, it appears that crystal is making me type in the GroupUsed value. It would be nice to still be able to use a drop down list.

Thanks again for all of your help on this!

Steph-

looks like kbabu is away.........but still, hope lives

i hope somebody can help me.............

i have attached a zip file, which contains my problem, pls have a look and help me.

Quote:

---

Originally posted by amit_mash
looks like kbabu is away

---

K.Babu is now the moderator of this board.
He asked to receive notifications of new posts in this forum.
I think one of best ways to contact him is the following:
make your questions as new thread, and then...mail him or send
him a pm (look in profile) the link to your question (do not rewrite
your question, but simply write: New Crystal Report Question
and paste the link to your question...

Cesare I.

Hi,

Iam also recommanded for your questions as new thread.

K.Babu

Quote:

---

Originally posted by Cimperiali
K.Babu is now the moderator of this board.
He asked to receive notifications of new posts in this forum.
I think one of best ways to contact him is the following:
make your questions as new thread, and then...mail him or send
him a pm (look in profile) the link to your question (do not rewrite
your question, but simply write: New Crystal Report Question
and paste the link to your question...

Cesare I.

---