-
March 3rd, 2004, 09:17 AM
#556
a Crystal Report Forum...
Why don't they open a Crystal Report Forum?
It would be really very useful!!
sounds good. Let me suggest it to Brad
...at present time, using mainly Net 4.0, Vs 2010
Special thanks to Lothar "the Great" Haensler, Chris Eastwood , dr_Michael, ClearCode, Iouri and
all the other wonderful people who made and make Codeguru a great place.
Come back soon, you Gurus.
-
March 5th, 2004, 10:50 PM
#557
HOPE SOMEONE ONLINE CAN HELP ME NOW!!!
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
-
March 10th, 2004, 01:18 PM
#558
crystal report w/ mas90 and access database
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
-
March 11th, 2004, 05:25 AM
#559
Crosstab Report
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.
-
March 11th, 2004, 11:19 AM
#560
awesome
this single topic here is 1000 times better than the CrystalDecisions *support* forum .
-
March 16th, 2004, 03:59 AM
#561
Deployment
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
-
March 16th, 2004, 10:32 AM
#562
Re: Deployment
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
-
March 19th, 2004, 05:55 AM
#563
New line
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
-
March 19th, 2004, 03:13 PM
#564
Exporting Text files
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
-
March 19th, 2004, 04:23 PM
#565
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!
I'd rather be wakeboarding...
-
March 22nd, 2004, 07:41 AM
#566
Multiple tables and databases.... 1 group
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.
P.D. Sorry for my really bad english.
Thanks for advance-----
Keylen
-
March 22nd, 2004, 08:14 AM
#567
Me again
Thanks i got the solution, i change the link in Visual Link Assistant
Ba bye people
-
March 22nd, 2004, 08:26 AM
#568
Re: New line
Stupid question, stupid answer... :-)
chr(10), obviously...
-
March 22nd, 2004, 09:31 AM
#569
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?
-
March 23rd, 2004, 09:00 AM
#570
Crystal Report Password in Database
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|