we have one client he want's to display sales report by customer wise using different databases.for example he is maintaining every year databases in single server .he need to display all sales report by customer wise in single report.how can i display.could you please any one explain clearly how to display that one.

in ssrs i created one datasource and one dataset .so one table is displaying with that dataset.so i need to display two tables in one report(design form). if i create one more dataset for second table .in excution i am getting error the datasource1 is not found.can any one please tell me how to create two tables in one design form.

you can create as many tables as you want and also as many datasets inside same report. Are tables linked to correct datasets? or is it like table is linked to one dataset and you're trying to use other dataset's field inside it?

i have one problem with below query if i give filter from 01-01-12 to 01-31-12 it is showing correct result .but if give filter 01-01-13 to 01-31-12 in privious result that 01-01-12 to 01-31-12 result getting wrong .see if i gvr for 12 year filter same january month i am getting correct but if i give 13 year filter in privious year this 2012 january gettng wrong result.

how do you expect someone to go through your query and understand? why not you provide some sample data from tables and explain what you're trying to get? thats much better than posting query like this

Hello visakh, my problem is if i give date filer 1st jan 2012 to 31 jan 2012 showing one result .same lyk if i gve jan same for 2013 this result also getting correct.but i have one field prevoious year.so if i give 2013 jan i need to show prevoius year field result also .prevoius year means 2012 jan .i am gtng previous year result wrong.

i created one table in that table one column field credit sales.i need credit sales monthly wise so i created query for jan month.if i give parameter jan1 to jan31 it will be showing correct result.so if i give feb like upto dec if i give any month parameter i need to display that month cradit sales result.but if i give for feb it is not showing.

I need help from you i asked regarding this issue already i am not getting correct solution for my probelm.i need to display prevoius year and previous month result along with present year and present month .i will put query below pls modify the query.pls i must need this solution pls help me.

set @Cur = cursor fast_forward forSelect [DBName] FROM [CCIL-2012].[dbo].[CCIL-2012$DBName]open @Curfetch next from @Cur into @DNamewhile (@@fetch_status = 0)begin INSERT INTO @ListofIDs VALUES(@I,@DName); fetch next from @Cur into @DName

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.

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.