RS2k - Display text to say there are no rows?

Hi,

This is probably an easy one, but its been bugging me.

If I have no rows for a particular table, is there any way that I can simply display some text saying something like 'no data available for report' ?

Similarly, I was thinking I could hider certain controls on the report if there are no rows available by using an expression in the Visible property of the control.

Any suggestions are appreciated.

Regards.

MrPeds

In the VS Properties (not the Properties from the context menu) there is a NoRows property that is the Text you want displayed when the dataset returns no rows. There is not a way to determine from the table at run time if there are any rows or not, but you can get a row count on DataSet1 like:

Code Snippet

=CountRows("DataSet1")

Hope this helps.

Larry

RS Migration to new server

My team is moving its development to London. A Reporting Services
server has been configured in London, but aside from simply importing
existing RDLs, what is the best way to migrate existing subscriptions,
snapshots, etc. to the new server from the old? Is this simply a copy
of certain tables in the Reporting Services database?
At a 10,000-ft. level, how can this be accomplished? A simple link to a
how-to will suffice, I just had trouble finding one.
Thanks!
MikeDid you ever receive help on this. We're going through the same thing, and I
have two servers to migrate.
--
Thanks,
CGW
"Bassist695" wrote:
> My team is moving its development to London. A Reporting Services
> server has been configured in London, but aside from simply importing
> existing RDLs, what is the best way to migrate existing subscriptions,
> snapshots, etc. to the new server from the old? Is this simply a copy
> of certain tables in the Reporting Services database?
> At a 10,000-ft. level, how can this be accomplished? A simple link to a
> how-to will suffice, I just had trouble finding one.
> Thanks!
> Mike
>|||This link should help if you are moving to the SAME version of reporting
services..
http://support.microsoft.com/default.aspx?scid=kb;en-us;842425
If you are using a different version, then you're in the same boat as I am.
If you get any info on migrating to newer version, please let me know.
Hope this helps
"CGW" wrote:
> Did you ever receive help on this. We're going through the same thing, and I
> have two servers to migrate.
> --
> Thanks,
> CGW
>
> "Bassist695" wrote:
> > My team is moving its development to London. A Reporting Services
> > server has been configured in London, but aside from simply importing
> > existing RDLs, what is the best way to migrate existing subscriptions,
> > snapshots, etc. to the new server from the old? Is this simply a copy
> > of certain tables in the Reporting Services database?
> >
> > At a 10,000-ft. level, how can this be accomplished? A simple link to a
> > how-to will suffice, I just had trouble finding one.
> >
> > Thanks!
> > Mike
> >
> >|||Excellent!
--
Thanks,
CGW
"J Selburg" wrote:
> This link should help if you are moving to the SAME version of reporting
> services..
> http://support.microsoft.com/default.aspx?scid=kb;en-us;842425
> If you are using a different version, then you're in the same boat as I am.
> If you get any info on migrating to newer version, please let me know.
> Hope this helps
> "CGW" wrote:
> > Did you ever receive help on this. We're going through the same thing, and I
> > have two servers to migrate.
> > --
> > Thanks,
> >
> > CGW
> >
> >
> > "Bassist695" wrote:
> >
> > > My team is moving its development to London. A Reporting Services
> > > server has been configured in London, but aside from simply importing
> > > existing RDLs, what is the best way to migrate existing subscriptions,
> > > snapshots, etc. to the new server from the old? Is this simply a copy
> > > of certain tables in the Reporting Services database?
> > >
> > > At a 10,000-ft. level, how can this be accomplished? A simple link to a
> > > how-to will suffice, I just had trouble finding one.
> > >
> > > Thanks!
> > > Mike
> > >
> > >