Trying to Import a Custom Report that has 2 Tables Linked

[zonger]

I have been trying for months to figure out how to import a custom report that has 2 tables linked. I have talked with Nortel experts and no one can figure it out. I am using the AgentPerformance and Supervisor tables. They are linked on SupervisorUserID. The alias are setup as iAgentPerfomanceStat then Supervisor. I have no problem importing a report tha has one table such as iAgentPerformanceStat but when I try to do a report with 2 tables it fails. Does anyone have any ideas what I might be doing wrong?

 

[fonchick]

Hi There,

According to the NTPs, you can link the AgentPerformanceStat with the following:

ActivityCodeStat using the fields Timestamp/UserID
AgentByApplicationStat using the fields Timestamp/UserID
AgentBySkillsetStat using the fields Timestamp/UserID

Are you doing a left outter join to link these?

 

[zonger]

I actually have no problem linking the two tables in Crystal. I'm getting the correct data within the report in Crystal. I'm having problems getting the report to import into Symposium.

 

[ErwinStevanus]

Hi zonger,

I guess that there are certain rules you have to follow when you're importing a crystal report file to symposium.

I experienced the same thing when I first tried to join a table. Everything looks fine in Crystal report, but I could not import the report to Symposium. It turned out to be the join type for the table (Apparently Symposium only supports left outer join). I changed the join type, and everything is okay

Also, I notice that you're trying to join AgentPerformanceStat table with Supervisor table. On the Reports & Display Guide, as highlighted by fonchick, the AgentPerformanceStat can be linked with:
- ActivityCodeStat using the fields Timestamp/UserID
- AgentByApplicationStat using the fields Timestamp/UserID
- AgentBySkillsetStat using the fields Timestamp/UserID

To isolate the problem, I suggest that you try to create a test report using any of the above tables. Once successful, then you can try to join with Supervisor table.

Good Luck

 

[da2004]

I use a simple trick to link several tables in Crystal and schedule the reports with the sccs-client.
Just do the timestamp selection in Crystal with a formula like this: ...Stat.Timestamp = Currentdate-1 ... in the "Select Expert" from Crystal.
Just import your Custom Report now as "Config only", should run now without problems.