Search results for query: *

Hello, I am currently returning the date from an Cube Dimension into an OWC Pivot Table as such: 2008-01-30 00:00:00 I have been researching how to apply a short date format (mm/dd/yyyy) on the web page as such: RowAxis.InsertFieldSet(FieldSets("Request Open Date")).NumberFormat = "Short...

Hello, I am currently returning the date from an Cube Dimension into an OWC Pivot Table as such: 2008-01-30 00:00:00 I have been researching how to apply a short date format (mm/dd/yyyy) on the web page as such: RowAxis.InsertFieldSet(FieldSets("Request Open Date")).NumberFormat = "Short...

Hello, I've looked in Outlook at the rules and for other ways to do this, so I was hoping someone here might be able to help. Is there a way I can send an e-mail notification is an hourly e-mail is late or doesn't arrive as expected? For instance, if the email from a certain sender is over 60...

Hello, I've been looking at different approaches for creating a dependent drop-down list (or text box), but have been unable to come up with a solution that works. In some cases there will be only one value for a value chosen in a drop-down, in other cases there may be more than one. In the...

Hello, I have been looking for an application that would enable me to set-up an hourly job to run. This job would populate and submit (or submit a pre-populated form) that would run (submit) once an hour. The client is worried the form might not be running so they want some kind of confirmation...

Hello, I have this query which is pulling from a production table: select o.OrderNumber as [Order Number], o.CustomerID as [Customer ID], o.LastName + ' ' + o.FirstName as [Customer Name], c.Email, c.AdditionalEmail as [Additional Email], c.Phone, o.ShippingCity as [Shipping...

Hello, When trying to send mail through my application I am getting this error: A first chance exception of type 'System.Net.Mail.SmtpException' occurred in System.dll System.Net.Mail.SmtpException: Failure sending mail. I am using ASP.NET 2.0 and the project is in Visual Studio 2005...

Hello, I've been researching this for some time. Does anyone know if you can conditionally jump to a report? Something like this: =iif(Fields!TEST.Value = "?????" And Fields!TEST2.Value > 0, TestDetailReport, "") I've tried this based on the text color also but keep getting errors like this...

Hello, I've been researching this for some time. Does anyone know if you can conditionally jump to a report? Something like this: =iif(Fields!TEST.Value = "?????" And Fields!TEST2.Value > 0, TestDetailReport, "") I've tried this based on the text color also but keep getting errors like this...

Hello, is there a way to rename .bak files from the default naming that happens in an automated SQL backup job? I've been lookging through the maintenance plan and subplans, help files, online and it doesn't look like there's a way to do it in the management console. I wanted to avoid having...

Hello, I have a financial report which takes quite a while to run, approximately 30 minutes. It is a data intensive report pulling in many years worth of data which I have converted from an RPT to RDL. The RPT takes a long time as well but eventually renders the report and has been in...

Hello, here is my code which works to run a DTS package from my VB.NET app: Public Sub ExecutePackage(ByVal sServer As String, ByVal sPackageName As String, ByVal sPackageGuid As String) Dim opak As New Package2Class opak.LoadFromSQLServer(sServer, "test", "access", , ...

Hello, I have a stored proc which uses several select statements for multiple resultsets, but I've come up against a brick wall because it seems that SQL Server Reporting Services 2005 doesn't support multiple select statements and will only return results from the first select statement. If...

Hello experts, Is it possible to run a query to pull the fiscal period and posting settings across multiple companies (databases)? If so, could someone please show me an example of how I would query this? I wasn't sure if there is a system table in the Dynamics db I could query or if I had to...

Sorry, I forgot to put the subject on this. Hello experts, I have this stored proc which returns sales for a given beginning and ending date range. The challenge I face is breaking out the results so the results are displayed by month as follows: Sales By Customer...

Hello experts, I have this stored proc which returns sales for a given beginning and ending date range. The challenge I face is breaking out the results so the results are displayed by month as follows: Sales By Customer: Qty $ Qty $...

Hello, I am trying to create a report that breaks out the results in a crosstab by the month part of dates like 2/2/2007. I've been researching this but have yet to come up with a definite strategy to handle this in SRS. Could someone please show me how, I would really appreciate it. Thanks...

Hello, I have the following script which performs a nightly differential backup... DECLARE @name VARCHAR(50) DECLARE @path VARCHAR(256) DECLARE @fileName VARCHAR(256) DECLARE @fileDate VARCHAR(20) SET @path = '\\test\SQLBACKUPS\' SELECT @fileDate = CONVERT(VARCHAR(20),GETDATE(),112)...

Hello, Please excuse my newbie question. Could someone please tell me what tables would be involved with creating a report for posting and fiscal period setup that would display open-close period info? I'm assuming from what Ive learned so far it would involve using the GL tables, but I've...