-
Sep 6th, 2003, 01:33 AM
#1
Thread Starter
New Member
How to execute SQL Statement in Crystal Reports Formula?
How to execute SQL Statement in Crystal Reports Formula?
I'm using Crystal Reports 8.x and I've a summary report which I want to insert a field into it. This field is not in the field list but I want to take it from the database table. So that's the reason why I want to execute the SQL Statement in the Crystal Report Formula.
Is it posible to do that? If it's possible to do, could you please show me how?
Thanks so much,
Sirisak K.
PS! I don't want to generate the complicate query for that field. But I want to use Crystal Report Formula to get it from the database table directly.
-
Sep 8th, 2003, 09:55 AM
#2
You can't execute a query in a Formula. Your best bet might be to add a subreport.
-
Sep 8th, 2003, 09:08 PM
#3
Fanatic Member
not sure if CR8 has sql expression fields, but in CR9 this is what you would be after i think. its in the field explorer window. just pop ur sql statement in there.
-
Sep 9th, 2003, 10:34 AM
#4
Lively Member
Is this field in another table or in the existing table ? If this field is in the existing table just validate your report against the database and it should show the field in the field explorer. Otherwise add the table or like bruce says use a subreport.
How can you use the sql expression option with tables or fields that are not include in the report.?
Do, or do not. There is no 'try'.
-
Sep 10th, 2003, 12:02 AM
#5
-
Sep 10th, 2003, 06:08 AM
#6
Lively Member
Magic..mmm..like pulling a rabbit out of a hat you mean..?
Do, or do not. There is no 'try'.
-
Sep 10th, 2003, 06:40 PM
#7
Fanatic Member
Select Rabbit FROM Hat WHERE RabbitInside = False ORDER BY Rabbit
TaDa, Recordcount = 1
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|