Search results for query: *

Hi, I want to create a crosstab-report with reportstudio. In this crosstab I want to insert a calculated column. In Impromptu this was possible via the button "Advanced..." in query-view. I couldn't find something similar in ReportNet, neither I could find another way. Is there a possibility...

I created a report with report studio. There is query A which selects my data. I have another query B which selects detail data - both queries are joined via the Master-Detail-Relationship. I want to insert a calculated item (into the main query and main list) which references to a column/fact...

Hi! I have built a report and a drill-through report in ReportStudio. for example Report A: Nr, Name (Drill Through on Name, Parameter = Nr) Drill Through: Nr, Values This works fine and when I click on one name of the "Report A" the drill-through with the corresponding values to this name...

Hi, is there a possibility to view the generated SQL in Cognos ReportNet (Report Studio)? I have a report with two prompts (2 seperate queries). After I inserted a header section - report studio generated another query (master-detail query). I already found the possibility to show the SQL for...

We are migrating from Cognos Impromptu to ReportNet. We want to have one framework-model for all reports (different packages are ok). The problem is that our database-model is complicated. We have a lot of loops and different joins in the database. For example: Loops: Table A -> Table B Table...

Hi, I have three reports. From report A the user can drill to report B. And report B has defined a report picklist prompt (report C). So when I drill from A to B the prompt from report C is between. Report C contains a list of all prices (price 1,2,3,4,...) and the user should choose one...

Hello, I have a tricky problem. My report (Impromptu 7.0) contains products, which are sorted and grouped by productgroups. e.g.: product 1 price1 product 2 price2 product 3 price3 ----------- footer: group A total price(1-3) product 4 price4 product 5 price5 product 6 price6...

hi all, I have published impromptu reports (7.0) in upfront via Reports Publishing. Some reports are in landscape and some of them are not displayed the way they are displayed in Impromptu. In impromptu the report-layout fits on one page, unlike in upfront. In upfront the generated...

Hello! I created a report (Impromptu 7.0) where the user should determine if he want's to see a certain column (e.g. target values) or not. I already looked through the thread401-331757 , but the solution of this threat only is for displaying either one or another column. I only want to...

Hi! I have again an outer join problem... I have created a report which displays the deliveries of container within a specific period (2 type-in date prompts ?start? and ?end?). This report also should display a container, if there was no delivery to this container (within the period). Note...

Hello! Is there a possibility to display the current date in a type-in prompt as default value? Note: I'm using impromptu 7.0. thanks Timida

Hello! I have a problem with an outer Join and a drill through report. I want to show all products from one group with the price. In the first report I select the group and a price (there are about 10 different prices). The drill through report should show all products in the group even if they...

Hi I have a impromptu-report where the execution time is way to long. So I analysed the SQL-Statement. After adding a particular index to it - the execution time is very short: for example (simplified statement): Select table_a.nr, table_a.name, table_a.date,... from table_a, table_b where...