Sending a print job to two separate printers using VB 6
I have prepared a Restaurant Software in VB 6.0 and Access 2001. I have to print a prepaid bill in two copies (one for customer and another for kitchen). One epson lq 300+ printer is attached in LPT1: port and another in USB001:port. I printed the Bill through LPT1: port and I could not print [...]

Answer Question   |  January 12, 2009  3:34 PM
Crystal Reports, Crystal Reports printing, Printers, Software development, Visual Basic 6, Visual Basic printing

Printing a Crystal report – paper size
I have an application that uses Crystal reports 10 on a Citrix environment. Suddenly, when trying to print the report from the screen the printer defaults to a strange size of paper (12′ x 18′) when the printer settings are correctly setup for Letter. ANy ideas?

Answer Question   |  January 9, 2009  9:41 PM
Crystal Reports, Crystal Reports printing

DB2 SQL Confusion
I am failing to understand why the following won’t work SELECT m.index, SUM(d1.amt), SUM(d2.amt) FROM master m, detail d1, detail d2 WHERE m.index = d1.index AND m.index = d2.index AND d2.qalif = 1 GROUP BY m.index I wrote another sql that does work, I just don’t understand why I get higher values on SUM(d2.amt) than [...]

Answer Question   |  January 9, 2009  4:46 PM
DB2, DB2 SQL, SQL

AutoCAD
which function should you enable to make your cursor behave magnetically toward specific points?

Answer Question   |  January 11, 2009  10:12 PM
AutoCAD, Autocad 2007

How do I get a message to show when the report doesn’t return any data?
It’s been a couple of years since I’ve worked directly with Crystal so need a little help. I am in the process of writing some technical specifications for reports that will be developed in Crystal. If a report is ran and no data meets the criteria of the report we want to display a message [...]

Answer Question   |  February 16, 2009  9:47 PM
Crystal Reports, Crystal Reports Errors

Slow JDBC DB2 Connection
Hello, Having an issue with a new server we are setting up. The server is Linux RHE 4, running DB2 8.1 and Domino 7.03. Our DB2 databases reside an a separate dedicated DB2 server and are cataloged on our new server. Connections to these databases are working fine using SQL tools and from the server [...]

Answer Question   |  January 8, 2009  9:12 PM
DB2, DB2 8.1, DB2 8.x, DB2 Performance, Domino 7.0.3, Domino 7.x, JDBC, Linux RHE 4

converting a point shapefile to a polyline shapefile
When in arcmap i have a point file with latitude and longitude points, how do i convert those points into a polyline shapefile while keeping the attributes from the point file? I know that i can creat a new shapefile and make the line myself however it wont get the same attributes as the point [...]

Answer Question   |  January 8, 2009  7:11 PM
ArcMap, ESRI, polyline, Shapefile

dw testing tools
what testing tools are available for data warehouse testing

Answer Question   |  January 8, 2009  4:23 PM
Data Warehouse Testing, Data warehouses, QA testing

Acrobat Pro 7 to 9 upgrade problem – shared network folder creation
We used Acrobat Pro 7 for collaboration by using shared internal network folders. When we recently upgraded to Pro V9, we cannot create the shared network folders anymore. We use XP and MSO 2003. Tried Adobe support, didn’t help. Key is assistance in creating a network folder on a shared corporate drive to enable pdf [...]

Answer Question   |  January 8, 2009  2:12 PM
Adobe Acrobat, Adobe Acrobat 9 Pro, Microsoft Office, Office 2003, Windows XP

Is there a way of checking remote PCs to see how much of the hard drive is taken up with MS Office documents?
I would like to run a report that tells me how much space on all our user’s laptops is taken up with MS Office files (Excel, Powerpoint, Word). Currently a lot of our laptop users are saving their data to the local HDD and we would like to get them to back up this data [...]

Answer Question   |  August 10, 2009  11:46 AM
Backup and recovery software, hard disk storage, Microsoft Office, Remote PCs, Remote users, Reports

Customizing AutoCAD 2007 using VB.NET
Hi Sir, I am able to open autocad using vb.net. Now i want to add an object(text or image) to this autocad file and customize the font, color, orientation etc through vb.net code . Can anybody help me to get a code for this. Thanks a lot in advance

Answer Question   |  January 8, 2009  7:35 AM
Autocad 2007, VB.NET 2005, Visual Basic .NET

Crystal Reports can’t connect to Access 2007
We have just upgraded from Access 2003 to Access 2007 and CR-XI can not see the dB’s. I think it is the new file extensions with Access 2007. Anyone know how I can connect and see the dB’s.

Answer Question   |  January 8, 2009  8:58 PM
Access 2007, Crystal Reports, Crystal Reports XI, Crystal reports Xi to Access 2007, Microsoft Access

Code to upload CSV file to AS400
I am looking for code to convert .CSV file to AS400 automatically. I need to automate this feature. Thanks in advance.

Answer Question   |  January 7, 2009  5:46 PM
CSV, CSV to AS400

Data Area Lock issue in RPG ILE
Hi, I am using a data area in a RPG ILE program which will lock the data area and updates value. If the data area is locked, the program has to unlock the data area which is locked by the same user in any of his other session. Is it possible? If yes, please let [...]

Answer Question   |  January 13, 2009  9:54 AM
Data Area, Data Area Lock, RPG, RPG ILE

Performance impact by using GUID instead of sequence as primary key
Is there anyone has experience on using GUID as the primary key in the data model of a huge data warehouse? What is the impact of the performance compare with the sequencial surrogate key in Oracle 10g or higher version?

Answer Question   |  January 6, 2009  6:46 PM
Data Model Primary Key, Data warehouse, GUID

Duplicate Record formula in Crystal 11
I have a formula written as such: If onfirstrecord then {CHART_IMPORT_ERROR.ERROR_MESSAGE} else If {CHART_IMPORT_ERROR.ERROR_MESSAGE} = previous({CHART_IMPORT_ERROR.ERROR_MESSAGE}) then “”"” else {CHART_IMPORT_ERROR.ERROR_MESSAGE} Currently ” is showing up if the record above is a duplicate. However, I would like it to display nothing instead of “. I’d prefer it to actually count the number of duplicates but I [...]

Answer Question   |  January 6, 2009  5:00 PM
Crystal Reports 11, Crystal Reports Duplicate Records

Query/physical file headings
Hi, I have a query that creates a file. I transfer the file to my C drive as a cvs file that I send out to a vendor. He would like headings on the file…..I can’t seem to find out how to do this…..I know this is a silly question but how can I get [...]

Answer Question   |  January 16, 2009  4:19 PM
CVS, Microsoft Excel, Physical File

Reporting problem when dates contain zeros in the same field
Using AcuODBC and creating simple lists involving dates, ie, termination date in an employee file. When I select only records that (in this case) do NOT have a valid date in the TERM-DAT I select no records at all. The data is a signed decimal 8 characters with a valid sign. Crystal seems to not [...]

Answer Question   |  January 6, 2009  1:06 AM
AcuODBC, Crystal Reports

PlanView software migration
We are migrating from 7.4.1 to Enterprise 9.2. How should we prepare for this migration? What questions should we ask?

Answer Question   |  January 5, 2009  4:51 PM
PlanView, PlanView 7.4.1, PlanView Enterprise 9.2, PlanView Migration, Portfolio Management

conditional formatting in crystal reports 8.5
I have a field that is the result of a runtime calculation that i’ve formatted as a percentage. when the value is > 1, i want it to show as n%. when the value is zero, i want it to show as -. i’ve got the customized format to work as long as the value [...]

Answer Question   |  January 9, 2009  3:35 PM
Crystal Reports, Crystal Reports 8.5, Crystal Reports Conditional Formatting