?
Solved

Crystal Reports SQL expression

Posted on 2009-04-08
2
Medium Priority
?
558 Views
Last Modified: 2012-05-06
I am following the guide from www.ml-consult.co.uk/cryst-06.htm

The guide says to create sql expressions in the subreport (the data is coming from tables from Outlook's calendar).
However the sql expressions section isn't present in the field explorer for this data source.

Am I able to just create regular formulas?

The sql expressions should be

{fn dayofweek('Appointments'.'Appointment Date')}

When I tried in formulas dayofweek{Apppointments.Appointment Date} the error returned was "The remaining text does not appear to be part of the formula" referring to the expression inside {}.

I am running crystal reports 2008 (v 12)

Any thoughts? Thanks Ed.
0
Comment
Question by:edmacey
2 Comments
 
LVL 77

Accepted Solution

by:
peter57r earned 2000 total points
ID: 24095081
dayofweek({Apppointments.Appointment Date} )
0
 

Author Closing Comment

by:edmacey
ID: 31567929
Brilliant thanks
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
I recently went through setting up a JasperReports Server using the AWS EC2 instance, and this article will cover some basic administration tasks I had to perform.
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…
Suggested Courses
Course of the Month15 days, 20 hours left to enroll

850 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