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

Dynamic list headers

Started by beerguy82, 24 Sep 2009 10:13:55 AM

Previous topic - Next topic

beerguy82

I'm working on a order and inventory project here and have the report working as spec'd out, except for one small thing.  I'm trying to get the list column header to display the 'Week Beginning' date for each column, but have yet to find a way to do it.  The report looks like the below:

SKU  SKUDESC  InventoryDate  UnitsOrderThisWeek  UnitsOrderedNextWeek  UnitsOrdered2WeeksOut Etc...

I'm running this off of a relational source with a relative time table built in.  The relative time table is built something like this:

Date  WeekBeginning  RelativeYear  RelativeWeek  RelativeMonth  RelativeDay

I'm using RelativeWeek out of the time table to sum up my order units for each column, but I can't figure out how to get the WeekBeginning into the list column header, everything I try alters the data of that column. 

Any ideas?

Tim

rockytopmark

Assuming you have Crosstab...

1). Add the WeekBeginning item to your query
2). unlock the report
3). Click to select the text item inside the column edge cell (RelativeWeek) that you want to change
4). Change the Data Item Label property to use the WeekBegining item
5). Lock the report
6). select the column edge cell and click properties and select the WeekBeginning data item.

I am not sure I understand why you aren't able to just use WeekBeginning instead of the RelativeWeek for your columns ... can you elaborate?

beerguy82

This is actually a list report, not a crosstab, my apologies for not being clear about that.  In my original post, the SKU, SKUDESC, etc are the column headers, and the UnitOrdersThisWeek, NextWeek, etc are defined calc'd as:

if(relativeweek = 0) then (UnitOrders) else (0)

...and I change the = 0 to = 1 for next week, = 2 for two weeks out and so forth. 

Does this make sense?  Thanks for the quick reply, btw.

rockytopmark

Change the Source Type property to Data Item Value for the List Column Title.

If there is more than 1 value, your column heading may be either the first or the last value returned by the query, but it will be one value.

I am not sure if this solves your issue or not, but that is how you can get the VALUE of an item in the Header