Hiding Breadcrumb And Home Link At The Top
May 16, 2007Hi,
How can I hide breadcrumb shown at the top of report and Home link for a Browser role ??
thanks,
prashant
ADVERTISEMENT
Access2003 Cannot Link (but Excel2003 Can Link) To Tables In Access97 Database
Feb 20, 2008I have created an Access2003 project (existing data) that links to external data. First I connected to a SQL Server 2000 database. Success. Then I tried to set up a Transact SQL data connection to a legacy MDW-secured Access97 database. (A third-party VB6 application goes against it, and we don't have the source code, so we cannot upgrade it.)
The Transact SQL link tests OK but I cannot select any of the tables or queries from the list presented. However, with the same credentials, I can use these same objects in Excel 2003.
When setting up the link in Access2003, I specify JET 4.0 OLE DB Provider, I enter the MDW file on the All tab, a username and a password on the Connection tab where I browse to the MDB file, and specify Shared Deny None on the Advanced tab. When I test the connection, it tests OK ("Test connection succeeded"). Yet on the "Select the Database and Table/Cube which contains the data you want" dialog, "(Default)" appears in the grayed-out dropdown. Then, beneath that dropdown, there is a grid with Name and Description columns. The grid contains query names but the grid is not enabled. The list of queries is this table is grayed out. Neither of the scrollbars works.
BUT... if I use the SAME username and password in Excel2003, and specify the same MDW, there is no problem working with these same database objects in the legacy Access97 database. WHAT IS DIFFERENT ABOUT THE WIZARD IN EXCEL THAT ALLOWS IT TO SUCCEED AND THE WIZARD IN ACCESS THAT CAUSES IT TO FAIL HERE? In Excel, the list of available providers says Microsoft Access Driver, not JET 4.0 OLE DB Provider.
Thanks
TR
Cannot Link To SQL Tables Using ODBC Link Table In Access 2003
Feb 3, 2006When trying to link to an SQL table in Access 2003, the software appears to be malfunctioning.
The sequence of events is File - Get External Data - Link Tables - Files of Type: ODBC Databases().
The Problem: On two of my computers, the select data source window does not pop up, preventing me from linking to any ODBC data source.
Observations: This function has worked normally in the recent past and works on other computers running Access 2003. One difference between the computers working and non-working computers is Norton Antivirus 2006 (recent upgrade).
Has anyone experienced anything like this? What's going on?
Hiding A Zero Value
Jan 11, 2007How can I hide or suppress the 0-values (zero) in a report?
View 8 Replies View RelatedHiding Particular Objects
Aug 1, 2000Hey guys,
Is there any way to hide a particular object(table,sp,tr etc) from
a particular user?
we are developing softwares for the clients..and Once we install our product we dont want the clients site guys to go and delibrately view the data from sql server but through the front end. Is there anyway that i can do that...?
For Eg..the front end codes are capsulated as DLLs so that no can view the code.. Like that for SQL Server..can we do that kinda stuffs to prevent them?
MS SQL Hiding Behind Access
Dec 7, 2005Hi guys
We have a helpdesk application which is based on an MS SQL database, and which runs with a rather large and complicated C# based interface. We don't have the code for this, so we can't customise it. Long story short, what we want is to create an interface in Access (or similar) which accesses the same database as the helpdesk suite, and allows reading AND writing, and some rather complex operations (which SHOULD be fairly simple to do in SQL).
Unfortunately, I have been given this project, and I know about as much about Access and SQL as I do about Ghengis Khan's fashion sense.
I will follow with more information as required, but I'm going to need a lot of help with this one. First things first, is Access the way to do this? Is it going to be easier to create a new Access DB and synchronise it with the SQL, instead of both applications using the same database?
The only way I can get Access to interrogate the SQL database is to create a Data Access Page - is this the correct starting point? The only problem is that this seems to only offer HTML, and is far from being a friendly interface, at least not to me.
I know that I currently have no grounding in physics and I'm trying to build a space station, but any advice that you could give me would be much appreciated.
Thanks guys!
Hiding The DB Design.
Feb 3, 2004Hi all,
I am going to install my application at my Client's place.
I do not want them to know about my DB design and also i have a lot of master information that I dont want the Client to view.
The Client insists that he would have the Super Administrator user ids and passwords (ie. "sa" - user).
Is there any way i can encrypt my DB design and the data in the DB.
Or is there any other way of restricting the Client from viewing my DB design and data???
Thanks
Vishal
Hiding NULL
Mar 29, 2006In SQL 2000 Query Analyzer, you can set up the text output pane toleave null values blank.That could give you this (assuming it's set to comma-delimited) --CREATE TABLE #Test (A int, B int)INSERT #Test SELECT 1,2INSERT #Test SELECT NULL,4INSERT #Test SELECT 5,NULLINSERT #Test SELECT NULL,NULLSELECT * FROM #TestA,B1,2,45,,I can't figure out how to set up 2005 Management Studio the same way.I can only manage to get outputs like this, with "NULL" instead ofempty fields --A,B1,2NULL,45,NULLNULL,NULLHow can I get rid of the NULLs?Thanks,Jim
View 2 Replies View RelatedHiding Data
Jul 20, 2005Hi,I am intetrested to know if there is a way to hide the information in aspecific column in my table. SQLServer 200. Something like a passwordprotection were you only see *****. I have a DBA but want to hide salaryinformation from him that is stored in the database.Any suggestionsThanksElmo
View 3 Replies View RelatedHiding A Table
Feb 28, 2008Hi,
I am designing a report with a few tables in it which i selectively want to hide if there is no data to display in them.
The tables hide themselves but leave behind a big void without compressing the fields beneath them.
Is there anyway to make sure that the tables are hidden and it compresses the space which it would have otherwise occupied?
The two methods i have tried are:
1. Put an expression in the visibility property and set it to true if the row count is zero
2. set the expression in the NoRows property to =""
(both without luck)
Any suggestions would be greatly appreciated.
Regards,
Ash
Hiding Parameters
Jan 11, 2008
Hi There,
I am fairly new at RS, and have a question about showing/hiding parameters :
What i would like to do is have one report, with the parameters :
Report By : (Date/Week)
Buisiness Stream : (Spares/OEM)
Start Date : (Date)
End Date : (Date)
Start Week : (Start Week Num)
End Week : (End Week Num)
What I would like to do is show the 'Start Date' and 'End Date' when the Report By value = Date
OR
Show the 'Start Week' and 'End Week' parameter when Report By value = Week.
Can someone help me with this?
Thanks
Jamie
P.S. If its not possible to hide the fields, could i grey them out??
Hiding Sub Report
Jan 9, 2008I have main reports and also sub reports in the same project [folder]. I don't want to show sub reports in the reports drop down list. Can you please let me know how to do it?
Hiding Reports
Jul 23, 2007Is there a way to hide reports before publishing and then hiding reports via the Report Manager? We have some subreports that before we publish, we would like to set a flag to hidden so the Report Manager will know after the deploy that this report is to be hidden.
Thanks for the information.
Hiding A Subreport
Jul 24, 2007We have a parameter that takes the values of "Yes" or "No" (non-queried). If the user chooses "Yes", we want the subreport to display, but remain hidden on "No".
In the expression for visibility, we have the following:
=IIf(cstr(Parameters!Heading.Value = "Yes"),False,True)
When the report runs we get the following error: "The input string was not in the correct format."
Has anybody seen this before?
Thanks for the information.
Hiding Groups
May 1, 2008I know how to hide groups using Expressions that use parameters that can be passed in, but can you hide groups that are inside other groups. Here is my situation. Our company has different organization levels. On reports the users want to select which organization levels they want to see the #s for. So I set up groups for each org level like so....
Org Level 1
Org Level 2
Org Level 3
The data results are like so
Org Level 1 Org Level 2 Org Level 3 Category $ Amount
USA Midwest Kansas 1 500.00
USA Northeast Maine 1 200.00
And I sum the $ Amount Per Category for each Org Level using grouping in the report.
Then based on the selections they make it hides the org levels they don't need to see. The issue is that the report will not show org level 2 or org level 3 if org level 1 is not visible, and org level 3 can't be visible if org level 2 isn't visible, etc.....Anyone know a solution to this situation, I know this has had to have come up.
Thanks,
Adam
Hiding Database Views
Oct 17, 2001Help Please!
How can I hide databases from users that do not have permission to log onto them in the SQL Enterprise Manager.
Thanks in advance for the help.
-Rich
Hiding System Tables
Jan 25, 2000Is there anyway to hide system tables in a database so that only user tables are viewed?
Gary
Hiding Implementation/Code
Jul 14, 2004We are planning to sell a software.. and don't want our clients to access the code or database design.
Is there any way to hide the stored proc/trig code and the database table?
Help is highly appreciated.
Thanks
Hiding System Tables
Jan 12, 2004Hi,
Is there a way to hide the system tables on EM?
Thanks
Hiding Parameter Prompts
Jan 24, 2008Hello everyone,
I have a request to hide certain parameters in a report based on the current user logged into our web based report viewer using the ReportViewer control fo asp.net.
I am doing the standard stuff required to display the report as shown below.
Code Snippet
rptViewer.ServerReport.ReportServerUrl = new Uri("http://172.17.144.26/ReportServer"); // new Uri(MINETSecurity.WebSettings.WebServerPath, UriKind.Absolute);
rptViewer.ServerReport.ReportPath = ReportName;
rptViewer.ServerReport.DisplayName = "Report1";
rptViewer.ServerReport.ReportServerCredentials = new CustomReportCredentials("myUsername", "myPassword", "myDomain");
Now that i have loaded the report into the viewer i illiterate through the report parameters looking for the ones which the specified user should not see as show below.
Code Snippet
ReportParameterInfoCollection MyReportParams = rptViewer.ServerReport.GetParameters();
foreach (ReportParameterInfo MyParameter in MyReportParams)
{
// returns a value from a custom class which is a predefined value for this user based on the current user logged into the website
string Value = CustomParameterValues.ToString(GlobalUserSettings.CurrentUser.CustomValueList);
if(Value != "") MyParameter.PromptUser = false;
}
Here is where the promblem lies, when i try to set the value of PromptUser i get the following compiler error.
Property or indexer 'Microsoft.Reporting.WebForms.ReportParameterInfo.PromptUser' cannot be assigned to -- its is read only
Is there anything i can do to set certain parameters invisible to the user and set there value myself. I know i could create 2 seperate reports and set the PromptUser value in the designer but i dont really want to be duplicating reports just to hide or show parameters.
I have tried using the SetParameters method of the ReportViewer component to pass the value of the parameters that should be hidden and even set the visible property to false, but it dosn't seem to work.
Any help here would be appreciated.
Cheers
Scott Blood
Is There A Unique Row Id Hiding Behind The Scenes?
Oct 11, 2007I've heard that if one doesnt have a clustered index on his/her table, that clustering occurs on some underlying row id. Is this true? If so, is that id retrievable?
View 16 Replies View RelatedHiding A Subreport SSRS
Mar 9, 2007Hi,
I'm a newbie inSSRS, kindly help!!
i have a subreport and it needs to be displayed only based on some selection criteria, in all other case it needs to be hidden.i made the visibility to hidden, but when i run the report,it gives me a blank page where it usually gets me the subreport.How can i remove this blank page from getting displayed ?
PS: this is the expression i have added :
=IIF(Parameters!strChoice.Value="Single",True,False)
Thanks in advance for any help..
Hiding Tables In A Report
May 6, 2007Hi,
Can anyone help me with the expression I need to use in order to hide a table with no rows? I have put my table inside a rectangle with the idea that I would just hide the rectangle if there weren't any rows but I can't find any examples of what expression I can use to specify the no rows condition.
Thanks!
Debi
Hiding Sections Of Text
Feb 15, 2008I'm new at Reporting Services. I need to know if the Reporting Services will meet my needs.
I need to create a report that looks much like a Word document with large sections of text. Is it possible to hide some sections of text based on boolean fields in a SQL table/query?
Alternatively.. will it handle rich text? I could then select the appropreate section to display by query.
Thanks in advance
Hiding Header Row In A Group
Mar 21, 2007I have a table with a group. I have one row of the group that is the header for the detail section. How can I suppress the row header in the group if there is no data in the detail section for a group value? I was thinking something along the line of setting the visibilty of the row header to an expression based on the existence of data in the detail, but don't know how to go about this.
Thanks.
Hiding Of Default Objects In MS SQL Server
Jun 1, 2005When created database in Microsoft SQL Server, many no. of default objects will be created.when executed the command "sp_tables", so many no.of system tables will appear in addition to our own created tables. How to Hide them?
View 1 Replies View RelatedHiding Succeeding Rows In A Table
May 20, 2008My scenario is:
I got this ReportItems.Value which is an Integer lets name it Value1.
I got this rowcount and lets name is Value2.
Can you help me generate a query wherein:
1.Value1 = Value2
2. And the Row from Value2 and its succeeding Rows be deleted or be hiden.
ic3m@n
Hiding Secret Columns From Users
Nov 23, 2005Hi,On my SQL Server 2000, I have a table of data (tblAllData) containing anumber of columns, some of which are 'secret'.I have to let some users access the database using ODBC from an Excelsheet, and I would like that they do not know at all that the columns exist.I tried creating a view for them (qryAllData) that only selects thecolumns that should be visible, but when the creating theODBC-connection, both the query and the underlying table shows up.If I select the table as datasource, the query-builder in excel shows alist of all the columns, including the secret ones. If I try selectingthen, of course, an error occurs.I would like either that the columns for the table don't show or thatthe table does not show at all - and only reveals the existence of theview to the odbc-client.Is that possible?Here's what I tried so far:<pre>USE DbAllDatasp_addlogin @loginame='ODBCAccess', @passwd='ODBCAccess', @defdb='DbAllData'sp_grantdbaccess 'ODBCAccess'sp_addrolemember @rolename = db_denydatawriter, @membername = ODBCAccessREVOKE ALL FROM ODBCAccessDENY SELECT ON dbo.syscolumns TO ODBCAccessDENY SELECT ON dbo.syscomments TO ODBCAccessDENY SELECT ON dbo.sysdepends TO ODBCAccessDENY SELECT ON dbo.sysfilegroups TO ODBCAccessDENY SELECT ON dbo.sysfiles TO ODBCAccessDENY SELECT ON dbo.sysfiles1 TO ODBCAccessDENY SELECT ON dbo.sysforeignkeys TO ODBCAccessDENY SELECT ON dbo.sysfulltextcatalogs TO ODBCAccessDENY SELECT ON dbo.sysfulltextnotify TO ODBCAccessDENY SELECT ON dbo.sysindexes TO ODBCAccessDENY SELECT ON dbo.sysindexkeys TO ODBCAccessDENY SELECT ON dbo.sysmembers TO ODBCAccessDENY SELECT ON dbo.sysobjects TO ODBCAccessDENY SELECT ON dbo.syspermissions TO ODBCAccessDENY SELECT ON dbo.sysproperties TO ODBCAccessDENY SELECT ON dbo.sysprotects TO ODBCAccessDENY SELECT ON dbo.sysreferences TO ODBCAccessDENY SELECT ON dbo.systypes TO ODBCAccessDENY SELECT ON dbo.sysusers TO ODBCAccess--allow selectingGRANT SELECT (idx, col1, col2) ON tblAllData TO ODBCAccessGRANT SELECT ON qryAllData TO ODBCAccess</pre>TIA,M
View 5 Replies View RelatedHiding The Database List From A Certain Usergroup
Jun 18, 2007Is there a way to limit what user will see in Enterprise Manager? Iwould like them to only see there db's and not all them.
View 5 Replies View RelatedConditionally Showing/hiding A Parameter
Jul 16, 2007I have a report that in most cases takes 4 parameters. In a few special cases, though, it takes 5 parameters. I have my code modified enough such that it can handle this exception, however I cannot figure out how to conditionally show the 5th parameter based on the 4th parameter. Is this possible?
View 3 Replies View RelatedHiding Sub Report - Auto Deployment
Jan 9, 2008I just asked you about how to hide the sub report from showing it in the drop down list. I have done it with the report manager [Report properties--> general --> Hide in Listview]. I am using RSBuild tool to automatically deploy the reports.I don't know what modification I have to make in the RSBuild code to incorporate this new functionality[Hiding sub report]. Can you please let me know how to do it?
I am using the following code, The description property is working correctly. But the Hide in List view property is not working.
Property[] properties = new Property[2];
Property Prop1 = new Property();
Property Prop2 = new Property();
Prop1.Name = "HideInListView";
Prop1.Value = "True";
properties.SetValue(Prop1, 0);
Prop2.Name = "Description";Prop2.Value = "Muni deployed sub report";
properties.SetValue(Prop2, 1);
But I don't know the proprty name and value for Hide in List view.
Can you please give me the suggestion?
Blank Space When Hiding Textboxes
Jan 20, 2008Hello,
Ik have a problem with the free space if I'am hiding textboxes.
I put 2 textboxes in a rectangle and when I hide the rectangle then the textboxes are gone but the space that the rectangle needed is now blank.
Can I suppress the blank space?
Mvg,
Hans
Hiding Elements For Print And Export
Aug 25, 2006Is it possible to suppress the output of certain report elements when the report is printed or exported? I want a particular image element that has a hyperlink to be visible when the report is viewed within RS's ReportViewer, but don't want it to show up on the printed or exported file. I figure, if this is even possible, the most obvious methods would be either:
1. Put the element in the page header or footer, then set up the page header or footer to not show up on the printed or exported report.
2. Put the element anywhere on the report, and set it to hidden when the report is printed or exported.
Are either of these possible? If not, is there another way to accomplish this?
Thanks,
Don