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 cant join views?

Hi friends
i have quick question with report builder utility .am using VS2005 and Sql 2005.
When creating report model solution ,when adding field names from a table it loads fields names as it is ,right ? so to make end users life easier i created
Views with lengthy field names.

the issue is ,i'll start with an example ,i've 2 views (ParentView and ChildView) and the tables used by these views have foreign key relation ship .when i use these 2 entities in report builder as soon as i add a column from one view (say ParentView) the other view disappears from list !! I assume Report builder looks FKey to link 2 entities and since am using views which will not have any fkeys on them it removes other entities from list.
is there any way to link these 2 views so that users can add few columns from ParentView and few more from ChildView.
Yes, If i use tables directly everything works fine .
Thanks for your help.
i finally figured out .if any one interested
when we double click on data source view (in report model project you created) it gives graphical representation of objects where we can drag & drop to create relationships just like diagrams in Enterprise Managers

report builder cant join views?

Hi friends
i have quick question with report builder utility .am using VS2005 and Sql 2005.
When creating report model solution ,when adding field names from a table it loads fields names as it is ,right ? so to make end users life easier i created
Views with lengthy field names.

the issue is ,i'll start with an example ,i've 2 views (ParentView and ChildView) and the tables used by these views have foreign key relation ship .when i use these 2 entities in report builder as soon as i add a column from one view (say ParentView) the other view disappears from list !! I assume Report builder looks FKey to link 2 entities and since am using views which will not have any fkeys on them it removes other entities from list.
is there any way to link these 2 views so that users can add few columns from ParentView and few more from ChildView.
Yes, If i use tables directly everything works fine .
Thanks for your help.
i finally figured out .if any one interested
when we double click on data source view (in report model project you created) it gives graphical representation of objects where we can drag & drop to create relationships just like diagrams in Enterprise Managers

Report being generated never shows second report

I have a VS2005 Windows application that displays a reportviewer (SQL 2005) report in a tab control, then displays a second report in a second tab with reportviewer, and so on. The really strange thing is that I had this application working for about 3 months. I even had up to 30 reports in 30 tabs at one point. BUT, for some reason now all I get is the first report and the second, third, etc. tabs show a reportviewer with "Report being generated" that never displays the report. Even worse, another user is able to run this application and DOES get all the reports displayed. So what could have been updated on my PC that is causing this problem?

Thanks in advance.

The obvious question to ask is what's changed? Have you installed any service packs or updates recently? Maybe it was some new software?|||

I was hoping someone else could tell me what installations might cause this problem, because I can't be 100% sure what updates have been done to my PC. Our Network Services group pushes updates and with MS always forcing updates, it's difficult nowadays to know what's going on on your own PC. Anyway, in January, I installed Red Gate's SQL Prompt 3 and Net Services pushed McAfee OAS. I don't know the exact day Report Viewer stopped working, but I'm pretty sure it was working after these installs. The SQL Server/SSRS 2005 is running on SP1, my client SQL is on SP1. Here's the header info in the most recent SSRS log:

<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.2047.00</Product>
<Locale>en-US</Locale>
<TimeZone>Eastern Standard Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting Services\LogFiles\ReportServer__02_22_2007_21_43_20.log</Path>
<SystemName>BNTRA</SystemName>
<OSName>Microsoft Windows NT 5.2.3790 Service Pack 1</OSName>
<OSVersion>5.2.3790.65536</OSVersion>
</Header>

Here are the last few lines in this log, that show me trying to run 2 reports. It looks like it does the same processing for both reports here, but it just can't display the report in the viewer.

w3wp!library!5!02/22/2007-22:08:11:: i INFO: Call to RenderFirst( '/JobReports/EOJreport' )
w3wp!library!1!02/22/2007-22:08:12:: i INFO: Call to RenderFirst( '/JobReports/EOJreport' )
w3wp!webserver!5!02/22/2007-22:08:12:: i INFO: Processed report. Report='/JobReports/EOJreport', Stream=''
w3wp!webserver!1!02/22/2007-22:08:13:: i INFO: Processed report. Report='/JobReports/EOJreport', Stream=''
w3wp!library!5!2/22/2007-22:13:21:: i INFO: Cleaned 0 batch records, 0 policies, 2 sessions, 0 cache entries, 2 snapshots, 12 chunks, 0 running jobs, 0 persisted streams
w3wp!library!a!2/22/2007-22:23:21:: i INFO: Cleaned 0 batch records, 0 policies, 2 sessions, 0 cache entries, 2 snapshots, 12 chunks, 0 running jobs, 0 persisted streams
w3wp!webserver!5!2/22/2007-22:29:04:: i INFO: Reporting Web Server stopped

Need more info? THANKS.

|||

After a lot of searching and matching dlls, it looks like that VS 2005 SP1 is my problem. I've started another thread here:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1279959&SiteID=1

Report being generated never shows second report

I have a VS2005 Windows application that displays a reportviewer (SQL 2005) report in a tab control, then displays a second report in a second tab with reportviewer, and so on. The really strange thing is that I had this application working for about 3 months. I even had up to 30 reports in 30 tabs at one point. BUT, for some reason now all I get is the first report and the second, third, etc. tabs show a reportviewer with "Report being generated" that never displays the report. Even worse, another user is able to run this application and DOES get all the reports displayed. So what could have been updated on my PC that is causing this problem?

Thanks in advance.

The obvious question to ask is what's changed? Have you installed any service packs or updates recently? Maybe it was some new software?|||

I was hoping someone else could tell me what installations might cause this problem, because I can't be 100% sure what updates have been done to my PC. Our Network Services group pushes updates and with MS always forcing updates, it's difficult nowadays to know what's going on on your own PC. Anyway, in January, I installed Red Gate's SQL Prompt 3 and Net Services pushed McAfee OAS. I don't know the exact day Report Viewer stopped working, but I'm pretty sure it was working after these installs. The SQL Server/SSRS 2005 is running on SP1, my client SQL is on SP1. Here's the header info in the most recent SSRS log:

<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.2047.00</Product>
<Locale>en-US</Locale>
<TimeZone>Eastern Standard Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting Services\LogFiles\ReportServer__02_22_2007_21_43_20.log</Path>
<SystemName>BNTRA</SystemName>
<OSName>Microsoft Windows NT 5.2.3790 Service Pack 1</OSName>
<OSVersion>5.2.3790.65536</OSVersion>
</Header>

Here are the last few lines in this log, that show me trying to run 2 reports. It looks like it does the same processing for both reports here, but it just can't display the report in the viewer.

w3wp!library!5!02/22/2007-22:08:11:: i INFO: Call to RenderFirst( '/JobReports/EOJreport' )
w3wp!library!1!02/22/2007-22:08:12:: i INFO: Call to RenderFirst( '/JobReports/EOJreport' )
w3wp!webserver!5!02/22/2007-22:08:12:: i INFO: Processed report. Report='/JobReports/EOJreport', Stream=''
w3wp!webserver!1!02/22/2007-22:08:13:: i INFO: Processed report. Report='/JobReports/EOJreport', Stream=''
w3wp!library!5!2/22/2007-22:13:21:: i INFO: Cleaned 0 batch records, 0 policies, 2 sessions, 0 cache entries, 2 snapshots, 12 chunks, 0 running jobs, 0 persisted streams
w3wp!library!a!2/22/2007-22:23:21:: i INFO: Cleaned 0 batch records, 0 policies, 2 sessions, 0 cache entries, 2 snapshots, 12 chunks, 0 running jobs, 0 persisted streams
w3wp!webserver!5!2/22/2007-22:29:04:: i INFO: Reporting Web Server stopped

Need more info? THANKS.

|||

After a lot of searching and matching dlls, it looks like that VS 2005 SP1 is my problem. I've started another thread here:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1279959&SiteID=1