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!

Reporting & Notification Forums - Reporting
Forum to discuss reports for SalesLogix including Crystal, SQL Reports, etc. View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to Reporting | New Thread

View: Search:

Author

Thread: Button on Contact Detail to run a history report

Khevna Mehta
Posts: 34

Button on Contact Detail to run a history report Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 14 Mar 08 4:06 PM

I need an easy way to open a crystal report from the contact detail view. This report should show all history for the logged user for this particular contact.

[Reply][Quote]

Mike Spragg
Posts: 1226

Re: Button on Contact Detail to run a history report Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 15 Mar 08 6:22 AM

Application.basicfunctions.crystalreportpreview ("family","rptname)- it's up to you to create the report !

[Reply][Quote]

Khevna Mehta
Posts: 34

Re: Button on Contact Detail to run a history report Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 19 Mar 08 8:22 PM

Mike, i did create the report. The report seems to work fine when I hard code to contactid, but when I try to use Application.BasicFunctions.ReportAddCondition to pass the id , it does not seem to work.

Does Application.BasicFunctions.ReportAddCondition in v7.0.1.

Thanks
Khevna

[Reply][Quote]

Snow Monkey
Posts: 214

Re: Button on Contact Detail to run a history report Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 20 Mar 08 2:10 PM

I do not know about this addcondition from the app object level. Try this and this has to work.(both of this i guess is doing the same thing)
With objReport
.DiscardSavedData

objReport.RecordSelectionFormula = " {CONTACT.CONTACTID} = '" & lueContact.Lookupid & "'" & _
" AND {INF_ACCT_CONTACT_ASSOC.ACCOUNT_ASSOCIATION} = 'Employer' "
End With

[Reply][Quote]

Robert Levine
Posts: 132

Re: Button on Contact Detail to run a history report Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 12 May 08 5:55 PM

Does this method replace our old Application.BasicFunctions.ReportAddCondition commands?

[Reply][Quote]

Page 1 of 1

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!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 11/25/2024 12:43:05 PM