Crystal Reports deleting the line dynamically
I created a report, in which I have on the header address line. for example. Ammi Dep 92-11 22 Ave Elmont, LI 11373 but some customer could have Ammi Dep 92-11 22 Ave Apt # 2A Elmont NY 11373. but what is happening right now is that when a customer doesnt have an apartment number [...]
Answer Question
| April 25, 2008 10:06 PM
Crystal Reports
I created a report, in which I have on the header address line. for example. Ammi Dep 92-11 22 Ave Elmont, LI 11373 but some customer could have Ammi Dep 92-11 22 Ave Apt # 2A Elmont NY 11373. but what is happening right now is that when a customer doesnt have an apartment number [...]
Answer Question
| April 25, 2008 10:06 PM
Crystal Reports
Crystal Reports group name
I have created a crystal reprot. There I have a group which has two values , either “Yes’ or “NO” these values are coming from the database. Now on the group name, when the value = ‘Yes’ then groupname should be “Existing customer” and if value=’No’ then groupname should be ” Not Customer” so can [...]
Answer Question
| March 15, 2012 10:02 PM
Crystal Reports
I have created a crystal reprot. There I have a group which has two values , either “Yes’ or “NO” these values are coming from the database. Now on the group name, when the value = ‘Yes’ then groupname should be “Existing customer” and if value=’No’ then groupname should be ” Not Customer” so can [...]
Answer Question
| March 15, 2012 10:02 PM
Crystal Reports
Looking for commercial software that does data driven subscriptions for SQL Server Reporting Services
Is there any commercially available supported software that does data driven subscriptions for Reporting Services? This is the *only* feature we need from the enterprise edition and we are looking for alternatives to paying MS $30,000 just to get this one capability.
Answer Question
| May 22, 2008 1:52 PM
Business intelligence software, SQL Server Reporting Services
Is there any commercially available supported software that does data driven subscriptions for Reporting Services? This is the *only* feature we need from the enterprise edition and we are looking for alternatives to paying MS $30,000 just to get this one capability.
Answer Question
| May 22, 2008 1:52 PM
Business intelligence software, SQL Server Reporting Services
Convert report to HTML and tag using invoice number
Using Crystal Report, I have imported the database to a created form, now I wish to export to HTML and create individual invoices using the invoice number as the document name in order to create a search engine to call up the required invoice. How do I create the proper tag or invoice name for [...]
Answer Question
| April 24, 2008 3:01 PM
Crystal Reports, HTML, Web development
Using Crystal Report, I have imported the database to a created form, now I wish to export to HTML and create individual invoices using the invoice number as the document name in order to create a search engine to call up the required invoice. How do I create the proper tag or invoice name for [...]
Answer Question
| April 24, 2008 3:01 PM
Crystal Reports, HTML, Web development
Formula workshop – using AND/OR
Using the formula workshop, I am trying to display all records from 10am to 11am that have EITHER data in “field A” OR data in “field B”. What is returned are records in the correct time frame (10am-11am), that have data in the “field A”, however the records that have no data in “field A” [...]
Answer Question
| April 24, 2008 7:09 PM
Crystal Reports, Formula Workshop
Using the formula workshop, I am trying to display all records from 10am to 11am that have EITHER data in “field A” OR data in “field B”. What is returned are records in the correct time frame (10am-11am), that have data in the “field A”, however the records that have no data in “field A” [...]
Answer Question
| April 24, 2008 7:09 PM
Crystal Reports, Formula Workshop
Territory code in UDB DB2 database
A reader wrote in with this question: <i>Can you explain the meaning of the territory code when creating a db2 udb database? Certain documentation say that the territory code determines the way dates are displayed but I’ve experimented by creating several databases with different territory codes but I don’t see any difference when using these [...]
Answer Question
| September 23, 2009 4:54 PM
DB2, Territory Codes
A reader wrote in with this question: <i>Can you explain the meaning of the territory code when creating a db2 udb database? Certain documentation say that the territory code determines the way dates are displayed but I’ve experimented by creating several databases with different territory codes but I don’t see any difference when using these [...]
Answer Question
| September 23, 2009 4:54 PM
DB2, Territory Codes
DB2 indexes and Crystal Reports
Is it possible to access DB2 (V5R1) indexes from the Visual Linking Expert screen in Crystal Reports(8) and if so how?
Answer Question
| September 23, 2009 10:31 AM
AS/400 DB2, Crystal Reports, Crystal Reports 8, DB2, Indexes, V5R1
Is it possible to access DB2 (V5R1) indexes from the Visual Linking Expert screen in Crystal Reports(8) and if so how?
Answer Question
| September 23, 2009 10:31 AM
AS/400 DB2, Crystal Reports, Crystal Reports 8, DB2, Indexes, V5R1
How i can use CVS on my system
How i can use Content Versioning System (CVS) on my system. I don’t know anything about CVS but i have to use it.
Answer Question
| April 22, 2008 5:55 AM
Content management, CVS
How i can use Content Versioning System (CVS) on my system. I don’t know anything about CVS but i have to use it.
Answer Question
| April 22, 2008 5:55 AM
Content management, CVS
Alternative to FTP for file transfer to iSeries (AS/400)
I’ve been tasked with attempting to find a better alternative to FTP for transfering files from an FTP server to the iSeries. The files being transferred are based on a server that is being replaced and the manager of infrasturucture does not wish to put FTP on the new box. The current process uses FTP [...]
Answer Question
| April 24, 2008 6:49 PM
AS/400, AS/400 FTP, File transfers, FTP
I’ve been tasked with attempting to find a better alternative to FTP for transfering files from an FTP server to the iSeries. The files being transferred are based on a server that is being replaced and the manager of infrasturucture does not wish to put FTP on the new box. The current process uses FTP [...]
Answer Question
| April 24, 2008 6:49 PM
AS/400, AS/400 FTP, File transfers, FTP
How to pass Parameter of stored procedure Crystal report
How to pass parameter of Crystal report from visual Basic while crystal report created with stored procedure
Answer Question
| April 16, 2008 12:42 PM
Crystal Reports, Stored Procedures, VB, Visual Basic
How to pass parameter of Crystal report from visual Basic while crystal report created with stored procedure
Answer Question
| April 16, 2008 12:42 PM
Crystal Reports, Stored Procedures, VB, Visual Basic
Virtual Directory
How to perform operations in IIS without logging in as administrator user. e.g creating virtual directory, assigning permissions to a virtual directory and so on.
Answer Question
| February 3, 2009 9:46 AM
IIS, Network administration, Virtual directory
How to perform operations in IIS without logging in as administrator user. e.g creating virtual directory, assigning permissions to a virtual directory and so on.
Answer Question
| February 3, 2009 9:46 AM
IIS, Network administration, Virtual directory
Eenabling full outer join option in crystal report
When i use Crystal Report 10, i alwaya found FULL OUTER JOIN option as disable. How to enable this option ?
Answer Question
| April 19, 2008 9:32 AM
Crystal Reports, Database, FULL OUTER JOIN
When i use Crystal Report 10, i alwaya found FULL OUTER JOIN option as disable. How to enable this option ?
Answer Question
| April 19, 2008 9:32 AM
Crystal Reports, Database, FULL OUTER JOIN
Return or print more than one date
Basically i have two dates suppose minDate and maxDate, Just i want to find diff in day..If both dates are same then i want to return mindate and if difference is there then then i want to return all dates from mindate to maxDate..How to do this?Please help me
Answer Question
| May 8, 2008 3:47 PM
Crystal Reports
Basically i have two dates suppose minDate and maxDate, Just i want to find diff in day..If both dates are same then i want to return mindate and if difference is there then then i want to return all dates from mindate to maxDate..How to do this?Please help me
Answer Question
| May 8, 2008 3:47 PM
Crystal Reports
Data Migration Betrieve Tables to MS SQL Server 2005
Hi! could somebody help us advice on what to do and what to prepare if we are going to migration our current database Betrieve tables to MS SQL Server 2005? Thanks. Note: We are currently accessing the Betrieve tables thru PervasiveSQL v8 engine.
Answer Question
| May 8, 2008 8:10 AM
Data migration, Database migration, Migration, Pervasive, SQL Server 2005, SQL Server migration
Hi! could somebody help us advice on what to do and what to prepare if we are going to migration our current database Betrieve tables to MS SQL Server 2005? Thanks. Note: We are currently accessing the Betrieve tables thru PervasiveSQL v8 engine.
Answer Question
| May 8, 2008 8:10 AM
Data migration, Database migration, Migration, Pervasive, SQL Server 2005, SQL Server migration
Crystal Report Problem in VB6
I am using VB6 with back ground Database DB2 AS400 iSerices and Crystal Report 9.0. When I Show the Report Its prompt me to enter password. I have tried to find the solution and found some thing about LogOnServer but every example is there for Crystal Report 7,8, and 8.5. I have tried to use [...]
Answer Question
| April 14, 2008 6:49 AM
AS/400 DB2, Crystal Reports, VB
I am using VB6 with back ground Database DB2 AS400 iSerices and Crystal Report 9.0. When I Show the Report Its prompt me to enter password. I have tried to find the solution and found some thing about LogOnServer but every example is there for Crystal Report 7,8, and 8.5. I have tried to use [...]
Answer Question
| April 14, 2008 6:49 AM
AS/400 DB2, Crystal Reports, VB
FICO ECC 4.7 versus ECC 6.0
What is the difference in terms of FICO functionality between SAP ECC 4.7 versus ECC 6.0? Thanks.
Answer Question
| June 18, 2008 3:33 AM
ECC4, ECC6, SAP FICO
What is the difference in terms of FICO functionality between SAP ECC 4.7 versus ECC 6.0? Thanks.
Answer Question
| June 18, 2008 3:33 AM
ECC4, ECC6, SAP FICO
Staffing Projects
We are finding it difficult to staff our projects through the use of traditional job boards. What sources have other hiring managers found successful in identifying competent IT resources to fill Software Development and Business Analyst position to work on J2EE / open-source projects?
Answer Question
| May 31, 2008 5:40 PM
Business Analysts, J2EE, JasperServer, Java, JBoss, JUnit, Mule, Open source, Software Engineers
We are finding it difficult to staff our projects through the use of traditional job boards. What sources have other hiring managers found successful in identifying competent IT resources to fill Software Development and Business Analyst position to work on J2EE / open-source projects?
Answer Question
| May 31, 2008 5:40 PM
Business Analysts, J2EE, JasperServer, Java, JBoss, JUnit, Mule, Open source, Software Engineers
I sthere a need for Cognos ReportNET with SAP BI?
We made the decision to use Cognos ReportNet several years ago as the web front end to SAP’s BW system. We made that decision as SAP’s tools appeared weak and not very user friendly. I hear that SAP has made strides in there formally weak areas and It would be good to hear if anyone [...]
Answer Question
| May 19, 2008 3:39 PM
Cognos, SAP, SAP BI, SAP BW
We made the decision to use Cognos ReportNet several years ago as the web front end to SAP’s BW system. We made that decision as SAP’s tools appeared weak and not very user friendly. I hear that SAP has made strides in there formally weak areas and It would be good to hear if anyone [...]
Answer Question
| May 19, 2008 3:39 PM
Cognos, SAP, SAP BI, SAP BW
Crystal Reports newbie has a question
I am an intern at my company and I *think* I have to use Crystal Reports to complete one of my projects. I will start by explaining what I need done. I would like to know if it is possible, and if it is, how I would go about doing it. I am building a [...]
Answer Question
| April 9, 2008 1:01 PM
Crystal Reports, Web development
I am an intern at my company and I *think* I have to use Crystal Reports to complete one of my projects. I will start by explaining what I need done. I would like to know if it is possible, and if it is, how I would go about doing it. I am building a [...]
Answer Question
| April 9, 2008 1:01 PM
Crystal Reports, Web development
LogOnServer Problem in Crystal Report
I am using VB6 with back ground Database DB2 AS400 iSerices and Crystal Report 9.0. When I Show the Report Its prompt me to enter password. I have tried to find the solution and found some thing about LogOnServer but every example is there for Crystal Report 7,8, and 8.5. I have tried to use [...]
Answer Question
| April 8, 2008 11:35 AM
AS/400 DB2, Crystal Reports, VB
I am using VB6 with back ground Database DB2 AS400 iSerices and Crystal Report 9.0. When I Show the Report Its prompt me to enter password. I have tried to find the solution and found some thing about LogOnServer but every example is there for Crystal Report 7,8, and 8.5. I have tried to use [...]
Answer Question
| April 8, 2008 11:35 AM
AS/400 DB2, Crystal Reports, VB
