Sunday January 21st 2018

Categories

Insider

Archives

‘SQL, BI, IT news’ Archives

Purpose of Business views in Crystal Reports

Purpose of Business views in Crystal Reports

During interview for Crystal Reports Consultant a question may be asked that what are business views and what is their purpose. We write more on this topic in coming posts, lets enjoy the following for now; Introduced in Crystal reports 10, Business views, enables users to avoid the complexities of the data source by creating a layer on top of [...]

Crystal Enterprise™ Business Views

Crystal Enterprise™ Business Views

Crystal Enterprise™ Business Views helps you better manage reporting across multiple data sources and applications by simplifying data access, change management, and data-level security processes. An optional service in Crystal Enterprise, Business Views allow you to integrate data from disparate sources, handle promotion/demotion between [...]

Microsoft SQL Server 2008 Express with Advanced Services

Microsoft SQL Server 2008 Express with Advanced Services

Microsoft SQL Server 2008 Express with Advanced Services is a free, easy-to-use version of the SQL Server Express data platform that includes an advanced graphical management tool and powerful features for reporting and advanced text-based searches. This edition provides powerful and reliable data management tools and rich features, data [...]

Example of using a parameter in Crystal reports

Example of using a  parameter in Crystal reports

We are writing this post on request of Beginner users in crystal reports. This post will show ways to use parameters in Crystal reports. This post is based on an example on northwind Database and try to show ways to use simple parameter in Crystal reports. We assume that you have already created a new report with data from employee table [...]

For Loop – Crystal Reports Example

For Loop – Crystal Reports  Example

A For Loop is the best tool to use when you want to execute a section of code a predetermined number of time. Suppose you a character field name Account Name in Table Employees you want to know how many times Letter S is contain in each AccountName. It can be accomplished through a For Loop; Local Numbervar Index; Local NumberVar [...]

ToText formula example

ToText formula example

Totext is a formula in Crystal reports used to convert numeric value to text for example you want to write Your Salary is {StoredProcedure3_1;1.Salary} you will receive an error stating that string missing. So to write the same you need to use totext function as follows; "your salary is RS" + Totext({StoredProcedure3_1;1.Salary})

Performance Monitoring and Tuning in Crystal Reporrs

Performance Monitoring and Tuning  in Crystal Reporrs

In Crystal Reports developer interview, Interviewer sometime asked how to improve slow running reports.  Most of the time we know all that by experience, but to satisfy interviewer, we must give them some formal answer because they may not have as much hands on experience as the job applicant / they only have read some documentation and want [...]

Data Quality

Data Quality

Data Quality refers to the degree and state of data in terms of completeness, validity, consistency, timeliness and accuracy that makes it appropriate for a specific use. According to J.M. Juran, High quality of data implies that the data is fit for it's intended uses in the operations, decision making and planning.

Types of Data Profiles

Types of Data Profiles

Data profiles computed by data profiling analytical techniques include: * Distinct lengths of string values in a column and the percentage of rows in the table that each length represents. Example: Profile of a column of US State codes, which should be two characters, shows values longer than 2 characters. * Percentage of null [...]

Data Quality and Data Profiling

Data Quality and Data Profiling

A Glossary of Terms by Brian Marshall * Data Quality * Data Quality Domain * Data Quality Rule * Data Profiling * Data Quality Profiling * Database Profiling Data Quality is a measure of the value of data in relation to potential data problems: * missing data records or data [...]

 Page 5 of 8  « First  ... « 3  4  5  6  7 » ...  Last »