Showing posts with label rs2000. Show all posts
Showing posts with label rs2000. Show all posts

Friday, March 9, 2012

Displaying Fields from Multiple Datasets (RS2000)

Hi guys, I have this problem of displaying fields from multiple datasets.

When I drag a field from the first dataset into a table, it works and displayed correctly. However when I dragged a field from a second dataset, it will be shown as

=First(Fields!FirstName.Value, "DataSet2") for Strings and

=Sum(Fields!StatusFlag.Value, "DataSet2") for Integers

I just want the integer from that single row but it sums up all the rows. When I removed the SUM keyword, the IDE will show build errors when I try to build the report. Is there any way to get around this? thanks!

Use the First keyword for integers as well.|||According to the data types, the IDE will always choose SUM as the aggregate for numeric values and FIRST as the aggregate for non-Integers. As Brad mentioned you can changed that, this is just a suggestion of the Designer.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

Saturday, February 25, 2012

Displaying a RS2000 Report in a .NET 2.0 control

Hello,
I need to display a report on a winform.
The report is a RS2000 report served by a RS2000 server.
The winform is in a VB .NET 2.0 (VS 2005) project.
1) Can I use a ReportViewer control (.NET 2.0) on this winform to display
this RS2000 report?
2) Must the ReportViewer control have its own dataset even though the report
is being served?
Thank you in advance,
RichardTwo modes for control: server and local. Local requires giving the control
the rdlc file and the dataset. Server mode doesn't and is much easier to do.
BUT, the server mode works only with RS 2005.
Your best bet is to embed an IE control and use URL integration.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Richard" <Richard@.discussions.microsoft.com> wrote in message
news:214F9EC1-BFD6-43E6-AC25-42D3A2A2B6F2@.microsoft.com...
> Hello,
> I need to display a report on a winform.
> The report is a RS2000 report served by a RS2000 server.
> The winform is in a VB .NET 2.0 (VS 2005) project.
> 1) Can I use a ReportViewer control (.NET 2.0) on this winform to display
> this RS2000 report?
> 2) Must the ReportViewer control have its own dataset even though the
> report
> is being served?
> Thank you in advance,
> Richard|||Thank you. Yes, I suspected that my only option was IE control.
But using the IE control and url integration, how can the navigation links
("My Subscriptions") and tabs ("Properties | History | Subscriptions") at the
top of the report's page be disabled or removed so the user don't see them,
just the report?
Thank you in advance,
Richard
"Bruce L-C [MVP]" wrote:
> Two modes for control: server and local. Local requires giving the control
> the rdlc file and the dataset. Server mode doesn't and is much easier to do.
> BUT, the server mode works only with RS 2005.
> Your best bet is to embed an IE control and use URL integration.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Richard" <Richard@.discussions.microsoft.com> wrote in message
> news:214F9EC1-BFD6-43E6-AC25-42D3A2A2B6F2@.microsoft.com...
> > Hello,
> >
> > I need to display a report on a winform.
> > The report is a RS2000 report served by a RS2000 server.
> > The winform is in a VB .NET 2.0 (VS 2005) project.
> > 1) Can I use a ReportViewer control (.NET 2.0) on this winform to display
> > this RS2000 report?
> > 2) Must the ReportViewer control have its own dataset even though the
> > report
> > is being served?
> >
> > Thank you in advance,
> >
> > Richard
>
>|||You have control over all of that with the URL. However, being a URL the
user if they knew what they were doing could still get to those areas by
modifying the URL.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Richard" <Richard@.discussions.microsoft.com> wrote in message
news:68DB3C3D-E6F5-49FD-A217-AFCEB434C80A@.microsoft.com...
> Thank you. Yes, I suspected that my only option was IE control.
> But using the IE control and url integration, how can the navigation links
> ("My Subscriptions") and tabs ("Properties | History | Subscriptions") at
> the
> top of the report's page be disabled or removed so the user don't see
> them,
> just the report?
> Thank you in advance,
> Richard
> "Bruce L-C [MVP]" wrote:
>> Two modes for control: server and local. Local requires giving the
>> control
>> the rdlc file and the dataset. Server mode doesn't and is much easier to
>> do.
>> BUT, the server mode works only with RS 2005.
>> Your best bet is to embed an IE control and use URL integration.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Richard" <Richard@.discussions.microsoft.com> wrote in message
>> news:214F9EC1-BFD6-43E6-AC25-42D3A2A2B6F2@.microsoft.com...
>> > Hello,
>> >
>> > I need to display a report on a winform.
>> > The report is a RS2000 report served by a RS2000 server.
>> > The winform is in a VB .NET 2.0 (VS 2005) project.
>> > 1) Can I use a ReportViewer control (.NET 2.0) on this winform to
>> > display
>> > this RS2000 report?
>> > 2) Must the ReportViewer control have its own dataset even though the
>> > report
>> > is being served?
>> >
>> > Thank you in advance,
>> >
>> > Richard
>>|||If the report server and the report are 2000, can't the 2005's ReportViewer
control display the report? Thank you.
"Bruce L-C [MVP]" wrote:
> You have control over all of that with the URL. However, being a URL the
> user if they knew what they were doing could still get to those areas by
> modifying the URL.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Richard" <Richard@.discussions.microsoft.com> wrote in message
> news:68DB3C3D-E6F5-49FD-A217-AFCEB434C80A@.microsoft.com...
> > Thank you. Yes, I suspected that my only option was IE control.
> > But using the IE control and url integration, how can the navigation links
> > ("My Subscriptions") and tabs ("Properties | History | Subscriptions") at
> > the
> > top of the report's page be disabled or removed so the user don't see
> > them,
> > just the report?
> >
> > Thank you in advance,
> >
> > Richard
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> Two modes for control: server and local. Local requires giving the
> >> control
> >> the rdlc file and the dataset. Server mode doesn't and is much easier to
> >> do.
> >> BUT, the server mode works only with RS 2005.
> >>
> >> Your best bet is to embed an IE control and use URL integration.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Richard" <Richard@.discussions.microsoft.com> wrote in message
> >> news:214F9EC1-BFD6-43E6-AC25-42D3A2A2B6F2@.microsoft.com...
> >> > Hello,
> >> >
> >> > I need to display a report on a winform.
> >> > The report is a RS2000 report served by a RS2000 server.
> >> > The winform is in a VB .NET 2.0 (VS 2005) project.
> >> > 1) Can I use a ReportViewer control (.NET 2.0) on this winform to
> >> > display
> >> > this RS2000 report?
> >> > 2) Must the ReportViewer control have its own dataset even though the
> >> > report
> >> > is being served?
> >> >
> >> > Thank you in advance,
> >> >
> >> > Richard
> >>
> >>
> >>
>
>|||No, the reportviewer control only support RS 2005 reports.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Richard" <Richard@.discussions.microsoft.com> wrote in message
news:AF954A4C-BB99-4188-AD7B-3FEEC4873247@.microsoft.com...
> If the report server and the report are 2000, can't the 2005's
> ReportViewer
> control display the report? Thank you.
> "Bruce L-C [MVP]" wrote:
>> You have control over all of that with the URL. However, being a URL the
>> user if they knew what they were doing could still get to those areas by
>> modifying the URL.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Richard" <Richard@.discussions.microsoft.com> wrote in message
>> news:68DB3C3D-E6F5-49FD-A217-AFCEB434C80A@.microsoft.com...
>> > Thank you. Yes, I suspected that my only option was IE control.
>> > But using the IE control and url integration, how can the navigation
>> > links
>> > ("My Subscriptions") and tabs ("Properties | History | Subscriptions")
>> > at
>> > the
>> > top of the report's page be disabled or removed so the user don't see
>> > them,
>> > just the report?
>> >
>> > Thank you in advance,
>> >
>> > Richard
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> Two modes for control: server and local. Local requires giving the
>> >> control
>> >> the rdlc file and the dataset. Server mode doesn't and is much easier
>> >> to
>> >> do.
>> >> BUT, the server mode works only with RS 2005.
>> >>
>> >> Your best bet is to embed an IE control and use URL integration.
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> "Richard" <Richard@.discussions.microsoft.com> wrote in message
>> >> news:214F9EC1-BFD6-43E6-AC25-42D3A2A2B6F2@.microsoft.com...
>> >> > Hello,
>> >> >
>> >> > I need to display a report on a winform.
>> >> > The report is a RS2000 report served by a RS2000 server.
>> >> > The winform is in a VB .NET 2.0 (VS 2005) project.
>> >> > 1) Can I use a ReportViewer control (.NET 2.0) on this winform to
>> >> > display
>> >> > this RS2000 report?
>> >> > 2) Must the ReportViewer control have its own dataset even though
>> >> > the
>> >> > report
>> >> > is being served?
>> >> >
>> >> > Thank you in advance,
>> >> >
>> >> > Richard
>> >>
>> >>
>> >>
>>