Search results for query: *

I e-mailed Crystal and they told me all I wanted from Enterprise was possible but I wanted to check with unbiased opinions too. I want to be able to place a report at geocities.com using ODBC drivers. Then anyone with these drivers would be able to access the report and run it from...

I'm grouping on Invoice Number. Within Invoice Number there can be multiple product codes. If there is ever a product code 80 within an invoice number I want to use one formula but if there is never a product code 80 I want to use another formula. I have tried simply saying: IF {Line_.Pr_Code}...

I have linked an Access database with 3 btrieve databases and the report is incredibly slow. It takes 92 seconds to access the databases and 8 seconds per record for the report to run. In 30 minutes I only had 251 records! How can I speed this up?

I've created a database that has two fields: name and position. Every Thursday I need two individuals names on a calendar and every Sunday I need four names. But only one individual of position A should be on Thursday and one on Sunday. The others should be of position B. I've created the...

The subreport shows up as a link in the crystal viewer but I'm not able to click on it. What am I doing wrong? In Crystal Reports I can activate the subreport.

I have a page that accepts and installation number, performs some math when the user hits the button, and give them a serial number. I would like to be able to also ask for their name, company name, e-mail address, etc. and when the button is hit to perform the math the personal data would be...

I have a page on geocities that I would like to add a box where someone could insert an installation number and then my page would display the (installation number + 4) - 25 for their serial number. But I can't find an example anywhere to help me out. Can anyone explain?

Instead of opening up the Crystal Viewer can the data that would appear in the report be viewed on a VB6 form? If so, how?

Has anyone found a way to incorporate the round button and transparent background color look from XP into CR?

I've created a CR report that is displayed through VB6. I would like the user to have the option of refreshing the report every so many minutes (determined by user preferred). And also if the report could be choosen to stay on top. It's not large and it would be convenient for it to display the...

I've created a CR report that is displayed through VB6. I would like the user to have the option of refreshing the report every so many minutes (determined by user preferred). And also if the report could be choosen to stay on top. It's not large and it would be convenient for it to display the...

Is there a way to have the report stay on top of the desktop and refresh automatially based on a number of minutes inputted by the user?

I have a loop using the database JobCost to look at the field del_date and I've inserted a MsgBox that shows me the data in del_date. I loop through the database but the del_date never changes from the first record. What am I doing wrong? Do While rsJobCost.EOF = False rsJobCost.MoveNext MsgBox...

I'm trying to display YTD Tot_Sales. In the Data Environment Designer I created an expression that tried to convert del_date (8 char., string, yyyymmdd) and find it in YTD. It seemed so simple. But I continously received an invalid scalar function error. Pervasive's website acknowledged the...

How can I convert my delivery date in the format of a string (yyyymmdd) so that I can easily use the YTD function?

I have a database where del_date is a string in the format of yyyymmdd but I need to sum a field for YTD. How can I convert my date so that it is recognized by the YTD function? I've tried: WHERE (Del_Date = 'jobcost".del_date} in YearToDate') among other ways.

I have a query that SUMs total sales but I need to check the delivery date against the current date and make sure the SUM I display is YTD. How can I get the current date and what calculation could I perform to make sure the data is not more than one year from today? I was thinking of: SELECT...

In Crystal I can arrange a parameter to allow for multiple values. When choosing which store to use in the report, store 1, 3, 5 can be the only ones or * can mean all. In the record selection I put: {Header_.Store} like {?Store} But in VB6 how would I allow someone to enter multiple values?

In VB6 I'm trying to modify the following to allow me to select data from VB6 instead of using the parameter in Crystal. But my date format is yyyymmdd as a string and this gives me an error message saying a string was expected here: strSelectionFormula = "{JobCost.DateEntered} in...

I have a database that can't be updated but salesman commission needs to be calculated and then whether they were paid kept with the database. Can I create a database in Access that will only have the one field --containing "paid" or blank -- joined to the original database?