Report Model && Cube Necessity

Hi there,


We are working on a business intelligence solution and are breaking our heads on something that is too critical for us to proceed any further and support our stance. Please help. The case is as follows.

SELECT [Month]
,[Total Sales]
FROM [TryYas].[dbo].[Yearly]


Month Total Sales
Jan 1000

Feb 200
SELECT [Month]
,[Sale]
FROM [TryYas].[dbo].[Monthly]


Month Sale

Jan 100
Jan 300
Jan 400
Feb 100
Jan 50
Feb 60
Feb 40
Jan 150
Feb 100


Say there are two tables like the ones above.. We need to know if a report model can be built so that we can build reports where the details from the first table will be shown and when the user clicks on the Month (Say Jan) details for Jan Should be pulled from the second table, something like a drilldown would also be fine.

Now, with our understanding here makes us feel that it can't be done with a report model but is possible with Report Desinger. We need to know if it is possible to have such an implementation with a report model when a cube is built or not even with a cube. Any inputs, suggestion, explanations, references, code samples, etc.. etc.. would be of GREAT HELP.

Thanks and regards,
yaseen