|
|
Reporting Services
Reporting Services
-
One of the biggest problems I've been having with upgrading my mad reporting skills from RS 2000 to RS 2005 has been with cascading parameters in OLAP reports. WIth the new and "user friendly" connection method to Analysis Services, I couldn't Read More
|
-
Yesterday I ran into a small problem with adding parameters in a report's URL. All parameters were based on MDX queries. One parameter was for time, and the parameter usually looks like this "[Time].[YMWD].[Month].&[4]&[2007]". When I did Read More
|
-
Just solved a problem with some matrix controls in RS2000 reports. The columns groups on Months. Not all months have numbers. And for some silly reason, February and March would still display the numbers for the latter months.
Read More
|
-
During the last few weeks, I've installed SQL Server 2005 and Microsoft Office SharePoint Server 2007 countless times. It's getting old. So now I think my next project will be to create a package and script to:
install SQL Server 2005 with Analysis Read More
|
-
Today I'm trying to fix a report where there's a matrix with quite a lot of nested IIFs. The columns show 3 different kinds of numbers for each month of the year + a total. The footer shows the sum for each month. But the sum should be different for Read More
|
-
The last few days, my ego has been really, really bruised. I've been working on OLAP based reports in Reporting Services 2005 again. Being fairly experienced with RS / AS 2000, I ran into all sorts of problems when RS just didn't behave quite like Read More
|
-
Today I found something usefull while surfing, a tool called BI Documenter.
http://www.bidocumenter.com/Public/Default.aspx
The current version can't be used for Reporting Services documentation, but the next can, according to the developers' blog. Read More
|
-
Some years ago, I had to create a pivot looking grid. I didn't know the word Pivot at the time, or how to do it, but I got some great help from a fellow developer, Per Holje.And today I had to dig out the code once again, because of a project involving Read More
|
-
I'm currently making a report, showing a table with numbers and a text box with description, each related to an employee's data. I wanted to have each emloyee o a new page, but couldn't figure out how. A lot of how-tos on the web suggested to set up the Read More
|
-
Sometimes, it's nice to have alternating background colors in Reporting Services reports. Doing this in tables is fairly easy, and can be done in 2 different ways; one using RowNumber and one using runningvalue:
=IIF(RunningValue( Fields!MyField Read More
|
-
My initial joy of having a brand new service pack for SQL Express is now turned to frustration. For some stupid reason, I can't install the service pack on my test server. I'm currently running a Community Server Test site, and don't feel like uninstalling Read More
|
-
SQL Server 2005 sp 1 was released on April 18th. Information can be found at http://www.microsoft.com/sql/sp1.mspx
Download SQL Server 2005 Service Pack 1
And then there are some new tools and SP1 for SQL Server 2005 Express Edition at http://msdn.microsoft.com/vstudio/express/sql/download/. Read More
|
-
I'm currently working on some Reporting Services reports for a customer in Finland. I've been setting the language settings in Report Designer to Finnish (Finland) for almost all the reports. You can set the language settings to either Finnish or Finnish Read More
|
-
Someone called Vivian / Vyv posted to the Reporting Services news group on how to replace the tekst in the page title of reporting services reports. By default, the page title is "Report Manager"". Not very descriptive, so she had made a good Read More
|
-
Some data formats are just hopeless to work with. The last few weeks, I've had the "pleasure" of working with an Axapta database. (Microsoft Dynamics Axapta). More spesifically, working on accounts in Axapta. For some reason, this field looks Read More
|
|
|