Topic: Save data returned from query into Crystal Posted: 01 Aug 2013 at 1:11am
I have a simple question: Is possible to save somehow data returned from a query and then later use in teh Formula Expert. My idea is to write simple queries like SELECT * FROM table_name and than later on process this data in the Crystal environment!
Crystal command?! My idea is to read data from DB (using a simle query) and instead of complicating a query (which must be compatibile in Oracle and SQL server)really write a simple SELECT and save the returned data in a Crystal structure/memory and than later prepare/sort/modifiy my "simple" data in Formula Editor and only then display the data onto a report!
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 02 Aug 2013 at 4:21am
you can "save data" with a report by setting that as an option in your report set up. However it will refresh the data when it is rerun so if your source has changed it will update the data in the report. Crystal is not a repository for data, it is used to display data only.
Aha OK I got it this "save data". Also reflects the file size when you save the report. This are only displayed data.
But yeah "Crystal is not a repository for data, it is used to display data only" are the words which I don't wanted to hear... but I will try to speak with my boss 4 another solution...
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
IP Logged
