Page 1 of 1

Crystal Reports 8.5 Drill Down NOT Working..??

Posted: Thu Aug 15, 2019 7:22 am
by RiazKhan
Crystal Reports 8.5

Currently I am using crystal reports version 8.5, and calling startreport function to activate the preview. Using tcrw32.prg functions. My usual practice is to create a temporary dbf file and append the required data into the temp file and call that temp file into the crystal rpt file.

In the installed version of crystal report 8.5 the report drilldown is enabled and working. Once compiled and running or calling the report through FiveWin the report drilldown does not work or is disabled....

I tried the same with CR X still no luck.

If there some new functions to compile for the new crystal reports version. If so any help for guidance is appreciated...

I did not find any help on the forum..so need guidance..

Thnx / regards

Re: Crystal Reports 8.5 Drill Down NOT Working..??

Posted: Sun Aug 18, 2019 10:32 am
by dutch
Dear RiazKhan,

Could you try this data of the CR Object.

Code: Select all

oCRViewer:EnableDrillDown               :=  1
I hope it can help.
Dutch

Re: Crystal Reports 8.5 Drill Down NOT Working..??

Posted: Sun Aug 18, 2019 3:28 pm
by RiazKhan
Hi Dutch,

Thankyou for your response, but sadly this did not work. I tried a few alternative methods but still dirilldown is disabled.

Is it a limitation in CR 8.5..???

If so, I can upgrade to higher version but need guidance....

Any suggestions..

Riaz

Re: Crystal Reports 8.5 Drill Down NOT Working..??

Posted: Mon Aug 19, 2019 6:52 am
by dutch
I use CR XI Release 2. It works fine.

Re: Crystal Reports 8.5 Drill Down NOT Working..??

Posted: Mon Aug 19, 2019 8:36 am
by RiazKhan
Great Dutch, that is nice you are up to date...

Can you guide me through of the tools that I require, I can upgrade to CR X1 R2.
It will help me a lot in completing some BI reports for clients.

my email is listed below...

Thanks/Regards

Re: Crystal Reports 8.5 Drill Down NOT Working..??

Posted: Mon Aug 19, 2019 10:31 am
by dutch
Dear RiazKhan,

You can find solution here and search "Crystal Report" in this forum. It has a lot information. I use CRXI with MySql.

https://forums.fivetechsupport.com/view ... hilit=CRXI

Re: Crystal Reports 8.5 Drill Down NOT Working..??

Posted: Mon Aug 19, 2019 3:36 pm
by RiazKhan
Okay Dutch,

Thnx....I will look it up....

Re: Crystal Reports 8.5 Drill Down NOT Working..?? (RESOLVED)

Posted: Wed Aug 21, 2019 10:19 am
by RiazKhan
Dear Dutch,

All is well now .
Its working in CR 8,5 and also in CR 10 . I will install CR X1 R2 on my test laptop, and try the same on that.

Thanks once again.

I have attached an image to show you if the preview looks good and is same as yours.

The right click pop up menu, upon selecting or clicking 'FREEZE PANE' ..the system application closes with no error.

Have I missed anything..??

Regards

Image

Re: Crystal Reports 8.5 Drill Down NOT Working..?? (RESOLVED)

Posted: Wed Aug 21, 2019 12:35 pm
by anserkk
While distributing your FiveWin application, do you need to have Crystal reports viewer to be installed on each and every PC ? OR Can we manage this within our Fivewin application for eg including one or 2 DLL's from Crystal Reports along with our Fivewin application in the exe path ?

Many years back, I was told that every client PC requires Crystal Report viewer to be installed. If it is still the same then it is a cumbersome task. Do not know whether things have changed with the latest versions of Crystal Reports. Asking this just for academic interest

Re: Crystal Reports 8.5 Drill Down NOT Working..?? (RESOLVED)

Posted: Wed Aug 21, 2019 1:32 pm
by RiazKhan
Anser,

No...I just copy a few DLL's at the clients PC in Windows System folder. And we are good to go...These DLL's are in the search path.

I usually use Windows Terminal Server and only one time installation is required. In this case no DLL's are required at client end.

Regards

Re: Crystal Reports 8.5 Drill Down NOT Working..?? (RESOLVED)

Posted: Sat Aug 24, 2019 6:43 am
by anserkk
Thank you for clarifying my doubts. :)
RiazKhan wrote:Anser,
No...I just copy a few DLL's at the clients PC in Windows System folder. And we are good to go...These DLL's are in the search path.
If you don't mind can you please share the list of DLL files that are required to be copied on to the Windows System folder?

It would have been nice, if the DLL's are kept along with the FiveWin application exe path. Maybe, we will have to include the Fivewin application path also in the search path so that we don't have to touch Windows system folder

Re: Crystal Reports 8.5 Drill Down NOT Working..?? (SOLVED)

Posted: Tue Aug 27, 2019 8:35 am
by RiazKhan
Anser,

List of files copied into system32 folder. Belonging and required in search path of crystal reports.

crpe32.dll
crxf_pdf.dll
crxf_rtf.dll
Crxlat32.dll
p2bbtrv.dll
p2bxbse.dll
p2ctbtrv.dll
p2ixbse.dll
P2ldb2.dll
P2LIFMX.dll
p2lodbc.dll
p2lora7.dll
P2lsql.dll
P2lsyb10.dll
p2molap.dll
p2sdb2.dll
p2sfs.dll
p2sifmx.dll
p2smcube.dll
p2solap.dll
p2soledb.dll
p2sora7.dll
p2ssql.dll
p2ssyb10.dll
u252000.dll
u25dts.dll
u2dapp.dll
u2ddisk.dll
u2dmapi.dll
u2dnotes.dll
u2dpost.dll
u2dvim.dll
u2fcr.dll
u2fdif.dll
u2fhtml.dll
u2fodbc.dll
u2frdef.dll
u2frec.dll
u2fsepv.dll
u2ftext.dll
u2fwks.dll
u2fwordw.dll
u2fxls.dll
u2fxml.dll
u2l2000.dll
u2lcom.dll
u2ldts.dll
u2lexch.dll
u2lfinra.dll
u2lsamp1.dll

Regards

Re: Crystal Reports 8.5 Drill Down NOT Working..??

Posted: Tue Aug 27, 2019 8:53 am
by RiazKhan
Can anyone suggest....
Why my export button is disabled on Drilled Down Report and is enabled on the main report page.
I have

oCRViewer:SetProp( "EnableExportButton" , 1 )

Any help....

Thnx

Image

Re: Crystal Reports 8.5 Drill Down NOT Working..?? (SOLVED)

Posted: Thu Aug 29, 2019 3:57 am
by anserkk
RiazKhan wrote:Anser,

List of files copied into system32 folder. Belonging and required in search path of crystal reports.

crpe32.dll
crxf_pdf.dll
crxf_rtf.dll
Crxlat32.dll
p2bbtrv.dll
p2bxbse.dll
p2ctbtrv.dll
p2ixbse.dll
P2ldb2.dll
P2LIFMX.dll
p2lodbc.dll
p2lora7.dll
P2lsql.dll
P2lsyb10.dll
p2molap.dll
p2sdb2.dll
p2sfs.dll
p2sifmx.dll
p2smcube.dll
p2solap.dll
p2soledb.dll
p2sora7.dll
p2ssql.dll
p2ssyb10.dll
u252000.dll
u25dts.dll
u2dapp.dll
u2ddisk.dll
u2dmapi.dll
u2dnotes.dll
u2dpost.dll
u2dvim.dll
u2fcr.dll
u2fdif.dll
u2fhtml.dll
u2fodbc.dll
u2frdef.dll
u2frec.dll
u2fsepv.dll
u2ftext.dll
u2fwks.dll
u2fwordw.dll
u2fxls.dll
u2fxml.dll
u2l2000.dll
u2lcom.dll
u2ldts.dll
u2lexch.dll
u2lfinra.dll
u2lsamp1.dll

Regards
Thank you :)