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 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
How to generate a Crystal Report report through java by using MS-Access 2003. Steps for generating the report through Java.back end MS-Access2003.
Answer Question | March 18, 2013 5:04 AM
Crystal Reports, Java
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
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 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
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
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 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
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
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
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
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’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
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
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
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
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
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
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