Report design scenario

Hey guys,

I want to create a report called "Report X", which has four reports under it. Assume the following scenario.

1. Report X

1.1. Bar chart report

1.2. Pie chart report

1.3. Matrix report

1.4. Pie chart report

In addition to this, there are about four parameters that should be available for all reports. So my question is: what approach should I follow to implement/design a report for the above requirement.

Thank you for your cooperation in advance.

Sincerely,

Amde

The question is discussed/answered in this thread: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=374405&SiteID=1

Report Bulilder & Report Designer (Comp matrix)

Guys,
Is there any comparison matrix available online between Report Builder &
Report Designer (VS2005)? If yes, can you please redirect me to it?
Thanks,
RohitAlso, I want to know if the reports designed in Report Designer can be
opened in Report Builder. If we cannot, then, are there any alternatives? I
want to give an option (to the client) to modify reports created via Report
Designer without using 3rd party report designer tools or VS2005. Is this
really possible?
I also want to the limitations of Report Builder.
Thanks,
Rohit
"Rohit Peyyeti" <rohit@.translogicsys.com> wrote in message
news:eMAlNv6HIHA.1208@.TK2MSFTNGP05.phx.gbl...
> Guys,
> Is there any comparison matrix available online between Report Builder &
> Report Designer (VS2005)? If yes, can you please redirect me to it?
> Thanks,
> Rohit
>|||I have not found a way to open a report developed in REport DEsigner thru'
Report Builder.
"Rohit Peyyeti" <rohit@.translogicsys.com> wrote in message
news:Oru4y76HIHA.3768@.TK2MSFTNGP06.phx.gbl...
> Also, I want to know if the reports designed in Report Designer can be
> opened in Report Builder. If we cannot, then, are there any alternatives?
> I want to give an option (to the client) to modify reports created via
> Report Designer without using 3rd party report designer tools or VS2005.
> Is this really possible?
> I also want to the limitations of Report Builder.
> Thanks,
> Rohit
>
> "Rohit Peyyeti" <rohit@.translogicsys.com> wrote in message
> news:eMAlNv6HIHA.1208@.TK2MSFTNGP05.phx.gbl...
>> Guys,
>> Is there any comparison matrix available online between Report Builder &
>> Report Designer (VS2005)? If yes, can you please redirect me to it?
>> Thanks,
>> Rohit
>|||On Nov 5, 7:00 am, "Rohit Peyyeti" <ro...@.translogicsys.com> wrote:
> Guys,
> Is there any comparison matrix available online between Report Builder &
> Report Designer (VS2005)? If yes, can you please redirect me to it?
> Thanks,
> Rohit
Here's a link to a general comparison between the 2.
http://technet.microsoft.com/en-us/library/aa964121.aspx
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Thanks!
Also, can the data model created in VS2005 used in Report Builder (without
losing all the Calculated Members)?
...
Rohit
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1194322866.005853.151330@.o38g2000hse.googlegroups.com...
> On Nov 5, 7:00 am, "Rohit Peyyeti" <ro...@.translogicsys.com> wrote:
>> Guys,
>> Is there any comparison matrix available online between Report Builder &
>> Report Designer (VS2005)? If yes, can you please redirect me to it?
>> Thanks,
>> Rohit
>
> Here's a link to a general comparison between the 2.
> http://technet.microsoft.com/en-us/library/aa964121.aspx
> Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>

Report builder problem in SSRS 2005

Hi Guys,

I had a problem which bothered me for a while, My SSRS 2005 DB is migrated from 2000, knowing that i need to manually create "Report Builder" role in item level security in report services, I've created it and gaves the tasks rights as MSDN document suggested. Now the problem is that report builder can't open any report services root thus can't open any model via webpage, however it can do so in server itself.

I think it's a security issue, anyone has got a solution for this one ?

Best Regards,

-Chris

HI,Chris:

WHAT do you mean 'can't open '? Do you have some error messages when you try to open a model via pages?

Report

This is general scanario and I want some feedback from you guys.
I am planning to add new indexes, drop some indexes, and change other
indexes to composite and covering indexes. I want to create report that
shows the indexes used by queries before and after I make changes. What
should I do?
Can anyone tell me that which one would be the best solution.
1) SHOWPLAN_TEXT option. Use the output for the report.
2) Show Execution Plan option. Use output for the report.
3) Tuning Wizard against a Workload file. Use the output for the report.
4) DBCC SHOW_STATISTICS statement. Use the output for the report.
> 1) SHOWPLAN_TEXT option. Use the output for the report.
Gives you an text ouput of the execution plan. Easy for such documentation

> 2) Show Execution Plan option. Use output for the report.
Gives a pictorial output. Tough for documentation purpose hence.

> 3) Tuning Wizard against a Workload file. Use the output for the report.
Great for all recommendations. Needs a very good workload to arrive at a
decent solution and suggestions.

> 4) DBCC SHOW_STATISTICS statement. Use the output for the report.
Gives the histogram output of the Indexes. Good to know on the selectivity
activity.
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com
http://groups.msn.com/SQLBang
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
"Noor" <noor@.ngsol.com> wrote in message
news:uhgj1N%23jEHA.1996@.TK2MSFTNGP09.phx.gbl...
> This is general scanario and I want some feedback from you guys.
> I am planning to add new indexes, drop some indexes, and change other
> indexes to composite and covering indexes. I want to create report that
> shows the indexes used by queries before and after I make changes. What
> should I do?
> Can anyone tell me that which one would be the best solution.
> 1) SHOWPLAN_TEXT option. Use the output for the report.
> 2) Show Execution Plan option. Use output for the report.
> 3) Tuning Wizard against a Workload file. Use the output for the report.
> 4) DBCC SHOW_STATISTICS statement. Use the output for the report.
>

ReporItems referring to a cell containing a subreport?

Hi guys,

i have a column in a report that must calculate a percentage based on two columns that follow them. I am aware that i can use the ReportItems! collection for this, but one of the columns i need to reference is actually a subreport because its data comes from a different source. It is just a single cell subreport, which makes it appear totally part of the table it is in. Is this possible? Just to be clear, what i want is an expression like this in my cell:

= FormatPercent( ReportItems!CurrentEarnings / ReportItems!BudgetedEarnings )

the BudgetedEarnings cell is actually a subreport, but all i want is the text it is showing.

Thanks for any help or suggestions!

sluggy

No, referring to a report item in a subreport is not allowed.

|||Dang! Thanks |||Hi, how did you get around this issue? I am trying to do the same thing.

ReporItems referring to a cell containing a subreport?

Hi guys,

i have a column in a report that must calculate a percentage based on two columns that follow them. I am aware that i can use the ReportItems! collection for this, but one of the columns i need to reference is actually a subreport because its data comes from a different source. It is just a single cell subreport, which makes it appear totally part of the table it is in. Is this possible? Just to be clear, what i want is an expression like this in my cell:

= FormatPercent( ReportItems!CurrentEarnings / ReportItems!BudgetedEarnings )

the BudgetedEarnings cell is actually a subreport, but all i want is the text it is showing.

Thanks for any help or suggestions!

sluggy

No, referring to a report item in a subreport is not allowed.

|||Dang! Thanks |||Hi, how did you get around this issue? I am trying to do the same thing.