I need help to come up with a logic to filter this out.
Scenario
I need to sum up the login-logout's total number of hours per agents.
On a regular case with multiple login-logout, the formula will be the first login vs the last logout based on the login date.
Twist
Now the problem is on night...
Good Day,
I need help with regards to my connectivity to our Avaya Database.
I found out that I can do it by using Informix.
I just want to know what did I missed because im having problem with my linked server settings
on my sql server r2 2008.
Reference #1...
Im currently running a SQL SERVER 2008 R2.
and I need to connect to AVAYA CMS database to generate reports.
I found out that it can be done with the help of informix oledb as a provider.
The computer i was using already had an IBM INFORMIX DRIVER when i checked the computer's odbcad32.exe.
also...
Hello,
I need help interpreting a certain lines of code,
I was asked to modify it and target a specific task/report.
'Create Main Script
Open "Y:\Access DB\EXPORT.ACSUP" For Output As #1
Print #1, "'LANGUAGE=ENU"
Print #1, "'SERVERNAME=xxx.xx.xx.xx"
Print #1, "Public Sub Main()"
This code...
Greetings!
I'm fairly new to this, so if there is already a thread to this topic that might help me learn this or a link to an external site.
I've been browsing about this and I want to understand this better. Specifically, using ms excel to export reports from a CMS (e.g. AVAYA) putting it to...
Good Day To all!
I'd like to ask for an idea of how to get a specific .dbf file on a file system (with sub folders)
e.g.
Folder 1
-somefile.dbf
-otherfile.dbf
-Folder 1.1
--thisfile.dbf
--somefile.dbf
Folder 2
-thisfile.dbf
-somefile.dbf
-otherfile.dbf
My objective is to Consolidate all...
Hi experts!
Now, I have two free tables and bot are used in a form and both are in buffering mode
freetable1 is on buffering 3 (coz its just what i need, record editing)
freetable2 is on buffering 5 (coz i manipulate more than 1(one) record on this table)
NOTE: the primary key of freetable1 is...
Appreciation and Thanks to the Tek-Tips Community!
Just want to say thanks to this community esp. to Olaf, JRB-Bldr, Ilya, MikeLewis and others.. My app for the company i work on is up and running, networked and stuff.
Thanks so much!
Dexter
Regarding to my practice, i was thinking about putting a report generator. a monthly, weekly and annual reports. i know how to use data grouping on reports but i dont have an idea on grouping it with these selections. is there any previous post related to this question?
I've been researching...
Whenever i do join two tables and export them into an xls/xl5, its working fine but i get these repeated records to fill up the spaces. is there a way to avoid that and make it look neat?
thanks!
Dexter
I have a table and i want to edit something on the record and i added a few records and then i change my mind, instead of clicking save i clicked cancel. What would be a good way to revert that already been added records.
NOTE:
considering its a form that do AED(add, edit, delete)
as it adds it...
now i have a finished product "sysyem.exe" by the product of tremendous patience of you guys on me. my last struggle is to work this on an existing LAN. steps/guide for this to be done?
i was making an information system and upon completion:
Q1: in the log in my app. how do i manage this? will i let the users(admin is the level of the users) to delete log and look like cheating? or will i let it list thousands of transactions on the app that i imagine is sort of messy. in this...
as of my knowledge, report populates it contents according to the current query contained in a cursor e.g. SELECT * FROM tbl_db INTO CURSOR temp
anyone there can help me how can i populate this report with multiple bands? i need to populate it with the list of people and each people listed and...
i have an auto generated menu for my mdiForm form the menu designer and im having problems in puting actions actions to the selected menu. what i did is appended codes to the generated menu.mpr
*!* code i appended
ON SELECTION BAR 1 OF file mdiForm.fmethod1() --> not working [Transaction Log]...
hi to all
i made a vfp project that contains a log in and an mdi form
problem:
after running login and after log in---
*codes to redirect*
*!* filter codes here
loginform.release()
do form mdiform
everything works perfectly except:
when i click the menu on my mdi parent its shows the error...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.