|
||||||
|
|
This article is day four in a week of reporting articles. Most users want to export reports to Excel so they can manipulate the data. If possible, set up the report for the cleanest exporting possible. This process starts when writing T-SQL. For example, one can extract only the date instead of a datetime value when [...] This article is day three in a week of reporting articles. This seems like a no-brainer, but it is not as easy as you would think. Often your users will not know what they want and certainly not where to get it. Don’t take direction from this guy. Let’s say Milton, a purchasing agent, [...] This article is day two in a week of reporting articles. Create standard layouts for both landscape and portrait reports and have them approved by management. Many larger companies have Corporate Identity Guidelines created by marketing experts with standards already defined for marketing and sales documents. Adhere to the standards religiously. If creating your [...] This article is day one in a week of reporting articles. If you are going to become a business intelligence ninja, start at the beginning. You need to develop standard procedures for report creation. They include: Who can request reports? A good percentage of my day is spent writing reports. The report formats could be SQL Server Reporting Services (SSRS), Crystal Reports, M2M VFP reports, or ODBC Excel Spreadsheets. The latter three methods usually involve T-SQL, which I write by hand using TOAD for SQL Server or the SQL Server Management Studio (SSMS). In the [...] Dashboards are a hot topic these days and I need to investigate the available options. I had a Qlickview demonstration in person, but I’d like to talk to any of you who are using it. So, are any of you folks using it? Would you mind telling me your opinions of the product?
I love learning new things. I couldn’t help but in a small way feel like Luke Skywalker when he first felt the force. I’ve been trying to get access to a SQL 2008 Server for the longest time, and it’s finally happened. I wrote and published my first SQL [...]
A Christmas Story At the time of this writing, the M2M error log is still being kept in a text file, not surprisingly called error.log. I understand that this is probably the most expedient way for M2M to capture it. I suspect it’s a lot easier code-wise to simply append [...]
Movin’ on Up. In a previous post, I indicated that I would post my migration procedures. Made2Manage offers instructions to set up a test server and basic migration directions, but they don’t offer recommendations of what exactly should be tested during migrations. This is unfortunate, because only they know where [...] In a previous post I recommended the use of Crystal Reports and listed some of the advantages of doing so. One of the primary reasons I am looking forward to the Made2Manage .Net future is my fervent hope that VFP Reporting will go away. Visual FoxPro reporting must die. In this [...] |
|||||
|
Copyright © 2010 Made2Mentor - All Rights Reserved |
||||||
Popular Articles