Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Selecting/Using data from first member of a group Post Reply Post New Topic
<< Prev Page  of 2
Author Message
cbaldwin
Groupie
Groupie


Joined: 09 Apr 2014
Online Status: Offline
Posts: 81
Quote cbaldwin Replybullet Posted: 31 Mar 2017 at 5:05am
Failed to retrieve data from database.
ORA 00905 missing keyword
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 31 Mar 2017 at 5:06am
what is your data source type and where did you try to use this?

Edited by DBlank - 31 Mar 2017 at 5:07am
IP IP Logged
cbaldwin
Groupie
Groupie


Joined: 09 Apr 2014
Online Status: Offline
Posts: 81
Quote cbaldwin Replybullet Posted: 31 Mar 2017 at 5:15am
We have an oracle database.
I inserted the SQL script into a Crystal Command table. When i attempt to save the Crystal Command table i get this error.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 31 Mar 2017 at 5:18am
Sorry, I assumed you were using sql.
I don't use oracle but I know the syntax is different.

Anyone else want to jump in for the correct syntax on this (assuming the logic still applies to that source type)?
IP IP Logged
cbaldwin
Groupie
Groupie


Joined: 09 Apr 2014
Online Status: Offline
Posts: 81
Quote cbaldwin Replybullet Posted: 31 Mar 2017 at 5:35am
Thank you very much for your time and effort.
IP IP Logged
<< Prev Page  of 2
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.