|
|
 | | From: | Bruce W. Mercer | | Subject: | Re: CRViewer/SelectExpert | | Date: | Fri, 3 Dec 2004 18:45:23 -0800 |
|
|
 | FYI,
I just got done with Crystal on this, and they say that it is
a bug, but have no intention on fixing it.
--
Bruce W. Mercer
What would you like your computer to do?
Mercer Enterprises
Custom Software, Reporting, and Network admin.
"Bruce W. Mercer" wrote in message
news:x45Ol6%23zEHA.1504@news-server...
> Hi all,
>
> Boy, I just got bit hard. I designed and sold an application
> for reporting to a client using Crystal's RDC/CRViewer, and
> then allowing them to use the selection expert to view needed
> records only. Well it worked great on the first report, that was
> all character fields. Then the client wanted more reports added
> to the module and I quoted him based on how the first report
> went. Well guess what, the selection expert is not working for
> date or numeric fields.
> Has anyone hit this yet? and if so, would you mind sharing
> a solution. I searched Crystal's site with no luck yet.
>
> TIA
>
> --
> Bruce W. Mercer
> What would you like your computer to do?
> Mercer Enterprises
> Custom Software, Reporting, and Network admin.
>
>
|
|
| | From: | *Lysander* | | Subject: | Re: CRViewer/SelectExpert | | Date: | Mon, 06 Dec 2004 08:23:28 +0100 |
|
|
| Bruce W. Mercer schrieb:
> FYI,
>
> I just got done with Crystal on this, and they say that it is
> a bug, but have no intention on fixing it.
Until now I did not stumble over this, thanks for the info.
Did you consider capturing the event yourself?
The viewer has events, which you can use in your app.
For example I make a good use of 'printbuttonclicked'.
There is an event 'SelectionFormulaButtonClicked'; maybe you will be
able to manipulate the selection formula from your dBase-app.
ciao,
André
|
|
| | From: | Bruce W. Mercer | | Subject: | Re: CRViewer/SelectExpert | | Date: | Tue, 7 Dec 2004 07:49:55 -0800 |
|
|
| *Lysander*
Thanks for the response, Yes I have been trying to think how
I could work around this with dBASE (PLUS 2.01). In my
searching I found a ActiveX for the search and Select Expert.
But have not been able to get dBASE to see it. I also did not
know that you could capture events in the CRviewer. Would
you mind showing me a little snip of code? I also have been thinking
about writing a select Expert in dBASE. I already have something
built, but is not as flexible as CRW's select expert.
TIA
--
Bruce W. Mercer
What would you like your computer to do?
Mercer Enterprises
Custom Software, Reporting, and Network admin.
"*Lysander*" wrote in message
news:p%237ILV22EHA.736@news-server...
> Bruce W. Mercer schrieb:
> > FYI,
> >
> > I just got done with Crystal on this, and they say that it is
> > a bug, but have no intention on fixing it.
>
> Until now I did not stumble over this, thanks for the info.
>
> Did you consider capturing the event yourself?
> The viewer has events, which you can use in your app.
> For example I make a good use of 'printbuttonclicked'.
> There is an event 'SelectionFormulaButtonClicked'; maybe you will be
> able to manipulate the selection formula from your dBase-app.
>
> ciao,
> André
>
|
|
| | From: | *Lysander* | | Subject: | Re: CRViewer/SelectExpert | | Date: | Wed, 08 Dec 2004 08:26:56 +0100 |
|
|
| Bruce W. Mercer schrieb:
(snip)
look if you can use this, I just now copied it out of an actual form,
where the event is captured successfully. This example is for CR 10; if
you have another version you must change the class-ID of the
Active-X-Object on your form.
There also is an example included, how to pass selection formula to the
report-active-X.
Please watch line-wrap
This is not a turnkey, as you see, so excuse me please if in some points
it is not 100% clear for you. Hope it will help you. Feel free to ask back.
ciao,
André
~~~
Function Print205501
Form.Left = 4
Form.Top = 4
Form.Height = 785
Form.Width = 1015
Form.RA101.Visible = .F.
Form.AX101 = new ACTIVEX(Form) // Viewer
with (Form.AX101)
height = 5
left = 0
top = 0
width = 5
classID = "{A1B8A30B-8AAA-4A3E-8869-1DA509E8A011}"
Visible = .F.
endwith
Form.crxApp = new OLEAutoClient("CrystalRuntime.Application.10")
Form.crxRep = Form.CrxApp.OpenReport("&Home_CR9\P2055000.rpt")
Form.crxRep.RecordSelectionFormula = '{D2010000.P2010_001Z} = "'+MNum+'"'
Form.AX101.NativeObject.PrintButtonClicked = {;Form.RepPBC(false);}
Form.AX101.NativeObject.ReportSource = Form.crxRep
Form.AX101.NativeObject.EnableExportButton = .F.
Form.AX101.NativeObject.EnableGroupTree = .F.
Form.AX101.NativeObject.EnableDrillDown = .F.
Form.AX101.NativeObject.EnableAnimationCtrl = .F.
Form.AX101.NativeObject.DisplayGroupTree = .F.
Form.AX101.NativeObject.EnableSelectExpertButton = .F.
Form.AX101.NativeObject.ViewReport()
Form.AX101.Visible = .T.
Return
Function RepPBC
Form.crxRep.PrinterSetup(Form.hWnd)
biz.F2017.BookOrders()
Return false
|
|
|
