Search results for query: *

Geoff, I must have had my blinders on yesterday. Thanks for replying again and clueing me into the obvious... at first I didn't recognize , "Globals!ReportServerUrl". With a fresh pair of goggles on this morning I've implemented your solution with 100% success. I had to modify the code a bit...

Thank Geoff but I don't think this will do what I'm looking for. The function requires an argument value. That value is what I'm looking for. I think I understand what the function does but I've already got that functionality by using a report variable. The problem is that I have to update...

I'm using RS2008 R2. I've created a report that has Action:Go to URL expressions. The expressions link to another report detail that render directly to Excel and work just fine. The issue I'm having is coding the expression to work in all three of our deployment environments. We have a...

You'll want to look at setting conditional formatting properties of the Age field with your criteria. The use of continuous forms complicates what you're trying to do as any other code based solutions will want to enable/disable each row of Age, not just the row you're on.

Exactly... that's why I'm trying to see if there is a more dynamic way to do this. As a developer I know I can navigate the tableDefs collection and pull out the data I want from the tabledef objects in that collection. But let's assume I'm not a developer... what makes more sense; declaring...

Hi Majp, thanks for the reply. I know this isn't really a practical or typical thing to do. I'm just trying to see what can be done with classes. The thing I'm trying to get at is the drop lists from the object... or intellisense. I want to see the tables in the database appear as a drop...

I'm not certain this can be done so I'm posting the question to see if anyone can respond with a possible solution. Since describing what I want to do is somewhat confusing I'll try to define it with an example. Here is what I want my code to look like when using the Helper Class: Dim...

Thanks jebenson and SHelton. Using code referenced from the link, I linked again to "How to: Customize Data Formatting in the Windows Forms DataGridView Control" at http://msdn2.microsoft.com/en-us/library/z1cc356h.aspx. After modifying a bit of the code I was able to accomplish what I needed...

I've researched the heck out of this one and cannot find a solution using the DataGridView control. Using VS2005 I'm trying to display one of two Icons in a datagridview control column based on the boolean value of the columns row data. The data source is based on a Person table with a Name...

I've ended up just creating toolbar buttons and set the background color to display it visually. Not the solution I'd have liked but will work for now. Again, if anyone can come up with a better solution or knows how to incorporate an existing toolbar item into another app I'd like to hear...

I'm not certain if this can be done so I'm wondering if anyone has been able to do this. I want to use the Highlight (No Highlight) toolbar menu item in my application. It's found in MS Word, under the Formatting toolbar. When selected it allows the user to select one of several color...

Mastakilla, do you mean a constant value for the Key and IV values? Would this not compromise the security of the encryption as a hacker could retrieve the constant values if stored in the code. The TripleDESCryptoServiceProvider randomly generates a Key and IV value when the CreateEncryptor()...

I'm new with .NET and trying to figure out the use of encryption. I've created an app that utilizes XML as a data source and I want to learn how best to encrypt the xml file. What I'm missing in this code is the ability to shut the application down and run it again later without losing the...

I've got a weird problem to address and after numerous attempts trying to solve this using Visual Studio 2005 I've nearly given up. Please note I am a beginner to VB.NET. Problem Defined: Given an .xls file containing contact data from MS Outlook (Export the contact list to an excel file). I...

...one of the values. This of course does not work in a query. It's only for display purposes in the control. To return all records in a query with a filter you have to return "*". To do this I recommend changing the code to Replace(Forms!frmReports!cboSelection,"<All>", "*") Hope this...

Your code is changing the filter of the report "Quote" and not the report name itself. Is the value of the combo box a report name or a field value to be used as a filter in the report called "Quote"? If like you ask, the goal is to open one of a variety of reports (ReportA OR ReportB OR...

Another suggestion is to use the REPLACE function in your report. Change Form![ReportDialog].....spot to Replace(Form![ReportDialog].....spot,"<All>","*") The resulting criteria is "*" instead of "<All>" so instead of returning nothing your query will return all records.

...exclude the last day, will be calculated later in 3.3 SELECT @x_ElapsedSeconds = @x_ElapsedSeconds + ((@x_IntervalDays - 1) * (DATEDIFF(second,'00:00:00', @x_condteOffStartTime) + DATEDIFF(second,@x_condblOffEndTime,@x_condblDayEndTime) )) -- 3.3 Closing day...

Thanks Bob, I think this is an excellent start. Actually it is possible for either of the start or end date parameters to fall within the "off" hours. Say for example the start time was at 03:30:00 and the end date was at 12:00:00 on the same day. The result should be 02:00:00 because the...

I need some help creating a function that will return a string formated like hh:mm:ss. The function will have two parameters and is set up as follows... Create Function ftnGetElapsedTime(@x_StartDate DATETIME, @x_EndDate DATETIME) Returns CHAR(08) The business logic excludes "Off" hours in...