Search results for query: *

hi all. While developing reports, I noticed a very strange problem. Let me explain what I am doing and how. I got a MainReport, which got 2 SubReport. The MianReport, I got 1 parameter Rundate, I execute a stored Procedure in the Command line to generate a Report ID. Example Code is...

hi All, While developing reports, I noticed a very strange problem. Let me explain what I am doing and how. I got a MainReport, which got 2 SubReport. The MianReport, I got 1 parameter Rundate, I execute a stored Procedure in the COMMAD (database object) to generate a Report ID. Example...

hello All, I got a report (container report) which got 4 sub-reports. All the 4 subreports extracts data through Tsql Stored Procedures. in the paramters field, i got 1 which i can seelect multiples values for. i select multiple values paratmer in the container report, do a formula to using...

hello All! i have written a stored Procedure, i got 7 breakdown Options. for Example A, B, C, D, E, F, G, Now let say i got a table having calulted data in fields tablename (A, b, c, d, e, f, g, CalulatedAccounts, CalcultedSum, TotalProfit) now let say i am returing my data...

hi there, I recently worte a few new very complecated and long reports for a new client. these reports were written on the test instance of the database. after the UAT i ask them should i map them to live database. they said no Need of it as when we publish reports in there system, the system...

HI THERE, i got a bit table, where i will be putting annual calcuLated data for future use. now the problem is they want it all automated. i cannot create a function becuase at the end it will not return any data but will insert the calculated data into a table. saME way a procedure WILL NEED...

I want to do a select statement to fill a table . the field in the tables are as follows CustomerID Amount band 1 Amount band 2 Amount band 3 Amount band 4 …..Amount band 12 the band selection criteria given below. • Period Band 1 - Up to 1 year • Period Band 2 - Over 1 but not over 2...

hi there. i want to create a stored procedure, which will drop a table A frist, then will create the table A again wid fresh data e,g create stored procedure ABC as begin execute immediate 'drop table A'; create table A as select * from longQuery.... ; end now i want to sechedule a job to...

Can anyone help me built a SQL query to to select this data and calculate the accrual according to the detials given below. On a Friday the report will accrue for three days (ie for Fri, Sat and Sun) using the amount outstanding For example : - BusinessDay Amount Accrual...

Can anyone help me built a SQL query to to select this data and calculate the accrual according to the detials given below. On a Friday the report will accrue for three days (ie for Fri, Sat and Sun) using the amount outstanding For example : - BusinessDay Amount Accrual Thurs 40...

3.4.6 On a Friday the report will accrue for three days (ie for Fri, Sat and Sun) using the aggregate repo quantity amount outstanding at CoB Fri. For example : - BusinessDay Amount Accrual Thurs 40 2,739.72 Fri 40 8,219.18 * Mon 60 3,424.66 * Fri 40...

HI all, i got some 200 reports. All published in crystal enterprise. Some of them are really heavy reports, and usually keep the database server extremly busy while running. Sometime we need to run 4 different instances of the same heavy reports for different paramenters dates. which really...

HI all, I want to add a Case When statment after the where clause of a select statement. example given below, its not working please help. select counter,sum(a),sum(b),sum(c) from tablename where tablename.startdate=20080705 and case counter when 24 then tablename.employeenumber...

hi there, Is it possible to trigger a crystal report in crystal entriprise when there is an entry of a record in a database. help and suggestion please

hi there, Is it possible to trigger a crystal report in crystal entriprise when there is an entry of a record in a database. help and suggestion please

HI, i am a crystal reports developer. My manager asked to write to him, why should we upgrade from crystal reports 10 to crystal reports 2008? we are using crystal entriprise as well. and with the same thing he ask me to write why we should not upgrade it as well ? he wana know both sides of...

i got a table inwhich data is stored in this manner details given below. Date Advances tradetype 20080801 100007.04 pwsweep 20080802 234567.56 pwrefund 20080802 237564.56 pwsweep 20080802 100.56 pwnlf-p 20080803 3000...

HI I AM USING ORACLE 10G. I AM TRYING TO RUN THIS SCRIPT IN A STORE PROCEDURE BUT IT GIVING ME ERROR. CAN ANYONE FIX IT FOR ME PLEASE ?? IF (SELECT DATEFIELD FROM TABLE)<>TODAYDATE THEN INSERT INTO TABLE(DATEFIELD, FIELD2, FIELD3) VALUES(20/12/2008,25,30) ELSE END IF;

HI there. I am using the formula the current value in the databasetable.tablefield=5.58 after applying the formula Cstr(databasetable.tablefield,2)=6 i want it to print Cstr(databasetable.tablefield,2)=5 how this can be done please help!!!

hi there, I have written a function to check if a given date is a working day or not. the body of the function is given below. function IsWorkingDate(datein varchar2) return boolean is knt integer; begin insert into dmo_pwlb_reports_tt_isworking select f_date from tblholid_dat hol...