Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. timida

    prompt page does not show up in page explorer

    Hello ravina! I think mfgf is right. It appears that there is still an old parameter in the report. It is possible that the parameter is used in the expression of an data item or in a filter or it is used from a prompt... One possibility to find "lost" parameters is to open the report and then...
  2. timida

    Prompt Pages Taking a LONG TIME to display

    Hi NEAR, I assume you are using ReportNet / Report Studio...? I have the same problem with one of my report. As far as I know, the reportserver validates the report before the prompt-page is shown. So it takes ages before the prompt is displayed. However I'm not sure if it is possible to skip...
  3. timida

    Conditional Formatting With Multiple Queries?

    Hello JKas, I suppose you use ReportNet. What do you mean with "adding a Box" - Do you put the Query2 in a ListColumn of the Query1 or do you put it in a Block or a Table? However, if you have the Query2 in a ListColumn and you change the Box type to "None" the column heading is still...
  4. timida

    Parameter - where to find?

    Hi Mexchen, you have to delete every reference to the old parameter. It is possible that the parameter is used in the expression of an data item or in a filter or it is used from a prompt... Copy the report to your clipboard and paste it to an editor. In the editor you can search after your...
  5. timida

    Hide a column.can't use "static choices"

    Hi Lohita, could you please give an example? kr, timida
  6. timida

    Hide 2 columns based on prompt values

    Hi lohita, does it work now? I suppose there is still one mistake.. When your variable has the values "By Date" and "By Period", than you have to use "ParamDisplayValue("yyyy") so that the variable is compared to the Dispaly value of the prompt. However I would recommend that you use the...
  7. timida

    Hide 2 columns based on prompt values

    ...steps and you inserted the parameter (variable) to your query. And you are able to see your prompt, but there is no effect to the columns. * What are the values of your variable and what type of variable you used? * In the Expression Definition of your variable what is displayed...
  8. timida

    ReportNet - Display (or hide) columns based on prompt values

    Hello lohita, I need more information: Do you use conditional formatting or a conditional block? Are you prompted for the variable? (if no please insert the parameter in your query - description is above in my post of 13 Jul 05 2:37) kr, Timida
  9. timida

    ReportNet: calculated columns in crosstab

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

    Use data from 2 different Query

    It is not possible to insert 2 data items from different queries to one list. The reason is that there is only one query behind a list. Using a third query as link is only possible when you use the 2 other queries within this query (2 levels). (I already tried this possibility, but didn't work...
  11. timida

    Use data from 2 different Query

    Here is my situation: * Query 1 contains the tank levels for a certain day. * Query 2 contains the deliveries (to this tanks) for a certain day. In my Report I want to show the tank levels and as detail list the deliveries (I linked the two lists via master/detail relationship). Problem is that...
  12. timida

    Use data from 2 different Query

    I also want to know how to use data from 2 different queries --> see thread401-1137903. To create a view is not a feasible solution for my situation. Is there any other way to do this? kr, timida
  13. timida

    use facts from one query in another

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

    Hide or show an object in a conditional block list

    Hi H69PP, maybe this helps: http://www.tek-tips.com/viewthread.cfm?qid=1089845 (ReportNet - Display (or hide) columns based on prompt values)? kr, Timida
  15. timida

    CRN: open DT in iFrame

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

    CRN - making a proper framework-model

    Hi COGNOISEcom, Thanks for your help, our current model is really complicated. However, I found a Cognos documentation about "Modeling in Framework Manager for Predictable Queries and Results". According to this document I have to resolve all loops and duplicate joins,... kr, Timida
  17. timida

    CRN: view generated sql in ReportStudio

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

    ReportNet - Display (or hide) columns based on prompt values

    Hello vzak, I just tried it using a conditional block. And it worked well. The basic steps are the same (see my first post for details). 1) create report with 3 columns 2) make a new prompt page with value prompt (e.g. Parameter1) 3) add to the property "static choices" 2 new choices 4) add a...
  19. timida

    ReportNet - Display (or hide) columns based on prompt values

    Hi, Sorry, your are right I forgot the most important thing.... After all the above mentioned steps. Click on the Query Explorer and select your Query (e.g. Query1). Then you see three columns (dimensions, facts and filters). In the column "facts" there are three column items (your three list...
  20. timida

    CRN - making a proper framework-model

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

Part and Inventory Search

Back
Top