Hello!
I'm using business objects to show the report Some fields have expression like
=Fields!Customer.Value.Address.Street
but when Address value == null then textbox will show #Error label.
Any ideas how to hide this #Error label, beacause if Customer does not have address I'd rather see empty value than #Error in report
Thanx
Hello all,
I have a report with some groups which can all be expanded/collapsed by clicking on a textbox with an action attached to it.
The example I used can be found here: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=600583&SiteId=1
But I want to hide the row containing this textbox (or the textbox itself) on the actual printed report.
Is there any report item that can tell me if the report is in preview phase, or can it be solved in any other way?
Kind regards,
Dirk Holland
Any way to hide the reporting services error message??? Please help me out to solve this problem
Hello,
I have a report with parameter whice is a multi value parameter.
The problem is that this parameter does not always get a value and when he doest get a value the user gets an error message like:
The "all_names" parameter is missing a value.
Is there a way to hide this error from the user?
I can't check the "allow null value" for this parameter because its a multi value parameter.
Thanks.
I want to add up the values in a couple of text boxes in another textbox. How do I refer to the textboxes?
fields!textbox1.value doesn't work..what does?
I want to do a login in vb.net, when the user enters username and password, it looks into ms sql to find user then compare password with database then select user in database and closes form to open another form with selected database. please help, i am stranded with my project and i am getting nowhere.
View 6 Replies View RelatedHi all,
I've recently started using reporting services after about a 2 year break and have been refreshing my knowledge. I've got a very simple report linked into MS CRM, the report is designed to display cases that are overdue, displaying green colums for cases less that 2 hours old, orange for 2 - 4 hours and red for over 4 hours.
In the backgroundColor field for the details colums I have this code-
Code Snippet
=iif(Fields!Hours_Neglected.Value < 2, "Green", iif(Fields!Hours_Neglected.Value > 4, "Red", "Goldenrod"))
this works fine in the preview window in VS2005 but when I try to deploy I get this error:-
"Warning 1 [rsRuntimeErrorInExpression] The BackgroundColor expression for the textbox €˜ticketnumber€™ contains an error: Input string was not in a correct format. G:AppsVisual Studio 2005ProjectsCRM ReportsCRM ReportsNo Responce.rdl 0 0"
Can anyone shed any light on what this problem is as I'm struggling to find anything online......
Thanks in advance
I want to do a login in vb.net, when the user enters username and password, it looks into ms sql to find user then compare password with database then select user in database and closes form to open another form with selected database. please help, i am stranded with my project and i am getting nowhere.
View 1 Replies View Relatedhi im trying to code a login page using asp.net, vb.net. i have 2 web-controlled textboxes whose values i want to compare to userID and password stored on a SQL server database called users. When button clicked, call function checklogin.
heres the code:
Private Sub btn_login_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btn_login.Click
If Page.IsValid Then
Dim usersDS As New System.Data.DataSet
usersDS = checklogin(userID.Text, password.Text)
If usersDS.Tables(0).Rows.Count = 1 Then
FormsAuthentication.RedirectFromLoginPage(userID.Text, False)
Else
error_log.Text = "Invalid Credentials: Please try again"
End If
End If
End Sub
Function checklogin(ByVal userID As Char, ByVal password As Char) As System.Data.DataSet
Dim connectionString As String
Dim dbConnection As New SqlConnection
Dim dbCommand As New SqlCommand
Dim dataAdapter As New SqlDataAdapter
Dim ds As New DataSet
connectionString = "server=localhost;user id=sa; password=chaos; Integrated Security=SSPI; database=users"
'server=localhost; database=users; integrated Security=SSPI;Â?@user id=sa; password=chaos
dbConnection.ConnectionString = connectionString
With dbCommand
.Connection = dbConnection
.CommandText = "SELECT COUNT (*)Â?@AS pass FROM tbl_users WHERE ((tbl_users.userId = @userId) AND (tbl_users.password = @password))"
End With
dataAdapter.SelectCommand = dbCommand
dataAdapter.Fill(ds)
Return ds
End Function
Heres the error i get:
Details of exception: System.Data.SqlClient.SqlException: There is a syntax invalid near
line {''1
Source error:
Line 75:. CommandText = "declare@userID As varChar; declare @password As varChar; End With .."Line 76:.. line 77:of SELECT COUNT(*) AS pass FROM tbl_users WHERE((tbl_users.userId=@userId)AND(tbl_users.password=@password))
Line 78: DataAdapter.SelectCommand=dbCommand
Line 79: DataAdapter.Fill(ds)
ive just started using .net, im a lil lost...thanks for any help. cheers
Hi!
I use LINQ to SQL for showing reports, everything works fine but when I do something like
Fields!Order.Value.Customer.Address.StreetName it will show The addressStreet value
but if Customer or Address object value is null Textbox will output #ERROR message.
How can I get rid of this, is there any way to override the Textbox control?
Hi!
I dont know if i will explain this correctly, but my problem is with reporting service.
I'm supposed to Sum value in one textbox and than that sum use it in sum in other textbox.
Something like this:
Sum(Fields!Abc.Value/(Fields!dfg.Value+Sum(Fields!abc.Value)),"matrix1_RowGroup1")*100
I get error msg 'The Value expression for the textbox 'textbox49' contains an aggregate function (or RunningValue or RowNumber functions) in the argument to another aggregate function (or RunningValue). Aggregate functions cannot be nested inside other aggregate functions.'
Something like this wont work either Sum(Fields!abc.Value/ReportItems("textbox56").Value)*100
Error The Value expression for the textbox 'textbox55' uses an aggregate function on a report item. Aggregate functions can be used only on report items contained in page headers and footers.
So, pls help if you know how to reference textbox in other in body of report.
Thx.
Hi...
I whant to hide this
Ex.
=Fields!D_FAMILIA_MIS.value
This fields have 4 group and i whant to sum only group added just over 1 line as sub group
I do not speak English well, so it does not lead bad
MC
OVLA
Hi everybody
In my web application I am using SQL Server 2000. But as we all know, its presence in the network is visible to all the clients in the network. Anybody who has SQL Server client installed and knows the password of the database would be able to access DB remotely and this is what I don't want. I want user to access my database only when they are loggedon on physically (directly) on the machine on which SQL Server is installed.
Your replies are awaited.
Thanks in advance.
Regards,
Zulfiqar Dhuka
Configuration:
Windows2000 , SQL7
Three people have administrative priveleges (with priveleges Enterprise admins)
There is special DB in SQL7
Some tables should be hidden from 2 admins (they should be unable to read information from these tables)
Is it possible?
And if it is possible, How to do it?
Thank you very much
Merry Christmas
Happy New Year
Seasons greetings
I have a dimension named Products with the following hierarchy:
Type
Sub Type
Product
Due to requirements I want that a particular product, whose name is, say, "XYZ" should not be displayed when the user drills down to the lowest level i.e. the Product level.
I tried playing with the Advanced Properties tab but could not make any progress and thus will be grateful for help.
Thanks.
Hi,
Is it is possible to hide some parameters in report? Also it should be possible to pass values to this hidden parameters from the application. When I did this through Report Manager, some error message like ' the parameter 'XXXX' is read-only. ....' appears.
Thank You
Sreeraj.P.T
Hi knights,
Pls show me the way to prevent the other users seeing all logins when they logon into SQL Server. Thnks in advance!
Hello,
I have a matrix with subtotal.
I want to hide or show the subtotal by a parameter.
The header of the subtotal is not a problem since it have the "visibility" property.
The problem is that when I'm clicking on the green rectangle to go to the subtotal area itself - It doesn't have the "visibility" property.
So I don't see the header but I see the subtotal date itself.
Any idea on how to resolve this?
Thanks.
Hello Everyone. I need help again.
I have a reports made in VS business intelligence project with a lot of parameters. So it means it automatically creates textboxes of that parameters. I want to hide those textboxes. Pls help.
Thanks
-Ron-
How can I add a sub in my query so that it can hide and need password to view or edit?
View 6 Replies View Relateddear All,
I want to make a Report with attractive selection parameters.
That I mean, there is a parameter, Tparam (Time Param) which will activate other parameters (3 parameters: TimeA_1, TimeA_2 & TimeA_3. These selection values have been registered in the "Aviable values => non-queried".)
when Tparam selected TimeA_1 then Parameter for TimeA_1 will activated (and the others will be disappeared/hidden), vice versa for the other control (TimeA_2 & TimeA_3)
any idea to do that?
thank you...
Hello,
I have a rectangle which contains a chart. Most of the time, the chart has data, so the rectangle should be visible. Sometimes, however, the chart may have no data (zero records). In that case, I would like to hide the rectangle.
Is there any way to "query" data from the report's recordset to see if a certain condition is true.. if so, use that to control the visiblity of the rectangle?
I have one column in the recordset that has many values... the chart will only display data if certain values are returned in the recordset.
Thanks for your advice!
I am currently working on a rather simple report, it cosists of a table with two columns
The first column contains Employee Names, and the second column contials details of what the have worked on
I have made the second column invisible, and can be made visible when the eployee name column is expanded.
The problem that i am having is that when the second column is collapesed, it still leaves whitespace, in the first column, of how ever many rows that are contained in the second column, is there a way, I can get rid of that whitespace?
Thanks
Chris
I'm creating a report that is grouping the rows per year and month, as it does this there are certain rows that show up that I would like to hide since the value in one of the columns is < = 0. For the purpose of my report I don't needs these rows to be illustrated. How can I do this?
Thanks,Alex
I trying to create a report that looks like this:
Item Shipped OnHand PO# DueDate POQty
1234 0 0 111 8/01/07 12
222 8/08/07 12
333 8/16/07 12
2345 4 0 444 8/04/07 24
I pull back all the data in a single query and the result looks like this...
Item Shipped OnHand PO# DueDate POQty
1234 0 0 111 8/01/07 12
1234 0 0 222 8/08/07 12
1234 0 0 333 8/16/07 12
2345 4 0 444 8/04/07 24
Now I can use the Hide Duplicates property to fix the Item column since the query groups on item guaranteeing uniqueness. But that won't work for the Shipped and OnHand columns because adjacent items may have the same Shipped and OnHand totals. How do I hide the Shipped and OnHand values if and only if the Item is the same? Is this really a problem of hiding duplicates or do I need to break apart my query or find a sub-reporting solution?
Hello, I would like to not have to see the aspnet_ tables and stored procedures that are created when using the Membership, roles, and personalization. Currently I have to suffer seeing the handful of tables and 40+ stored procedures in both the Visual Studio and the SQL Management tool. I have found that on a 2000 SQL Server I can execute a command that forces objects to be created as system objects. If I execute this before creating the objects they become system objects and I don't have to see them any longer. However, this trick does not work in SQL Server 2005. So, I would like to know either 1) is there an easy way to hide these objects or 2) is there a way to change the objects to system objects in SQL Server 2005? CodeGuy
View 5 Replies View RelatedIs is possible to hide "salary" or other sensitive data from a person who is a Sys-Admin. My belief is that there is no way. Please correct me.....
Assumptions: SQL Service account has Local Admin privelege.
Sysadmin can do anything on local machine, including run scripts adding themselves to any default/instance of SQL on the machine.
Please direct me to any other source of information for this topic.
Thanks for your input
Is there a way to not have system objects (tables, procs) display in Enterprise Manager?
View 1 Replies View RelatedHi,
How can I hide all the system tables so that only user tables show in table view.
Thank you very much!
John
Hi everyone,
I've recently installed MSQL Server 7.0 Standart Version and every time I create a new database, system tables are created and are visible also. That means, I instantely get 18 tables, 20 views, 18 stored procedures and so on. Can I hide them??? I mean, my tables are all mixed with the system tables. If I can hide all the system tables and views and so on please tell me! Thanks.
I am setting up several isql job in Enterprise Manager and as a cmdexec job I need to pass the user id and password( -P). I shtere any way not to pass this as text and perhaps hide/encrypt it since any one who opens the task scheduler and looks at the job can read the password?
Thanks.
DAvid Spaisman
Hi,
I have a dimension called customers having the following levels:
ALL
Level 1 CustType
Level 2 Cust Rank
Level 3 Cust Name
Suppose that the possible CustTypes are "Potential", "Active", "Lost".
Is it possible to hide displaying Level 1 and below if the Custtype (Level 1) = "Potential"
Hi All,
I would like to control user access to my Report Manager.In detail,I would like to hide some report folders from certain users when they access the Report Manager.Some of the users are not suppose to see certain folders on the report manager,and some users are suppose to see all report folders.
How can I do this?.Where should I include this settings?