Search results for query: *

hi guys, I have a scenario where i have to handle the null values in the filter (say, in the WHERE condition i need (START_DATE is NULL) or (START_DATE >= ?Startdate)) How can i get this expression. I have to create this in formula editor or SQL Expression editor. Can anybody help in this...

Hi Mex, Parameter is just a place holder, which can be created either through filter definition or the prompt definition. for example when you say Name = ?xyz? in the filter definition, the xyz is the parameter which is gonna hold the specific value, based on which the report will be filtered...

Hey JGirl, I've created a value prmpt. But it cognos automatically displays a type -in prompt. The poor performance is as you said bcoz of the size of the table which contains 1 million records. Is there any workaround to display the unique values to be displayed in the prompt. thanks anand.

Create required filters in the target report and make them as optional filter. Now in Drill through report( the report from which u wanna drill thru) create the appropriate drill thru's. Anand.

Hi Everybody, I'm using Reportnet MR2 and oracle 9i for creating reports.My scenario is like this, the report should display contents based on the filters. When i hard-ode the values in the filter i'm getting the result what i need. ( say based on region, area etc). Now i tried creating prompt...

Hi, I'm trying to create a drill through report from reportnet report to a html file. My reportnet report consists of Product Line, Product Type and Product Name fields. I wanna create a drill thru from the product name field which should display the Product name which i selected in a seperate...