?
Solved

Looking to add SQL Query to a crystal Report.

Posted on 2014-11-12
4
Medium Priority
?
203 Views
Last Modified: 2015-02-12
Looking to add below SQL query to crystal report.

select substring(messagetrackeddata, PATINDEX('%=%', MessageTrackedData)+1, (PATINDEX('%;Header%', MessageTrackedData)-PATINDEX('%=%', MessageTrackedData))-1)
from outboundx12messagelog where outboundx12messagekey = 589317
0
Comment
Question by:JDCam
2 Comments
 
LVL 101

Accepted Solution

by:
mlmcc earned 1000 total points
ID: 40437867
Is this to an existing report?

You can build reports based on a Crystal Command.
When you select the data source choose the ADD COMMAND
Enter the SQL
Crystal will run the SQL before the report opens

mlmcc
0
 
LVL 18

Assisted Solution

by:vasto
vasto earned 1000 total points
ID: 40437905
You can create also a view

select substring(messagetrackeddata, PATINDEX('%=%', MessageTrackedData)+1, (PATINDEX('%;Header%', MessageTrackedData)-PATINDEX('%=%', MessageTrackedData))-1)

Open in new window


and add it o the report
0

Featured Post

Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

PL/SQL can be a very powerful tool for working directly with database tables. Being able to loop will allow you to perform more complex operations, but can be a little tricky to write correctly. This article will provide examples of basic loops alon…
In this article, we will show how to detach and attach a database and then show how to repair a corrupt database and attach it, If it has some errors. We will show how to detach and attach using SSMS or using T-SQL sentences.
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

608 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question