Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: marydn
  • Content: Threads
  • Order by date
  1. marydn

    Send Nicely Formatted SQL Query via Email

    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...
  2. marydn

    DropDownList and Parameters

    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...
  3. marydn

    Load User Names Into Combo Box

    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...
  4. marydn

    Update schema attached to Word document

    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...
  5. marydn

    Print Fake Header on Top of Each Page

    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...
  6. marydn

    SQL Math Function

    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...
  7. marydn

    Search String........

    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...
  8. marydn

    Number to Text

    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.
  9. marydn

    Export Multi-Column Report to Word 2000

    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...
  10. marydn

    Graphic moves from left to right then starts over again...

    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.
  11. marydn

    Using Flash in ASP Application

    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...
  12. marydn

    SQL Date Range Calculation (SQL 2000)

    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...
  13. marydn

    The Moving Legend

    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...
  14. marydn

    Print on one page

    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...
  15. marydn

    Supress null values in graph

    Hello, I created a simple graph that displays a name and a count. The data comes directly from the db so I don't sum any data in the report. The problem is that all my names must be in the report even if there is no count value. However, in my graph all the names appear even when there is no...
  16. marydn

    Number of Days in a Month excluding Sat and Sun

    Would anyone know how I would calculate the number of days in a given month excluding Saturdays and Sundays? I would also like to count the number of Saturdays and Sundays per a given month. Any help would be greatly appreciated. M.
  17. marydn

    Pass Multiple Values to SQL Proc

    Hello, I am trying to pass a muliple value parameter to my SQL proc and I am not sure how to accomplish this. What I am trying to do is create a do loop that pulls in every value selected by the user then pass that value with all the approriate quotes, etc...to the proc. So If the user...
  18. marydn

    Find time difference

    Hi, I need to find the differene in time for 2 fields. The table is set up as follows: Field Name Data Type UpDate varchar (i.e. 2002-04-01) UpTime varchar (i.e. 22:50:00) DownDate varchar (i.e. 2002-04-01) DownTime Varchar (i.e. 22:45:00) All I want to get is...
  19. marydn

    3 Parameters that allow multiple values

    Hi, I have a report that has 3 parameters that allow multiple values. However, it doesn't seem to filter the data correctly. It seems like the report meets each individual condition and not all the conditions as a whole. I am using Crystal 9.0 and this is my formula: If {?Site Status} =...
  20. marydn

    Eliminating commas within a concatenated string

    Hi, I concatenate an address in SQL and when I call the data in the ASP page I see all the commas where there is no address. I want to eliminate the commas. For example: 123 Elm Street, Miami, FL 20333 If there is no adress it shows as: , , on the page. I am sure this an easy fix, but not...

Part and Inventory Search

Back
Top