Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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