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!

Register Log in
  • Congratulations Chriss Miller 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: redsand23
  • Content: Threads
  • Order by date
  1. redsand23

    Attaching db

    I am new to this so please excuse the ignorance. I have an sql db on a standalone server that is not on our network. I copied the mdf & ldf and copied them onto a stick and put them on the network production sql box. I tried to do an attach database and received the following error error...
  2. redsand23

    Creating a schedule with a twist

    I have a query that prioritized and determines actual hh:mm:ss each job takes. For example pri job time 1 abc 04:20:00 2 bca 01:10:00 I want to be able to popluate this data into a grid or calendar control based on a start time of 08:00am in 5 minute increments. Here...
  3. redsand23

    Mulitple "All" Parameter selection criteria question

    I am running cr9.2 and am having difficulty with multiple paramter selection criteria The goal is to have the user have the ability to choose any combination (Both all/none all/1 all 1 value) {QryRep.ReqDate} in {?StartDate} to {?EndDate} and IF {?Cellname} <> "All" then {QryRep.Cellname} =...
  4. redsand23

    Can I make a conditional circle?

    I am attempting to create a corporate dashboard with metrics and a red/yellow/green circle next to the metric depending on the value. Is there a way to format a circle(Formated square) to do this. I had thought about the webdings but can't figure out how to change the font color for the...
  5. redsand23

    Postscript Newbie - Distiller

    I need help with the correct syntax. Mr. Greer was nice enough to point me in this direction. I am pulling data from my mainframe and can actually save in .ps format. I just need assistance on how to handle multiple lines of data. This is what I have in the .ps file %!PS /Courier 12...
  6. redsand23

    DISTILLER QUESTIONS

    Hello all, I am trying to use distiller for the first time. I have created a watch dir and am trying to process a file. The file is a.txt and only has the word test in it. When I process the file I get the following errors. Start Time: Friday, July 22, 2005 at 2:39 PM Source: a.txt Destination...
  7. redsand23

    Problem Closing excel?

    I have DTS importing a couple of excel files into SQL for which I have linked in a view, I then take the view and dump it into excel which works great. The last step I take the excel file and e-mail it out. I get the following error, error sending mail: MAPI error: Could not open the attached...
  8. redsand23

    Is there a way??

    Is there a way of doing this in DTS. I want to merge 2 text files that are tab delimited and using 2 fields(Sales order & line) as the link between the files. After the merge I want to save in excel format and then send it out in an e-mail. (I have the e-mail figured out). Any help would be...
  9. redsand23

    SQL connection logon & password

    Is there a property that will allow me pass the logon & password to connect to the SQL database in the below asp code. I am having to login to get the page to load when connecting to an sql database. When I use access and use a trusted connection I do not have the problem. I have tried the ole...
  10. redsand23

    ASP - ODBC - IIS6

    I am running a 2003 server, running iis6 and having difficulty with opening ASP pages that connect to either an sql database or Access via odbc. I have browsed the forum and have performed the following tasks 1) Made sure iusr had permissions to the db folder 2) Set execute scripts and...
  11. redsand23

    MSQUERY ODBC and Excel..

    Can you push data from Excel that is returned from a database via MSquery back to the database. Here is what I am trying to accomplish. Excel 2000 - I have created a query that links directly to an external ODBC database and its' data is populated into Excel. I need to be able to modify the...
  12. redsand23

    Excel worksheet in access.

    Here is my challenge. In excel, at the bottom of the window there are options to average,count,max,min, or sum. So when you select cells in a column it displays the sum or average of the selected cells. Is there a way to incorporate this function in access. Specifically, I want the user to be...
  13. redsand23

    Web report report.asp

    I am having a problem with web reports in sms. The report page opens fine, but there are no reports available. I have checked sms report directory and I have reports in there. Do I need to copy these reports to IIS to be able to see them? I am running sms 2003, 2003 server with IIS. Any help...
  14. redsand23

    Passing parameters via url? cr 9.0

    Running cr 9.0 using the crystal report viewer. I can not seem to get the passing of parameters correct. I have a single param called report_type I have tried the following...
  15. redsand23

    Cross tab percent total

    Hello all I am running Crystal 9 and trying to perform a cross tab that will give me the actual % total for a cross tab. 200401 200402 200403 200404 0-1 DAY LEAD TIME 94.12 91.93 93.29 90.13 ontime 5,311 5,458 6,358 5,577 total rec 5,643 5,937 6,815...
  16. redsand23

    Link Subreport by GroupName

    I am using CR 9 with access. I have a report grouped by date(It is set up to print by week.) I also have a subreport that is a separate table that is also grouped and set up to print by week. When I report the group name I always get the first day of the week on both reports. The problem I am...
  17. redsand23

    Std Deviation

    I have (I hope) a simple question. I have 3 fields in a group header. Units Passed, Units Rejected, and total opportunites(passed + rejected). How do I calculate std deviation? I looked at the stdev function but I it looks like it just wants one field. Obviously I am pretty new and would...
  18. redsand23

    Interactive report viewer....

    How do I get rid of the top bar on the interactive viewer that show the crystal logo and the words CRYSTAL REPORT? Thanks
  19. redsand23

    Html Export/Print button? Supported

    Hello all, I am new to the web reporting, I have a quick question. Does the HTML viewer support exporting and printing. I put these into the reportpageviewer.asp .HasPrintButton = true .HasExportButton = true And did not receive an error but did not get the print/export functionality to work...
  20. redsand23

    SQL database login?

    I have the below asp page that uses crystals canned web pages to view reports. When I run the report it asks me to login to sql. Is there a way to put that login&password info into the asp page and then set .EnableLogonPrompt = false <%@ Language=VBScript%> <% Response.ExpiresAbsolute = Now() -...

Part and Inventory Search

Back
Top