Search results for query: *

Thanks for the reply, I was able to get the results I need after many attempts. I created two data items: [CurrentWeek] - _week_of_year(getdate()) [PriorWeeks] - _week_of_year(getdate())-12 The created a filter using the two and made sure [calendar week] was included in the report to show the...

I'm having a bit of an issue. i need to show the sales of an item for the last 13 weeks. We have a time dimension and a field called 'Calendar Week'. I tried to create a filter using this field and the function '_week_of_year' but can not get it to. In fact, I cant get the to display the current...

I'm having some difficulty getting a "Value Prompt" to work on my Prompt page. I've created a simple customer listing report and tested. I then added a filter on State within the Page Explorer window & when I run the report I get prompted with a dropdown box to select the State, it works...

I have followed an example from Cognos support that shows you how to sort by column. One of the steps after you create a class is to add the value "sortable" to the Selector field. my only problem, is I cant that Selector field in the properties window. Since I'm new to cognos I thought they...

thank you!

I tried searching for an answer before I posted but no luck. I'm extremely new to writing reports but I've been asked to add this into a customer report where the value is displayed whenever they look at the customer details. I'm trying to determine the MTD sales but I don't know how. I know...

I'll try that, thank you.

I've created a prompt page that allows the user to select a Company and then a Location. Since there are so many numbers for both, I used a data item to join the Value and the Description together. I've done this for both Company and Location. Its works perfect, ex the listbox for company now...