Skip to Content

Should I change to SAP Crystal Reports for Visual Studio?

Hi, everybody

This is my first post on this forum.

I have developed several reports for SAP Business One using Crystal Reports version for SAP Business One,

Despite some bugs in the software, I am very happy with the report writer, as I can do practically everything I want.

However, there is something that is a bit annoying: In CR version for SAP B1, it is not possible to pass blank parameters.

We must enter all the parameters on the parameter screen.

I have developed a report which has numerous sub-reports.

Depending on which report the user needs, certain parameters may be unnecessary.

Unfortunately, CR version for SAP B1 does not accept blank parameters, so I must force the user to input some dummy parameters (which are not used at all in his report).

I have never used Crystal Reports version for Visual Studio, but I have read a bit on the forum.

I am familiar with Visual Studio, and SAP SDK.

My Questions:

(1) I use Management Studio, SQL and Crystal Reports to design reports that nearly always use SAP tables.

Which version of Crystal Reports would be more appropriate for my work? version for SAP B1 or version for Visual Studio?

(2) Is it possible for Crystal Reports version for Visual Studio to accept blank parameters?

(3) What advantages would there be using CR for VS rather than CR for SAP B1?

Added

(4) Are there things that CR for SAP B1 can do that CR for VS cannot ?

Thanks

Leon

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Aug 10, 2016 at 04:49 AM

    Hi Leon,

    You should be able to pass blank parameters unless the parameter is coming from Stored Procedure.

    There will be no different between the two CR version.

    Regards

    Edy

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 09, 2016 at 08:09 PM

    Hi Leon,

    I moved your post to the B1 forums.

    B1 uses CR for VS runtime but it is not up to date, B1 only supports a specific version and the database drivers are not included in the standard CR for VS redist packages.

    You could however try the test app I wrote for parameters, you'll likely have to comment out some of the code since the B1 SDK may not have it yet.

    Not sure how they distribute the runtime, and I believe it is 64 bit only so set your project to 64 bit mode and then search for KBA 2281780 which directs you to a DOC with the app attached.

    See if that works for you, you may have to copy over the 64 bit DB drivers maybe... I don't know exactly how B1 places or uses the CR for VS .NET SDK.

    Hope this helps?

    Don

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.