Search results for query: *

Awesome, that worked the way I wanted it to. Now can you elaborate more on formatting. I sure my master query and detail query will always have a one to one relationship and I want it to look like a simple list query, can you tell me how to do this. I'm not sure I understand you when you say...

I have a very simmilar situation. I created 2 query objects (ie query 1 and query 2) both contain a tabular object. Now I need to join both the query ojects based on a common field how do I do that?

I create 2 query objects (ie. Query1 and Query2). Now I would like to join the 2 queries. How do I do that? Each of the Query objects contain a tabluar model under them.

Because the report needs to be scheduled based on the completion of other events which Appworx is currently scheduling.

Thank, can you also tell me weather I can run a report-net report from the command-line. We use a scheduler called appworx and I'd really like to schedule a report-net report using the same tool rather than Cognos's scheduler. Will I need to install Cognos's SDK for this purpose?

Do I need the SDK installed to use this feture. Thanks for all your help. I'll try that and get back.

Below is the format of the report I need to develop: Product Year Season Week1 Week2 Week3 Week12 to date to date sales sales sales ....sales Sales sales ------- ------- ------- ----- ----- ----- ----- Using report net I created this report...

I have a report developed in report Net that is taking too long to run. 1. Will building a cube help speed this up? 2. Is there a way to rebuild the cube from the command line? I ask this question because I want to be able to schedule the rebuilding/refreshing of this cube based on the...

I'm trying to set a filter where the calander_date column is greater than equal to the minimum of 2 given dates. THis is what my expression looks like: [Business Layer].[DATE_INFO].[CALENDAR_DATE] >= minimum(to_date('31-jul-2004'), to_date('30-may-2005')) when I try to validate this function...

That will not work our fiscal calander is different from the regular calander. eg. of date_info table's data calander_date Fiscal_year ------------- ----------- 30-aug-04 2004 31-aug-04 2005 28-sep-04 2005 04-may-05 2005 29-Jul-05 2005 20-Jul-05...

I did try that, but what I'm trying to do is avoid the user intervention to select the current fiscal year, when it can be automatically calculated based on system date. I think my next step is going to be to add a function in oracle called get_current_fiscal_year with the following SQL ...

roberda, I still have not had any sucess with DoubleD's suggestion....but I got sidetracked and have not tried hard enough. Umag I liked your suggestion of creating multiple list queries for each data and show them side by side. Can you give me details on how to go about this. How do you create...

I'm using report net and would like to filter a simple report based on the time dimention to display all year to date sales. My filter in SQL language will read: where fiscal_year = (select fiscal_year from date_info where calendar_date = trunc(sysdate)) a) I'm not sure...

Awsome approch....thank you. I'll try that.

I'm using report studio to generate a report that has teh following columns: 'product' 'YTD sales' 'QTD sales' 'Last years sales' --------- ----------- ----------- ------------------ columns 2,3 and 4 query the sales fact table over a different time frame (YTD-year to date, QTD...