Problem in Exporting Crystal Reports

Hi All,
I have been using Crystal Reports 8.5 with VB6.0.
I want to set the Export options through VB code.
But when I call the Export method ,the settings whatever I made is not active,it is displaying the default settings only.
How to resolve this?

Thanks in Advance for all helps!

Regards,
Muthukumar.CThere are plenty of articles in Business Objects knowledge base about how to export reports using various interfaces:
http://support.businessobjects.com/library/kbase/articles/c2010117.asp
http://support.businessobjects.com/communityCS/FilesAndUpdates/autexprt.zip.asp

Be sure to always check the knowledge base before posting to forum. In most cases, you will find the solution much faster than you expect.

Problem in deployment of Crystal 10 with VB6

I've facing problem in creating the package for the application using VB6 and Crystal reports 10. What are the support files needed to be included in the package. I've already included Crviewer.dll,CRAXDRT.dll. But there is no response in the client machine.Whether Crystal Reports 10 need to be installed in client machine?

Please respond!

Thanking you,

Regards,
Rajarajan RI found solution to my deployment problems in the next link -->

http://support.businessobjects.com/communityCS/TechnicalPapers/rdc10_deployment.pdf

Problem in Dataset

Hi

I created a stored procedure which returns a dataset
that is passed to crystal report like this

dset = SqlHelper.ExecuteDataset(CommandType.StoredProcedure, "spr_CR_Demo2")

dset.Tables(0).TableName = "spr_CR_Demo2"

crystal.SetDataSource(dset)
CrystalReportViewer2.ReportSource = crystal

But only one record get displayed,how can i do it
anyone can help me

ThanxAre you sure that sp returns more than one record?
Open the report and Do Verify database. Save the report and Try it again

Problem in Crystl Report Viewer.CloseView Method

Hello K.Babu

My Self Sanjeev. i want to ask about crystal report viewer control. i am using crystal report 8.5 version. i using crviewer to view the report. by crviewer.viewreport() i view the reoprt now i want to close the view, so i use crviewer.closeview(index) method but it gives error. index parameter not accepting string data type. and also not 1,-1,0 to close the view. i use activeindex of crviewer but not woking. so please help me to solve this problem. i needed it veru much

SanjeevLooks like something is wrong with dealing with viewObject. Did u use AddView method to add ViewerObject. It's not picking the index properly.

THanks|||hello,

i have not used addview method to add view for the viewobject. how to use it? can u please explain it.

Thankx

Sanjeev|||So far in my application I haven't used view.. it's not clear yet whether I need to use view or not ?

I see this particular function :

closeCurrentView
If the canCloseCurrentView property is True, closes the current view. Equivalent to the Close button in the toolbar. A viewClosed and a viewActivated event are fired. The currentViewName property is changed.

Syntax
void closeCurrentView ()

check whether this server our purpose.

Thanks|||Sorry sir,

this will not solve the problem. i have know that whether the canCloseCurrentView() is method of what? 'coz both the ceviewer and crystalreport is not having property,method,function like this.

and i want to close the view.

sanjeev.|||Do u really need view in your application ? What if you don't close the view ?|||Hello Sir,

I want to create 1 DLL file which includs several reports in it. and i will add reference of that file to my VB Project. So i used Crystal 8.5 and Vb 6.0. i create 1 dll but with ne VB form which have the crystal report viewer control shows the Report which i passed through VB. now when i close the Form of viewer. Dll component does not get closed. i.e. the instance of the object is not closed and project goes into HangUp position. if so i want to close the view first so i can set the object to nothing.

So please help me to di it.

Sanjeev

problem in crystal reports design

hi,
I want to know if its possible to design crystal reports with checkbox. Iam working in vb.net and using crystal reports.What do you want to to that?

See if you find solution here
http://support.businessobjects.com/

problem in crystal report printing

i have developed a report in crystal report having field object with multiple lines. preview is perfect but it doesn't print in some dot matrix printer. please help me in this regard. thanks in advance.if printer is different then output may vary. use different printer setting for different printers.

Problem in creating Crystal reports

Hello friends,

I am creating crystal reports, I have used a crystal report viewer, but when i run it , i am asked the database login, I have set the windows NT Integrated security,so what userID and Password i should supply?

Kindly help me outIt should be no UID or PWD.
It should be windows authentication.

Good Luck.

Problem in creating Crystal reports

Hello friends,

I m stuck up with crystal reports. I have used crystal report viewer , but when I run it , i am asked database login , I have used Windows Integrated security what userid and password should I supply

Kindly help me outWhat are you using? Crystal Reports? The Crystal Report viewer in .Net? I'm assuming you are using SQL Server 2000? Need more info.

Erik Roessing

Problem Exporting to PDF - TRIED EVERYTHING (almost)

OK.. The newest member so go slow with me (normally do male modelling.. ;) )

Anyway. Using Crystal Reports 8.0 and VB6. It "exports" from VB6 to The Crystal Report Viewer 8.5. I then try to use the export button and it will export to RTF and Text BUT not to PDF. It will not export from the Viewer OR the actual program.

I have copied all relevant DLL's into Windows\crystal on the PC. These were u2fpdf.dll, u2ddisk.dll. There is no need to Regsvr32 them as they will not go in anyway.

I have also put them in windows\system32 just for good measure as well as program files/common files/crystal decisions/1.0/bin/*. I have tryed downloading different versions of these DLL's but it has made no difference.

I even installed Adobe Acrobat Writer as I thought this might make a difference but it has not.

ANY HELP would be appreciated as firstly I can't spell... and secondly I don't really know what I am doing.. I'm finishing off someone elses project...

Cheers

KirbanWhich OS are you using? CrViewer requires different dll's to Windows98 and earlier OS's. With XP you must use crxf_pdf.dll instead u2fpdf.dll and be sure to register your exportmodeller.dll after you insert the dll.

In one rare occasion I had to rename crxf_pdf.dll to u2fpdf.dll in order to get the client machine working.

Problem Export - Works on dev computer, not on other ones...

I have a problem exporting report with Crystal Report for Visual Studio .NET 2002.
In fact, with the computer I used to program, the export works fine. I've tried to get my .NET project on another computer, and there the export doesn't work...
The error occurs on the line : report.Export(); When I catch it, it says "Echec de connexion", which means "Connection failed".

Here are my config :

- The "good" computer : Win 2000 Server with last SP's, VS.NET 2002, Crystal Report for VS .NET

- The "bad" one : same one...

I also tried on an Xp computer, and it doesn't work either...

I've tried the Modules utility from Business Object to see if DLL's were missing on "bad" computer, but it's quite hard to define ('have to see the DLL under aspnet_wp.exe process, haven't I ?)

I install all services packs and hotfixes for Crystal Report for VS .NET 2002...It doesn't change anything.

So, if you have any idea, it would be welcomed !! Thanks.Check to make sure all the required Export dlls are installed on the "bad" computer.

Each Export format (Excel, pdf, etc) and each Export Destination (Aplication, Disk, etc) has to have a dll installed on the machine it's running on. If, for example, you can export to pdf, but not to Excel, your problem may be that the dll required for Excel Export is missing.

In Crystal Reports 8.5, there's a file called runtime.hlp that tells exactly what dlls are required depending on what your application uses.

(Ex. For CR 8.5 and Win2k, my Excel export dll is: C:\WINNT\Crystal\u2fxls.dll and my dll for Exporting to Application is: C:\WINNT\Crystal\u2dapp.dll)

Problem converting Crystal Report to RS2005

I've run into a problem while converting an old Crystal report into a
RS2005 version. The report in question gets a dataset from a SQL
stored procedure. The stored procedure passes details on paper
production by day, machine and grade. The report groups the data by
grade and then by machine. In the grade group footer, I perform a
calculation on the data that is as follows:
=sum(GradePeriod.value)*avg(SBK.value). This works the same as in the
crystal report. However, in the crystal report, they declare a global
variable, that basically creates a running sum of this calculation.
So in the Machine footer, it is a sum of all of the
sum(GradePeriod.value)*avg(SBK.value). Now if I try in RS to sum the
values in the footer by using
=sum(sum(GradePeriod.value)*avg(SBK.value)) I get an error that says
you cannot use an aggregate of an aggregate. So my question is, how
do I replicate what is going on in the Crystal Report in RS?In RS you need to give some thing like this in the header or footer you cant
give directly. Try this. (you should use "reportitems")
=Sum(ReportItems!Gradeperiod.Value)
Amarnath, MCTS
"dachrist" wrote:
> I've run into a problem while converting an old Crystal report into a
> RS2005 version. The report in question gets a dataset from a SQL
> stored procedure. The stored procedure passes details on paper
> production by day, machine and grade. The report groups the data by
> grade and then by machine. In the grade group footer, I perform a
> calculation on the data that is as follows:
> =sum(GradePeriod.value)*avg(SBK.value). This works the same as in the
> crystal report. However, in the crystal report, they declare a global
> variable, that basically creates a running sum of this calculation.
> So in the Machine footer, it is a sum of all of the
> sum(GradePeriod.value)*avg(SBK.value). Now if I try in RS to sum the
> values in the footer by using
> =sum(sum(GradePeriod.value)*avg(SBK.value)) I get an error that says
> you cannot use an aggregate of an aggregate. So my question is, how
> do I replicate what is going on in the Crystal Report in RS?
>|||It wants me to put the sum(ReportItems!GradePeriod.value) in the Page
Footer. I need to have these sums at each group footer, because I
cannot have one paper machine per page.
Dave
On Mar 15, 2:33 am, Amarnath <Amarn...@.discussions.microsoft.com>
wrote:
> In RS you need to give some thing like this in the header or footer you cant
> give directly. Try this. (you should use "reportitems")
> =Sum(ReportItems!Gradeperiod.Value)
> Amarnath, MCTS
>
> "dachrist" wrote:
> > I've run into a problem while converting an old Crystal report into a
> > RS2005 version. The report in question gets a dataset from a SQL
> > stored procedure. The stored procedure passes details on paper
> > production by day, machine and grade. The report groups the data by
> > grade and then by machine. In the grade group footer, I perform a
> > calculation on the data that is as follows:
> > =sum(GradePeriod.value)*avg(SBK.value). This works the same as in the
> > crystal report. However, in the crystal report, they declare a global
> > variable, that basically creates a running sum of this calculation.
> > So in the Machine footer, it is a sum of all of the
> > sum(GradePeriod.value)*avg(SBK.value). Now if I try in RS to sum the
> > values in the footer by using
> > =sum(sum(GradePeriod.value)*avg(SBK.value)) I get an error that says
> > you cannot use an aggregate of an aggregate. So my question is, how
> > do I replicate what is going on in the Crystal Report in RS... Hide quoted text -
> - Show quoted text -