Hello,

I finally cracked it down.

I am 95% positive that the method I have used can be the right method (hope this method does not land me in another issue :) )

There were few reports that were already created by my seniors and I was finally able to grab one report whose layout partially matched to the layout I desperately needed. So I scanned the report meticulously and found a solution.

I was able to get a report like this after checking Suppress all duplicates for User_id, name, and email address.

I was unable to do the same for Status and Role.

So I was struck at this layout.

What did I do?

1)I checked suppress all duplicates for status and job title fields also.

2)Then,  I opened the Group Expert and grouped by User_id.

3) Later I opened record Sort expert and sorted it by Group#1 user_id and then Description. It finally worked.

Finally my layout looks like this.

I verified manually against the data and it is displaying records with the right logic.

I tried using your formula but for some reason it was repeatingly displaying the same error. I was unable to figure out a way that could crack this error out.

“The field name is not known.”

So here I am unable to realize in what way can I thank you.

Issue 2:

Can you tell me if we need to lock the size and position of the report (.rpt) file before you upload into source control server/tool. (like PVCS or VSS).

Can you quickly navigate to all the next steps involved.

Like if you ask me to elaborate about oracle reports then I would say.

We initially design a .rdf file in windows development environment then we compile it to .rep file in Unix box which is our production server.

Before you explain just a quick note, we have java as user interface, so using JRC they will trigger the reports and make them viewable in a CRviewer which is also a part of Java API for Crystal reports.

Also for some reason though I paste the screen shots of my reports in PASTE FROM WORD ,it doesn't display anyone of them.

thanks

Namita