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
Solved

Looking to add SQL Query to a crystal Report.

Posted on 2014-11-12
4
144 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
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

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

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

In database programming, custom sort order seems to be necessary quite often, at least in my experience and time here at EE. Within the realm of custom sorting is the sorting of numbers and text independently (i.e., treating the numbers as number…
'Between' is such a common word we rarely think about it but in SQL it has a very specific definition we should be aware of. While most database vendors will have their own unique phrases to describe it (see references at end) the concept in common …
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

840 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