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 strongm 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: dawtes
  • Content: Threads
  • Order by date
  1. dawtes

    Record Selection

    Hi all, I have a parameter in my report and users can select multiple values. Can someone explain to me how I need to assign the values to the table field in the record selection? Thanks
  2. dawtes

    Slow data grid

    Hi I have a created a simple ASP page that return a row of 7K records using a data grid control and created a link for whomever to download the code as a CSV file. Everything works fine but for the result to be displayed on the data grid control is slow and it takes a lot longer to open a...
  3. dawtes

    Oracle Connection

    Here is my question: I have a code that work fine with access database and I want to use this code to work with oracle database. I have tried to change the connection string, command object and data reader but I do not seem to have luck yet. Can someone take a look at it and help me to fix this...
  4. dawtes

    Unable to see CSV file

    I am using this code to create a csv file and for some hidden reason I am not able to see my out put . I named my csv file filename="products.csv". can someone advise me what is wrong with this code.I do not get any error message but there is not result either. thanks <%@ import...
  5. dawtes

    eliminate error msg

    Hi all, Can somone advise me what i need to do to eliminate this error msg. thanks Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately. Compiler...
  6. dawtes

    How to use shell script in visual basic

    I have a .EXE file that i would like to run in visual basic.I did try to use shell script but it does not give me the result i am expecting to get. I need to double click for the exe file to be executed and i do not really know if i can do this inside the visula basic code. Private Sub...
  7. dawtes

    Copy and Convert

    I am trying to copy the file I need from the server in this case the location of my server is J:\IO\qebsfnam\pass2ebs and convert this file to pass2ebs.txt and test it if this file exit or not. Can someone take a look at this code and advise me where i made a mistake.I highlighted part of...
  8. dawtes

    Insert point in a text file

    What I am looking or hoping for is a simple routine/program to manipulate line text. For this particular text file, the intent is to add a period 4 digits before a "/" and skip adding a period if it already exists. The text file could be very large so it is impractical to consider adding a...
  9. dawtes

    Slow Query

    I am trying to use this query to create a view and use it in crystal report. However, this query is considerably slow. I am wondering if there is a way to make this query run faster. Thanks SELECT DISTINCT G.CSECNUM,E.IPLINENO, LL.LETTING, E.EIITEM, I.IDESCR, P.CONTID...
  10. dawtes

    Record Formating

    Hi, I have a report which has one group and about 25 records in the detail section from one field. Is there anyway to break the report when it reaches the 5th record and to start a new column. Thanks Example Group A Field A 1 2 3 4 5 6 7 8 9 10 . . . Change to Group A A A A...
  11. dawtes

    Grand Total

    Hi, Can you help me out on how to find the Grand total of this formula. if GroupName ({table_name.field_name}) = 'A' then (67.7 * Count ({table_name.field_name}, {table_name.field_name}))/100 else if GroupName ({table_name.field_name}) = 'B' then (37.8 * Count ({table_name.field_name}...
  12. dawtes

    Disable view Sub Reports

    Hi, I need a help in disabling view sub reports. I have a report with 4 sub reports in it. I don't want users to see the sub reports alone when they click on the main report. I don’t want users to know that there are sub reports in the back at all. Is there any way doing this. Thanks
  13. dawtes

    Phone Numbers

    Hello, Any idea how these records can be formated to (XXX)-XXX-XXXX. 507/437-4615 320-274-7433 320-685-7700 651-222-5555 218-847- 320-847-2419 6128691900 6128691900 218-759-8859 218-759-8859 218-631-1400 507-754-6107...
  14. dawtes

    “or” operator

    Hello, I need to know how the “or” operator works? Does it check all the conditions whether they are true or false even if it finds the true condition or Does it skip the rest of the condition statements when it finds the first true condition. Thanks.
  15. dawtes

    Sub Reports Box

    Hi, I have a report which has about 4 sub reports.When I publish the report and view it using crystal viewer, it displays a small box which I did not create in one of the sub reports. I am wondering how this small box show up in the report and what can I do to avoid from showing up in the...
  16. dawtes

    Checked Box

    Hi, Can you help me out inserting a checked box in a crystal report. I tried to pick from the computer's unicode character Map list, but it didn't work for me. is there any other way doing this? Thanks
  17. dawtes

    sub reports

    Is there anyway to switch sub reports location or make them not to take a space on the main report at all.. If the sub report doesn't have any data, remove the sub report from the main report. I appreciate it.

Part and Inventory Search

Back
Top