Solved

Crystal Reports SQL expression

Posted on 2009-04-08
2
536 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
[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
2 Comments
 
LVL 77

Accepted Solution

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

Author Closing Comment

by:edmacey
ID: 31567929
Brilliant thanks
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

Hi, In my previous Article  (http://www.experts-exchange.com/Database/Reporting/A_15199-Introduction-to-Microstrategy.html)I discussed some basic understanding of Microstrategy that how we can get in Intro of Microstrategy (MSTR). Now it's tim…
Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …

690 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