Posts Tagged ‘BI & Reporting’

It seems a good time to talk about security as the WannaCry ransomware attack outbreak two weeks ago is spreading like a wildfire and leaving the world helpless with the kidnapped documents, images, and videos. Although the Data Security I am going to speak to is different from the File Security, there is one thing […]

During the Crystal Reports development, it is very common data source (database, universe) definition modifications impact the fileds to be presented in the RPT, such as field renaming, data type changes, or even deletion of a specific data field. How can we synchronize the changes from the data source into RPT to make sure the […]

This is the second part of “Placeholders in the CMC – Business Objects”, please see the first part here 10. Placeholder List Table Placeholder Variables  Name Variable Description Title %SI_NAME% Report title, it is same as report rpt name  ID %SI_ID% InfoStore SI_ID value, System ID  Owner %SI_OWNER% Report owner who schedules the report  DateTime […]

Usually, after we finish developing a Crystal Report rpt with sufficient unit testing according to the report requirement, the next step is to upload it onto the CMC (Central Management Console) or InfoView server for scheduling. During the scheduling, we will be asked to walk through several steps (recurrence, schedule for, notification, database connection, filters, […]

After read chapter 1 of book《Head First Statistics》, I found there are some good points about how to use different charts in reports. So I summarized below to share with everyone. 1. Pie charts are used to compare the proportions of different groups or categories. It’s usually easy to tell at a glance which groups […]

Here, you can see “Optional Prompt” is dimmed as “False” and cannot be modified. It means the prompt is required to input value before running report. What if we set “Default Value” as blank and run the report? Click on “OK”, the page does not respond. We are required to input a standard date value, […]