KristiK

You can duplicate a standard report and modify the selection criteria, date ranges, etc., but the only way to create a report in order to customize the report headings is to use a report writer (such as Crystal Reports) and then import the created report into Symposium after it has been created using the report writer.

Do you need help with duplicating a standard report, or are you wanting to create a customized report?[/img]

John_In_Dakota

We are looking into creating are own reports. We dont use all the fields on most of the reports. We also dont want to spend a lot of coin.

John

KristiK

I don't know about cost, but Crystal reports is my only experience with Symposium. Nortel uses Crystal reports as the generator for their report templates and keeps Symposium releases compatible with newer versions of Crystal. They also provide training classes specific to using Crystal reports with Symposium, so I'm sure there are definitely benefits with using the Crystal software.

Probably the biggest issue is with importing user-created reports. Reports created in other applications cannot be imported. If you want to schedule user created reports using Symposium, they need to be imported first.

cperdue

9 posts
0 friends welcomed
Crystal Report Newbie

Crystal Report - Adhoc Report Dialog Box Question [5/7/2006 14:02:16]
This is dealing with Abandon Report. I am looking at trying to use the SQL Statement that I located on the PBX website. I am try to understand how the Report Dialog box work with Adhoc reports. Does this Report Dialog come up when there are report created. Does this Report Dialog Box select the proper table that is to be used with the report. And if that is the case where would I insert the special Query that I located on the PBX website. Also, I need to know where in the program that I need to put the below SQL code. I have work with other report but I have difficult knowing how to work with Crystal Report. Are their some information that I can read that can help me setup this report.


Select Timestamp, CallID, EventData, CallEventName

from dbo.eCallByCallStatYYYYMMDD

WHERE CallID IN(Select CallID from dbo.eCallByCallStatYYYYMMDD
WHERE CallEvent = 41)

ORDER BY CallID

rwhite

We use Crystal Reports also. For a moderate $ you get a lot of flexibility 'cause whatever you create today, someone will want it slightly different tomorrow- right?