Filtering not working on Crystal Report

SUGGESTED

Good day all,

We have a system that uses Crystal report for .NET frame 4.0 it used to work fine on that computer.

For instance, We normally filter by location, date, and other parameters report would bring up the correct information respectively.

However, there was an upgrade to Sage 100 and all of a sudden the filters although defined are no longer working. So let's say I chose NY as the location, it will bring up all locations as opposed to the one specified.

The filter work under the same user on other computers except for the computers with Sage 100 installed.

How can Fix this issue? Am I missing something?

Parents
  • 0
    SUGGESTED

    Hello  &  I was able to fix the problem.

    So to fix it I did the following:

    1. Close both Sage and NextGen Applications

    2. went to C:\Program Files (x86)

    3. Deleted the  SAP BusinessObjects

    4. Went to Add and Remove program

    5. remove all instances of Crystal Report installed

    6. Run CMD as an admin

    7. switch to the NextGen Directory

    8. Ran VCP /R command to register all components of NextGen

    9. Ran VCP by itself again once the first one was complete

    Ran a report in Sage successfully and also ran one in NextGen with the filters that wouldn't work before and it ran successfully.

    Thank you again for your comments.

  • 0 in reply to JR IT

    Thanks for info JR IT.  I'm going to file this away in my soltuions database.

    However,  what is VCP / VPC? 

Reply Children