Search results for query: *

Just run the reports (as amalcolmf said) overnight and save your reports as reportView. This will cache the sql-statement. Jochen

Hi Andy, I'm not sure wether I got your question right, but couldn't you just limit the number of displayed rows in your report and then sort asc or desc by leaving the ranking how you did it?! Just come back if that isn't a solution for you, ok?! Jochen

Hi Damzi, this would do the trick: Add a calculation column to your list and add 1 in the expression editor! Sum the column and add a new list to your page header, which should base on your first (and only) query! Add the calculation item to your new list, choose type of box none and as...

Hi Damzi, just go to the menu Extras in ReportStudio and copy the report to clipboard! Now you can edit the XML in an editor and copy it back to an empty report! Hope this helps, Jochen

Hi there, is there a way to figure out the runtime (except the information out of the Audit-DB) of a report and to display it on the report??? Thanx, Jochen

Hi Damzi, what do you want to do? Have you ever done an export to your deployment archive?? The zip-Files for the Audit-Database-Support and the cognos-samples for example you will have to copy and paste manually into your archive! Then you are supposed to see them via CognosConnection! Hope...

Hi, how did you determine the execution time for an report? Did you integrate this information out of the AUDIT-Database?? Would be nice, if you could give me an idea how you realized that! Thanx, Jochen

Hi Madraj, there is no real Template-function in ReportNet! Just in case you want to add a kind of template to the first selection-window, where you can choose the type of report you want to create, you can add there a new lets say pre-defined ReportNet-list, then you will have to adjust the...

Hi Nonio, just add a new dataitem as sortKey to your query and type in an expression like the following one: if(column 1-5) then (1) else if (column 6-10) then (2) .... else (0) Then sort on this sortKey! Hope this helps!! Jochen