Showing posts with label displaying. Show all posts
Showing posts with label displaying. Show all posts

Wednesday, March 28, 2012

Hide documente map

I have a report in which i don't know what I did but it has started
displaying the document map, I know this might be silly but still i haven't
been able to get rid of it, how do I do it?Rodrigo Sánchez wrote:
> I have a report in which i don't know what I did but it has started
> displaying the document map, I know this might be silly but still i haven't
> been able to get rid of it, how do I do it?
I don't normally use document maps, but have you already checked to make
sure that none of the groups have a document map label set? (Will be on
the first tab shown when you go into the "Edit Group..." dialogs.)
That's the first thing I would check for.
-BA|||Almost all reportitems (e.g. matrix, table, list, chart, rectangle, textbox,
line), and groupings (except chart groups where Labels have a different
meaning) have a property called Label. If the Label property is set on any
of these and the label expression returns a value different than Nothing,
the document map will show up.
You can close/hide the document map window if you want to temporarily get
rid of it.
The quickest solution to permanently find&remove all document labels is
probably this:
You can open an RDL file in a XML editor, report designer code view, or
notepad and just search for <Label> elements and remove them. (!) However,
make sure to *not* remove <Label> elements on report parameters or on chart
groupings (because these are the labels shown inside the chart).
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Rodrigo Sánchez" <rodrigoss@.netshoreprogramming.com> wrote in message
news:eSeN$FNrEHA.2696@.TK2MSFTNGP15.phx.gbl...
> I have a report in which i don't know what I did but it has started
> displaying the document map, I know this might be silly but still i
haven't
> been able to get rid of it, how do I do it?
>

Monday, March 19, 2012

hi , query for displaying data

i want to show selected data from my database table in the text boxes using select statment, can anyone help me out pl for displayin selected data from database directly in text boxes..It depends on what language you are programming (C#, VB, Java).
So, please post the question on the specific forum, to get the right answer quicker.|||sorry m new to this site, so didnt knew..
i m using vb.net language in my asp.net project.. can u help me or show me code that can shows the database rows into textboxes in asp.net page with select query..

Wednesday, March 7, 2012

HELP? Space available: 0MB when ...

displaying the property of a database? What does it mean?

I am sure when this happens but now when I right click on a database and
select property, the space available= 0.00MB.

I still have physical space on the server.

When viewing the taskpad.

Space allocated:

data 5500MB used, 1700 MB free
log 15MB used, 300 MB free

Please help. Thank youif i remember something i read correctly, the database files are set to a certain size upon creation. any space that isn't used by working data is filled up with empty pages.

If the database isn't storing any more data, then it must be full. In this case you would need to set it to automatically grow when it gets full.|||I forgot to add that the data file and log file are set to automatically
growth by 10%.

Any other thoughts. Thanks|||For a database that size, I would set it to a flat growth rate (say 10 or 50MB, depending on how fast it grows). As for Enterprise Manager. I have not trusted the numbers it generates for a long time. I would not worry too much over it.

Help: Table name displaying twice in SQL Statement inside SQL Server Enterprise Manager

For some reason whenever I look at the SQL statement of a particular table, the table name displays twice.
For example,
SELECT * FROM State State
Even when I execute this statement, it still returns the correct results. It does this for all tables in this particular database. I also check another database and thoses display the table names in the SQL statements correctly.
Does anyone know why the table name would display twice in a table inside of a particular database?

How (where) are these statements being generated? All this is doing is creating an alias for the table with its own name, so this won't hurt anything. It's much like doing:
SELECT A.Field1 FROM State A
Marcie|||

datagridgirl wrote:

How (where) are these statements being generated? All this is doing is creating an alias for the table with its own name, so this won't hurt anything. It's much like doing:
SELECT A.Field1 FROM State A
Marcie


It just came up whenever I look at the SQL statement (SQL Pane) after "Returning All Rows" of a particular table. I guess it is not a big deal. I just don't know why it would do that.|||

voodoo9055 wrote:

It just came up whenever I look at the SQL statement (SQL Pane) after "Returning All Rows" of a particular table. I guess it is not a big deal. I just don't know why it would do that.


I'm curious now...in what tool? I'm not seeing this behavior in either VS.NET (via Server Explorer) or Enterprise Manager...
Marcie|||

datagridgirl wrote:

voodoo9055 wrote:

It just came up whenever I look at the SQL statement (SQL Pane) after "Returning All Rows" of a particular table. I guess it is not a big deal. I just don't know why it would do that.


I'm curious now...in what tool? I'm not seeing this behavior in either VS.NET (via Server Explorer) or Enterprise Manager...
Marcie


Enterprise Manager.
It displays that way for one of my databases. The rest display normally.