Recent content by KingCrab

Easy with a dropdown and he user wont have to worry about * placement. Create a dropdown with the CONTAINS, STARTS WITH, ENDS WITH filter: (<param>='CONTAINS' AND <Field> LIKE '%<param2>%' ) OR (<param>='STARTS' AND <Field> LIKE '<param2>%') OR (<param>='ENDS' AND <Field> LIKE '%<param2>')

<report xmlns="http://developer.cognos.com/schemas/report/2.0/" expressionLocale="en-ca"><!--RS:8.1--> <modelPath>/content/package[@name='GO Sales and Retailers']/model[@name='model']</modelPath> <queries> <query name="Query1"> <source> <model/>...

If you bought the software you should be able to go to the cognos.com support section and download the pieces you have purchased. If not you need to contact support and see if they can help you. Nothing much you can do with the wrong software. FM in Cognos 8 is very different then RN1.1 FM

what exactly did you need help with? I have passed all the tests and I do not see this one as standing out from the others.

run each query's tabular data and see how long it takes to return. If they are all very quick then it is more then likely a formatting issue. To prove this take the query you have and drop them into a new list report without any formatting and run.

Data Item1: total([Sales] FOR [Salesman]) filter: rank([Data Item1]) <= 3

Always.. Never skip it. If you are going to skip it you may as well just run your query in toad or query analyzer. Creating a real report from pure sql would be a nightmare to maintain.

Your session ends when the user leaves your site. This is why when you manually do it it works, you never leave the site.

I believe there is one on the CD of one of the Kimball books.

Sorry I missed that "[PA Purchase Order Detail].[Material].[Material Identifier] like (?Material1?||'%')

Try this: <report xml:lang="en-ca" xmlns="http://developer.cognos.com/schemas/report/1/"><!--RS:1.1--> <modelConnection name="/content/package[@name='GO Sales and Retailers']/model[@name='model']"/> <querySet xml:lang="en-ca"> <BIQuery name="Report Query">...

Are you expecting to filter to seperate a comma delimited field for you? That wont happen.

Did you even try?

filter? Category IS NOT NULL

change your filter to what you have there. "[PA Purchase Order Detail].[Material].[Material Identifier] like (?Material1%?)" A LIKE filter would work best with a text box or similar. Where the user manually inputs the string.