In SSRS I have a List with, say, a table with two columns: name and number e.g.:
[Code]...
Name is never null, but number may be. In this case I want the report to include the NULL in each group, like this:
[Code]...
The SSRS, however, puts the null in a group on its own. How do I accomplish this?
The Error I am getting while adding a group to reporting services which exist in the database
"The user or Group domaingroupname is not recognized. (rsUnknownUserName)"
Consider this SSRS value expression :=IIF(First(Fields!MyCol.Value, "MyDataSet")=0, "yes", "no")
MyCol is a Nullable column. I want "yes" to be output only when MyCol equals 0. The code above correctly evaluates to "yes" when MyCol is 0. However, it also evaluates to "yes" when MyCol is Nothing (i.e. NULL in SQL Server). Is this expected behavior ?
I had to resort to the following longer expression to get the desired result :
=IIF(Not(First(Fields!MyCol.Value, "MyDataSet") is Nothing) And First(Fields!MyCol.Value, "MyDataSet")=0, "yes", "no")Is there a shorter version of this which also works ?
I am trying to implement a function for my SSRS report which will return a color value depending on the values of three dates.
[Code]...
I am using following code in rowdatabound fn.
Protected Sub gvwMileStone_RowDataBound(ByVal sender As System.Object, ByVal e As System.Web.UI.WebControls.GridViewRowEventArgs)
[code]...
ddlEProjectLevels is dropdownlist in edititemtemplate.Whwn i click edit in 1st row ddlEProjectLevels gets loaded with data from database.But in 2nd row dropdownlist does not contain values.Again in 3rd it gets loaded from db.Means in alternate rows,when i click edit dropdownlist(ddlEProjectLevels) doesnot load values.Can anybody help?
I`m using below login solution and need to add one more column with Working Group details.
Once user logs-in (after OK command MDIparent form is displayed), working group details will be displayed in toolstrip status label.
[URL]
I have a report with a dataset that has a column with booleans. In the table footer I want to display x / y where x is how many rows that were true and y is how many rows there was total.
[Code]...
I've found out that if two instances of an SSRS report run at the same time, any Code variables declared at the class level (not inside a function) can collide. I suspect this may be the cause of our report failures and I'm working up a potential fix.The reason we're using the Code portion of SSRS at all is for things like custom group and page header calculation. The code is called from expressions in TextBoxes and returns what the current label should be. The code needs to maintain state to remember what the last header value was in order return it when unknown or to store the new header value for reuse
View 11 RepliesI would really like to know if there is anyway in which I can package two or more set up files together with my vb.net application; so that after installing the application, it automatically starts installing the other applications from the other set-up files.
In my case I want to include mysql server and client together with the application for a demo cd, that am making for a client.
I am doing a simple backup of sql server database through VB.NET form. It gets executed well but I want to display details of successful query execution in a label (i.e. time taken, database size etc.)
The message which I want to display in label is like "Processed 296 pages for database 'aaa', file 'aaa' on file 1. Processed 1 pages for database 'aaa', file 'aaa_log' on file 1. BACKUP DATABASE successfully processed 297 pages in 0.522 seconds (4.660 MB/sec)."
This result we get in sql server query window when we execute backup query there. I want to get this message in label when I fire backup query from Windows form in VB.NET
I am building a site for our company to share files between all users but administrators will be the only users who can add new files to the site.I need the administrator to be able to upload a file to a folder on the server and at the same time create a new record for that file and include a title, description, url of file, and other details in the database. In one click.
View 4 RepliesI have 4 Tables Master And Three Tables Details
how to programming this Technique
This Picture dispaly what i mean http://img300.imageshack.us/img300/3981/26072009110315.png
i would like to select from the following table:
PostTable
feed dateinserted count
box1 2011-05-28 11:00 1000[code].....
the total number of records for the previous day where the feed is, 1, 3 and 5 i.e.the feeds I need to retrieve totals for will just be selected based on what I need for instance it could be box4 and box 5...not specifically odd and even...I hope this makes it more clearer..what I have for all records:
select sum(count) as [total] from PostTable where Cast(dateinserted as DATE) =
CAST(getdate()-1 as DATE)
Im using VB 2008 express but dw any code i get ill just use the tool 2008 has to put the code in 2008.Anyways what im trying to do is make a chat program for about 100-200.How can i get a server on my comp so i can update the list of usernames of passwords without updating the program? How can i get the program on there PC to check my server on my comp if there input is validate? How can i get several users into the chat?How can i get it to display there names when they join the chat and get it to disappear when they leave?
View 14 RepliesI'm trying to get a details view in ASP.NET to display the details of the logged-in user only. I have been told to use:
select * from STAFF where USERNAME = user.identity.name
I thought this was too simple to be true and I was correct as it shows no data when I attempt to run.
How can i remove this in my crystal report . this value is showing if my date field in null . "1/1/1900 12:00:00 AM". I don't want to show thin is my report.I have two dates , case open date and case close date . if the case is not closed its showing this value so i want to remove this.I am using sqlsever.
View 3 RepliesI am calling a Java-script function, in that i am passing the value of hidden field, that hidden field i want to use at server-side, but the value of hidden field is null.[code]...
View 1 RepliesI'm using VS2010, vb.net, .net framework 4.0, and SQL Server 2008 Express on Windows 7 Pro with all updates installed. I have developed a website that uses memberships, profiles, and roles. I allowed the built in providers to create the aspnetdb.mdf file for me in the App_Data folder. I added a number of my own tables to aspnetdb.mdf so I would have a single database for all my site's data.
I am hosting the site on my own server. It uses Windows 2003 Server, IIS 6, SQL 2008 Express, and all of my software including the OS is up to date with the the latest servicepacks, updates, and all of the .net framework updates including 4.0. There are no updates left to install and I'm sure that my issue isn't due to a missing update or framework version.
I copied the aspnetdb.mdf and .ldf files from my app_code folder to the sql server express folder on my server and attached the database. I do this because I don't want the file to autoattach, because I will likely use a commercial hosting service in the future. I added a sql server user with ownership rights to the DB. strong text
I then modified my connection string in web.config to point to the UNC of my SQL Instance on my server and to authenticate with the sql server username and password that I set up with ownership rights to that database. I updated my membership, role, and profile providers in my web.config file to use the new sql connectionstring and I was sure to include the application="/" setting and to use before each provider.
I can run the site just fine from my development machine. I can log on to it and use all of its features. However, when I publish the site to my server I can access the site, both locally over my intranet and over the internet. I can navigate around on it and it retrieves all of the data from the tables that I added to the database myself, but when I try to log on to it or to create a new account (basically anything that uses memberships, roles, or profiles) the site crashes with the error and all of the data below.
I've checked to verify that the application name in my aspnetdb database is in fact simply "/". I've ensured that I'm running from an application pool that is using the 4.0 framework. Much of the googling and reading that I've done seems to indicate a problem with my providers, but I can't understand why it works perfectly on Casini (or whatever the development server is called) on my local machine but crashes on my web server. In both cases they are connecting to the same database.
I would be so grateful if anyone could tell me what I'm doing wrong here. Following are the full error displayed by my server when the site crashes and also what I feel are the relevant sections of my web.config file.Full content of error message and relevant sections of web.config are below:
Server Error in '/' Application.
Value cannot be null.
Parameter name: type
[code]....
I get a 'Conversion from type DBNull to String is not valid' error when I proceed to insert the row with a null cell value from my program to MS Sql Server even if the column is already set to accept null values in the database. How do I solve this? FYI I'm using an unbound datagrid, and I get all the screen values during runtime.
Property SerialNo()
Get
Return strSerialNo [code]...
How can I achieve this. Insert Null Value into SQL Server DateTime Field?
View 5 RepliesI have this simple-minded query:
select a.str_number+' '+a.str_name+' '+a.str_suffix+' '+a.str_apt AS addr from mytable
This query works as long as none of the concatenated values are not NULL. If any is null, the address does not show.
I tried this:
select IsNULL(a.str_number+' '+a.str_name+' '+a.str_suffix+' '+a.str_apt AS addr,'') from table
What I would like to accomplish is to replace NULL with empty space if the value is null but I still get no values.
I'm trying to match up a specific group name and see if it exists for the currently logged in user using Active Directory roles. If the Group Name exists for the Current User, I want that group name to be displayed in a drop down list. Example: If current user is in BIG Group, display BIG in drop down list.Problem: All I am getting is SIDs and I'm not able to get anything to match up to the group name and nothing will show up in the drop down list.I also get the following Error:Error: Object variable or WIth block variable not set.How do I fix this?? here is the code I am using:
Private Sub GetMarketingCompanies()
' code to populate marketing company drop down list based on the current logged in users active directory group that
[code].....
Enumerate if an Active Directory group's member is user or another group
View 1 RepliesWhen I deployed my project on a server, in certain circumstances, I get an error page that indicates I should create a custom error page. I was wondering how exactly I would implement this custom error page the server asks for to give me a precise and helpful message or preferably, how I would get the error to just display on the main page?This is the error message I got below
Runtime Error
Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine.
Details: To enable the details of this specific error message to be viewable on remote machines, please create a <customErrors> tag within a "web.config" configuration file located in the root directory of the current web application. This <customErrors> tag should then have its "mode" attribute set to "Off".
<!-- Web.Config Configuration File -->
<configuration>
<system.web>
[code]....
Notes: The current error page you are seeing can be replaced by a custom error page by modifying the "defaultRedirect" attribute of the application's <customErrors> configuration tag to point to a custom error page URL.
<!-- Web.Config Configuration File -->
<configuration>
<system.web>
[code]....
I am writing an application and I do not know how to reference a group of controls inside a group box. I will include the code I have written so far and a picture with a detailed explanation as to what I am trying to do. Feel free to comment on any discrepancies that you may notice in my code.
Code:
Public Class Form1
' The following class-level constants are used
' to calculate the price of the model
Const decCOUPE As Decimal = 18000
[code].....
I want to remove a group (include all items in this group) in ListView, but unsuccessful, the code is below, why?
ListView1.Groups("GroupName").Items.Clear()
ListView1.Groups.Remove(ListView1.Groups("GroupName"))
anyone have some quick code on how to do this?
wmi is not a option.
I have a report already setup on the ReportServer. And its subscription as well. What I'm trying to do is add the ParameterValue "CC" and some email addresses then send the email out. It doesn't seem to work.
My code:
Dim emailReader As SqlDataReader = selCount.ExecuteReader
Dim emailsTest As List(Of String) = New List(Of String)
[code].....
This is Nagaraj.here i have a doubt .how to set the credintials for ssrs in vb.net .here i am running a web application with code behind as vb.net.
View 1 RepliesI want to divide the content in my application to groups each group has its own rectangle border with the group name located at the top border, i've seen it before and i'm not sure what is the correct name of this control, anyone knows what I'm talking about ? EDIT: Ok, I found the Groupbox Control but how do i use it? should i just drag other controls inside it or i should add controls directly into it?
View 2 Replies
