The first 3 columns of my report are dynamic, depending entirely on parameters passed to the stored procedure. The result set from the stored procedure is used as the dataset in my Reporting Services report. Sometimes there are fields that are not returned in the result set and I wanted to display blanks if they weren't there. I tried all the tricks using iif(isNothing(Fields!field1.Value, "",Fields!field1.Value) and using Fields(Parameters!parm1.value).Value in my argument list. Neither of these worked. I created 3 textboxes in my report (table) and placed the three different values in them, i.e., Fields!field1.Value, Fields!field2.Value, and Fields!field3.Value. In certain cases, one or two of these fields would not be returned in the result set. I made them hidden. Then in my other textbox, where I wanted to display the value, I added as the expression, Code.DetermineFieldValue(Parameters!parm1.value, ReportItems!txtTextBox1.Value, ReportItems!txtTextBox2.Value, ReportItems!txtTextBox3.Value) I did this for each of the 3 textboxes, just replacing parm1 with parm2 or parm3. In the embedded code, the function was defined as: public function DetermineField(value1 as object, value2 as object, value3 as object, value4 as object) as object I just refered to my fields as value1 through value4 and it worked. I have been trying this for about a week and couldn't get anything to work. Apparently, it will accept the textbox not having a value, but cannot handle the dataset field directly if it is not returned. It never got to the code. Hope this helps someone. Dove11

Hi. I ended up temporarily doing the following: F2.cmbPub.SelectedValue = strPub F2.cmbPub.Enabled = False F2.cmbPub.DropDownStyle = ComboBoxStyle.Simple This disables the box showing the selected value only. I am coming from a browse screen that has a datagrid with 2 unbound boolean columns, Edit and Delete. The rest of the columns are bound. When I check the Edit box it shows the detail screen with the information for the selected item. I just wanted to be able to allow the user to display the values in the combo box, but not be able to select from it. I wanted the default to be the selected value. I will use the above code for now, but just wanted to know if there was a way to do it. Thanks.

I have tried this already and it still allows the user to select another item (other than the original selected item) in the dropdownlist. This is what I want to prevent. I want them to view it, but not select another item. I want it locked.

This is VB .Net

sorry. This is VB .NET.

I have seen a way to do this a week ago, but cannot find the link. I want the user to view all the items in the combo box, but I don't want them to change the value. Has anyone seen this link or know the answer? The combo box is on the form. It is not in any other control. Thanks

I have a windows form with a datagrid control. I bind the grid to my datasource and then add 2 unbound boolean columns. I create a tablestyle so that I can display these columns (Edit, Delete) in columns 0 and 1 before the bound columns. I can check the check box in the column and it branches to where I want it to go, but unless the row and column coordinates are (0,0) it does not display the check mark until I exit my other app and return to the grid. I displayed the value in the column and it is set to True. I added the code from http://msdn2.microsoft.com/en-us/library/ms996485.aspx to make the check box respond to one click. How do I get it to show the mark prior to the DataGrid MouseUp Event? That's where I branch to my other app. I have turned off tristate. I want the user to see the check mark when they first click the check box. Thanks.

I am using a stored procedure and returning rows to display in my report. I am grouping by a SOURCE field in the stored procedure. When the rows for this source are displayed on separate lines, I suppress the printing of the source on the subsequent lines by using the Previous function. In other words, if I have 5 rows, I print the source on the 1st row (occurrence) but not on rows 2-5. That works great. What I want to do now is sum the data columns for that source by adding a total line. I'm using the Previous function to check when the source changes, but I'm printing the total line on the first occurrence of the new source instead of the last (after row 1 instead of after row 5). I basically need to do a look ahead, determine how many rows I have, and then when I get the last row, print the total line. Is there a way of doing this within Reporting Services?

Sorry, I wasn't sure, since it was regarding a web service and SOAP Header. I thought it would go in the XML forum. Thanks for the information. I really appreciate it.

Thanks Mike. I will try that. The server IP address I am trying to capture is a client's. This client is using our web service. We want to allow only a certain range of IP addresses access to the web service. Marcy

Hi Mike. Thanks for replying. I am using Microsoft Development Environment 2003 Version 7.1.3088, Microsoft .NET Framework 1.1 Version 1.1.4322 SP1, Microsoft Visual Basic .NET, ASP .NET. Marcy

I have created a web service on our server. The client created an application to send us some information in a SOAP header. We process this information and return some values back to them. This is working fine, but we wanted to capture the client's server IP address when we record our logins. Using Request.UserHostAddress will capture the IP address from the client's computer, not from the their web server. Is this possible to do? Or would they need to pass it through a SOAP Header.

Thank you for responding. I have done all that you suggested before I wrote this. See posting dated 5/22/2006 16:33, subject bubbling events. The linkbutton is added to a template column on a DataGrid. I'm not sure however what you mean by setting it's onclick attribute. It's commandname = "view" and the DataGrid onitemcommand = "ViewRecipientSubDetail". I want to branch to the DataGrid's onitemcommand event, which is the event handler. I have determined the row that contains the linkbutton that fired the event. It still isn't firing.

I'm trying to simulate the click event for a linkbutton in a template column on a datagrid. This is a web form. I cannot get the DataGrid's onitemcommand event to fire. I tried bubbling events and couldn't get it to work (see posting dated 5/22/2006 16:33). Is there another way, through a timer or some other method that I can get this to work? I have a client who wants this feature and is ready to pull some work out if we can't get it to work. Thanks for your help.

I am having trouble with the EventHandler definition and the parameters to the routines. I have a datagrid with a template column. On that template column is a linkbutton. I want to simulate the click event of the linkbutton by bubbling events. It doesn't work. It goes through the code but the DataGrid onitemcommand event doesn't fire. Here's a code snippet. The DataGrid name is grdReceivingData, onitemcommand="ViewRecipientSubDetails", LinkButton commandname="view". At class level: Public Event Command As CommandEventHandler Sub, function, eventhandler definitions: For i As Integer = 0 To (grdReceivingData.Items.Count - 1) If grdReceivingData.Items(i).Cells(0).Text = DBASUB.ToString Then OnCommand(grdReceivingData.Items(i).Cells(4).Controls(1), New CommandEventArgs("view", String.Empty)) Exit For Else Exit Sub End If Next Protected Overridable Sub OnCommand(ByVal e As CommandEventArgs) Dim handler As CommandEventHandler = CType(MyBase.Events.Item("ViewRecipientSubDetails"), CommandEventHandler) If (Not handler Is Nothing) Then handler.Invoke(grdReceivingData.Items(0).Cells(4).Controls(1), e) End If MyBase.RaiseBubbleEvent(grdReceivingData.Items(0).Cells(4).Controls(1), e) End Sub Protected Overrides Function OnBubbleEvent(ByVal source As Object, _ ByVal e As EventArgs) As Boolean If TypeOf e Is CommandEventArgs Then Dim args As New DataGridCommandEventArgs(grdReceivingData.Items(0), _ grdReceivingData.Items(0).Cells(4).Controls(1), CType(e, CommandEventArgs)) MyBase.RaiseBubbleEvent(grdReceivingData, args) Return True End If Return False End Function Public Delegate Sub CommandEventHandler(ByVal sender As Object, ByVal e As DataGridCommandEventArgs) -- modified at 11:42 Tuesday 30th May, 2006

Ok, I figured out how to display the asp code. <%# DataBinder.Eval(Container.DataItem, "DESCRIPTION") %> [<%# DataBinder.Eval(Container.DataItem, "STATUS_NAME") %>](Subscription Status)

View Details

For some reason the asp code didn't show properly. It shows in the edit but not in the preview. I'm not sure what I'm doing wrong. Any suggestions? why does it have removed= onitemcommand="ViewRecipientSubDetails"

I am trying to bypass the display of an overview page and go directly into the detail page by simulating the LinkButton click event. I'm having some trouble getting my code to work, mostly with interpreting what the parameters mean. I'm trying to create a CommandEventHandler which is supposed to handle the LinkButton click event, but when I look at it's value in Debug, it is set to Nothing. Here is my code: (this is the only LinkButton on this grid; the code for this takes place in the same class (_default)) I am using Microsoft Visual Studio .NET 2003 7.1.3088, Microsoft .NET Framework 1.1.4322 SP1 <%# DataBinder.Eval(Container.DataItem, "DESCRIPTION") %> [<%# DataBinder.Eval(Container.DataItem, "STATUS_NAME") %>](Subscription Status)

View Details

After the subscriber enters a user ID (INETNUM) and clicks the logon button, DisplaySubOverview Sub is executed, and if there is data, it is bound to the grid. If we have records to display