syalman

Hi to all... l have main dataset and one sub dataset. in main dataset below quesy exists SELECT 1 FROM DUAL My actual query is in sub query. l just use main Dataset to pass parametter to sub dataset. the my problem is ; even if each time entered parametter is changed the result of report is not changing. Always giving same result . with out looking at parametter. Something like coming from cache...

yes i am expecting any answer

yes i am interested in samething

hi to all i have several "Detail" bar. And there is a table in each "Detail" band which gets data from own "Data Source". When report runs (all have own datasource ) returns total row count to the master dataset. l want that "total row count" value to use in title band i fixed a "Text Field" to that Title Band. and i have set "Print When Expression" of that "Text Field" $V{v_row_count_main} !=null Yes my plan is total row count will be shown when table which is in "Detail" band returns rows. i mean more than zero row. such as 1, 2, 3 or more row. but when table returns zero row or null value that "Text Field" will be disappear.. but this is not working because "Print When Expression" always using $V{v_row_count_main} value in calculating as null. thanks to all

thanks a lot. working fine as i wished

Hi to all. I have a detail band in that detail band l fixed 2 table with different datasource. My question is . when all data of first table is listed in page than immediately listing of table2 data is starting. I want second table starts listing in next page. Not just end of the first table. thanks...