11/26/2024 12:24:17 AM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
Forum to discuss writing script in Architect plugins for SalesLogix & general SalesLogix customization topics (for Windows client only). View the code of conduct for posting guidelines.
|
|
|
|
Placing condition on Crystal Report
Posted: 30 May 06 6:45 PM
|
fiogf49gjkf0d Does anyone know whether the "ReportAddCondition" function supports custom tables or not?
It seems I can filter the SLX tables but not the custom tables.
I get "Nor owset was returned for this table, query..." error.
Script 1: for opening the report
Application.GlobalInfo.Item("g_InvoiceID") = txtuInvoiceID.Text
application.BasicFunctions.PrintDetail "Coop:Co Op Invoice By Vendor"
Script 2: for "When Open" event of the report
application.BasicFunctions.ReportClearConditions
application.BasicFunctions.ReportAddCondition "S_C_INVOICE:S_C_INVOICEID", "=", "'" & _
Application.GlobalInfo.Item("g_InvoiceID") & "'", "String", ""
I'm running SLX 6.2.0
Please help. Thank you.
|
|
|
|
Re: Placing condition on Crystal Report
Posted: 31 May 06 8:34 AM
|
buy abortion pill online usa abortion pill mifepristone buy online fiogf49gjkf0d Paul,
If your custom table is not the main table for the report, then you will need to add a join between the main table for the report and your custom table. For instance, if the main table is ACCOUNT:
application.BasicFunctions.ReportAddCondition "ACCOUNT:ACCOUNTID=ACCOUNTID:S_C_INVOICE!S_C_INVOICEID", "=", "'" & _
Application.GlobalInfo.Item("g_InvoiceID") & "'", "String", ""
|
|
|
|
Re: Placing condition on Crystal Report
Posted: 31 May 06 10:24 AM
|
fiogf49gjkf0d Thanks, Peter...
However, S_C_Invoice is the main table.
I tried using the above code (and variations of it) but it didn't work...
I even created global joins but that didn't help neither. |
|
|
|
Re: Placing condition on Crystal Report
Posted: 31 May 06 10:31 AM
|
fiogf49gjkf0d Paul,
If S_C_Invoice is the main table then you won't need the join. You also should not add the single quotes to your string variable. That gets resolved when you specify the datatype "string".
Peter |
|
|
|
Re: Placing condition on Crystal Report
Posted: 31 May 06 10:51 AM
|
difference between naltrexone and naloxone naloxone and naltrexone read fiogf49gjkf0d That was a quick response ^^
I found out why it wasn't working...
I was using "PrintDetail" to bring up the report when I should've been using "DoInvoke" to bring up the report...
Thank you very much for your help. |
|
|
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|
|
|
|