Crystal Reports XI: Multi-Level subreports?
A subreport can never have a subreport in any version of Crystal. A main report can have several subreports, however.
View Answer
| March 5, 2009 8:38 PM
Crystal Reports, Crystal Reports Subreport, Crystal Reports XI, Crystal Reports XI Subreport
A subreport can never have a subreport in any version of Crystal. A main report can have several subreports, however.
View Answer
| March 5, 2009 8:38 PM
Crystal Reports, Crystal Reports Subreport, Crystal Reports XI, Crystal Reports XI Subreport
How to Determine Database Access on AS/400
It’s the object security that’s important DSPOBJAUT mylib/myfile Individuals/Groups/*PUBLIC may be granted use/change and when you press F11 it steps through more details ie: read/change/delete exist (they could delete the actual file) alteer to change the file structure etc. Phil Hi, You should also check the settings on the user profiles. If the user profile [...]
View Answer
| March 5, 2009 4:59 PM
AS/400 database, AS/400 Permissions, DB2, DB2/400, iSeries database, JD EDWARDS, JDE
It’s the object security that’s important DSPOBJAUT mylib/myfile Individuals/Groups/*PUBLIC may be granted use/change and when you press F11 it steps through more details ie: read/change/delete exist (they could delete the actual file) alteer to change the file structure etc. Phil Hi, You should also check the settings on the user profiles. If the user profile [...]
View Answer
| March 5, 2009 4:59 PM
AS/400 database, AS/400 Permissions, DB2, DB2/400, iSeries database, JD EDWARDS, JDE
Database Connection Error
You are probably calling a stored procedure (PRC_RI_REPORT) that does not exist in the package xxx in the Oracle database. If you are sure that both the package and the procedure exist, you may need to grant execute privileges to the package, and call the procedure this way if the connected user is not the [...]
View Answer
| March 4, 2009 2:36 PM
Crystal Reports, Crystal Reports Database, Crystal Reports error messages, Database Connection Error
You are probably calling a stored procedure (PRC_RI_REPORT) that does not exist in the package xxx in the Oracle database. If you are sure that both the package and the procedure exist, you may need to grant execute privileges to the package, and call the procedure this way if the connected user is not the [...]
View Answer
| March 4, 2009 2:36 PM
Crystal Reports, Crystal Reports Database, Crystal Reports error messages, Database Connection Error
2009LT-Opening drawings from Windows Explorer
This is a known issue with 2009LT PreUpdates. What updates have you applied? I would start with Autodesks Update 1 which can be found here http://usa.autodesk.com/adsk/servlet/ps/dl/item?siteID=123112&id=11581572&linkID=9240618 and then update 2 which can be found here http://images.autodesk.com/adsk/files/autocad_2009_and_autocad_lt_2009_update_2.html You can read more about the features and fixes here http://heidihewett.blogs.com/my_weblog/autocad_2009/
View Answer
| February 26, 2009 5:56 PM
AutoCAD, AutoCAD 2009, AutoCAD Errors, AutoCAD Multiple Sessions, Windows Explorer
This is a known issue with 2009LT PreUpdates. What updates have you applied? I would start with Autodesks Update 1 which can be found here http://usa.autodesk.com/adsk/servlet/ps/dl/item?siteID=123112&id=11581572&linkID=9240618 and then update 2 which can be found here http://images.autodesk.com/adsk/files/autocad_2009_and_autocad_lt_2009_update_2.html You can read more about the features and fixes here http://heidihewett.blogs.com/my_weblog/autocad_2009/
View Answer
| February 26, 2009 5:56 PM
AutoCAD, AutoCAD 2009, AutoCAD Errors, AutoCAD Multiple Sessions, Windows Explorer
Find out what is in dbms_sql cursor
One option could be to write the statement to a file, using the UTL_FILE package, but it is possible that a similar limitation also exists in that package. I would use a loop to display the statement (using dbms_output) in 254 byte substrings. —————————
View Answer
| February 25, 2009 11:26 PM
DBMS, DBMS_SQL, Dynamic SQL, Oracle
One option could be to write the statement to a file, using the UTL_FILE package, but it is possible that a similar limitation also exists in that package. I would use a loop to display the statement (using dbms_output) in 254 byte substrings. —————————
View Answer
| February 25, 2009 11:26 PM
DBMS, DBMS_SQL, Dynamic SQL, Oracle
Sparklines in Word or Excel
If I understood correctly you want to summarize the document. There is option Auto summarize under Tool menu. Kindly reply if this is helpful. Regards Sarfaraz Ahmed <a href=”http://findsarfaraz.blogspot.com”> MS Excel help </a>
View Answer
| February 25, 2009 10:51 AM
Excel 2003, Microsoft Excel, Microsoft Word, Office 2003, Sparklines, Word 2003
If I understood correctly you want to summarize the document. There is option Auto summarize under Tool menu. Kindly reply if this is helpful. Regards Sarfaraz Ahmed <a href=”http://findsarfaraz.blogspot.com”> MS Excel help </a>
View Answer
| February 25, 2009 10:51 AM
Excel 2003, Microsoft Excel, Microsoft Word, Office 2003, Sparklines, Word 2003
ERP system
Ok, I’ll take a stab. Have a separate product number for the rejected item and have alternate bom for the production product which include x% of the rejected item. As the product is being rejected, have a receipt transaction for the product. ************************************************************************************************************************** This situation is common in some industries, so what I can share [...]
View Answer
| February 24, 2009 5:17 PM
ERP, ERP manufacturing, Quality assurance, Quality control
Ok, I’ll take a stab. Have a separate product number for the rejected item and have alternate bom for the production product which include x% of the rejected item. As the product is being rejected, have a receipt transaction for the product. ************************************************************************************************************************** This situation is common in some industries, so what I can share [...]
View Answer
| February 24, 2009 5:17 PM
ERP, ERP manufacturing, Quality assurance, Quality control
Install QMF V9
there is a lot here
View Answer
| February 23, 2009 12:06 AM
QMF, QMF Objects, QMF V8, QMF V9
there is a lot here
View Answer
| February 23, 2009 12:06 AM
QMF, QMF Objects, QMF V8, QMF V9
As400 File Transfer to Windows
Use the iSeries Navigator which should have been installed with Client Access or FTP the file.
View Answer
| February 20, 2009 11:59 PM
AS/400 Client Access, AS/400 File Transfer, Client Access, File transfers
Use the iSeries Navigator which should have been installed with Client Access or FTP the file.
View Answer
| February 20, 2009 11:59 PM
AS/400 Client Access, AS/400 File Transfer, Client Access, File transfers
Single Page subfile for duplicate records
Hi S22 You’ve chosen to create tricky little piece of code. The duplicate records make it impossible to find your place if you move the record pointer in other processing. So any other processing should be by another access path. When you initially load the subfile you probably read one extra record so you can [...]
View Answer
| February 20, 2009 7:10 PM
Duplicate records, Subfile
Hi S22 You’ve chosen to create tricky little piece of code. The duplicate records make it impossible to find your place if you move the record pointer in other processing. So any other processing should be by another access path. When you initially load the subfile you probably read one extra record so you can [...]
View Answer
| February 20, 2009 7:10 PM
Duplicate records, Subfile
Installing SAP on Windows Vista Basic
Hello Sir, To proceed ahead, please check with HP if they have necessary drivers for your computer compatible with Windows XP. Once they confirm that they have drivers. Get a Windows XP CD and follow manual to install Windows XP. Note: Kindly ensure that you backup all required data before you proceed with installation. I [...]
View Answer
| February 19, 2009 10:01 AM
Dual booting, ECC4, ECC6, SAP ECC, SAP installation, Vista compatibility, Windows XP
Hello Sir, To proceed ahead, please check with HP if they have necessary drivers for your computer compatible with Windows XP. Once they confirm that they have drivers. Get a Windows XP CD and follow manual to install Windows XP. Note: Kindly ensure that you backup all required data before you proceed with installation. I [...]
View Answer
| February 19, 2009 10:01 AM
Dual booting, ECC4, ECC6, SAP ECC, SAP installation, Vista compatibility, Windows XP
Setting up PHP environment – CGI vs Module
Moderator Note: I’m not a professional developer but I’m a hobbyist dabbling in various Web development projects. You may be reading about security and performance issues and wondering the best route to go. My personal preference is a host that uses <a href=”http://httpd.apache.org/docs/1.3/suexec.html”>PHPSuExec</a>. Some resources you may wish to browse: <a href=”http://ca.php.net/manual/en/security.cgi-bin.php”>PHP Manual – Installed [...]
View Answer
| February 17, 2009 3:30 PM
Apache modules, CGI, PHP, PHP installation
Moderator Note: I’m not a professional developer but I’m a hobbyist dabbling in various Web development projects. You may be reading about security and performance issues and wondering the best route to go. My personal preference is a host that uses <a href=”http://httpd.apache.org/docs/1.3/suexec.html”>PHPSuExec</a>. Some resources you may wish to browse: <a href=”http://ca.php.net/manual/en/security.cgi-bin.php”>PHP Manual – Installed [...]
View Answer
| February 17, 2009 3:30 PM
Apache modules, CGI, PHP, PHP installation
Ensuring the same data is served when using multiple load balanced servers
their is a lot of solution. First do a cluste with both http server. and your load balencer will distribute the load. that is the most effective and reliable solution second use a tool like double take to replicate online data between servers. it acts like a cluster software but you can desable the failover [...]
View Answer
| February 16, 2009 9:46 PM
Data Replication, FTP, HTTP, Load balancer, Load balancing, Storage management
their is a lot of solution. First do a cluste with both http server. and your load balencer will distribute the load. that is the most effective and reliable solution second use a tool like double take to replicate online data between servers. it acts like a cluster software but you can desable the failover [...]
View Answer
| February 16, 2009 9:46 PM
Data Replication, FTP, HTTP, Load balancer, Load balancing, Storage management
Monitoring and management of real time RPO and RTO
I see you don’t have much grasp of the english language. The answer is no, it’s not, you will fail, so give up your outsourcing contract now to save face. No ! this will not be the solution.Rather I would expect to have opinions, ideas or experienced scenarios. It it is not possible then what [...]
View Answer
| February 14, 2009 7:44 AM
Disaster Recovery, Disaster recovery and business continuity, Disaster recovery services, Disaster recovery software, Recovery Point Objective, Recovery Time Objective
I see you don’t have much grasp of the english language. The answer is no, it’s not, you will fail, so give up your outsourcing contract now to save face. No ! this will not be the solution.Rather I would expect to have opinions, ideas or experienced scenarios. It it is not possible then what [...]
View Answer
| February 14, 2009 7:44 AM
Disaster Recovery, Disaster recovery and business continuity, Disaster recovery services, Disaster recovery software, Recovery Point Objective, Recovery Time Objective
Easytrieve: Blank page before report data printed
Check your printer properties and see if it is set to include a separator page. This puts a blank page between jobs so multiple users can easily separate their print jobs from each other.
View Answer
| February 13, 2009 8:59 PM
Easytrieve, Easytrieve Printing
Check your printer properties and see if it is set to include a separator page. This puts a blank page between jobs so multiple users can easily separate their print jobs from each other.
View Answer
| February 13, 2009 8:59 PM
Easytrieve, Easytrieve Printing
Microsoft Word error
The error message tells you your problem: “c;usersdonnadocuments 02.jpg”.file may be in use by another app or fileformat not supp by any of the installed converters, or file may be corrupt. The file type of the document you are trying to open in a JPG or a picture file. Pictures can be inserted into a word [...]
View Answer
| February 13, 2009 1:57 PM
File formats, Microsoft Word
The error message tells you your problem: “c;usersdonnadocuments 02.jpg”.file may be in use by another app or fileformat not supp by any of the installed converters, or file may be corrupt. The file type of the document you are trying to open in a JPG or a picture file. Pictures can be inserted into a word [...]
View Answer
| February 13, 2009 1:57 PM
File formats, Microsoft Word
Does Oracle Stream data replication requires identical tables structure between source and Target Databases?
This is really a question of requirements and possibilities. I am presuming that you have looked over the High Availability and Replication documentation and you are looking for something more flexible. In Streams, there are no explicit constraints for table design or structure. Yes, you can have different PKs in tables of two databases. That [...]
View Answer
| February 10, 2009 7:04 PM
Data Replication, Oracle Stream Data Replication, Oracle Streams, Oracle Table
This is really a question of requirements and possibilities. I am presuming that you have looked over the High Availability and Replication documentation and you are looking for something more flexible. In Streams, there are no explicit constraints for table design or structure. Yes, you can have different PKs in tables of two databases. That [...]
View Answer
| February 10, 2009 7:04 PM
Data Replication, Oracle Stream Data Replication, Oracle Streams, Oracle Table
Bare minimum templates for Project Management
Jaideep, you may wish to visit this website below. This page provides a wide variety of downloadable forms sorted into IT Project Management categories. Forms, Templates and Checklists <a href=”http://www.ittoolkit.com/qtools_listing.html”>Project Management and IT Planning Tools</a> Welcome to the directory of our free, fill-in form planning tools. Each checklist, template, and scorecard is produced in PDF [...]
View Answer
| February 10, 2009 1:31 PM
IT project management, Project management, Project management templates
Jaideep, you may wish to visit this website below. This page provides a wide variety of downloadable forms sorted into IT Project Management categories. Forms, Templates and Checklists <a href=”http://www.ittoolkit.com/qtools_listing.html”>Project Management and IT Planning Tools</a> Welcome to the directory of our free, fill-in form planning tools. Each checklist, template, and scorecard is produced in PDF [...]
View Answer
| February 10, 2009 1:31 PM
IT project management, Project management, Project management templates
ASP.NET and Multiple Access Databases Open
That is possible, but I would recommend you close the database connection after you get the information that you need from each. Open Connection Get Data from database Close Connection Work with data
View Answer
| February 9, 2009 8:19 PM
.NET applications, ASP.NET, Concurrent database connections, Concurrent users, Database connectivity, Microsoft Access, Multiple databases, Web development
That is possible, but I would recommend you close the database connection after you get the information that you need from each. Open Connection Get Data from database Close Connection Work with data
View Answer
| February 9, 2009 8:19 PM
.NET applications, ASP.NET, Concurrent database connections, Concurrent users, Database connectivity, Microsoft Access, Multiple databases, Web development
Is SATA II disks adequate for running VMs
If you aren’t going to be placing a lot of load on the disks then SATA II should be fine. I would use two disks for the host OS, and not one because if that one disk fails you will have lost the OS, and all your VMs will be offline until you get the [...]
View Answer
| February 8, 2009 8:13 PM
Hyper-V, Hyper-V on Windows Server 2008, SAS disks, SATA 2, SATA 2 disks, SATA hard drives, Serial Attached SCSI, Virtual Machines, Windows Server 2008
If you aren’t going to be placing a lot of load on the disks then SATA II should be fine. I would use two disks for the host OS, and not one because if that one disk fails you will have lost the OS, and all your VMs will be offline until you get the [...]
View Answer
| February 8, 2009 8:13 PM
Hyper-V, Hyper-V on Windows Server 2008, SAS disks, SATA 2, SATA 2 disks, SATA hard drives, Serial Attached SCSI, Virtual Machines, Windows Server 2008
