Formatting a History Field to one line

[cathey04]

I am using CR10 and Oracle 9, HPUX os. The database is HP OpenView Service Desk, and I am pulling data from the service call and service call history fields view, and in the history view, each record has every single entry in the history. What is happening is when the data is returned there are several lines that repeat. I fixed that by formatting it to suppress duplicate fields, but now it shows up with one entry for the main part (service call), and then another line with the Accepted Date (formula), another line with the Accepted Date (formula), and Misrouted (formula), and Resolved (formula) So it looks like this when exported to Excel data (trimmed down)

ID Created Routed Accepted Misrouted Complete Close code
1 9/7 software
9/7
9/7
9/8
9/9

Then when it exports as different lines 1/1/00 comes up above the separate entries of Routed, Accepted, etc. Gosh I hope this make sense, if not, please let me know. I would attached the query and export but not sure if I can here.

 

[dgillz]

Insert a group by ID number, then insert summaries of the various date fields, to get them in the group footer. Drag the "software" field (not sure of the field name) into the group footer as well. Then hide the details section.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[cathey04]

Thanks dgillz - the columns didn't line up very well, the software field is the close code name. I am not sure what you mean about inserting a summary for the various dates, could you give me an example?

 

[lbass]

If there is one date per column per ID, then after you insert a group on ID, you can right click on each date field and insert a summary (maximum) on it at the ID group level. Then drag the ID groupname into the group footer and suppress the details and group header sections. Drag the close code field into the group footer, too.

-LB

 

[cathey04]

That worked great! Thanks. Now my issue is when I export to an Excel (data only) file, when I bring it up into Excel all of the blank fields default to 01/01/01, how do I suppress this so the field is blank (it doesn't show up like this on the preview screen)?

 

[dgillz]

Did you suppress the details section?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[cathey04]

You two are my new heros, thank you so much for your help! Both suggestions worked beautifully!!!!