There are a few important and helpful things to watch out for in Access reports. They spring from the fact that, unlike most other database components, reports often have to stand on their own. So their formatting and layout have to be more complete and …
The IsNull function in Crystal allows us to deal efficiently with nulls, or empty fields, in a data source. I talked about this in an earlier post. We don’t want to skip partly empty records, in most cases. But if we bring in nulls, we …
Crystal Reports handles nulls, or completely unfilled fields, in a particular way. And it’s very important that anyone using the program understands the details clearly. A null, in Crystal’s view, is a database field which never had anything in it, and doesn’t now. A real-life …
Project allows for things like calculated fields and other custom data. It holds some fields “in reserve” aside from the ones set up for task names, durations, etc. This way, users can insert data the program couldn’t know about in advance. (I mentioned custom text …
Fields, in Crystal Reports, are the way we bring data from a source into a report. Sometimes, we need to combine the data with text even more directly than placing them side by side. The technique we can use is similar to creating a mail …
MS Project has a LARGE number of fields set up by default, for almost anything the program can track. But even with all the feedback the design team gets, they can’t anticipate everything a user might need to monitor during a project. So the team …
One of the more abstruse points of procedure in Access involves the three so-called normal forms. What, exactly, are they? If you think “guidelines”, or “protocols”, you’d be in the ballpark. When building a database, especially a relational database, there are some “streamlinings” which allow …
When setting up layouts in Crystal Reports, the parameter field can be a tremendously helpful feature. As with a parameter query in Microsoft Access, it gives the report a significant degree of flexibility. The report’s basic structure and purpose are the same, but the ability …