Use more than 1 Order By clause in SQL statement

Hi All,

Do you want the order of your reports in two parameters. Good news, its possible. Use

Order By QDate Asc, Order By DeskName Asc 

to achieve the desired result

Reports not showing the right order of dates or week numbers horizontally

Hi All,
I had this issue from quite a long time. I was trying to publish the data weekwise and strangely the order of weeks would be like Week 2, Week 5 and then Week 3. I medled with lot of SSRS features to correct this...but alas all I had to do was mend the query and add Order By Date/Week Desc/Asc and Viola!...I got my report headings in the order Week 2, Week 3, Week 4 and then Week 5

Excel is pasting the same formula value and not changing with cell value

Hi Folks,
Today I faced a strange issue. When I enter the cell value ABC in A2 and apply the =Proper(A2) I get Abc.
But when I paste the same formula to B3 cell value with formula =Proper(B2) for B2 value DEF I am still getting Abc instead of Def.
The same issue repeated for all formulas.
After trying various options in excel, I was able to find the resolution.
All I had to do was :
Click on Formulas  tab >Calculation Option>And choose Automatic option

Viola!
My formula values were back

Column mappings do not reflect while Configuring SSIS connection manager

Hi Folks,
After I was able to get the sharepoint connection manager and when I try to configure it with the Site URl, I could not get any input parameters.
All I had to do was hit 'REFRESH' tab at the bottom and VIOLA..all column mappings were found

SPCRED not present in SSIS connection manager

Hi Folks,
I am so happy to get this issue resolved.
Got an assignment to import data from the Sharepoint list. 
Browsed and found out that I had to install "SharePointListAdaptersSetup.msi" first.
After the donwload I could not proceed further as SPCRED - connection manager for sharepoint was not present.

All I had to do was close BIDS completely ans start again

Viola..SPCRED was back