Separate Detail Sections 1

[ABerkowicz]

I am on CR 8.0. I have 2 details sections.

In Da: I have empid, department, formula1 (which gives office based on formula)

In Db, I have empid, department, formula2 (which gives office based on a different formula)

Some empids may have the same values in formula1 and formula2 or they might be different. What I ultimately need to do is somehow figure out how to sort formula1 and formula2 in the same sorting pattern. Right now when I sort/group, it treats them as separate sections. It groups all in formula1 first than formula2 - then these are not in order.

Does this make sense? Any ideas?

 

[idle]

I think you will need to explain how the formulas work, especially how they are different from each other, and how they can be the same, and what sort of order you want the results to be in.
Your solution will not be found in changing the ordering or grouping, as the information you are dealing with in the detail sections a and b is all coming from one record at a time. Therefore, detail section a will always be before b, and the easiest way to change the apparent order is to change the results that the formulas return.

 

[kenhamady]

If I understand what you are trying to do, you might not be able to do it. You can't sort detail A to a different part of the report than Detail B. They are the same record, so they have to stay together in the report. Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/

 

[ABerkowicz]

Yep - I thought that they are the same record and that this could not be done. I am looking at possibly doing a subreport and creating a shared variable for which I might be able to do the grouping on? I just do not know much about shared variables right now...Any insights would help.
Thanks,
Angela

 

[kenhamady]

You can't group the records from the subreport with the records of the main report. The only way to do what you want is to do a union query in the database and report off of that. There is no other way to group on a single record in two places. Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/

 

[ABerkowicz]

That was exactly what I wanted to do - group on a single record in 2 places...Thanks again for your help. (I probably will just rewrite it using SQL and some stored procs)
Angela