Crystal Report

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