Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Setting Criteria to reports
Message
From
19/02/2010 07:17:23
 
 
To
19/02/2010 06:37:04
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
01449749
Message ID:
01449885
Views:
34
oh thanks but i already learned to chain reports :P. I wanted to set criteria which i can do! but i dont kno how to put in it my listener code. but im going to do somethin else thanks


>Hi Ken
>
>You might wana have look at www.report-sculptor.com
>
>With RS you can chain multiple frx reports very easy. Here is sample of how this is done in RS
>
>
>local oRS
>oRS = GetRsObject()
>oRS.lAutoFirstPage=.f.
>
>local cFrx1,cFrx2
>with oRS
>
>    .OpenSession()
>
>
>     cFrx1 =   HOME() + 'SAMPLES\SOLUTION\REPORTS\' +  'ledger.FRX'
>     cFrx2 =   HOME() + 'SAMPLES\SOLUTION\REPORTS\' +  'Colors.FRX'
>     cFrx3 =   home()+ 'tools\Filespec\'  +  '60frx1.FRX'
> 
>     .LoadFrx(rsFrx(cFrx1                    ))  &&Import result of frx for given scope
>     .LoadFrx(rsFrx(cFrx2                    ))  &&Import result of frx for given scope
>     .LoadFrx(rsFrx(cFrx3                    ))  &&Import result of frx for given scope
>  
> 
>    .CloseSession()
>
>  
>endwith
>oRs.Output( 1 , .t. )  &&Foxpro9 native preview
>
>
>Command cluses (for/while only) are passed directly to inner rsFrx() function
>
>...rsFrx(cFrx3,cForClause,cWhileClause) )
>
>
>Now, If chaining of reports is done in order to provide
>some more complex multipart layout, then with RS you can make actually ONE report which is comprised
>of two (or more) subreports (sections) with much greater control over report execution/rendering.
>
>RS is completely free.
>
>HTH
>Sergio
>
>
>
>
>
>>>>>>Hello! i have the following to preview my reports (it does something weird but thats another story)
>>>>>>
>>>>>>
>>>>>>    loListener = newobject('_ReportListener', ;
>>>>>>   home() + 'ffc\_ReportListener.vcx')
>>>>>>   loListener.ListenerType = 1
>>>>>>   KEYBOARD "{ctrl+f10}" 
>>>>>>   loListener.AddReport(('client_app1'),'nopageeject')
>>>>>>   loListener.AddReport('student_app')
>>>>>>  * loListener.AddReport('studenst_app_old')
>>>>>>  *loListener.AddReport('report2')
>>>>>>   loListener.RunReports()
>>>>>>
>>>>>>
>>>>>>
>>>>>>before i use to do normal report so adding the following criteria
>>>>>>
>>>>>>	report form student_app for client.clientid = ApprClientId 
>>>>>>
>>>>>>was easy.
>>>>>>Looking at the code...im not too sure i can say the same thing in my new code. Or can i?
>>>>>>or should i just do a query and select the record i want
>>>>>
>>>>>I think you need to set it using CommandClauses property. Do a research in this direction. But actually Help doesn't provide any example of how to do this.
>>>>
>>>>
>>>>err...i looked at it...but the commands dont seem like what i wana do :(
>>>
>>>I spent some time as well in the Help trying to find something useful, but didn't. I didn't try to google on this problem.
>>
>>oh...well..it cant be done?i saw something.. but its..
>>http://spacefold.com/articles/tmm/CommandClauses.aspx
Previous
Reply
Map
View

Click here to load this message in the networking platform