Improve company productivity with a Business Account.Sign Up

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

Crystal Report List Object as Cognos

Hi Guys,

Anyone know how about creating a List Report like the List Object in Cognos?

Like for example, I wish to have different years of Profit and Loss in three columns for analysis purposes.
0
adriankohws
Asked:
adriankohws
  • 3
  • 2
2 Solutions
 
mlmccCommented:
Have you considered a crosstab report?

mlmcc
0
 
SNeupaneCommented:
You can create data item with if or case statements.
for example,
if ([year] = 2012) then ([Profit]) else (null)
do the same for each year 2011, 2010 etc...
You may have to use cast to match datatype and filter for null afterwards.
0
 
adriankohwsAuthor Commented:
Hi mlmcc, crosstab is rigid in designing, many requests cannot be fulfill, that's why I am looking into list objects. Even when using Cognos, I seldom use Cross-tab unless it's quite a simple relationship. List object is always the best to tailor to special needs. Especially when it comes to formatting the report, Cross-tab is a pain.

Hi SNeupane,
What you suggested will be a pain to match them. What if I wish to write a 12 months rolling forecast + budgets with full year budget comparison for a Profit and Loss lol....

I was just looking for a yes or no answer. That means Crystal do not have something like List Object that I can do the same like Cognos.

Let's see if anyone else throw in their opinions, otherwise, I will segregate the points among you two.

Cheers.
0
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
mlmccCommented:
No, Crystal doesn't have an object like that.

WHat does the data look like and what do you want s the report?

mlmcc
0
 
adriankohwsAuthor Commented:
Oh mlmcc, thank you for your warm offer to help. No lol. Because most of the masses marktet use Crystal report than to Cognos. As a matter of fact, it's simply uncomparable in prices, so I was thinking if Crystal can achieve like the list object would be a great thing to have. Cheers.
0
 
adriankohwsAuthor Commented:
Thanks guys.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

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