Search results for query: *

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

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

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.

When user logs in I display a summary page. I would like to automatically refresh the summary page after 30 mins and timeout the user(take user back to the login page) after 1hr. Here is my code. It refreshes the page but doesn't timeout. <META HTTP-EQUIV="refresh"...

Hi, I am trying to create a matrix report and I want to export that to excel. But, I am running into some problem with populating the columns. There are two columns in the database table and one tracks number of years and the other tracks the fiscal year. Based on number of years I need to...

Hi, I am creating a report which has set of sub reports. As there is no subreport concep in oracle reports I am using repeating frames to work with. I am running into some problems with displaying the data on one frame. ex. I want to display the main record first and all the child records...

When the parent checkbox is checked all the child check boxes will be checked. My problem is how to uncheck child checkboxes when parent is unchecked. Here is my code <script> <!-- function CA#chkTime#(){ for(i=0;i<document.myForm.atype.length;i++) { var...

I have a query which gets the following values - company names and emp names. I display the results grouping on a company name. <cfoutput query="emp" group="company_name"> <input type="checkbox" name="check" value="#company_name#">#company_name# <cfoutput> <input type="checkbox"...

Hi, I need to insert balnk lines in the report based on a count returned by a feild in the report, so that users will try to enter the data later in the feild. Can someone please give me some hints in proceding with this problem. Any help is very much appreciated on this. Thanks. Garry.

Hi, I want to populate the report title during runtime, based on a value in the colum. I am running into some problems with group frequency error, if someone can please share there ideas on the appraoch to this problem I would really appreciate it. Thanks.

Hi, Is there a way to specify color for each label in a pie chart. For example for label A green color, label B Blue color, Label C Red color. Thanks.

Hi, I need to format label values on the pie chart to show two decimal places example 12.22. When I select Point label style as Numeric it is displaying as 12.2. and also Is it possible to show label value and percentage. Thanks.

I am trying to create a cummulative line graph. I have problem displaying the cummulative value. For example on x axis I am displaying days monday, tuesday. If I worked 4 hrs on monday and 3 hrs on tuesday, I would like to show 4 hrs on monday and 7 hrs on tuesday. How do I add up the previous...

Hi, I am trying to print a report using the duplex style by setting my printer in duplex mode. When it prints it is printing the numbers incorrectly for example. When I generate my report it has 8 pages(my query has 4 rows).As my report is 2 page report when I print a report I want something...

Hi, I have a report in which about 10 feilds are retrived from the database and the remaining are the boiler plate objects which are upto 2 pages. I tried to put a line break (by drawing a line) after it displays part of the objects so that the remaining gets printed on the other. But it...

Hi, I am new to oracle reports and I am trying to print a jsp report via rwrun command and I am getting the following error. REP-0549: Destination type must be 'file','printer','mail' or 'sysout' in batch mode. if someone could please specify how to fix this batch problem I would really...

Hi, I am trying to connect to Oracle database using Actuate and I am getting this error. &quot;Could not load library acorcl80.dll/acorcl90.dll. Its version might be incompatible with the database client version.&quot;