Have installed Cognos Express 9.5 trial and hooked some data in from my company.
When I create a crosstab query in report designer the row and column headings show when I publish it but there's no data showing at all. There's definitely data in the field of the table I'm pulling from (and it's formatted as number). If I pull in eg Location and Lbs in a basic query it shows the Lbs fine, if I pull Lbs into crosstab there's nothing showing. Help?
How on earth do I create a summarising of two columns of data, eg if I have 3 fields in a table:
Company - Location - Weight
Company1 - Location1 - 50Lbs
Company1 - Location2 - 30Lbs
Company2 - Location1 - 60Lbs
Company2 - Location2 - 10Lbs
If I pull just Company and Weight into the query analyser it shows:
Company1 - 50Lbs
Company1 - 30Lbs
Company2 - 60Lbs
Company2 - 10Lbs
How do I get it to summarize as:
Company1 - 80Lbs
Company2 - 70Lbs
I can't seem to see any way to group and sum like this?
Many thanks to anybody who can assist.
Pinned topic Some basic problems - please help
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-03-11T12:37:24Z at 2012-03-11T12:37:24Z by SystemAdmin
SystemAdmin 110000D4XK214 Posts
Re: Some basic problems - please help2012-03-11T12:37:24ZThis is the accepted answer. This is the accepted answer.I think I might see why both these issues are occuring - it's not recognizing fields as numbers.
When I pull a table directly from my SQL server it shows the field with a measure tape icon - assume this means it recognizes it as a number and is measurable?
When I import data from my SQL server into a local table in MS Access then link the MS Access table into Cognos Express, it shows the field with a white/blue stripe - assume this means it doesn't see the data type as a number?
the MS Access local table is definitely Number data type.
Why would it see this field as a number directly from SQL, but not see it as a number directly from a MS Access table?