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 Mike Lewis 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: *

  • Users: Ericordina
  • Order by date
  1. Ericordina

    DTS error DATA pump WRONG POINTER

    Hello, I'm trying to create a DTS statement wich must transfer records from DATABASE1.TABEL1 to DATABASE2.TABELTEMP. Select Distinct ID ID2 getdate () as 'DATE' from TABEL1 where not exists (select id,id2 from DATABASE2.user.TABELTEMP)...
  2. Ericordina

    Creating % ON SUBTOTAL

    Hello, I become mutch better with webfocus. And right now i have an report wich have have 2 hold files to combine 2 statements in one report. To give them an total i have used the subtotal option. However when i tried to create an compute to calculate the % than the result is not goed...
  3. Ericordina

    COLUMN TO ROW WITH TITLE

    Thanx that is indeed the solution for this problem
  4. Ericordina

    Getting the last 5 years automatically throug where clausile

    Hello, I'm trying to create an report in wich i can use automatically the information of the last 5 years. the field in the table is filled till 2099 and the max year must be the year eq system year. I hope someone can give me some advise to solve this greetings eric
  5. Ericordina

    count with accross

    Thanx that is indeed the solution
  6. Ericordina

    COLUMN TO ROW WITH TITLE

    I Found it. I have used SALARIS/A25='SALARIS'; SALARISNIEUW/A25='SALARISNIEUW'; TOTALSALARIS/A25='TOTAALSALARIS'; TABLE FILE EMPDATA SUM TOTALSAL AS 'TOTAAL SALARIS' OVER SALARYNEW AS 'SALARISNIEUW ' OVER SALARY AS 'SALARIS ' OVER ITEM AS 'PCT' ACROSS YEAR AS ' '
  7. Ericordina

    count with accross

    I have also an other problem (sample from empdata) If i have an collumn salary and thats accrossed by year How is then possible to generete an formule wich can count the salary of year minus salary-1 /salary of year *100
  8. Ericordina

    COLUMN TO ROW WITH TITLE

    I already have tried it with multiple report through an hold file
  9. Ericordina

    COLUMN TO ROW WITH TITLE

    I will try to give a sample I will use the empdata to try te explain my problem First i must define year out hiredate define YEAR/YY=Hiredate If i have done that dan i must try to create the last 5 years and that must be automatically so every new year wil be the max(year) and the other 4...
  10. Ericordina

    COLUMN TO ROW WITH TITLE

    Hello, I'm not working for so long with webfocus and i tried to made an report with an accros by and sum The numbers are hard fields in the tabels. But how can i get the columns defined as single rows instead of columsn accrossed year. I have tried also the command OVER I hope i made it...

Part and Inventory Search

Back
Top