Viewing 15 posts - 1 through 15 (of 102 total)
I agree with the "nice" part, but it's not an easy one if you don't regularly poke around altering tables, using transactions etc.. (judging by the figures: 50% wrong, it...
November 24, 2010 at 7:08 am
As this is the Integration Services forum: I suggest you build a SSIS package to import the data from the excel file into the appropiate tables.
If needs be, you can...
November 10, 2010 at 7:56 am
Nice question! It made me do some reading-up on a feauture I've never used so far.
Allways good to refresh those areas once in a while.
Really like the "none of the...
November 9, 2010 at 2:52 am
I agree with Bob: how should we know which date 40358 is, without executing a command?
Poor question, poor explanation as well (as pointed out in some other reactions).
November 5, 2010 at 2:28 am
Well, If you can find a good example of the script you can easily go from there.
http://consultingblogs.emc.com/jamiethomson/archive/2007/03/28/SSIS_3A00_-Building-Packages-Programatically.aspx might be a good place to start your search (maybe a little old).
November 4, 2010 at 9:49 am
Hard to guess what exactly is happening there, but could it be that your asp.net app is trying to connect to SSRS under its own credentials (the account running IIS),...
November 4, 2010 at 9:07 am
I agree with Daniel that it is better to create a couple of data-driven subscription by hand, and then just manipulate the data for the data driven subscriptions form your...
November 4, 2010 at 9:01 am
As metadata in a package can not be changed while the package is running, you should create a package "on the fly" with the source and destination you need, validate...
November 4, 2010 at 8:35 am
If I recall correctly someone (might hav been Chris Webb) said in a PowerPivot-demo that it was important that your keys are a single, numeric column. I don't recall the...
November 4, 2010 at 5:44 am
In my opinion SSRS is not the right tool to solve this.
You could trick it for one record at a time by having a special report where the user-input is...
November 4, 2010 at 5:07 am
This is indeed a simpler example than the ones I have seen before, as it requires no codebehind on the report.
There is one pitfall however that should be noted: the...
November 3, 2010 at 2:58 pm
It is a long shot, but is there a 2008R2 SQL Server instance installed on your ReportServer for the SSRS-db's?
If so, you could consider creating a linked server on...
November 3, 2010 at 2:40 pm
The problem you are experiencing is due to the fact that in SSRS the dataset from the cube is imported as-is, and further used ïn a way similar to a...
November 3, 2010 at 10:02 am
My guess is you should put the two charts in one rectangle to keep them together, even when the report is expanding to the right.
This works splendidly in SSRS 2005,...
November 3, 2010 at 8:41 am
You should look into using runningvalue instead of sum in you calculation, corrected for the value in the current month (because you want the standing at the beginning of the...
November 3, 2010 at 8:30 am