|
|
|
Помогите новечку с Crystal Report
|
|||
|---|---|---|---|
|
#18+
Есть txt файл, вот его начало. Как этот репорт загнать в Crystal Report? автор//VISTA //notes Summary //end notes //Database //End Database //Title Some summary select p.saddr2 from property p where p.hmy = #hprop#; select 'FOR PERIOD ENDING ' || to_char(last_day('#postfr#'), 'mm/dd/yyyy') from dual; select 'PROPERTY #' || rTrim(p.scode) from property p where p.hmy = #hprop#; Select 'ADD1= ' || rtrim(p.saddr1) || ' CSZ= ' || rtrim(p.scity) || ', ' || rtrim(p.sstate) || ', ' || rtrim(p.szipcode) from Property p Where p.hmy = #hProp#; //end title //Select select q.building,q.sdesc,' ',q.scode,sum(q.open_bal),sum(q.open_prepay),'', sum(q.base_charge),'',sum(q.receipts),'',sum(q.dClosingbalance_arrears), sum(q.closing_prepay),q.iseq from (Select /*+ INDEX(t PK_TENANT) INDEX(u PK_UNIT) */ 'BUILDING #'||nvl(u.sfield7,' ') building, decode(cg.sdesc, NULL, 'PREPAYMENTS', upper(cg.sdesc)) sdesc, decode(cg.iSequence,NULL,0,cg.iSequence) iseq, 'ZZ' || cr.sName sname, cr.sCode scode, nvl(sum(datax.open_bal),0) open_bal, nvl(sum(datax.open_prepay),0) open_prepay, '', nvl(sum(datax.base_charge),0) base_charge, '', nvl(sum(pay_recd),0) receipts , ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 10.02.2009, 19:02 |
|
||
|
|

start [/forum/topic.php?fid=31&fpage=92&tid=1536383]: |
0ms |
get settings: |
7ms |
get forum list: |
12ms |
check forum access: |
3ms |
check topic access: |
3ms |
track hit: |
55ms |
get topic data: |
10ms |
get forum data: |
2ms |
get page messages: |
31ms |
get tp. blocked users: |
1ms |
| others: | 220ms |
| total: | 344ms |

| 0 / 0 |
