|
|
-
|
|
You probably will not notice that the object name in SSRS is case-sensitive until you copy somebody’s RDL report file and modify on top of it.
I recently did just that. Some of the column names are the same, so I didn’t bother to change it.
This caused the case mismatch between the col......
|
|
-
|
|
Reporting for a financial institute can be very difficult due to complex business rules. Reporting can be even harder when the data is about paying employees incentives/bonuses when the rules can be even more complex.
I got into a habit of writing a report/ETL Definition document for every reportin......
|
|
-
|
|
I’ve wrote a blog about SSIS – Enable Package Configuration for Deployment.
It showed you how you can set up the package configuration files on your development PC and enabled it in BIDs.
If you are a release coordinator, you would follow the same step to create the configuration files......
|
|
-
|
|
Incremental loading is not a easy topic. I am just concentrating on a very narrow focus here.
Here is the context of this blog.
Data Source: relational database in DB2
Data Destination: a table in SQL database
Reporting: a SSRS report with direct data pull from the above table
ETL: Implemente......
|
|
-
|
|
I wrote a blog on SSRS – How to toggle the details with Invisibility property for TableRow?
when I showed a draft version of the report to a supervisor, he said that he preferred to have one heading per column.
After some thinking, I feel that he has a point.
So I re-arranged the columns to......
|
|
-
|
|
Very often we need to process data from the beginning of month to the current day. So we need to write code to find the beginning of the month.
In SSRS, here is the VBA code you can use to default your report’s start date to the beginning of the month:
=DateAdd("D", -1.0 * DatePart("D", Toda......
|
|
-
|
|
You’ve seen reports that look like this:
When the plus sign is fully expanded, you will see another level of details.
I’ve created reports like this, with summary at the top level, and details being expanded every time the plus sign is clicked. The plus signs can be nested.
To cre......
|
|
-
|
|
I had a post awhile ago about the LastId Dilemma – Resolved Finally. I used a DBCC command to check the seed value of an identity value, and then to “reseed” the seed value to a mush higher value to avoid the possibilities of duplicate key values.
So what are DBCC commands? DBCC s......
|
|
-
|
|
It’s straightforward enough to get all the steps inside a SQL job, and also all the SQL jobs.
......
|
|
-
|
|
Is your SQL environment growing so big and intertwined that your memory cannot tell you right away which SSIS package is populating which tables, and witch tables are used by which SSRS reports, and which SQL job is executing which SSIS package or procedure? Welcome to the real SQL world!
A DBA in......
|
|