• 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,...

    Gamblersgobroke75 pointsBadges:
  • Crystal Reports – How to force page break

    I have a report that I am designing that requires that a new page be generated if a property has more than 6 occupants as the form will allow for 6 listings and if there are more, a second page needs to be generated. Does anyone know how to do this in Crystal? The version that I am using is 10....

    PAuser0 pointsBadges:
  • 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.

    TracyReid10 pointsBadges:
  • 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 can...

    WoodEngineer6,425 pointsBadges:
  • 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 their...

    AVLJACKIE5 pointsBadges:
  • 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?

    DebbieB7310 pointsBadges:
  • Crystal Report Error

    The error is: "The page size was not large enough to format the contents of an object in the report".

    DebbieB7310 pointsBadges:
  • 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.

    BoatsTours0 pointsBadges:
  • 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...

    dyarosh5 pointsBadges:
  • 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

    tcuccaro40 pointsBadges:
  • 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?

    nelsont5 pointsBadges:
  • 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

    hh4ever265 pointsBadges:
  • 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?

    af15 pointsBadges:
  • Micrsoft Dynamics GP – Reporting Tool

    My company has been bought over and we are moving from INFOR Aurora to MS Dynamics GP. As part of the move, I am to retrain as a management reporting person. The 'new' system currently runs Crystal reports but they are open to looking at other reporting tools. My question is - Is Crystal the best...

    KasMcc230 pointsBadges:
  • 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...

    wrgaff5 pointsBadges:
  • Extract part of a field in crystal reports

    I need to be able to extract part of a field to use in a crystal report. For example: my account # is any number of digits with a - followed by another number. I just want the numbers in front of the -. If the account = 1234-1 i want it to return 1234. if the accoutn = 123-23 i want 123. How can i...

    Gisles5 pointsBadges:
  • Convert string to number

    In Cyrstal reports, how do i convert a string to a number

    Starrbound10 pointsBadges:
  • 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...

    Jazzvirg5 pointsBadges:
  • Exception Join in Crystal Reports

    How do I create an expection join in Crystal Reports 11. That is, I want ONLY the rows in FILEA that do not have a row in FILEB when joining them on FIELDX

    GregInAtl35 pointsBadges:
  • Stored Procedure and crystal reports resources

    Can anyone please tell me where to buy store procedure and crystal reports book in one.  Thanks.

    Khanhhoa5 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following