Recent content by Ajith2002

Hi Friends, How do we compare a DateTime field with a DateTime value selected from a Parameter field ? The field in the DB is of type String and is of the format - 2003-01-08 12:17:53.000 The DateTime parameter value is in the format - MM/DD/YYYY HH:MM:SS How do we format these dates...

Thanks guys. My problem is resolved. I changed the Record selection formula I posted before to this way - {Field1} <> &quot;&quot; and // since there are 70,000 records with blank Field1 value. if {?Parm1} = &quot;ALL&quot; then true else {Field1} = {?Parm1} and {Field2} = {?Parm2}...

Hey guys, I found out what's wrong. In fact, there are around 70,000 records with Field1 value = null. So when I select 'ALL' in the parm1 it's fetching all the records, which caused the delay. So I changed the formula like this - if {?Parm1} = &quot;ALL&quot; then true else {Field1} =...

Guys, It still didnt help me. ;-(( This is my updated Record Selection formula - if {?Parm1} = &quot;ALL&quot; then true else {Field1} = {?Parm1} and {Field2} = {?Parm2} and {Field3} = {?Parm3} and {Field4} startswith 'P' and {Field5} >={?StartDate} and {Field5} <= {?EndDate} How does...

Steve, I have got four parameter fields in my report, not just the state field. So my Record Selection formula look like - if {?Parm1} = &quot;ALL&quot; then true else {Field1} = {?Parm1} and if {?Parm2} = &quot;ALL&quot; then true else {Field2} = {?Parm2} and {Field3} = {?Parm3} and {Field4} =...

How do we get all the values in a parameter list, by selecting a value(say, '*' OR 'ALL') from a parameter list ? The parameter field is State, once when you select * or ALL, the report should take all the State values. Thanks in advance.

How can we add values to a ListBox(Not DropDown ListBox) thru Code ?

Hi, I have a hidden field called &quot;hRank&quot;. And in &quot;selectChange&quot; function i am passing the index of drop down list as a parameter, which is stored in &quot;intSelectedValIndex&quot; and storing it in &quot;hRank&quot;, as shown in the function below. Please tell me how to...

Hi, I have a hidden field called &quot;hRank&quot;. And in &quot;selectChange&quot; function i am passing the index as a parameter, which is stored in &quot;intSelectedValIndex&quot; and storing it in &quot;hRank&quot;, as shown in the function below. Please tell me how to retrive that...

Hello Guys, In a jsp page, I have a hidden text box. I need to retrive that hidden value in a jsp variable. Can anybody pls tell me how to do that, without submitting the form (or either method =post). I tried using request.getParameter(&quot;variable name&quot;); But didnt worked out...

Hi folks, How do we pass a value from a JavaScript code to Java code, within the same JSP page ? I want to execute a Java code using a value I get from a JavaScript function(inside same JSP page). Thanks very much in advance.

I dont have much details. This question has been asked in one of the interview. I am wondering whether we could create a database using the RPTs provided by any chance.

How do we create a database from RPTs ? You'll be given a set of RPTs from which you need to create a database. What are the possible ways to do this ? Thanks very much.

Hi Guys, I've got a datetime field called CloseDate in a table 'tableA'. DB is Oracle 8i. when you run the report, a parameter(End Date, of type DateTime) will be asked to select the End Date/Time. Then I'm checking whether the CloseDate is less than or equal to End Date(parameter). Everything...

Thanks Rogar! It's fine now.