Recent content by JPCogAdmin

Hi, Has anybody done Venn diagrams in Report Studio 8 ? If so, did you use MapInfo to get his done? Is this kind of chart doable without MapInfo? Thanks

All, Just figured out my error. -Jim

HI, I have a measure in MS-Access (This is to troubleshoot stuff only) and the measure is a number column. However, when I try to generate the report in Report Studio its not aggregating the column? Thanks for any help.

Thank you Ties. Those are really good suggestions. Jim

Ties, Thank you very much for the example. That really helps. Also, do you know if this report format is normal?

Hi, How would you create a cross tab report that would have the weekly period on top? For instance | | 7/7/07 - 7/14/07| 7/15/07 - 7/22/07| | | Trip A 5 | 8 | Trip...

Hi, How do you use the _age() function in Cognos 8 to show age in years only? IE. 60 or 53.... I'm trying to use it but it give me YYYYMMDD so, I'd like to strip out MMDD and just return the YYYY. Thanks for any help.

rm1234 (MIS), You can do that by first creating a filter. In that filter write the query for how you want to format your database date! The date is coming from the database correct? Format depends on the specific db vendor. However, you should know the format for your database type. Next...

cog8user, Yes, try doing what almeids has suggested. Cog8user, do you know how to create cascading prompts? Ok, having built the prompt appropriately then go look at the query and its filter? Find out what is being sent as a query to the Cognos server. Write that in the next post and lets...

cog8user, Give us a sample of the values. It should work but perhaps you have something in your query filter that may not be working. Ok, so after they select the prompts and execute the query what kind of data are you expecting and what do you get as a result now? -Jim

Thank you MF. That's really good. Thank you once again. -Jim

What are the major differences between these 3 types of SQL in Framework Manager. I'm sure they put them in because they serve a different purpose? Cognos SQL. Native SQL Passthrough SQL Also, can any of these accept a prompt parameter to be passed in? Thanks -Jim

Thank you for the compliment MF. That's my philosophy, help and you will be helped. I try to improve all the time and if my knowledge helps others then I'm satisfied. Thank you MF. I've already began the list of questions I have for him/her. ;-) -Jim

Hi All, I'm gonna be going to Report Studio training (V. 8 MR2 ) and I would like to contribute to the forum here. If you have any questions regarding Report Studio I'll be more than happy to post them to the instructor while I'm in training. Thanks -Jim By the way, this training will be...

Hi MF, I wrote the SQL as passthrough SQL. The query I had written had about 2 inline views and the outer query was listing columns as well as inline view columns. Thank you for your response MF.