Search results for query: *

If the date is in the following format "10-Apr-2006" how do I add 10 days to the above date format. Thanks.

I have text box 1 where user can enter date in mm/dd/yy or mm/dd/yyyy format. I would like to populate the text box 2 by adding 10 days to the date entered in the text box 1. How do I add 10 days to the date in entered in mm/dd/yy or mm/dd/yyyy format. Thanks.

Hi Sagae, Here is the example I am trying to accomplish and having problems; 1) I have column called data_string in table a 2) I try to relate the table a with table b on the primary key 3) Created a prompt based on the created date from table b as the user is interested in seeing the weekly...

Hi Gurus, I am new to cognos and I am trying to create a report using impromptu. I am having problem in formatting the report.Any help is greatly appreciated. Here is the example. I inserted a text frame into the report and I am naming the column heading as description. Total is the computed...

Hi All, When I run following query SELECT distinct TOP 50 c.id, a.UnitQty, MIN(b.PeriodBeginDt), MAX(b.PeriodEndDt), b.SBAmt, b.BdgAmt, f.cttypecd FROM tSBU a, tSB b, tCS c, tcbg e, tctr f WHERE c.Id = b.Id AND c.Id = e.Id AND c.id = f.id AND c.SeqNum = b.SeqNum AND...

Nagornyi, Thanks for your kind reply. This is what user wants to see in the report. If BLDG and WBLDG are matching then he wants me to display as a single record like below. ID, BLDG, WBLDG 323, NV HOMES NV HOMES If BLDG and WBLDG are not matching like the below eample...

Hi, I am trying to create a blank reecord if the values in the column doesn't match, but I am running into some problems. For example I have the following values ID, BLDG, WBLDG 323,NV HOMES,NV HOMES -- OK 323,NV HOMES,NV HOMES11-- Not OK. User wants something like 323,NV HOMES 323...

Hi Nagornyi, Thanks a lot for all your help, I am still having the problem and I found that part of the problem is with the data also. But now I have a clean set of data which I am running only for a certain year range and it getting me three distinct different values and I want them to sum...

Hi chessbot, I use the same name for all the parent checkboxes. I display the results from a query. company names are the parent checkboxes and emp names are the child checkboxs. I group on a company name. My problem is I want the parent checkbox to be checked automatically when the user checks...

There is no error. When I check all the child checkboxes in a group it doesn’t check the parent checkbox.

no its not working.

I changed as mentioned above but, its not working <script language="JavaScript"> function allChecked(child, parent) { if (!child.length) // if not an array { parent.checked = child.checked; alert(parent.checked) return; } for (var i=0; i<child.length; i++) { if...

Hi Nagornyi, I have tried to get the thing working based on your old suggestion, but I am running into some snags with the data I am populating in the year column. I am trying to get the sum of the amount in the year column and I have noticed that the amounts are not changing and they are...

I applied the above script but something is not working. When I check all the child checkboxes in the group the parent checkbox is not getting checked. Here is my code. <script language="JavaScript"> function allChecked(chks, prnt) { if (!chks.length) // if not an array {...

How do I make the parent checkbox to be checked when I check all the child check boxes in that parent group. Thanks.

Hi Nagornyi, I tried your tip, but still it is causing me the same problem. Thanks.

Hi, I am trying to pass more than one value to the report and it is returning me a blank page every time I run the report.Following is my sql statment select * from test_data where distr in (&p_1) and I am passing values as (3011,3058) to the report when I try to run my paper layout. But I am...

I have a form were I display parent and child checkboxs Parent A checkbox as two child check box's. Parent B checkbox as three child check box's 1. when user checks and submits two parent checkboxs (A and B) I would like to display a error message that "you can select from only from one parent...

Hi, I am having problems saving a matrix report to excel. It distorts the complete settings of the report and it is saving entire contents in just one cell. Any help on this is very much appreciated. Thanks.

Hi Nagornyi, I am sorry to trouble you, but I am still having the problem with query. When I hardcoded the number of years, it is complaining about the start_year in this part of the query (select start_year + rownum - 1 column_year from all_tables where rownum <= NUMBER_OF_YEARS)F in this...