Recent content by manlia

I tried to add a lead for the third time, and getting the error "Record is unavailable". And, when I looked at the Evenet viewer and MS CRM platform error, it said that "THE SPECIFIED Object was NOT FOUND". I have check on the security/roles, and they're okay which means. any roles I used...

Hi, Does any body know how to create a report in Microsoft CRM that can give a list of records in Account, Contact, or Opportunity that DON'T HAVE activities? Thanks Lia.

Hi, Does any body know if there is away to create a report or, maybe query or, add-on in Microsoft CRM that can give a list of records in Account, Contact, or Opportunity that DON'T HAVE activities. Thanks Lia.

Hi, I have a report that works fine with English (United States) Regional Option in the Control Panel using Windows 2000 workstation. Once I changed the Regional Option to French (Canada), it gives me a date formula error. How to resolve this issue? Currently my date format is MM/DD/YYYY...

Your assumption above is correct. Sorry for not explaining the details. I'm using CR 8.5 with Oracle OLE DB database. And, the 3 dates are 3 different fields from 3 different tables in the database. Thanks for the workaround, but I probably won't do it since it's touching the SQL query which...

The requirement is based on those 3 dates. I never done this before either. It seems an awkward report. To me it doesn't make sense either. But, any other workaround will be great. Thanks

The client need a report to show the calculation for each quarter based on the user defined time periods ("From" and "To" date parameters). The "From" and "To" date parameters are ranged among 3 different date fields. If the parameter is put from...

Thanks lyanch for the feedback. If it's only based on 1 date, your solution will be good. But, the client wants to be able to reports of those 3 dates for the quarter grouping. This is a kind of awkward report I think. The Q1 and Q2 will be based on the "FromDate" parameter field...

I'm not sure if this can be accomplished within Crystal report: The report need to show the calculation for each quarter based on the user defined time periods ("From" and "To" date parameters). The "From" and "To" date parameters are ranged among 3...

I'm sorry. Please disregards my previous reply. I think I got it. I have to use "Sum" instead of "Count" Thanks a bunch!

Hi lbass, Thanks for your feedback. However, I'm still getting a count as 1 althought the records now obviously shows "0.00". Any idea? Thanks Lia

I'm using Crystal Report 8.5. I did a summary count from a field which returns no records. However, the count returns 1 although there is no records. I can't figure it out why it's counting as 1 although there is no records returned. I'm counting a date field that is put on the detail...