Viewing 15 posts - 8,731 through 8,745 (of 11,678 total)
Phil Parkin (11/18/2011)
I think Excel can handle only 256 columns.
True for 2003. 2007 onwards allow 16,384 columns
This makes the solution:
upgrade from office 2003 to office 2007/2010.
We're almost 2012, your current...
November 18, 2011 at 3:49 am
Phil Parkin (11/18/2011)
I think Excel can handle only 256 columns.
True for 2003. 2007 onwards allow 16,384 columns, requiring a truly microscopic font in SSRS 😛
Or a lot of A0 pages......
November 18, 2011 at 3:48 am
cengland0 (11/18/2011)
So, when the time ends in .001,...
November 18, 2011 at 3:47 am
ChrisM@Work (11/15/2011)
Lowell (11/15/2011)
(He or She) clicks the Instant 30 seconds button, waits 10 seconds, watching the count down, and then...
November 18, 2011 at 3:41 am
Vacation jobs:
* finance department of a hospital
* various jobs at different warehouses. Most of the time doing heavy lifting.
* very shortly calling people to take surveys. Annoying job, lying to...
November 18, 2011 at 3:36 am
Some dummy instructions: 🙂
in the editor of your flat file source you need to configure the error output.
For the column col10, put the error configuration to "Redirect row" for truncation.
This...
November 18, 2011 at 3:27 am
I think Excel can handle only 256 columns.
In my opinion, a report with more than 10 columns is not user-friendly anymore.
If you have more, you are just creating data dumps....
November 18, 2011 at 3:17 am
I must say they really put an effort in forum spam these days.
So much text...
November 18, 2011 at 1:40 am
You'll need to put some ETL in place to convert the measures to the corresponding data type.
Furthermore, normally a measure isn't a string. Strings mean it is some sort of...
November 18, 2011 at 1:31 am
Read your Excel file like you normally do, and then use SQL to read from the SSAS cube.
This is possible, according to the following article:
http://cwebbbi.wordpress.com/2006/06/14/can-i-run-sql-against-an-analysis-services-cube/
However I'm not sure you can...
November 18, 2011 at 1:25 am
weisietan (11/18/2011)
the first data will counted but the last will not counted.
Example:
Name between 'A%' and 'C%'
just will get the...
November 18, 2011 at 1:09 am
Nice question. This one should have been 2 points and the one of yesterday only 1 point.
Ah well 🙂
November 18, 2011 at 1:04 am
The difference between the SQL and the MDX is that in your first query, you join also against PackageSales. However, you don't need this table to get your result. The...
November 18, 2011 at 12:01 am
Yesterday I gently ticked someone on the fingers for cross posting.
I got a private message of him apologizing and he explained me that he had now read the forum etiquette...
November 17, 2011 at 11:19 pm
samvanga (11/17/2011)
But if for some reason you dont want to use this approach, you could...
November 17, 2011 at 11:19 pm
Viewing 15 posts - 8,731 through 8,745 (of 11,678 total)