Crystal Report

I want to configure the crystal report template file to allow application to dynamically set the link to the bitmap from code.

Is this possible? Do I use PESetFormula(...) for this?

Or do I need to hardcode the path and name of bitmap file in my crystal report template?

Thanks

__Manan__

I m using VB 6, crystal report 8 and oracle 9.

I m getting problem to using parameter field through VB.

Please give me code of vb for how to pass parameter through VB using parameter fields

hi group,

i'm new to crystal with vs.net and did some reports for a website after reading the wrox book.

now i try to depoly my first winform app with crystal reports in it and it doesn't work. everything's fine on the pc where i developped it, but on any other pc i get an error message that i try to translate from german: querry module error: c:\windows\temp\temp_15....f9.rpt

i did the following: first create an xml dataset that was used to create the report from. next i fill another dataset with runtime filtered data from my database. this works, i can see it in the datagrid. than i set the report datasource to the dataset with the filtered data and execute it.

than i built a setup project, which reports no errors and deployed the solution. the form works fine, only when i hit the buton to connect the report to the dataset i get the above mentioned error.

any help?

thanx anyway

chris

Crystal Report 8.5

I am using a sub report. I have inserted the subreport into my primary report via the report designer.When i invoke the primary report from my VB6 application i get an error "File Not Found". I guess this is because the VB appilication cannot find the path for the sub report. How can i specify the path of the sub report in the VB Application?

Dear Mr. Babu

I am working on a test project. Were I use access 2000 and VB and for report crystal report. In access I have 25 tables with collect data about 25 different dimensions of an auto part. I created a report using crystal report and put 25 fields [field name 'dimension'] from each database into report. For eg my report looks like.
dimen1.value, dimen2.value, dimen3.value and so on till 25 dimension.

Now after creating a report I entered first record with 25 dimension i.e. one value per table. After that I entered 2nd record in which I put only 4 dimension. Now when I preview the report my problem is 1 record show all the 25 dimen. perfectly but 2nd record which has only 4 dimension shows first 4 dimension correctly but from the fifth dimension it shows records of first record.

I am really confused . Why the 2nd row in report shows the data in 5th dimension of first record. 2nd row in report is supposed to be blank as I have entered only 4 dimensions. If you can guide then please help

Hi All,
I am a new learner and user of Crystal reports. I have one query. I have made a line chart. I have made it thru chart expert, in that the names of the legends were automatically created by the software and I have no ways to change it.
eg. My table structure is

Week Date
Plan Number
Actual Number
Forecast Number

On my X-Axis the vales of weeks are shown and on Y Axis -- forecast, Actual and Plan values are shown. SO when I create a grapf, the legend names are automatically given by the software as.... sum of plan......
sum of forecast
sum of Actual

I want to change it to Just Plan, Actual, Forecast. How to go about it?

Please help me as I have to submit my work to client in few days.


Thanx & Regards
Varsha

Hi,
I have a very simple problem: I have a selection parameter that is defined as string. During selection I want to define a search query using wildcards on a defined DB field. So I have defined the selection parameter as follows:

{db.column_name} like {?PARAMETER}

The compiler returns an error on the PARAMETER saying that it is not a string.
If I try to convert the parameter using functions like toText the error changes into somethingh like "number, date, boolean required".

Is there any document that can help developing with Crystal Report?

Thanks in advance.

Hi K. Babu! I hope you can help me with my dilemma.

Can i put page columns in a crystal report??? If it is possible, how can i do it??

Attached is the format i want to do with my report

Thanks in advance!

Joy :)

How do i insert variable number of images retrieved from database in to a crystal report at runtime.

HI
I am having problem with crytal report. I am a newbie. i have made a report with the wizard and added the report form viewer control and set its source property to my report. but when i start my applicaton it asks for server, database, user and paasword what to do. i don't want this dialog to come. anybody plz could fix this problem.
THNX IN ADVANCE

Hi,
Well my problem is that i cant print grouped data horizontally..for example...


stud_id quartercd fees
1 101 3000
1 102 4000
2 101 5000
1 103 3500
2 102 2100
3 101 4500
2 103 3000
3 102 2500


now in crystal report i want to print in the following format

studid quarter1 quarter2 quarter3
1 3000 5000 4500
2 4000 2100 3000
3 4500 2500

please help me i m in trouble....the above report requires data to be grouped horizontally..with normal grouping it gives the following output

studid 1
quarter1 3000
quarter2 5000
quarter3 4500

and so on..which is not required pls help...
regards
Anand

could any one help to reterive data from mssql to crystal report
this is the link for my code

http://www.codeguru.com/forum/showth...hreadid=248305

thank u all

Hello Babu,

hoping this is an easy one - I am really new and I have a report that I need to have the user choose multiple elements or 'all' elements for the sort - I have the multiple element working but I am not sure how to get the 'al'' working...

example:

database holds element COLOR - values: blue, red, yellow, green, orange..

I want the user be able to pick 1 value, multiple values, OR I would like them to be able to pick 'ALL' and I would like ALL by default (so it picks ALL colors)...

I hope this makes sense :)
Thanks !
Jennifer

hi ,
i use my .net2002 IDE to develop a report veiwer tools, i use this in other win2000 machine with .net frame work,but when i open .rpt file use this tool,it disappear "missing registration .dll",i already include some module in this application (regwiz.msm),why?
thanks.

How to Improve Crystal Report performance ?

For simple report it took 1-2 minutes to show report.

I have upgrade to crystal reports 8.5 to take advantage of the Active Data Driver/Reporting. Problem, the documentation states that a System DNS connection must be created. I have been successful in creating and connection to a report. However I would like to create a DNS-Less Connection. Any clues on how to connect to the Crystal Report Viewer using a DNS-Less Connection?:D

Hi,

I have started to develop reports using the Crystal Reports.

Case #1
We can design report into Crystal report and save it as .Rpt file.

Case #2
We can design report as like data report into the Visual Basic Interface and save it as DSR Files.

Problem #1
I Need to change Database connection for report at run-time.
Is there need of creation of DSN.
(I can't use DSN, it is out of our architecture )

Using Case#2, I have no need to change database connection of report, because report is connected to Data Environment connection, I can change only Data Env. Connection to other Database.

So, Please tell me hot to change database of crystal report at runtime for .rpt ?

Question #1
If I used reports like Case#1.
Are they included into the my Application .Exe or I can keep them separate as like .RPT

Question #2
Speed : Crystal Report takes too much time to load the report

Please guide me this.

Hi every one ,

I am trying to pass parameter to crystal report 8.0 from VB6.0 form .
But it is giving problem .
I have written following code

CrystalReport1.ParameterFields(Todate) = CDate(DTPicker2.Value)
CrystalReport1.ParameterFields(PaymentType) =CStrCombo1.Text)

it is okay up to this level but when i tryed to give action to crystalreport1 as
CrystalReport1.action = 1
then it is giving problem .

can any boody tell me why i am getting problem .

Thanks in advance .

Suyog

Hi,
Following is code for parameter.
Ex:

' Customer ID parameter. This is a number range parameter.
CrxReport.ParameterFields.GetItemByName("Customer ID").AddCurrentRange 1, 100, 3

' Last Year's Sales parameter. This is a currency parameter.
CrxReport.ParameterFields.GetItemByName("Last Year's Sales").AddCurrentValue 20000

' Region parameter. This is a string parameter with multiple values.
CrxReport.ParameterFields.GetItemByName("Region").AddCurrentValue "CA"
CrxReport.ParameterFields.GetItemByName("Region").AddCurrentValue "NJ"

' Today's date parameter. This is a date parameter.
CrxReport.ParameterFields.GetItemByName("Today's Date").AddCurrentValue Date

Note : For more detail download this sample from www.crystaldecisions.com/Support

:rolleyes:
(Every body is Master..., No body is Master...)

Hello,

I'm new to this group, so sorry if I'm a little slow off the blocks.

I'm creating a crystal report object in an Access module, that is
using a report already created using the standard version of Crystal
(version 9).

Everything is ok, except when I password protect the database, and
subsequently update the tables in the database connection dialog in
the Crystal Report, I can no longer create the object in the Access
module....

perhaps I need to be using something like .logonserver or such
like.....but I suspect this uses DLLs that aren't available with the
standard version of Crystal Reports.

any info much appreciated

Tim

Greetings Babu,
I am using a dataset that consists of a SQL Server Stored procedure with a parameter, I would like to have a bottun on a windows form in my C# app that the user would press to pass in a param, do you know how I can pass in a param to my crystal report? EVerytime I add a param, and run my app, this dialog box pops up and asks for the parameter, i don't want this to happen because I want my text field to take care of passing hte param in? Could you provide any advice?

Thanks!!!
The TreeofWoe

Hi,

I am having a problem with a report for a table in a Access DB. I am filling this table with 3 - 5 records from a VB program and after that I display the report (crystal report 7.0). The problem is that not all the records are displayed. I have to wait about 5 sec and after that to make a refresh. After that everything is OK. Some times there is nothing displayed, some times there are displayed only some records. It is very rare that all the records displays since the first display.

PLS, anyone helps me.

All the best,
Eri.

Hi,

I' m working with VB6, CR 9 and SQL Server.

I connect to my Database by setting the DSN dynamically. So far so good, BUT.....
i want to connect to another database that has a different name, but the same structure with the main one.

My question here is: is there any way to have my database name dynamic in the report file so I don't have to go through and explicitly change the source names in the report?

THANX

hi,

I have used graphs in my report. I have used Crystal Report 6.0. The graphs are working fine in report wirter.
But when i'm executing the reports through my vc++ program it's not showing the graphs in the report. All other things are coming properly except the graphs.
What could be the possible reason. Am i need to include any lib file or anything else. Please help!!!

rdonline1

Jennifer,

Create a parameter called color, check the multiple value box, then click the set default values box. Add the values you want to choose from i.e. Red, blue etc.... Then type in "All" and add that. Make sure "All" is at the top of the list.

Then go into "Select expert" and create the formula below

if {?Color}= "All" then {Your . Field} like "*" else {Your . Field}={?Color}

Replace "Your . Field" with the appropriate database field

You will still have to click add for "All" when selecting, but it will be up by default.

Hope that helps,
Mike

Quote:

---

Originally posted by Jenreb1
Hello Babu,

hoping this is an easy one - I am really new and I have a report that I need to have the user choose multiple elements or 'all' elements for the sort - I have the multiple element working but I am not sure how to get the 'al'' working...

example:

database holds element COLOR - values: blue, red, yellow, green, orange..

I want the user be able to pick 1 value, multiple values, OR I would like them to be able to pick 'ALL' and I would like ALL by default (so it picks ALL colors)...

I hope this makes sense :)
Thanks !
Jennifer

---

Hi A. Kabu

I've using Cristal Report for some time. and I have a problem.

I need to resize the preview window. This window is made a child window of CRPEPlusView wish is derived from CView folowing the Document/View parathigm.

Then when I resize the application frameWindow the prevw window of Crystal Report don'st do it. there's any way to get that window's handle to rezie it or other way of doing it....

void CRPEPlusView::OnReportPreview()
{
...
GetClientRect(&Rect);
if (!app->printJob->OutputToWindow("Crystal Reports Class Demo",0,0,Rect.Width(),Rect.Height(),WS_CHILD ,this))
AfxMessageBox(app->printJob->GetErrorText());
else if (!app->printJob->Start())
AfxMessageBox(app->printJob->GetErrorText());
}

My Derived class from CWinApp has this two objects.
CRPEngine printEngine;
CRPEJob *printJob;

I have a report that works fine, it access a free table database using a DSN. When one of the tables is corrupt, the report crashes and the ASP web page kills IIS. I want to set a time out to the web page to stop it and let IIS to continue with it service. What can i do?

I have created a VB app, that will display crystal report.
The problem now is I have set my MS Access database a password. Therefore I cant view my crystal report now.
can u help me with this problem?

Your could download my program at:

www.bigcaterers.com.my/db/cybercaffe.zip

Quote:

---

Originally posted by K.Babu
hi,

Stores all pictures in database files using with OLE Object type.

Add the picture field in your crystal report.

yours,
K.Babu

MailID: [email protected]

---

hi,
I meet this question too,i used SQL 2000. So Should I stores all picture files content into database's image field? I only want to show a picture according a picture file whose name stored in database and picture file stored in my disk.
Can you give me a reply and some code?

Dear Sir,

I am using Crystal Report 8.5, I have designed my report into the .DSR format. I have created Setup of my application to Install, It installs the app on other system. But when I run the report it gives me error.

It shows Crystal Report Viewer and does not show the report but give this error Physical Database not Found.
:confused:

Hi Babu: I have an ASP application that that uses crystal report, I need to access the SQL query, modify it and reset it dynamically at run time. I am thinking to use ISAPI filters to interrupt the calls to the .rpt files in the ASP. Is it doable? Do you recommend a different methods? PS note that I want to do this with the minimum or no change to the code in the ASP.

Thanks
Basheir

:) HI everybody

I have 3 reports in my app. they are successfully install/distributed to other system. I have one Problem with them

One report get open properly, but other two reports give error that is "SERVER has not yet open". I am using ODBC due to my multi-databases.

My Programming I Change registry Entries of ODBC. I think it is fine because my app is working fine, only two reports give this error. Visual Basic is used.

Please help me.

hi...
why some of crystal report component in VB not there when i install crystal report 8.5... but if i install the built in crystal report in visual studio 6.0 cd , all the component appear... this is the beginning of my curiosity as a newbie...

sorry for bad english......:confused: :confused:

hello, hai

please tell me how i can learn cyrstal reports.net and please recomend me best books and sites.

i am waiting for your reply.

Hi Everybody,

I have been trying hard to print a crystal report thru CrystalReportViewer. I am able to do it but the problem is that I donot want the print dialog box that appears with it.

I also tried PrintToPrinter method of Report which does not bring up the dialog box but that does not help either as here the arabic characters in my report are printed as junk characters.

So one of the two things will solve my problem. 1. suppress the dialog box when printing thru crystal report viewer or 2. find a way to print arabic characters.

Regards,
Teekam.

Hi

How can I generate report on a pc where crystal report software is not installed. Is it possible. Or what is the other way.
I am calling report in my program using crystal report ocx control. So how it will work without installing crystal report software. Should I convert report file to exe or some other way.

Thanks

imran

Hi Friend

I need help regarding the crystal report group by function.

When we add a group by "DATE" with condition as "Weekly" it takes from Sunday to Saturday by default.But the requirement I have is Weekly should be from Monday to Saturday.IS there any way I can customize this group by function by Weekly where it can take days from Monday to Saturday?

Please reply

thanks in adv
Selvi

Hi to everyone.

I'm running a VB5 and crystal reports 4.6.1.

I have several CR controls in a form for different reports. When invoking the "cr.action = 1" in more than one cr control in the compilated .exe program I get the next message when closing the form:

XXXX caused a page fault
in module CRYSTL32.OCX memory location 0167:250127fb.
Registers:
EAX=00000000 ... etc.

Is anybody familiar with this error, and which is the solution?

Thanks in advance.

Rubber Duckie.

Hi to everyone.

I'm running a VB5 and crystal reports 4.6.1.

I have several CR controls in a form for different reports. When invoking the "cr.action = 1" in more than one cr control in the compilated .exe program I get the next message when closing the form:

XXXX caused a page fault
in module CRYSTL32.OCX memory location 0167:250127fb.
Registers:
EAX=00000000 ... etc.

Is anybody familiar with this error, and which is the solution?

Thanks in advance.

Rubber Duckie.

Hi,

What is your actual requirement, you want to skip the sunday?...

Thanks,
K.Babu

Quote:

---

Originally posted by tamilselvir
Hi Friend

I need help regarding the crystal report group by function.

When we add a group by "DATE" with condition as "Weekly" it takes from Sunday to Saturday by default.But the requirement I have is Weekly should be from Monday to Saturday.IS there any way I can customize this group by function by Weekly where it can take days from Monday to Saturday?

Please reply

thanks in adv
Selvi

---

Hi,

You can use with single cr control for more reports, just change the *.rpt file and the database connection, it's right.

if you face same problem using with the single cr control, Reinstall the cr applicaton and then try again.

Thanks
K.Babu

Quote:

---

Originally posted by Rubber Duckie
Hi to everyone.

I'm running a VB5 and crystal reports 4.6.1.

I have several CR controls in a form for different reports. When invoking the "cr.action = 1" in more than one cr control in the compilated .exe program I get the next message when closing the form:

XXXX caused a page fault
in module CRYSTL32.OCX memory location 0167:250127fb.
Registers:
EAX=00000000 ... etc.

Is anybody familiar with this error, and which is the solution?

Thanks in advance.

Rubber Duckie.

---

I want to create a report while is running a VB application. The report is generated by a database at runtime.
I can only show the data in one page and there are data which are not visible because the width of the paper is not enough.
How is possible to show all the data in differents pages?
I have the same problem if I use the crystal activex control or the RDC.
Thank you very much
Natalia

Hi,

I have a problem with a left outer join in the database expert.
I join two tables with a left outer join and it appears like it is like an inner join.

My database is pervasive2000. I have a connection through ODBC.

I found a document on the "Cr9_left_outer_join.pdf" and I added my driver to a registry key. But left outer join works like a inner join.

How can I solve this problem.

Thanks in advance !!

Dear K. Babu,

Done !!! ... and working fine.

Just one question, is there a way to "refresh" the CR control in order to clear the formulas passed via the ".ReplaceSelectionFormula " and ".Formulas(x)"?


Thank you very much.

Rubber Duckie

Hi,

Just you reassign the empty string that's enough.

cr.Formulas(x) = " myformula = '' " same as replaceselectionformula also.

yours,
K.Babu

Quote:

---

Originally posted by Rubber Duckie
Dear K. Babu,

Done !!! ... and working fine.

Just one question, is there a way to "refresh" the CR control in order to clear the formulas passed via the ".ReplaceSelectionFormula " and ".Formulas(x)"?


Thank you very much.

Rubber Duckie

---

Hi,

I have a typical problem that has to be solved immediately.

I created a report, which is been Grouped, I have subtotal, GrandTotal too. In the View I see the GroupHeader in end of the Page/ Subtotal in the next page. The reason I feel is lack of space, but I would like if the their is no space continue in the Next page. But I would like Groups continously not in separate pages...

Do reply Immd.

Thank You :)

With Regards
Soundar

I am running Windows 2000 Adv Server and SQL 2000 SP3.
Client is Windows 98.

Developing using VB6 and Crystal Report 5.

Problem: Even when I create a new login with DBO rights to the database, connecting at CR via ODBC, I am not able to see any tables other than 2 system tables. (refer to attached jpeg)

Any comments?

Hi K.Babu,
I would like to do some batch reporting from my program:
Our users use the program to look at their report thru the web, i was wondering if there is a code to either print it direcly from the web component or add the code in the webpage that create the report to print it as soon as it s loaded.. like this i can load another page and print it.. ect..
Thanks

Hi,

Try to view in ADO activex control from vb, through by odbc connection string.

your friendly,
K.Babu

Quote:

---

Originally posted by tadaguru
I am running Windows 2000 Adv Server and SQL 2000 SP3.
Client is Windows 98.

Developing using VB6 and Crystal Report 5.

Problem: Even when I create a new login with DBO rights to the database, connecting at CR via ODBC, I am not able to see any tables other than 2 system tables. (refer to attached jpeg)

Any comments?

---

Hi,

Insert the formula fields in cr, add the table fields in that formula fields,

here you can get the pageno and find it out the odd / even pages if the odd number page, view table1.field1 else if even number page view table1.field10, Try this logic.

yours friendly,
K.Babu

Quote:

---

Originally posted by nataliagonzalez
I want to create a report while is running a VB application. The report is generated by a database at runtime.
I can only show the data in one page and there are data which are not visible because the width of the paper is not enough.
How is possible to show all the data in differents pages?
I have the same problem if I use the crystal activex control or the RDC.
Thank you very much
Natalia

---