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: *

  1. kkinnea

    Draw diagonal line in chart

    This is for Dan of Three D Graphics: I've downloaded the evaluation of the replacement chart module, but I didn't see what I really need - an option to smooth lines in a line chart (regular series lines, not trendlines). Is this an option?? Thanks, Kristen
  2. kkinnea

    Blank records from import using TransferSpreadsheet

    Hello all, I'm using Access 2000 and Excel 2000. I am using TransferSpreadsheet to import data off a number of tabs in Excel workbooks (there are 2 with the same structure holding 2 different sets of information). For the same tab in each workbook, I get 107 extra, blank records from the...
  3. kkinnea

    Looking to export to 'Excel (Data Only)' through command line

    Our developer has created a back-end solution for running and outputting reports. The only issue is that we seem to be unable to access the 'Excel (Data Only)' option that is available in Crystal 9 through the command line. Has anyone been able to access this feature? Thanks, Kristen
  4. kkinnea

    Mail from ASP without SendMail utility

    Hello all, I am still feeling my way through ASP... I am developing an input form so users can add items to an event calendar. I have things set up so that the information is dumped into an Access2000 database with an indicator showing it is an inactive item. I would like to be able to have...
  5. kkinnea

    Chart formatting

    If you are using v9, you can right-click on a label and choose 'Chart Options'-->'Selected Item' to change font, size, etc. I modified a chart so I didn't see the default legend titles and overlaid my own which change based on the current month. If you want to make global changes to charts that...
  6. kkinnea

    How to print group footer at a specific location on a page?

    Hi all, This suggestion by synapsevampire is great, but there is one small flaw. In the extra Group Header suppression formulas, the second line should read: global numbervar LineCount; _not_ global numbervar LineCount:=0; The second version resets the count and the section is not...
  7. kkinnea

    Dividing 2 subtotals

    Hi all, I just tried dividing 0/0 on both Microsoft's calculator and in SQL Query Analyzer and each gave me exciting errors, so perhaps Crystal is also discouraging this. Thus you would have to check both: if (Sum ({IV30300.TRXQTY}, {IV30300.ITEMNMBR}) <> 0 and Sum ({IV30300.EXTDCOST}...
  8. kkinnea

    Insert query - can't spot the error

    Thanks to everyone who replied! The key turned out to be the following error message: Microsoft JET Database Engine error '80004005' Operation must use an updateable query. /test/events/add-event-end.asp, line 22 The host I am using, by default, does not set write permissions to db...
  9. kkinnea

    Insert query - can't spot the error

    robi2 and bbolte, Thanks for the advice. I actually have the single quotes added into my variable (I'm also checking for nulls there too) towards the top of the code: if Request.Form(&quot;evTitle&quot;) <> &quot;&quot; then Title = chr(39) & Request.Form(&quot;evTitle&quot;) & chr(39) else...
  10. kkinnea

    Insert query - can't spot the error

    I am unable to spot the error in this query: <% Dim strConnection, strQuery, Title, StartDate, EndDate, StartTime, EndTime, Address1, Address2, City, State, Website, Info if Request.Form(&quot;evTitle&quot;) <> &quot;&quot; then Title = chr(39) & Request.Form(&quot;evTitle&quot;) & chr(39)...
  11. kkinnea

    Can data source be changed from ODBC to OLEDB when using a command?

    Hi synapsevampire, I have written a command (query) to pull data for my report, rather than just adding tables to the report. I have tried in the past to use the 'Set Datasource Location' to switch to a OLEDB connection from an ODBC connection, but it doesn't appear to work. Instead, I get a...
  12. kkinnea

    Can data source be changed from ODBC to OLEDB when using a command?

    I am using CR 9 on Win2k Professional. Has anyone been able to use the 'Set Datasource Location' while using a command as the datasource? I'm interested in switching from an ODBC connection to OLEDB. Thanks, Kristen
  13. kkinnea

    Select All or {?Parameter}

    infomania and lyanch, Bless you, infomania, for a well-worded subject line and question so I could find this post, and you, lyanch, for a concise answer! I had been working on a similar problem for 2 days and this answer fixed it perfectly! Kristen
  14. kkinnea

    Need summary in report header based on parameter

    Ido, Hey, what do you know! That works! It's not as easy to format, but will certainly solve my issue. I didn't even think about a crosstab to solve this. Thanks again! Kristen
  15. kkinnea

    Need summary in report header based on parameter

    I have a problem I can't seem to find an answer to... There have been many user requests for &quot;roll-up&quot; totals for all clients at the top of reports. Since the clients usually constitute a group, I have been creating subreports and placing them either in the report header or in the...
  16. kkinnea

    Randomly Select Records

    I was not able to get the above described technique to work exactly as I need it to. I have a report that is grouping first by a selection of companies, then by state. What I need is: for each company, a random selection of records, regardless of state. I think my state group is getting in the...
  17. kkinnea

    No EOF or BOF, Exception error, but records are showing

    Cathy, That did it!! I'm assuming what I had didn't work before because a) at some point I was trying to compare to a field that wasn't there (that is at some point rsData(&quot;Category&quot;) didn't have anything to compare to and caused the exception) and b) I forgot to MoveNext before...
  18. kkinnea

    No EOF or BOF, Exception error, but records are showing

    I found the last loop and removed it, but now my detail is gone and I got the same second error as before. You can see the results at http://www13.brinkster.com/kkinnear/mktplc.asp
  19. kkinnea

    No EOF or BOF, Exception error, but records are showing

    I tried your code as demonstrated below: <% do until rsData.EOF %> <% strCurrCategory=rsData(&quot;Category&quot;) %> <td valign=top width=25%> <div align=center style=&quot;background-color: #000000; color: #FFFFFF;&quot;><b><%=strCurrCategory%></b></div><br> <%...
  20. kkinnea

    No EOF or BOF, Exception error, but records are showing

    Hi Cathy, Do you have a suggestion of what I could change it to? I wanted the second loop so I could easily sort the different categories into different columns. I put that line in so I could output a new column when I reached a new category. Thanks, Kristen

Part and Inventory Search

Back
Top