Is there a program like Access that can open a SQL database and display the information?
You can link the tables and view data using Access.
You can also install the SQL Client tools and use Enterprise Manager or Management Studio (depending on version).
|||Hi,If you have Access in place which supports ADP projects you can establish a connection to the database and will be able to view almost all user defined objects in the database.
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
I need some inputs regarding the
following points related to the SSRS reports:
1. We have a table in
the report and we want to change the display order of the columns when
downloading the report in the CSV format. What could be the possible approach
for this?
2. How to set bookmarks for a report when
downloading the report in the PDF format?
3. We have a table in the report and we
are hiding few cells of the table based on some condition. Now when a particular
cell is made invisible, a blank space exists at the location of that cell. The
requirement is that if we hide one cell, the cell below it must shift above i.e
at the location of the hidden cell.
In SSRS if we hide one row of a table,
then the row below it automatically shifts upwards, but this is not applicable
for a table cell.
Could anyone please provide vaulable
feedback on these points?
Thanks,
S Suresh
1. Not possible
2. Yes, you can create bookmarks for groups in your report by using "Document map label" feature when you edit the group.
3. Instead of having different cells in a row, merge all the cells and then have a rectangle inside that merged cell and then have multiple textboxes inside the rectangle in the same positions as cells were before. When you control the visibility of these textboxes inside a rectangle, they will move up if the visibility of the above cell is hidden.
Shyam
