Search results for query: *

Hi, Can somebody please let me know how can we implement correlated query in report studio. Ex: how to implement below query in Cognos. SELECT EMP_NAME, (SELECT SUM(SAL) FROM EMP MGR WHERE MGR.EMP_ID = EMP1.MANAGER_ID) FROM EMP EMP1 Thanks in advance, Meenakshi

Thanks to everyone for there reply. I tried doing this with the help of Java Script.Where I still have doubt regarding the performance issue.Hoping a reply on this from guru's in the forum. Intially I added a HTML text item and included following script. The query item that displays prompt...

In a prompt page, I have a value prompt which displays Month & Year i.e. like 2007 January format. The default selection for the value prompt should be the current month, which keeps changing for the every month. Since the default value stores only static how can this be changed to dynamic...

I implemented the same, by using a union query. This is how I did it.. I created one query with the data that I wanted.. ie Year-Month, County and Measure (Query1). Say the data I get through this query for 2007-01 is 2007-01,Country1,120 2007-01,County3,357 I created one more query to get...

Viverto, thanks for the reply. I will try this out

Hi, I am creating a crosstab report with Year-Month as rows and Country as Column. I have a multiselect prompt for Country. Irrespective of whether the data is there for a county or not, columns for the selected county should appear. Is there a way to get this done. Thanks in advance

Hi, I wanted to create some reports with prompts using a template. The template should allow me to choose which prompts are to be included in the report and which prompts are to be excluded. Is it possible to do? If so please guide me how to go abt creating it. thanks

Hi, I have a time dimension in which I have special category 'YTD'. By default this category is displayed below the regular categories. I want 'YTD' to be above all the regular categories. Is there a way I can get it? Please help. Thanks, Meena