AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Not Null In Crystal3/30/2021
You already have an active moderator alert for this content.If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details.When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources.
Also, please make sure that you answer complies with our Rules of Engagement. Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total. I wasted several days struggling on providing data for dynamic parameter until I read it today. A Command is a SQL Select statement that the user can write to extract data for a report. To determine whether a Command can be created for a specific type of connection, open the connection in Crystal; the first line under the name of the open connection will be Add Command. So, for example, when connecting to MS SQL Server, the getDate() function is used to get the current date but in Oracle it would be SysDate. Crystal formulas cannot be used in a command, so any calculations or filters must use SQL syntax. Instead, all of the data from the Command along with all of the data from the tables is pulled into memory and Crystal will process the join. With inner joins, this will frequently mean that much more data is brought into memory than will actually be used on the report. As a consequence, joining Commands to tables or other Commands can significantly slow down report processing. Just like when a Command is joined to tables or other Commands, this can significantly slow down report processing. Instead, the syntax of the SQL Expression should be used in the Command itself as either an additional field or in the Where clause. The Command Editor cannot see parameters that are created in the Field Explorer for the report. However, in the Command Editor only the Parameter Name, Prompting Text, Value Type, Default Value, and whether the prompt allows multiple values can be set. ![]() In this way the parameter can be made dynamic and almost any other properties can be set. Instead, I generally use a default of All (the asterisk causes this to sort to the top in dynamic parameters) to indicate that all values should be selected. The parameters will not show any field values until after the Command has been run. In general, ALL dynamic parameters for reports that are running in BO or CRS should be created and managed in the Business View Manager its more efficient and allows for parameters to be reused instead of recreating them for every report. Not Null In Crystal How To Do ThisAt some point in the future I plan to post a blog that walks through how to do this. Crystal will throw a warning that this is generally not supported. This warning can be ignored because this type of configuration is supported for this purpose. Especially since there are things that can be done in a Command that cannot be done when linking tables in Crystal. For example, it is possible to filter dated data to show only the most recent date, use a Having clause to show only data that meets a certain summary threshold, work with Union queries, or even pivot data so that it can be shown as if it were a cross-tab without actually using a cross-tab. Just about anything that can be done in a SQL query in a database can be done in a Command, which makes it a powerful tool for reporting. Ive been using Crystal for over 19 years and I avoid CR4E when I can I just cant make it sing like I can classic Crystal because the features just arent there.
0 Comments
Read More
Leave a Reply. |