Search results for query: *

I need to create a table/view using the data from two columns on an existing table. I don't know whether I should create a table or view or something else altogether. Obviously, I'm very new at this. The existing table looks like: Station_ID, integer Station_Code, char(30) ...many other...

We are using the DHTML viewer with Crystal RAS 9. When a report (without parameters) is refreshed, the new data shows up. However, when the report is printed or exported the saved report data is used instead of the new data, so it's an old version of the report. This phenomena does not occur...

I am trying to connect to an MS Access database from web reports run on Report Application Server 9 with the DHTML viewer. I am prompted to login to the database when there is no database password. The database is located on another server, so I've tried using a mapped drive, a url, and an ODBC...

We just added a password to the "sa" account on our SQL server. Now all the reports published on our intranet prompt our users for a username and password (this was not the case before). I've tried changing the ODBC connection to NT authentication and I've tried adding in our...

I need to collect and display some data by week (using groups), but I need the weeks to span from Mon-Sun instead of Sun-Sat. I can change the first day of the week inside of formulas, but I can't figure how to tell Crystal to group that way. Also, the first week grouping of this year (should...

I have a report that shows total sales amount and volume for all of our products in a particular time period. I would like to prompt the user for what he wants to sort by, sales amount or sales volume. How do I link the parameter I create to the Sort order or, even better, the TopN feature...

I created a report that displays information on a certain list of people. I need to display some odd information like birthday and office extension #. This information is kept in a table for account notes. In this table there is a code type and a code value. A type would be "B-DAY&quot...

I am creating a report showing all the donors who donated last year, excluding those who have donated this year. How could I design a formula to display and count these donors?