If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Cross tab not returning data for 1 user

Started by bpothier, 31 Mar 2016 09:39:12 AM

Previous topic - Next topic

bpothier

I have a cross tab that users parameters for the user to select their name from a drop down and the dates they want the report to run for. It works fine for every manager except one manager for one month. He is fine Jan and Feb but no data returns for March. If I run the tabular view from the query I see the data and it appears to be in the same format as everyone elses data. I can also get the data to return in a list. Another odd thing is if I put a list under the crosstab with the same fields and run it for that manager for March data returns in BOTH the crosstab and the list. But if just the crosstab is on the report it returns nothing.

Has anyone seen this before. I have attached some screen shots of the query and crosstab

Losing my mind

Bret