Search results for query: *

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

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

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} =...

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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() -...