Hello,
I'm trying to design a report for a client that includes a sub-report of all notes for a Job. I cannot figure out what table to use in Crystal. I cannot IMAGINE that the table is not available.

????????

Help!

Many thanks,
carol

Sorry, but the table is not available.

Are you serious??? May I ask when it might be available?

I'm sorry but that is just ridiculous. Given that clients pay $250 per year for upgrades -- where are the upgrades? Just what are they getting with the annual upgrades plan? Because there sure are not annual - or even semi annual upgrades for the Crystal module. Additionally, CR for Adagio is using a very old version version of Crystal Reports. I would think that Softrak would at least provide access to ALL tables and fields -- and provide a Crystal for Adagio update when new tables are added to the core modules.

Are ANY of the fields on the notes and alerts tab available? Even if I could include the single Notes field on the top of the Job Information / Notes & Alerts tab, that would be something.

I apologize for the tone of frustration in this post but I'm going to have to go back to my client with the news that this cannot be done and she is going to be VERY unhappy. I'm doing these reports for one of my colleagues' clients and this client is already unhappy with Adagio overall. If you see a mushroom cloud in Baltimore, you'll know what happened.

Any help you could lend would be most appreciated - like an update to the Crystal tables next week would be nice...

Thanks,
Carol

How about modifying the Job Notes Report to include the information they want from the Job?

Andrew - that's a good idea except there are a couple different versions of reports that they need that includes the notes.

Can one of you tell me the file name of the Job Notes report? I'm thinking that is going to be my only option to keep this client from coming completely unglued....

The tables are also available to GridView. What are you trying to show?

In the StandardRP directory, see AJC7200.RPT and AJC7200H.RPT. The 'H' version of the report is for Archived Jobs and the other report is for Open jobs.

Ok, thanks. Hopefully this will do the job....

But in the meantime, PLEASE provide an update for CR for Adagio so that ALL tables are available!!!!!!

Andrew,
Report 1 - (Sort by Customer)
Customer Name
Job #
Original Price
Start Date
Contract #
Notes

Report 2 - (Sort by Job)
Job #
Customer Name
Original Price
Start Date
Billings to Date
Notes

So, I'm adding all of the additional fields to the Notes Report and we'll see if it's acceptable. For whatever reason, we are in "damage control" so I really hoped I could do just what she needed.

Sigh...