Solved

Looking to add SQL Query to a crystal Report.

Posted on 2014-11-12
4
162 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 100

Accepted Solution

by:
mlmcc earned 250 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 250 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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
I'm trying, I really am. But I've seen so many wrong approaches involving date(time) boundaries I despair about my inability to explain it. I've seen quite a few recently that define a non-leap year as 364 days, or 366 days and the list goes on. …
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

710 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