Sequel IF and Else statements
I’m a newbie to Sequel and I’m trying to recreate some old Crystal Reports using Sequel. My question is: how does the IF, Else statement work in Sequel? This is the statement for Crystal, for a Termination report, we have six companies and if an employee transfers to one of our other companies, we need [...]
Answer Question
| April 30, 2013 2:40 PM
AS/400, Crystal Reports
I’m a newbie to Sequel and I’m trying to recreate some old Crystal Reports using Sequel. My question is: how does the IF, Else statement work in Sequel? This is the statement for Crystal, for a Termination report, we have six companies and if an employee transfers to one of our other companies, we need [...]
Answer Question
| April 30, 2013 2:40 PM
AS/400, Crystal Reports
Crystal Reports: Sum by certain date
I need to sum gift amounts based on the specific date a solicitor was assigned to the account.IE: One account has given gifts since 2/25/1999 however the solicitor for this account was not assigned until 5/15/2002. I want to sum all gifts this account has given since 5/15/2002.
Answer Question
| March 18, 2013 2:16 PM
Crystal Reports, Crystal Reports formulas
I need to sum gift amounts based on the specific date a solicitor was assigned to the account.IE: One account has given gifts since 2/25/1999 however the solicitor for this account was not assigned until 5/15/2002. I want to sum all gifts this account has given since 5/15/2002.
Answer Question
| March 18, 2013 2:16 PM
Crystal Reports, Crystal Reports formulas
Crystal Report through Java
How to generate a Crystal Report through Java by using MS-Access 2003. Steps for generating the report through Java.back end MS-Access2003.
Answer Question
| June 19, 2013 5:04 AM
Crystal Reports, Java
How to generate a Crystal Report through Java by using MS-Access 2003. Steps for generating the report through Java.back end MS-Access2003.
Answer Question
| June 19, 2013 5:04 AM
Crystal Reports, Java
Block Crystal Reports from iSeries access
We have a user who wants to use Crystal Reports to access data on an MS SQL server. She also has access to view limited data on the iSeries using an iSeries application with built-in security. How can we prevent her from accessing data on the iSeries using Crystal Reports. Is there a service we [...]
Answer Question
| March 11, 2013 12:37 AM
Crystal Reports, iSeries
We have a user who wants to use Crystal Reports to access data on an MS SQL server. She also has access to view limited data on the iSeries using an iSeries application with built-in security. How can we prevent her from accessing data on the iSeries using Crystal Reports. Is there a service we [...]
Answer Question
| March 11, 2013 12:37 AM
Crystal Reports, iSeries
Inventory transaction using Crystal Reports Visual and SQL
I have created a report with all parts in our warehouse with part location, qty and transaction dates. Since there are various locations with qty(or no qty) and various transaction dates linked to them, I can not max and get the info I need. I need all parts that have qty (or no qty) in [...]
Answer Question
| March 7, 2013 3:53 PM
Crystal Reports, SQL
I have created a report with all parts in our warehouse with part location, qty and transaction dates. Since there are various locations with qty(or no qty) and various transaction dates linked to them, I can not max and get the info I need. I need all parts that have qty (or no qty) in [...]
Answer Question
| March 7, 2013 3:53 PM
Crystal Reports, SQL
Adding field to Crystal Report, all data disappears
I have a Crystal Report. I have a user defined field. When I add this field to my report, nothing is displayed. What’s the problem?
Answer Question
| March 5, 2013 4:08 PM
Crystal Reports, Crystal Reports fields
I have a Crystal Report. I have a user defined field. When I add this field to my report, nothing is displayed. What’s the problem?
Answer Question
| March 5, 2013 4:08 PM
Crystal Reports, Crystal Reports fields
Crystal Report Error
The error is: “The page size was not large enough to format the contents of an object in the report”.
Answer Question
| February 19, 2013 1:45 PM
Crystal Reports, Crystal Reports Errors
The error is: “The page size was not large enough to format the contents of an object in the report”.
Answer Question
| February 19, 2013 1:45 PM
Crystal Reports, Crystal Reports Errors
Crystal Reports
I am trying to filter sales by the date of sale and having a whale of a time. I have a few years worth of sales data, but just want to see what was sold on a specific data Saturday for instance. Looking for any formula help for Crystal Reports.
Answer Question
| February 6, 2013 12:03 PM
Crystal Reports, Crystal Reports formulas
I am trying to filter sales by the date of sale and having a whale of a time. I have a few years worth of sales data, but just want to see what was sold on a specific data Saturday for instance. Looking for any formula help for Crystal Reports.
Answer Question
| February 6, 2013 12:03 PM
Crystal Reports, Crystal Reports formulas
How to suppress page header when a specific section prints
I have a report that basically is a letter and only contains data for one record. The report contains multiple subreports which print records that are related to the single record in the main report. The last subreport is in Detail Section 11. This subreport is setup to start each record on a new page. [...]
Answer Question
| February 1, 2013 1:33 PM
Crystal Reports, VS 2010
I have a report that basically is a letter and only contains data for one record. The report contains multiple subreports which print records that are related to the single record in the main report. The last subreport is in Detail Section 11. This subreport is setup to start each record on a new page. [...]
Answer Question
| February 1, 2013 1:33 PM
Crystal Reports, VS 2010
Examples of AS/400 create alias in Crystal Reports
Can someone give me an example of Crystal Reports create alias using AS/400 file? Thanks! Tony
Answer Question
| January 31, 2013 3:02 PM
AS/400, Crystal Reports
Can someone give me an example of Crystal Reports create alias using AS/400 file? Thanks! Tony
Answer Question
| January 31, 2013 3:02 PM
AS/400, Crystal Reports
Limit on Number of Records Returned by a Query
Are you familiar with a Crystal Reports issue that will not allow a report to return over a certain number of records? In our case, the number is 8500 records. Both Crystal and the database being queried are on a remote server, I suppose that some throttle is set for performance reasons?
Answer Question
| November 2, 2012 8:17 PM
Crystal Reports, Crystal Reports Record
Are you familiar with a Crystal Reports issue that will not allow a report to return over a certain number of records? In our case, the number is 8500 records. Both Crystal and the database being queried are on a remote server, I suppose that some throttle is set for performance reasons?
Answer Question
| November 2, 2012 8:17 PM
Crystal Reports, Crystal Reports Record
crystal reports
i have table inn my crystal report at the testing phase an cell contained very long paragraph and that caused the report to skip half of the page and add the long record to new page . how can i let the report behave in the right way like Excel for example. thanks in advance
Answer Question
| October 21, 2012 12:17 PM
Crystal Reports
i have table inn my crystal report at the testing phase an cell contained very long paragraph and that caused the report to skip half of the page and add the long record to new page . how can i let the report behave in the right way like Excel for example. thanks in advance
Answer Question
| October 21, 2012 12:17 PM
Crystal Reports
Can’t link tables in Crystal Reports
I came a cross a wired scenario the other day. Although we could see all tables of a database in Crystal, we could not establish manual links. When right clicking on a field only ‘Browse’ option was available. The ‘Start link’ option was not visible. any ideas?
Answer Question
| October 16, 2012 10:19 PM
Crystal Reports, Crystal Reports Database
I came a cross a wired scenario the other day. Although we could see all tables of a database in Crystal, we could not establish manual links. When right clicking on a field only ‘Browse’ option was available. The ‘Start link’ option was not visible. any ideas?
Answer Question
| October 16, 2012 10:19 PM
Crystal Reports, Crystal Reports Database
CR Formula For Adjusting Time
I’m looking for a formula that will adjust a timestamp if the current timestamp is not within business hours. If the current timestamp is after 5:00PM the timestamp should increment the date portion by the correct number of days (Depending on Day of Week) and the time portion should be set to 8:00AM. Similarly if [...]
Answer Question
| August 27, 2012 9:50 PM
Crystal Reports, Crystal Reports 10
I’m looking for a formula that will adjust a timestamp if the current timestamp is not within business hours. If the current timestamp is after 5:00PM the timestamp should increment the date portion by the correct number of days (Depending on Day of Week) and the time portion should be set to 8:00AM. Similarly if [...]
Answer Question
| August 27, 2012 9:50 PM
Crystal Reports, Crystal Reports 10
Convert string to number
In Cyrstal reports, how do i convert a string to a number
Answer Question
| June 19, 2012 1:15 PM
Crystal Reports, Crystal Reports Formatting
In Cyrstal reports, how do i convert a string to a number
Answer Question
| June 19, 2012 1:15 PM
Crystal Reports, Crystal Reports Formatting
X Position in Crystal Reports
How to extract the X Position Adjustment of a text object (PH) in Crystal Reports Programmatically. I know Size and Positon Window is not accessible in .net environment but you can access it in Crystal Reports. I am tring to extract the formula behind the X Position Adjustment inside the textbox.. Any help would be of [...]
Answer Question
| May 29, 2012 5:03 PM
.NET, Crystal Reports
How to extract the X Position Adjustment of a text object (PH) in Crystal Reports Programmatically. I know Size and Positon Window is not accessible in .net environment but you can access it in Crystal Reports. I am tring to extract the formula behind the X Position Adjustment inside the textbox.. Any help would be of [...]
Answer Question
| May 29, 2012 5:03 PM
.NET, Crystal Reports
How to view Crystal Reports in Internet Explorer?
when i deploy my asp.net website on windows 7 with oracle 11g database in backend.I am using sap crystal report version 13.0.2000.0 It gives error as Unsupported Operation. A document processed by the JRC engine cannot be opened in the C++ stack.Description: An unhandled exception occurred during the execution of the current web request. Please [...]
Answer Question
| May 24, 2012 6:01 AM
Crystal Reports, Oracle 11g
when i deploy my asp.net website on windows 7 with oracle 11g database in backend.I am using sap crystal report version 13.0.2000.0 It gives error as Unsupported Operation. A document processed by the JRC engine cannot be opened in the C++ stack.Description: An unhandled exception occurred during the execution of the current web request. Please [...]
Answer Question
| May 24, 2012 6:01 AM
Crystal Reports, Oracle 11g
Crystal report asks for parameter at runtime eventhough supplied once..
Hi, I have a problem with crystal reports at runtime…… I have a desktop application in which I have used crystal report… When I run the application, crystal report asks for parameters like range of dates and some specific string names as input for the report generation, I have entered these values manually so that [...]
Answer Question
| February 27, 2012 11:49 AM
Crystal Reports, Crystal Reports parameters
Hi, I have a problem with crystal reports at runtime…… I have a desktop application in which I have used crystal report… When I run the application, crystal report asks for parameters like range of dates and some specific string names as input for the report generation, I have entered these values manually so that [...]
Answer Question
| February 27, 2012 11:49 AM
Crystal Reports, Crystal Reports parameters
Print string values on new page based on character count Crystal Reports
We have a report created with CR 11.5 and have a field for detailed instructions our sales staff can enter text into. It will grow to 1000 chars, but will overlap other text sections below. Other sections in the report have a graphical representation of the product and need to stay in same size. How [...]
Answer Question
| February 28, 2012 7:24 PM
.NET, Crystal Reports, formatting, Printing
We have a report created with CR 11.5 and have a field for detailed instructions our sales staff can enter text into. It will grow to 1000 chars, but will overlap other text sections below. Other sections in the report have a graphical representation of the product and need to stay in same size. How [...]
Answer Question
| February 28, 2012 7:24 PM
.NET, Crystal Reports, formatting, Printing
SAP Business Objects
Hi experts, I am new to SAP BOBJ. Can you please share some knowledges to start. My job description at the moment is to understand the Business Objects as I will be supporting Xcelsius, Crystal Reports, and Web Intelligence. Please throw me some light on this matter.
Answer Question
| February 28, 2012 5:38 PM
Crystal Reports, SAP BusinessObjects, Xcelsuis
Hi experts, I am new to SAP BOBJ. Can you please share some knowledges to start. My job description at the moment is to understand the Business Objects as I will be supporting Xcelsius, Crystal Reports, and Web Intelligence. Please throw me some light on this matter.
Answer Question
| February 28, 2012 5:38 PM
Crystal Reports, SAP BusinessObjects, Xcelsuis
