Crystal Reports XI Passing Shared Value back to main report from sub report
I managed to sort this out now, the formula I used was (in Basic syntax): shared dShar_Value as double formula = dShar_Value I placed this on the main report but made sure that the SubReport was placed in the Title section so that the subreport would return the value first. Can anyone tell me how [...]

View Answer   |  March 16, 2010  1:31 PM
Crystal Reports Subreports, Crystal Reports XI, Shared Variable

ERP
That depends on the ERP package. Each package will handle the process differently. What ERP package are you talking about?

View Answer   |  March 12, 2010  7:22 PM
ERP

refresh crystal reports XI using vb6
How about basing the report on a sql query. All you need to do then is refresh the underlying record set.

View Answer   |  March 9, 2010  10:03 PM
Crystal Reports, Crystal Reports XI, VB 6, Visual Basic

Data conversion
Ensuring integrity of your data is a BIG job during any sort of conversion. Converting from one structure to another, from one RDBMS to another, from some sort of flat data store to an RDBMS,… Let’s say you are converting from some non-RDBMS data store to an RDBMS. In the RDBMS you would want to [...]

View Answer   |  March 1, 2010  7:21 PM
Data conversion

Microsoft Access 2003 Report Footer Formula
Looks like the question got truncated, so here it is again. The problem seems to be with having a formula in the Report Footer section of the Report. It prompts for a Parameter Value when I try to switch to Print Preview. The formula is: =Avg ( [ Accuracy ] ) It prompts me to [...]

View Answer   |  February 26, 2010  3:30 PM
Microsoft Access 2003, Reports

Business Intelligence in a cloud environment
If you are using Windows Azure then you can use the <a href=”http://www.microsoft.com/windowsazure/developers/sqlazure/datasync/”>Azure Data Sync</a> app to sync data between your Azure database and your local SQL Server. It will all depend on your cloud provider and your BI solution.

View Answer   |  February 24, 2010  10:56 PM
BIaaS, Business Intelligence, Cloud Computing in 2010

Barcode and fingerprint biometrics
Finger biometrics is when you need your finger to be verified before you can access or do something. this is quite common for laptops or even accessing some buildings that are high on security. Barcodes are stuff that are on the food packaging that have lines and numbers on it. Here’s more information on both [...]

View Answer   |  May 17, 2013  4:19 PM
Barcode, Biometrics, fingerprint biometrics

Cisco Unified Communications Manager: Max logins per user?
<a href=”http://www.cisco.com/en/US/docs/voice_ip_comm/cucm/admin/8_0_1/ccmfeat/fsem.html#wp1241822″> You can set the service parameter to allow for multiple logins. If you set multiple login not allowed, Cisco Extension Mobility supports only one login at a time for a user. Subsequent logins on other devices will fail until the user logs out on the first device.</a> <a href=”http://www.cisco.com/en/US/docs/voice_ip_comm/cucm/admin/8_0_1/ccmfeat/fsem.html#wp1178338″>Setting the Service Parameters</a>

View Answer   |  February 20, 2010  3:09 PM
Cisco, Cisco Unified Communications Manager, Cisco Unified Communications Manager 6.1, Unified Communications Hardware

AUTHID in DB2
Since no description has been supplied for what behavior is desired, I can only guess at what is really wanted. From my limited understanding, “AUTHID DEFINER / CURRENT_USER” is better shown as:<pre> AUTHID [ DEFINER | CURRENT_USER ]</pre> The procedure is created so that it runs under the authorization ID of the DEFINER (creator) or [...]

View Answer   |  February 17, 2010  11:24 PM
AS/400 Authorization List, DB2, DB2 stored procedures

Querying multiple member PF with SQL
You have to know the name of the member. CREATE ALIAS on the PF to the specific member name. Then in SQL just SELECT FROM ALIAS. =========================================================== OVRDBF is appropriate for individual jobs. The override is temporary and does not affect other jobs. CREATE ALIAS creates a permanent “override” to a specific member. An ALIAS [...]

View Answer   |  February 15, 2010  6:07 AM
AS/400 SQL, DB2, Physical Files, SQL

different technical backgrounds
So that all aspects of the project are looked at and considered. If you are deciding what new database server to buy for an application you’ll want to talk to the systems admin so that you know that the hardware fits within the companies support standards, etc. You’ll want to talk to the database administrator [...]

View Answer   |  May 17, 2013  10:52 PM
Hardware Management, Software Management

Isolation level in iseries DB2
http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp?topic=/db2/rbafzmstisol.htm

View Answer   |  February 11, 2010  10:16 PM
AS/400 DB2, DB2

Link between Access & Crystal
http://www.ehow.com/how_4479367_access-database-crystal-reports-xi.html

View Answer   |  February 10, 2010  5:11 PM
Crystal Reports, Microsoft Access

Calling a URL length more than 200 from CLP
There is no “canned” command to do what you are describing. You could certainly create a command where the CPP (be it in CL or RPG) provides the application level function you generally describe. Bruce Vining <a href=”http://www.brucevining.com/”>Bruce Vining Services</a> ============================================ It’s just a stab, but maybe you could build on this: what about a [...]

View Answer   |  February 8, 2010  4:01 PM
AS/400 DB2, CLP, CLPROGRAM, DB2, RPG

Deleting an S36 file
Haven’t seen a s36 environment since ’98 but i think it’s the REMOVE command.

View Answer   |  February 4, 2010  4:39 PM
File management programs, iSeries, S/36

SELECT AND OMIT in RPGILE
%SCAN for checking a value in a field by using an Indicator at EQ , where it is existed or not . It gives first place where it found . %SUBST to extract a portion from a field . %EOF to check , whether the file reached to the bottom or not . %CHECK to [...]

View Answer   |  February 4, 2010  8:35 AM
DB2, RPGILE

Mainframe – Someone moving my DB2 Object to READ ONLY
“moving TS to READ ONLY” – as in “START DB(name) SPACE(name) ACCESS(READ)”? First, you might just ask around. Failing that… Only a userid with the proper authority can do this. Or an application bound by someone with the authority. an sqlid (userid) who is SYSADM, or DBADM, maybe DBMAINT, or an sqlid who is the [...]

View Answer   |  February 3, 2010  9:44 PM
DB2, iSeries objects, z/OS

What is the .iso format?
It is a disk image. You would have to use some software to “mount” that image, after which you will see it as if you had inserted a disk with the software you were downloading. ————— An ISO is an image of a CD or DVD. Most every CD burning software can take an ISO [...]

View Answer   |  February 3, 2010  9:16 PM
Disk image, File formats, ISO

DB2 (Oracle funtionality in)
DB/2 runs on three IBM “mainframes” but the instructions would be very different on each. What is your system i-series (AS/400), AIX, or a true mainframe? Phil

View Answer   |  February 2, 2010  2:36 AM
DB2, DB2 file system, File systems, Flat files

How do I transfer 300 gigs of information?? Please Help!!
For what it’s worth, you may consider disabling any realtime virus protection during the copies.

View Answer   |  February 1, 2010  2:32 AM
File transfers, unstoppable copier, Very Large Databases, western digital