开发者

Crystal Reports PostgreSQL inet query

开发者 https://www.devze.com 2023-01-13 05:53 出处:网络
I\'m trying to create a report that allows a user 开发者_如何学运维to select a branch that they want to view traffic for in Crystal Reports 11.

I'm trying to create a report that allows a user 开发者_如何学运维to select a branch that they want to view traffic for in Crystal Reports 11.

The data type in question is of the inet data type in PostgreSQL, I cannot change it. Because of this, it appears as though the "Like" operator will not work correctly.

About the Inet Data Type: http://www.postgresql.org/docs/8.2/static/functions-net.html

It would be simple if I could get crystal reports to simply use the "<<" operator as defined on the PostgreSQL site, but I cannot figure out how to do this. Is it possible to force the SQL query to use a specific operator instead of Crystal Reports narrow, and completely insufficient selection?


Can you use a stored procedure from Crystal Reports? If so, just wrap your query inside a stored procedure and return the result to CR.

0

精彩评论

暂无评论...
验证码 换一张
取 消