Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 419
  • Last Modified:

Returning Duplicate Rows from a BO Universe

Experts,

I'm working on some financial reports using CR XI going against a BO Universe (BOE XI).  I'm having some serious issues because the query formed by Crystal is always formed using the DISTINCT command -- this is removing several "commonly occuring" GL entries from my report (all transactions of 100 dollars are represented by only one record).

Is there anyway to force the universe to return duplicate records?  I have complete control of both the Universe and and the report file.

Please let me know if there's anything I can do.

Thanks!
dK
0
dkDeveloper
Asked:
dkDeveloper
  • 2
  • 2
1 Solution
 
mlmccCommented:
I haven't used CR XI but can you edit the SQL it produces to delete the DISTINCT?

If not have you tried copying it and using a COMMAND as the data source?  

mlmcc
0
 
dkDeveloperAuthor Commented:
mlmcc,

You cannot edit the sql directly when the datasource is a Universe.  Unfortunately the source being a universe is one of my requirements (for data security reasons) so writting a command to tackle this is also not an option.

I'm thinking I'm just SOL on this one.

Thanks,
dK
0
 
mlmccCommented:
You may be.  

mlmcc
0
 
dkDeveloperAuthor Commented:
Alright,

After a lot of discussion with BO it turns out that this is (suprise) an acknowledge bug that has been resolved in CR XI R2.  You can fetch the download here - http://www.businessobjects.com/products/reporting/crystalreports/xi_r2.asp

This new version implements a couple of new menu options and apparently there is now an option to enable the returning of duplicate rows.

Please feel free to close this question with no points awarded.  I would consider leaving the post, should someone stumble across the same problem.

Thanks,
dK
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now