Visual Studio 2005

Question

Visual Studio 2005

2Tall

SSChampion

Points: 14644
More actions
March 10, 2008 at 7:48 am

#187572

Hi Guys. I am looking to create a default solution for my company for all bespoke reports.
Currently the application vendor has supplied a single default solution file + a number of .rdl files + Report Models.
I will probably begin by copying the default .rdl files then simply modifying them.
Question 1:
I created a new solution 'My Solution'.
I have an existing .rdl file(copied vendor .rdl file) I would like to simply add this .rdl file to 'My Solution' and for it to display in the following hierarchy:
Solution 'My Solution'
Accounts
------Shared Data Source
------Reports
Question 2:
There are various options when creating 'New Projects'. When would I need to create a 'Report Model'
I have attached a screen shot of current default solution.
Advice as always very much appreciated.
Phil.
Update: I have removed attachment at the request of a third party.
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

2Tall SSChampion Points: 14644 More actions · Answer 1

Hi. I have been having a play about and can now see how my original post is achieved.

I would like a heads up regards Report Models. I presume these are the building blocks for report projects and as the app vendor has already created various report models I shouldn't need to.

Thanks,

Phil.

-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

Tommy Cooper

Matt Miller (4) SSC Guru Points: 124210 More actions · Answer 2

The report Models are pseudo-universes (a la BusinessObjects) allowing the designer to create a "simplified" environment for their end users to create ad-hoc reports. You add tables/views, draw the relations between them ,possibly build standard aggregates, etc... and you put them in the model. Whatever is in the model is available to your end-users to use to create reports (in the report builder functionality available from the web interface).

On the other hand - your more "heavy-duty", standard reports should absolutely NOT be done using the report model as its basis, since you have ultimately no control over the SQL generated from there. You should code them directly, with SQL you can control, so that you can tune them as performance dictates.

----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

2Tall SSChampion Points: 14644 More actions · Answer 3

Thanks Matt. I am just beginning the long journey................SQL Guru by 2030!!

Many Thanks,

Phi.

-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

Tommy Cooper

Matt Miller (4) SSC Guru Points: 124210 More actions · Answer 4

Good luck from another schmoe on that same long road.....

----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?