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

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...

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