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...
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...
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...
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...
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...
...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...
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
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...
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...
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...
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
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 H69PP,
maybe this helps: http://www.tek-tips.com/viewthread.cfm?qid=1089845 (ReportNet - Display (or hide) columns based on prompt values)?
kr, Timida
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 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
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.