• 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:
  • Date Time Error in VB

    I have created a programme in VB6. It was running properly in Windows XP but now I have got a Windows 7 machine. At first due to the date format of windows 7 it was giving runtime error after changing the date format of machine it was running properly but as soon as I enter the date in date box it...

    rayansen10 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:
  • Migrating from Crystal Reports 11 to Crystal Server 2011

    Currently trying to configure Crystal Server 2011 to work with an existing crystal report, which resides on a separate server. We ultimately want users to be able to run reports from a web portal. I tried reading the documentation but the migration process is only documented for versions of Crystal...

    sysengineer5 pointsBadges:
  • Create duplicate of first detail line

    Hi I extract data from our ERP to show an order detail, to use with printing bar codes. The bar code software always ignores the first line, ao I am looking for a method to duplicate the first detail line only. For example I want: DB100 x 10 DB100 x 10 DB101 x 12 DB103 x 2 Instead of: DB100 x 10...

    Lewej5 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:
  • Formula Workshop gives me an error but no description of the error…

    Trying to run a report in Crystal Reports XI, and it pops up the Formula Workshop with the Error section populated with one of the formulas, but there's absolutely no text anywhere telling me why it threw the error.  Is there a way to find out what's wrong?

    Beaker19745 pointsBadges:
  • Query Engine Error – If tables are already linked then join type cannot change

    I recevied this error when I added a table to an exisiting report. I didn't change any joins.

    CherylinJax5 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:
  • Crystal Reports Error Message

    I haven't used CR for quite some time. I just tried to edit a portion of the report to change it to our company name. The error message is: The number of decimal places is too large or not an integer.

    Almeo20005 pointsBadges:
  • Date parameters within crystal reports 8.5 still brining up all records

    Hi, I have created a date parameter as I would like to be able to view absence within the company during certain dates. When I run the parameter it still brings up all the records. Is anyone able to help?

    Ajmx5 pointsBadges:
  • Crystal Report Problem With .net4

    [table] [tbody] [tr] [td class="votecell"> 0 down vote favorite [/td] [td class="postcell"> I Before Work With Crystal Report In .net 3.5 And Lowest Version But As Since Work With .net4 Get Face With Error " Error 5 The type or namespace name 'CrystalDecisions' could not be found (are you missing a...

    AliGogLos5 pointsBadges:
  • How do you use multiple member files in Crystal Reports?

    i have to retreive data from as400 iseires files that have multiple members and most do not have a logical for that member without creating a new logical is there anyway to tell crystal reports to use a certain member ?

    tcuccaro40 pointsBadges:
  • Crystal Reports Paradox Tables – data problems

    I am creating a report in Crystal XI using multiple paradox tables. If I use an idapi connection I lose data when I access the second table. If I switch to a DAO connection it runs very slow locally and will not event connect at all if I try to access the data from a data server. It must run off...

    Bdsystems5 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