Listbox to only appear if there are records returned from the SQL select query

I would like to make a listbox only appear if there are results returned by the SQL select statement.

I want this to be assessed on a click event of a button before the listbox is rendered.

I obviously use the ".visible" property, but how do I assess the returned records is zero before it is rendered?

hi,

there must be datasource(dataset or reader) for that listbox i believe.

if its dataset then use dataset.tables[0].Rows.Count, if its reader then use reader.hasrows.

hope it helps.

regards,

satish.

|||

Thanks Satish,

I used an if statement to assess if rows > 0

Cheers,

Ben.

|||

cheers Ben.

satish.

sql

List of color names?

I would like to put the names of the colors into the database to allow users
to configure how they want a matrix report to appear. I don't think they
are standard HTML names are they?
Can someone point me to where can I find this list of names, or any other
advice with this endevour?
cheers,
Paul.On May 10, 8:43 pm, Paul Ritchie <REMOVEpritc...@.xtraREMOVE.co.nz>
wrote:
> I would like to put the names of the colors into the database to allow users
> to configure how they want a matrix report to appear. I don't think they
> are standard HTML names are they?
> Can someone point me to where can I find this list of names, or any other
> advice with this endevour?
> cheers,
> Paul.
The colors are the same ones that are available when building a web
application. To view the available colors, add a textbox control to a
report in Layout view. Select the textbox control. Select 'F4' (or the
'View' drop-down tab -> Properties Window) and select the drop-down
list to the right of BackgroundColor.
Regards,
Enrique Martinez
Sr. Software Consultant

List control - New Page

I'm a newbie to SRS and have an easy questsion. I have a list control with a
text box and want the values in that text box to appear on a new page. I've
tried all the page break options in the list properties but nothing will
work. I've also tried creating a details group on my text box and that does
not work either. Any help would be appreciated.Found the problem. Page was too wide, and it would not display correctly in
preview mode.
"jweesies" wrote:
> I'm a newbie to SRS and have an easy questsion. I have a list control with a
> text box and want the values in that text box to appear on a new page. I've
> tried all the page break options in the list properties but nothing will
> work. I've also tried creating a details group on my text box and that does
> not work either. Any help would be appreciated.