Skip to Content
author's profile photo Former Member
Former Member

SQL Update Commands & Dynamic Parameters

Hello all,

I'm currently using Crystal Reports 2008 for SYSPRO with SQL Server 2008 R2, which has brought me to this inquiry...

I would like to have a SQL Update Statement to run every time this report is opened for a particular job(s) that updates a value in a SQL table for the particular job(s). After much questioning and research, I've arrived at the conclusion of utilizing the Command feature in Crystal and adding one to my report, which might be exactly what I'm looking for.

The only unknown I'm dealing with is if it's at all possible to add the dynamic parameter from my report into the Command object which will run my SQL update statement.

Is this possible? Or is there another Crystal feature for this.

Any input will be greatly appreciated! 😊

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Jul 10, 2014 at 01:54 PM

    Hi James,

    Have a look at this blog from Jamie to understand how this could be started:

    Creating a Table of Contents (TOC) in a Crystal Report - some HANA sql, and some info on write-backs


    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Don Williams

      I've been in contact with them and one of their suggestions was to join this community and see what would be the most efficient way of doing this in Crystal (aside from command objects). I was able to make a successful SQL update statement within a command object (and accidentally ran it).

      If there's any way I can pass the dynamic report parameter to my command object and/or create a command parameter and have the two parameters talk to each other, I would be all set.

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.