I am writing some financial report (e.g. P&L, Balance sheets etc).
Can any body please advise me on how I can bring data from multiple quires into the same data table?
i.e. Revenue in column and budgets etc on 1 column so I can do calculation.
I used crystal reports before where I could use link reports and bring values through to the main report for calculation. Is this possible in Reporting services, if yes how can I achieve this.
The format I require is :
Current period YTD
Ledger code/Dim rev bud var% rev bud var%
My idea is to bring budget related information into the main table using link reports or other datasets.
But I am not sure how I can relate 1 dataset to another
Eg. Data set1 brings revenue info for an account
Dateset2 brings budget info for the same account
I want use both values in the same table so that I can calculate the variance
Any help will appreciated
Can any body please advise me on how I can bring data from multiple quires into the same data table?
i.e. Revenue in column and budgets etc on 1 column so I can do calculation.
I used crystal reports before where I could use link reports and bring values through to the main report for calculation. Is this possible in Reporting services, if yes how can I achieve this.
The format I require is :
Current period YTD
Ledger code/Dim rev bud var% rev bud var%
My idea is to bring budget related information into the main table using link reports or other datasets.
But I am not sure how I can relate 1 dataset to another
Eg. Data set1 brings revenue info for an account
Dateset2 brings budget info for the same account
I want use both values in the same table so that I can calculate the variance
Any help will appreciated