Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
HOw to Trim parameter value
There should be a common functions folder with a trim function. The syntax is : trim(<value>)- DataVixen
- Post #5
- Forum: Cognos solutions
-
"Default Selection" in search and select prompt
Do you have any filters in your report that may be causing the report to not show the values in the prompt? This happened to me before and this was the cause. I deleted the filter and the values appeared.- DataVixen
- Post #2
- Forum: Cognos solutions
-
ReportNet CrossTab problem
Have you tried filtering the count (whatever you are measuring) to > 0? Can you recreate and post a sample report with Go Sales data? It's easier to solve when we can see excatly what's going on. Good luck!- DataVixen
- Post #7
- Forum: Cognos solutions
-
ReportNet->Report Studio->Bugs->Layout Calculations
I have dealt with this by inserting a new list with the Order Year and any necessary filters applied. Then Cut Order year so you have an empty list (this won't appear when run). Apply this query to the page in the Page properties, then drag the query item to the header. Try This: <report...- DataVixen
- Post #6
- Forum: Cognos solutions
-
Month-To-Date in Reportnet
For Month to Date: [Order date] between _first_of_month(current_date) and _last_of_month(current_date) Year to Date: (Sql Server Function) year([Order date]) = year(current_date) Not completely certain about Week to Date, but this will give you the last 7 days prior to the current date...- DataVixen
- Post #3
- Forum: Cognos solutions
