CODEWITHSUNDEEP
sql-servercrystal-reportsreport
Tshepo T-Man Machabaphala
Tshepo T-Man Machabaphala

Reputation: 11

Crystal Reports using vb.net 2008 and SQL Server database

I am busy with Crystal Reports, using vb.net 2008 with my SQL Server database, I'm seeing a problem here which I don't know how to solve. I've read somewhere about SQL Expression fields, they say they just appear under Field Explorer just like Formula Fields etc. But I cannot see it "SQL Expression Fields". Is there anyway I can add it to my Field explorer?

Upvotes: 0

Views: 1075

Answers (1)

campagnolo_1
campagnolo_1

Reputation: 2750

SQL Expression fields have to be created, just like formulas, they aren't "just there". You right-click on your Field Explorer "SQL Expression Fields" and choose "New". See this handy little link to give you more information and best practices. On the other hand, if you have more than one datasource in your report, SQL Expressions can not be used and you will not see the option in the Field Explorer.

Hope that helps,

Chris

Upvotes: 1

Related Questions