Referencing A Non-Linked Field

[progenysend]

I don't know how accurate that title is, but...

I'm working with Aspect ACD data. In the database, there are names associated with extensions for call originators, but I want to reference that to see who the call went to. I don't think I can use a sub report because this already is a sub report.

The data looks something like this:

FirstName LastName AgentExt DialedDigits
John Smith 1234 9999
Bob Jones 9999 1234

So, I want John's like to say he called Bob, and Bob's to say he called John. Any idea how I can do this? Just putting the field in there just gives me the same guy.

Thanks

 

[Turkbear]

Hi,
Is there a field(s) in the main report that you can link to this sub that connects DialedDigits to AgentExt ?





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[Turkbear]

Hi,
OR, link the table in the subreport to itself ( using an alias) and link DialedDigits in left one to AgentExt in the right one - use the names from the rightmost table for the 'called' part.( In case there are entries that made no calls to an extension, use a left-outer join to insure all the Left table's records are returned).








To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[progenysend]

I don't know if I can do that because I'm only dealing with one table in the sub report.

There is one table in the main report, but it's only used to give constants for the parameter values.... It tells the SubReport that Days are 24 hours, how to format dates, how to calculate start and end dates, etc...

The sub report is only one table and other tables cannot be linked. This is a report built by Aspect for their ACD, I'm just manipulating it.

 

[Turkbear]

If you cannot add that same table to the sub again using the Database expert ( a common CR technique, it will give it an alias name) then you may be out of luck in doing what you want..maybe ask Aspect tech support.





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[Madawc]

One thing you could do is pass a value back to the main report as a Shared Variable and then in the next section pass it down to another subreport. Inefficient but it should work.

Madawc Williams (East Anglia, UK). Using Crystal 10 & 11.5 with Windows XP