Saturday July 22nd 2017

Categories

Insider

Archives

‘Crystal Reports’ Archives

Selecting Null when there is empty string

Selecting Null when there is empty string

Many times we have a limited access to the data and views are created by IT departments and we have to select only the null or empty fields in Crystal Reports. I frequently came across this kind of issue and I tackled this by using isnull({Field})=True or {Field}="" in the record selection formula editor. Kaleem Mian Senior Consultant SAP [...]

Running Aggregate

Running Aggregate

An excelent use of sql to produce running aggregate like we do in reporting tools like Crystal Reports. Yhis example is take from Microsoft SQL Server 2008 Database Development self paced traing kit for 70433 by Tobias Rhernstrom,Ann Weber, Mike Hotek and Grand Masters. We used the database Adventure works in Sql Server 2008 and it produces the [...]

Derived Table with – WITH Clause

Derived Table with – WITH Clause

I have included the overview of Derived Table with WITH Clause as they have an important application in Data Base Reporting. A dervied table built with a WITH clause is also called "Common Table Expression" can be thought of a table within SQL statement that exists only for the duration of that statement. There can be many CTEs in a SQL [...]

Automated Business Intelligence – products profitability on month to month basis for 3 months, growth and Ranking grouped under store

Automated Business Intelligence – products profitability on month to month basis for 3 months, growth and Ranking grouped under store

I came across the client's request to develop a report that shows products profitability on month to month basis for 3 months, growth and Ranking grouped under store. as follows; . Database was my sql and ranking function was not available. There are number of ways to achieve this in the absence of Ranking function i.e. we can create temp [...]

Linking a sub report based on procedure – stored procedure parameters cannot be Linked

Linking a sub report based on procedure – stored procedure parameters cannot be Linked

I came across this question several time on linking stored procedure parameters to main report. Problem arises when we select stored procedure as a table or view from the data source. It can be resolved by calling a stored procedure from command window - "DatabaseName"."dbo"."StoredProcedureName"{?StartDate}, {?EndDate} and creating parameters in [...]

Formatting Issues arises when export to excel

Formatting Issues arises when export to excel

This problem usually arises when we have a sub-report even we place it in the main report with extreme care it adds extra lines. In such a scenario I use stealth Sub-report and use the data from sub-report to main report through shared variables, and use these as main report fields. Its an extra work but since we use the sub-report fields as main [...]

Developing / Integerating Fintrac data in a single Highly Formatted Fintrac report

Developing / Integerating Fintrac data in a single Highly Formatted Fintrac report

I was asked by the client to develop a single report which integrate all the fintrac transaction data. i.e Account Holders information, Receipts and disbursements, as they have to integer ate the data in time consuming manual process. Initially it seemed quite challenging however it wasn’t. Fintrac Account Holders main information was [...]

If Then Else Statement and applications using Crystal Reports

If Then Else Statement and applications using Crystal Reports

If then else statements are very handy when the data structure is complicated. I came across a scenario where one of my client need a report to see operation cost stats of employee hours on transactions happening during selected date parameters. The process was such that with each transaction following information was stored; Transaction [...]

Developing highly formatted advanced and dynamic Cross Tab Reports like Organizational Metrics, Year Over Year / Month to Month Growth Comparisons.

Developing highly formatted advanced and dynamic Cross Tab Reports like Organizational Metrics, Year Over Year / Month to Month Growth Comparisons.

Top management needs the data in Tabular format to see Organization growth and metrics to manage large organizations. Data is typically stored in Rows in relational databases and producing analytical business intelligence reporting involves importing data from databases into excel and then producing pivot tables, which are excellent to analyze [...]

Role of Crystal Reports in Highly Regulated businesses and organizations.

Role of Crystal Reports in Highly Regulated businesses and organizations.

In Regulated industries like Law, Medicine, Security and surveillance, Public Safety and Health Care advanced formatted reports are critical. Typically these reports include textual elements and statistics. Generating these reports involved manual and multiple, error prone laborious and costly steps in word documents / excel sheets to produce a [...]

 Page 1 of 16  1  2  3  4  5 » ...  Last »