Wednesday, January 23, 2013 6:54 AMDear all,
i have one problem in ssrs.i need to display sales report customer wise [sales and budget and variance and variance percentage] from different databases but in single server.it will be there detailes in multiple databases.i need to display detailes in single report.could you please anyone help me.for example we are maintaining 2010,2011 databases so i need to display customer no,sales,budget,variance,variance percentage in single report ...
year from 2012 year to 2013 date filter 01-01-12..31-12-13
Customer No. Sales -2012 Budget-2012 Variance-2012 Variance %-2012 Sales -2013 Budget-2013 Variance-2013 Variance %-2013
i need details like this in one report using multiple databases.please anyone help me.
navya krishna katta
Wednesday, January 23, 2013 5:44 PMSSRS provides several LookUp functions that allow you to retrieve 1 or more values from another dataset where a specified key field in each dataset (source and other) match. Check out the LookUp, LookUpSet and MultiLookUp functions. The 2012 aggregate functions reference is here: http://technet.microsoft.com/en-us/library/dd255275.aspx. You can switch it to 2008 or 2008 R2 as well.
Please Mark posts as answers or helpful so that others can more easily find the answers they seek.
Monday, February 04, 2013 8:24 AM
If i write code for multiple database i am getting error could you please solve the issue.
SELECT No_ FROM [Demo Database NAV (6-0)].dbo.[CRONUS International Ltd_$Customer]
SELECT Name FROM CCIL12.dbo.[CCIL-2012$Customer]
I am getting below error
"Implicit conversion of varchar value to varchar cannot be performed because the collation of the value is unresolved due to a collation conflict.".
Tuesday, March 26, 2013 5:55 AM
Friday, April 12, 2013 12:33 PM
I have created one ssrs report i gave parameters to that report item no,item catagery code and branch name. it is working good.but i need to give multiple selection for that parameters......can anyone please help me....in that parameters option i applied right click and give option multiple selection but it is showing error incorrect syntax near",".....please solve the issue.
Friday, April 12, 2013 3:37 PMNaveen, you should post this in a separate thread. This one is marked as answered so it is being passed over by people that want to answer questions. A new post will get the attention you need.
"You will find a fortune, though it will not be the one you seek." - Blind Seer, O Brother Where Art Thou
Please Mark posts as answers or helpful so that others may find the fortune they seek.