Crystal Reports Formula
I am trying to seperate data in a field. For example the data in my field looks like this: Coldwell Banker Residential – IL – Waukegan…I need to get rid of everything before Waukegan. In other words I want it to display only the town. I can do it with the mid function, however, there [...]
Answer Question
| July 31, 2009 3:14 PM
Crystal Reports
I am trying to seperate data in a field. For example the data in my field looks like this: Coldwell Banker Residential – IL – Waukegan…I need to get rid of everything before Waukegan. In other words I want it to display only the town. I can do it with the mid function, however, there [...]
Answer Question
| July 31, 2009 3:14 PM
Crystal Reports
Learning SAS
I am an IT professional and student looking to learn SAS to see if it would be beneficial for my organization. Can anyone recommend a good book for this that includes a CD with a trial version of the software?
Answer Question
| August 25, 2009 12:28 PM
SAS, SAS Training
I am an IT professional and student looking to learn SAS to see if it would be beneficial for my organization. Can anyone recommend a good book for this that includes a CD with a trial version of the software?
Answer Question
| August 25, 2009 12:28 PM
SAS, SAS Training
Uploading an image for use in Optio
I need to upload a signature file onto our AS400 for use in an Optio layout. Does anyone know what steps I need to do to get the image file into a usable format on the AS400 so Optio can use it? Thanks in advance.
Answer Question
| July 30, 2009 2:39 PM
AS/400, Optio Software
I need to upload a signature file onto our AS400 for use in an Optio layout. Does anyone know what steps I need to do to get the image file into a usable format on the AS400 so Optio can use it? Thanks in advance.
Answer Question
| July 30, 2009 2:39 PM
AS/400, Optio Software
Formula setup on the crystal report
I want to generate error on the report viewer when sum of the specific column is not equal to the sum of the other specific column.How can i solve this?
Answer Question
| July 30, 2009 12:21 PM
Crystal Reports, Crystal Reports formulas
I want to generate error on the report viewer when sum of the specific column is not equal to the sum of the other specific column.How can i solve this?
Answer Question
| July 30, 2009 12:21 PM
Crystal Reports, Crystal Reports formulas
view data from ODBC to Crystal Reports
i am using Crystal Reports 10 to display data from ODBC. The error “Failed to open rowset. Details:HY000:
Answer Question
| July 29, 2009 7:14 AM
Crystal Reports, Crystal Reports 10, ODBC
i am using Crystal Reports 10 to display data from ODBC. The error “Failed to open rowset. Details:HY000:
Answer Question
| July 29, 2009 7:14 AM
Crystal Reports, Crystal Reports 10, ODBC
Find hidden subreport
How do I quickly find a hidden subreport in Crystal Reports.
Answer Question
| July 28, 2009 3:24 PM
Crystal Reports XI
How do I quickly find a hidden subreport in Crystal Reports.
Answer Question
| July 28, 2009 3:24 PM
Crystal Reports XI
Oracle 6i Log in – User-name & Password
What is the user-name and password of Oracle 6i to Log in?
Answer Question
| July 28, 2009 5:06 AM
Database Management Systems, Oracle 6i
What is the user-name and password of Oracle 6i to Log in?
Answer Question
| July 28, 2009 5:06 AM
Database Management Systems, Oracle 6i
I use crystal report version 1o
I want to bring a value fron a table, but the sales order is in one company and the shipment isi in other company (in the same database) how can I display dis value . I can display the the received name but not the global id number . asigned to this name this is [...]
Answer Question
| July 28, 2009 7:47 PM
Crystal Reports
I want to bring a value fron a table, but the sales order is in one company and the shipment isi in other company (in the same database) how can I display dis value . I can display the the received name but not the global id number . asigned to this name this is [...]
Answer Question
| July 28, 2009 7:47 PM
Crystal Reports
When I ran a SQL thru JCL and using DSNTIAUL/DSNTIB81 using PARMS(SQL), what kind of locks it puts on table in SELECT statement?
When I ran a SQL thru JCL and using DSNTIAUL/DSNTIB81 using PARMS(SQL), what kind of locks it puts on table in SELECT statement?
Answer Question
| July 27, 2009 5:23 PM
DB2
When I ran a SQL thru JCL and using DSNTIAUL/DSNTIB81 using PARMS(SQL), what kind of locks it puts on table in SELECT statement?
Answer Question
| July 27, 2009 5:23 PM
DB2
DBCS “open data type” problem – time-critical situation
BACKGROUND: We use a case tool to create simple file maintenance and inquiry programs over our core software’s database. The new release of our core software has added DBCS support, and has changed a lot of long fields which were formerly data type “A” to data type “O”. Our case tool is recognizing these as [...]
Answer Question
| December 30, 2009 4:12 PM
Data conversion, DBCS, Logical File, open data type
BACKGROUND: We use a case tool to create simple file maintenance and inquiry programs over our core software’s database. The new release of our core software has added DBCS support, and has changed a lot of long fields which were formerly data type “A” to data type “O”. Our case tool is recognizing these as [...]
Answer Question
| December 30, 2009 4:12 PM
Data conversion, DBCS, Logical File, open data type
Can’t open PDFs from certain websites
I am long-winded, so please bare with me! We are having trouble opening pdfs on certain websites. Currently PDPworks as well as one of our vendors who uses twelvehorses.com as a pdf server. We are unable to open a pdf from pdpworks at all and are hit and miss with opening pdfs from twelvehorses.com. The [...]
Answer Question
| February 8, 2011 3:59 PM
Adobe, Adobe Acrobat 6.0, Adobe Acrobat 9 Pro, adobe reader, Cisco PIX, firefox 3.5, Internet Explorer 7, Internet Explorer 8, Network management software, Network monitoring, Network Monitoring Tools, Network testing, Networking, PDF, PDF hyperlinks
I am long-winded, so please bare with me! We are having trouble opening pdfs on certain websites. Currently PDPworks as well as one of our vendors who uses twelvehorses.com as a pdf server. We are unable to open a pdf from pdpworks at all and are hit and miss with opening pdfs from twelvehorses.com. The [...]
Answer Question
| February 8, 2011 3:59 PM
Adobe, Adobe Acrobat 6.0, Adobe Acrobat 9 Pro, adobe reader, Cisco PIX, firefox 3.5, Internet Explorer 7, Internet Explorer 8, Network management software, Network monitoring, Network Monitoring Tools, Network testing, Networking, PDF, PDF hyperlinks
VB 6, SQL Server 2000 & Crystal Reports
i am a developer using VB 6 EE, SQL Server 2000 & Crystal Reports 7 and windows XP & Windows NT platforms. But now i installed Windows Vista. i installed VB 6 EE, but cant work with SQL Server 2000 or Crystal reports. can u please suggest me wat i need 2 do.
Answer Question
| July 28, 2009 3:54 PM
Crystal Reports, SQL Server 2000, VB 6 EE, VB6
i am a developer using VB 6 EE, SQL Server 2000 & Crystal Reports 7 and windows XP & Windows NT platforms. But now i installed Windows Vista. i installed VB 6 EE, but cant work with SQL Server 2000 or Crystal reports. can u please suggest me wat i need 2 do.
Answer Question
| July 28, 2009 3:54 PM
Crystal Reports, SQL Server 2000, VB 6 EE, VB6
MAKE A CRYSTAL REPORT PAGE BREAK ON A RECORD CRITERIA?
I have a report where certain records are set by a binary switch to print a bold text. I want to prevent these records from printing as the last record on a page. I have tried to do a record count and forcing a page shift if my true false criteria for the binary is [...]
Answer Question
| July 23, 2009 8:23 PM
Crystal Report XI
I have a report where certain records are set by a binary switch to print a bold text. I want to prevent these records from printing as the last record on a page. I have tried to do a record count and forcing a page shift if my true false criteria for the binary is [...]
Answer Question
| July 23, 2009 8:23 PM
Crystal Report XI
Crystal Reports 2008 & viewer 2008
We are Using Crystal Reports 2008 I create a report. My end users use Crystal Reports Viewer how can I enable the refresh button on the report to allow the user to up date the report viewer
Answer Question
| July 27, 2009 5:34 PM
Crystal Reports 2008, Crystal Reports Viewer
We are Using Crystal Reports 2008 I create a report. My end users use Crystal Reports Viewer how can I enable the refresh button on the report to allow the user to up date the report viewer
Answer Question
| July 27, 2009 5:34 PM
Crystal Reports 2008, Crystal Reports Viewer
Crystal reports, change recurrance pattern
Hi, I have some reports that automatically run through the Crystal Management Console. I need to turn off or remove recipients from some of these reports. I have gone into the Schedule tab for each report and changes the recurrance and recipients then updated the parameters. The problem is that my changes are not having [...]
Answer Question
| July 22, 2009 1:58 PM
Crystal Reports, recipients, recurrance, scheduled reports
Hi, I have some reports that automatically run through the Crystal Management Console. I need to turn off or remove recipients from some of these reports. I have gone into the Schedule tab for each report and changes the recurrance and recipients then updated the parameters. The problem is that my changes are not having [...]
Answer Question
| July 22, 2009 1:58 PM
Crystal Reports, recipients, recurrance, scheduled reports
Crystal Formula – Maximum of a Running Total/Count?
Hi Everyone, I have a Crystal Report with the usual group headers/footers & detail section. On my detail section I have a ‘running total’ it is a count function and it counts the number of lines based on a Unique Reference Number But my problem is that I want to get the Maximum of this [...]
Answer Question
| August 13, 2009 10:19 AM
COUNT, Crystal Count, Crystal Reports
Hi Everyone, I have a Crystal Report with the usual group headers/footers & detail section. On my detail section I have a ‘running total’ it is a count function and it counts the number of lines based on a Unique Reference Number But my problem is that I want to get the Maximum of this [...]
Answer Question
| August 13, 2009 10:19 AM
COUNT, Crystal Count, Crystal Reports
Find and Replace in subreport Crystal Reports
Why “FIND and REPLACE” function does not work in subreport?
Answer Question
| August 31, 2010 10:23 PM
Crystal Reports 8.5, Find and Replace, Subreports
Why “FIND and REPLACE” function does not work in subreport?
Answer Question
| August 31, 2010 10:23 PM
Crystal Reports 8.5, Find and Replace, Subreports
how to block update command when using STRSQL ( db2/400)?
Hi People , I got several analysts that they must only use Select command through STRSQL prompt, I found I can block update command changing the object authority but I have loads and load of tables to change, is there any easier way to do that?
Answer Question
| July 24, 2009 4:46 PM
AS/400, AS/400 DB2, DB2, STRSQL
Hi People , I got several analysts that they must only use Select command through STRSQL prompt, I found I can block update command changing the object authority but I have loads and load of tables to change, is there any easier way to do that?
Answer Question
| July 24, 2009 4:46 PM
AS/400, AS/400 DB2, DB2, STRSQL
Crystal Report How Can Protect For password My Crystal Report’s rpt File?
How Can Protect For password My Crystal Report’s rpt File?
Answer Question
| July 20, 2009 6:39 AM
Crystal Reports 8.5
How Can Protect For password My Crystal Report’s rpt File?
Answer Question
| July 20, 2009 6:39 AM
Crystal Reports 8.5
Crystal report xi parameters
I have created a paramteter for the user to select a date from a list of dates. I have also created two parameters for the user to select a begin and end date. For each date, i setup each date value as a formula using the DATEVALUE ({query.datefield}). I inserted the parameters on the report [...]
Answer Question
| July 20, 2009 11:43 PM
Crystal Report XI, Crystal Reports
I have created a paramteter for the user to select a date from a list of dates. I have also created two parameters for the user to select a begin and end date. For each date, i setup each date value as a formula using the DATEVALUE ({query.datefield}). I inserted the parameters on the report [...]
Answer Question
| July 20, 2009 11:43 PM
Crystal Report XI, Crystal Reports
