Search results for query: *

Hello, I have an SSIS package where I use "Execute SQL Task" to pull back several rows of data which I want to send via an email. After the execute SQL task I use a for loop with a script task. However, I am struggling with the c# code. Most of the videos/help I have seen online use...

Hello, I am using ASP.NET for a web application. A user picks a product which takes them to another page. The page will display more details on the product as well as a dropdownlist, which allows them to chose a specific size. Once the size is selected the "add to cart" link must be updated to...

Hello, I need to pull all the users from Active Directory into my win forms application combo box using VB. I set the properties to load "name" and get firstname, last name. However, when users sign into the network the have to type in first letter of firtname and full last name. I am not well...

Hello, I have created a .NET windows application that exports an XML file. I use the data in this file to populate a Word 2003 document, which has an associated schema. However, whenever I make changes to the schema I find that the elements in the XML structure pane in the Word document are not...

Hello, I am using Crystal 10 and I have a report that can be viewed 2 different ways depending on user choice. This report must be exportable into Excel. I had to create a fake header in the details section in order to get the column headers to actually export into excel. The problem I am...

Can anyone tell me how I can solve the following problem with SQL built-in functions: I have a lease that is for $1,000 it has 5 year terms and increases 15% at the start of each new 5 year term. So after the first 5 years it will increase to $1,150. What I need to know is the average annual...

Hmmmmm...I tried Val, but apparently it is not a valid SQL function. I also tried: select convert(integer,left(code,4)), sum(amount) from Tablename However, that takes my 04134 and makes it 413 instead of the 4134 I desire.

I get the desired result with this: CASE WHEN Left(Code,1) = 0 THEN Substring(Code,2,len(Code)) ELSE Left(Code,4)END AS Test However, my numbers can sometimes be: 00964 964 964R So you can see my problem.

Thanks, but then 04134 becomes 0413 and I want it to be 4134.

Hello, I need to find codes in a table. For example: Code $ Amount 04134 1 4134 4 4134R 5 4134IM 6 I need to take these codes and make them consistent - 4134 and then total the amounts ($16) so I can link it to another table. Is there any way I can accomplish this...

That is not only good enough for me, but exactly what I needed. Thanks!

Is there anyway, in Crystal 9.0, to convert a number field to it's text value. For example $300 to Three Hundred? Thanks, M.

Hi, I am using Crystal 9.0 and need to export a multi-column report into Word 2000. The report looks fine in Crystal preview mode, but when I export it only the second column is seen and it repeats. For example: Crystal Preview: Columnn A Column B Crystal Design: Column A...

Hello, I created a graphic that shifts from frame 1 to 10 when it is run. However, it repeats itself over and over again. I would like it to move to frame 10 and stop. I am sure it is simple to do, but I cannot figure it out. Thanks! M.

I am new to web development. I have stuided the tutorials in Flash mx professional 2004, but not sure how to combine it with the app created in HTML and ASP. What I need to do is just create some visual effects - like when a link is clicked the page slowly transforms into another page,etc...Can...

Okay, I asked the SQL guru at work to help me out and this is what he created. It seems to work perfect! FUNCTION udfPeakMins (@Date1 datetime,@Date2 datetime,@peek int) RETURNS int AS begin -- Peek of 0 =Peek hours 8am-7pm -- Pekk of 1 =Non-Peer hours 7pm-8am declare @tot int...

rac2 - thanks for the response. However, it did not work. I guess the problem is that there may be more than 4 conditions. I think it gets complicated depending on whether or not the down time and up time takes place in the AM or PM. For example: Date Down Time Down Date Up Time...

Hello, I am trying to determine the peak minutes and non-peak minutes between dates. My table is structured as follows: Date Down Time Down Date Up Time Up 4-14-02 17:00:00 4-15-02 13:00:00 Now my peak minutes are 8:00:00 to 18:59:59 and non-peak are 19:00:00 to...

Can anyone explain to me how to keep my legend from moving? I went to chart options - General - Look - Layout - and selected Legend Below Chart. However, for some reason it doesn't save the request. When I close the report and re-open and run the legend appears on the left hand side. Do I need a...

Is there anyway I can print my report on only one page. It currently prints out on 2 pages. Part of the problem is that I have a subreport in the header, which is a graph. If I could shrink the graph I think the rest of the report may fit on one page. I am using Crystal 9.0. Any help would be...