Newbie question on CR & SC

[danstenzel]

Which forum would be the correct one to use for a Crystal Report interfacing to the Service Center?

Anyway - here is the question:

I am using: Service Center version 6.0.1
Crystal Reports: CR Developer; Product Type: Full Product Version: 9.2.2.693

I am writing a CR to extract a monthly closed report on calls that are in the problem summary (probsummarym1) with specific resolution calls and the time for specific clocks. So

When I try to link from an incident to the clock it does not work: e.g. SELECT clocksm1.name, incidentsm1.incident.id
FROM incidentsm1 incidentsm1
INNER JOIN clocksm1 clocksm1 ON incidentsm1.incident.id=clocksm1.key.char
I get NO rows returned.

The same problem occurs when I try to link the problem summary record e.g.: FROM probsummarym1 probsummarym1 INNER JOIN clocksm1 clocksm1 ON probsummarym1.number=clocksm1.key.char

Is there another way to link the problem/incident tables to the clock tables?

I also seem to be having problems with the SQL "LIKE"; is that a function of P4 and the ODBC Driver (? is that possible ?) or some other limitation of SC & CR? Quick after thought - same question for inner join.

Thanks.

[outlance]

Hi,

please check Peregrine support site and search in knowledge base for: ServiceCenter ReportCenter and Crystal Reports basics

It contains a link to a PDF document (some years old, but still very helpful).

If I remember correctly... inner join is not supported - shadowing to RDBMS (Oracle or MS SQL) could help. Check the document, you need to define erddef and joindefs before you can report over multiple tables. Using sub-reports is an alternative....

Hope's this helps for the first moment...

Greets,

Lars

[danstenzel]

Thank you Lars,

Found Document ID: 76425; Knowlix ID: S61-H1R-CHAV

Also used SC_RC_tutor.pdf from Document ID: 78613; Knowlix ID: S4K-41F-CY09 - this was much more useful. *NOTE* The screen shots did not match what was in Service Center version I was using ... but by following the directions I was able to accomplish creating the link.

Although I did not see the join that I created in Crystal Reports - all of sudden - like magic - the inner join now works.

[outlance]

fine

I meant this document, there's a link in the document I meant...

Lars

[gumarrita]

Hi guys:

Can someone attach the files mentiones above? I've found the link at HP SelfSolve Support but the link is broken.

http://support.peregrine.com/Product...C_RC_tutor.pdf

I googled but no results found.

Thanks in advance.