Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. garry1

    add days to date

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

    add days to date

    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.
  3. garry1

    Any help on this impromptu report problem.

    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...
  4. garry1

    Any help on this impromptu report problem.

    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...
  5. garry1

    Help with the crosstab problem in sqlserver.

    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...
  6. garry1

    How to do in oracle reports.

    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...
  7. garry1

    How to do in oracle reports.

    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...
  8. garry1

    Help needed with the matrix report.

    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...
  9. garry1

    check/uncheck parent and child checkboxes

    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...
  10. garry1

    check/uncheck parent and child checkboxes

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

    check/uncheck parent and child checkboxes

    no its not working.
  12. garry1

    check/uncheck parent and child checkboxes

    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...
  13. garry1

    Help needed with the matrix report.

    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...
  14. garry1

    check/uncheck parent and child checkboxes

    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 {...
  15. garry1

    check/uncheck parent and child checkboxes

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

    Passing more than one parameter value to report.

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

    Passing more than one parameter value to report.

    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...
  18. garry1

    check/uncheck parent and child checkboxes

    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...
  19. garry1

    Problems saving a matrix report to excel

    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.
  20. garry1

    Help needed with the matrix report.

    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...

Part and Inventory Search

Back
Top