Hide empty detail sections

Hi,
I'm building a report that displays a tree structure with the content
of some nodes of the tree (as detail). Some nodes don't contain any
info, thus the detail section is empty. How can I hide the empty
detail section in the report ? Now it displays always an empty row,
but I want to shrink this row because it contains no data. How can I
accomplish this ?
Franc.Never mind, found it already. For some reason you have to use the
expression editor. Just typing the expression in the text box of the
group visibility doesn't work.
Franc.
>Hi,
>I'm building a report that displays a tree structure with the content
>of some nodes of the tree (as detail). Some nodes don't contain any
>info, thus the detail section is empty. How can I hide the empty
>detail section in the report ? Now it displays always an empty row,
>but I want to shrink this row because it contains no data. How can I
>accomplish this ?
>Franc.

Help: Can I load all table content to the memory during SQL server Startup?

Dear Sir,
I use SQL 2000 server. I want to load all the table content to the
memory the SQL server startup.
How can I do that?
My computer has 2 G RAM. The total space of the databse is 1G.
I have set the mininum memory is 1G (in dynamic configue SQL memory) in SQL
server and check the "Reserved physical memory for SQL server". But no all
data load into the memory during SQL server startup.
I just know that if I write a SQL statement to request records, these
records will be load into memory.
SO, I think it is not a good method to select all tables once after the SQL
server just startup.
Thank you for your help!
--
Regards,
Anthony LamAssuming you really want to do this, create a stored procedure which reads the rows and mark it as a
startup proc (sp_procoption).
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"AA" <anthony@.jadeflex.com> wrote in message news:%23ARNLe$gDHA.3272@.tk2msftngp13.phx.gbl...
> Dear Sir,
> I use SQL 2000 server. I want to load all the table content to the
> memory the SQL server startup.
> How can I do that?
> My computer has 2 G RAM. The total space of the databse is 1G.
> I have set the mininum memory is 1G (in dynamic configue SQL memory) in SQL
> server and check the "Reserved physical memory for SQL server". But no all
> data load into the memory during SQL server startup.
> I just know that if I write a SQL statement to request records, these
> records will be load into memory.
> SO, I think it is not a good method to select all tables once after the SQL
> server just startup.
> Thank you for your help!
> --
> Regards,
> Anthony Lam
>