Crystal Reports- displaying calculations for date range prior to date search parameter
I’m working on a formula to calculate the number of criminal offenses that occurred in the same amount of days as my date search parameter but prior to the start date. The date search parameter is always changing. The idea is to compare the number of offenses from the last time period. I want to [...]
Answer Question
| June 6, 2012 2:57 PM
Crystal Reports XI
I’m working on a formula to calculate the number of criminal offenses that occurred in the same amount of days as my date search parameter but prior to the start date. The date search parameter is always changing. The idea is to compare the number of offenses from the last time period. I want to [...]
Answer Question
| June 6, 2012 2:57 PM
Crystal Reports XI
Oracle Database XE
i could not start up the project …could you please help me out from this thanks.. Connected to: Oracle Database 10g Express Edition Release 10.2.0.1.0 – Pro SQL> alter system reset sessions scope=spfile sid=’*'; System altered. SQL> alter system set processes=300 scope=spfile; System altered. SQL> shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. [...]
Answer Question
| June 6, 2012 12:49 PM
Oracle Database 10g
i could not start up the project …could you please help me out from this thanks.. Connected to: Oracle Database 10g Express Edition Release 10.2.0.1.0 – Pro SQL> alter system reset sessions scope=spfile sid=’*'; System altered. SQL> alter system set processes=300 scope=spfile; System altered. SQL> shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. [...]
Answer Question
| June 6, 2012 12:49 PM
Oracle Database 10g
How to create menu at Movex Explorer?
Hi , Im working with Movex RPG. Can anyone tell me how to create Menu at Explorer screen from Menu generated. At green screen means in AS/400 I have created but the same thing I need to create At explorer.? Is any setting requre at green screen side …. Plz help if anyone have worked [...]
Answer Question
| June 6, 2012 9:56 AM
Movex Explorer, Movex RPG
Hi , Im working with Movex RPG. Can anyone tell me how to create Menu at Explorer screen from Menu generated. At green screen means in AS/400 I have created but the same thing I need to create At explorer.? Is any setting requre at green screen side …. Plz help if anyone have worked [...]
Answer Question
| June 6, 2012 9:56 AM
Movex Explorer, Movex RPG
Set Graph in Oracle 10g
How I can set graph in oracle form 10g Please send a solution?
Answer Question
| June 6, 2012 9:39 AM
Oracle 10g, Oracle Forms 10g
How I can set graph in oracle form 10g Please send a solution?
Answer Question
| June 6, 2012 9:39 AM
Oracle 10g, Oracle Forms 10g
VB6 with too many SQL Select Statements
Hi Team, hope you can help me out here.. I have a VB6 form that is populated using VB6 and Access being the Repository. The problem is that I am opening and closing the Database for every query I have.. Approx 87 queries. In short I have 12 Rooms that I need stats for.. Ie [...]
Answer Question
| June 7, 2012 9:08 AM
Microsoft Access 1997, Visual Basic 6
Hi Team, hope you can help me out here.. I have a VB6 form that is populated using VB6 and Access being the Repository. The problem is that I am opening and closing the Database for every query I have.. Approx 87 queries. In short I have 12 Rooms that I need stats for.. Ie [...]
Answer Question
| June 7, 2012 9:08 AM
Microsoft Access 1997, Visual Basic 6
Import OST to Exchange
Hello, I have a very specific need of importing an OST file into Exchange Server ( OST files belong to some other server ). Can anyone help? Regards, Raj Malhotra
Answer Question
| June 15, 2012 7:13 AM
.OST files, Microsoft Exchange 2010
Hello, I have a very specific need of importing an OST file into Exchange Server ( OST files belong to some other server ). Can anyone help? Regards, Raj Malhotra
Answer Question
| June 15, 2012 7:13 AM
.OST files, Microsoft Exchange 2010
vmware
How do I connect internet via vmware? I checked adapter setting to NAT but it does not work. Thanks
Answer Question
| June 6, 2012 1:21 AM
VMware fusion 4
How do I connect internet via vmware? I checked adapter setting to NAT but it does not work. Thanks
Answer Question
| June 6, 2012 1:21 AM
VMware fusion 4
database
if i have one pf (pf009) and one logical file (lf009) on pf009. how we can add one more field after compalisation of logical file ?
Answer Question
| June 8, 2012 5:17 PM
AS/400 database
if i have one pf (pf009) and one logical file (lf009) on pf009. how we can add one more field after compalisation of logical file ?
Answer Question
| June 8, 2012 5:17 PM
AS/400 database
How to create an Outlook system that automatically archives team email conversations using rules and public folders.
I’m trying to set up an Outlook system using rules and public folders that does the following: - Allows any member of a team to “tag” a team email conversation so all future emails from that conversation will be automatically copied to a public folder. - Anyone on the team who needs to quickly find [...]
Answer Question
| June 19, 2012 4:27 PM
Microsoft Outlook 2007, Microsoft Outlook folders
I’m trying to set up an Outlook system using rules and public folders that does the following: - Allows any member of a team to “tag” a team email conversation so all future emails from that conversation will be automatically copied to a public folder. - Anyone on the team who needs to quickly find [...]
Answer Question
| June 19, 2012 4:27 PM
Microsoft Outlook 2007, Microsoft Outlook folders
Hard Code
Collecting & entering data in on bounces for a website. Boss told me to put in a “hard Code” for a site with no data for this category. Should I average the last 3 months of data & use that for the “hard code”. What’s meant by a hard code?
Answer Question
| June 6, 2012 2:25 PM
hard code
Collecting & entering data in on bounces for a website. Boss told me to put in a “hard Code” for a site with no data for this category. Should I average the last 3 months of data & use that for the “hard code”. What’s meant by a hard code?
Answer Question
| June 6, 2012 2:25 PM
hard code
As400
i need to convert folling rpgle code into rpg EVAL CMDKEY = %TRIMR(CMDKEY) + ‘ ‘ + F6COM
Answer Question
| June 7, 2012 2:14 PM
AS400 Data Definitions
i need to convert folling rpgle code into rpg EVAL CMDKEY = %TRIMR(CMDKEY) + ‘ ‘ + F6COM
Answer Question
| June 7, 2012 2:14 PM
AS400 Data Definitions
mails received in hieroglyphs instead of Cyrillic symbols in Lotus Notes 8.5
User receives externail email (with POP3/IMAP4 protocol) to his LN mailbox with hieroglyphs instead of Cyrillic symbols. If you send this email to the Exchange email it’s ok to view – Cyrillic as Cyrillic without any kind of cracky symbols. I have tried searching everywhere about this but tough luck..
Answer Question
| June 6, 2012 2:05 PM
Lotus Notes client applications
User receives externail email (with POP3/IMAP4 protocol) to his LN mailbox with hieroglyphs instead of Cyrillic symbols. If you send this email to the Exchange email it’s ok to view – Cyrillic as Cyrillic without any kind of cracky symbols. I have tried searching everywhere about this but tough luck..
Answer Question
| June 6, 2012 2:05 PM
Lotus Notes client applications
How to add a text box within a option group on a form?
I need help trying to add a text box to my option group on Access 2010. Within my option group I have it listed: Materials Labor Heat Rate Other: (text box) Or at least thats how I want it, but as I input the information to the “other” text box, it shows up on ALL [...]
Answer Question
| June 5, 2012 1:19 PM
Microsoft Access 2010, Microsoft Access forms
I need help trying to add a text box to my option group on Access 2010. Within my option group I have it listed: Materials Labor Heat Rate Other: (text box) Or at least thats how I want it, but as I input the information to the “other” text box, it shows up on ALL [...]
Answer Question
| June 5, 2012 1:19 PM
Microsoft Access 2010, Microsoft Access forms
Recompile CL program
Hi, We added few new fields to an exising Physical file. When I check for the dependents for the changed Physical file in ALDON it shows 250 dependent objects. Do I need to recompile all 250 objects? Thanks, Elan
Answer Question
| June 6, 2012 1:18 PM
AS/400, CL Program
Hi, We added few new fields to an exising Physical file. When I check for the dependents for the changed Physical file in ALDON it shows 250 dependent objects. Do I need to recompile all 250 objects? Thanks, Elan
Answer Question
| June 6, 2012 1:18 PM
AS/400, CL Program
CL/QMQRY
i hav code STRQMQRY QMQRY(SQLPROC) OUTPUT(*OUTFILE) + OUTFILE(QTEMP/SQLDT) In SQLProc txt file i am callin a sql procedure , developed using i series navigator and return data set using cursor. i want this cursor output in qtemp/sqldt file. in sqlproc if i mentioned SELECT statment , then it will work fine, but i want [...]
Answer Question
| June 7, 2012 12:16 PM
AS/400, QMQRY, SQL procedure
i hav code STRQMQRY QMQRY(SQLPROC) OUTPUT(*OUTFILE) + OUTFILE(QTEMP/SQLDT) In SQLProc txt file i am callin a sql procedure , developed using i series navigator and return data set using cursor. i want this cursor output in qtemp/sqldt file. in sqlproc if i mentioned SELECT statment , then it will work fine, but i want [...]
Answer Question
| June 7, 2012 12:16 PM
AS/400, QMQRY, SQL procedure
Crystal 8.5 export trouble
My Application is developed in Vb6,Sqlserver2003 and crystal report 8.5.this application is well run on windows XP,Server2003 etc. but now we are Shift our OS to Server 2008 R2 32 bit. application running well but when I trying to export reprot(i.e click on export button of the crystal report) suddenly application going to crash.I cant [...]
Answer Question
| June 5, 2012 9:48 AM
Crystal Reports 8.5, SQL Server 2003
My Application is developed in Vb6,Sqlserver2003 and crystal report 8.5.this application is well run on windows XP,Server2003 etc. but now we are Shift our OS to Server 2008 R2 32 bit. application running well but when I trying to export reprot(i.e click on export button of the crystal report) suddenly application going to crash.I cant [...]
Answer Question
| June 5, 2012 9:48 AM
Crystal Reports 8.5, SQL Server 2003
CL Programming
PGM DCL VAR(&TIME) TYPE(*CHAR) LEN(6) DCL VAR(&DATE) TYPE(*CHAR) LEN(6) DCL VAR(&YEAR) TYPE(*CHAR) LEN(2) RTVSYSVAL SYSVAL(QTIME) RTNVAR(&TIME) [...]
Answer Question
| June 7, 2012 9:36 AM
AS/400, PGM
PGM DCL VAR(&TIME) TYPE(*CHAR) LEN(6) DCL VAR(&DATE) TYPE(*CHAR) LEN(6) DCL VAR(&YEAR) TYPE(*CHAR) LEN(2) RTVSYSVAL SYSVAL(QTIME) RTNVAR(&TIME) [...]
Answer Question
| June 7, 2012 9:36 AM
AS/400, PGM
Cisco 1841 NTP configuration and sync
Hi, I have configured a cisco 1841 to sync with a ntp server. after entering the ntp command, show ntp status says that it is not yet synchronized but on show clock details shows that it is already configured based on the ntp server. These are the result of show commands and the running config [...]
Answer Question
| June 5, 2012 3:36 AM
Cisco 1841, NTP Configuration
Hi, I have configured a cisco 1841 to sync with a ntp server. after entering the ntp command, show ntp status says that it is not yet synchronized but on show clock details shows that it is already configured based on the ntp server. These are the result of show commands and the running config [...]
Answer Question
| June 5, 2012 3:36 AM
Cisco 1841, NTP Configuration
How to create an Outlook system that automatically achieves team email conversations using rules and public folders.
I’m trying to set up a Outlook system using rules and public folders that does the following: 1) Allows members of a team to “tag” an email conversation so all future emails from that conversation will be copied to a public folder.
Answer Question
| June 5, 2012 1:02 AM
Microsoft Outlook 2007, Microsoft Outlook folders
I’m trying to set up a Outlook system using rules and public folders that does the following: 1) Allows members of a team to “tag” an email conversation so all future emails from that conversation will be copied to a public folder.
Answer Question
| June 5, 2012 1:02 AM
Microsoft Outlook 2007, Microsoft Outlook folders
