what is the function name or the logical name for freezing data? 1

[Dausa67]

End result: Chart
Data is for vendor performance.

I have built my query to pull all open orders for outside sales for 4 different vendors. I have added a formula to tell me how many days early or late each line item is. The report that I have now is for the month of March. I want run the report on the first day of each month to capture a snapshot of the current trend. My current Chart has 1 bar for each of the vendors. When I run this again on April 1st I want it to keep the current snap shot for March and put a bar beside it reflecting current trend for April. In the end, “management” wants the report to reflect up to 12 months of activity for these 4 vendors.

What function or SQL clause do I use to create this chart snapshot of each month? I know this has a name and it's not Oscar Meyer.


Clay

 

[Thargy]

da,

What's probably happened is that you have switched to a different TNSNAMES file. Search the drive where you installed oracle for a file called TNSNAMES.ORA. There may be one from some time ago, and there may be one from your recent installation.

If the system has switched from the old to the new, then the settings in the old will no longer be 'visible' to the new installation.

I've posted a sample from my TNSNAMES below. You should look in your old TNSNAMES.ORA file for a similar entry, which corresponds to the db at work to which you formerly connected.

Copy the entry to your new file, and you should be able to access the db once more.

HOME1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = abcdefg)(PORT 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = HOME1)
    )
  )

Let me know how you get on.

Regards

T

 

[Dausa67]

T,
I am back on again but my MIS department requested that I remove 10g. I would still like to do a problem with you and start a new thread. I will use my current situation and hopefully this time I will have it up with in about 30 minutes.



Clay

 

[Thargy]

g'day!

That's fine. You don't really need a full 10g installation locally, but the client software is fine. Your MIS aren't being unreasonable, but they should enable you to query a relevant db on a read-only basis using sql developer.

I await your new posting.

Keep taking the tablets and don't give up!

Regards

T