Search results for query: *

Thanks so much for your help! It works great! Dan

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

Thanks for the link. The whitepaper indicates that RAS 9 refreshes data when the refresh command is issued (I'm assuming through the refresh button on the toolbar), which seems to work for us. The problem I'm having is not that the data does not refresh, but that the refreshed data does not...

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

Currently, the report connects using a Access/Excel(DAO) type of connection with it mapped like you said \\machinename\path...\file.mdb. Do you mean something different that this? I've tried the ODBC route and that didn't work either. It runs correctly from the Crystal Reports Designer on the...

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

Thanks for your help. I decided to use Crystal Enterprise eportfolio since it allows me to put in a default database logon.

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

Thanks so much for your help Rosemary! It works perfect now and it's much more efficient. Dan

The users type in the first and last week numbers that they'd like to include. Our broadcasts codes are all done according to week number so the week number is known by the employees who would use this report. If I use the select formula written above, what part of my original select formula...

You're right, the grpwk formula does work. Thanks for your help on that issue. You are correct in assessing the point of my select statement. The user selects the weeks they want to view data for and the report should include dates from the previous year if they are part of the first week. I...

This is my selection formula //include weeks selected by user DatePart("ww",{Table.datefield},crMonday,crFirstFourDays) in {?Initial Week} to {?Final Week} and //include only dates this year {Table.datefield} in {@StartofYear} to {@LastDate} and //exclude saturdays & sundays...

Thanks for the response Rosemary. It didn't work but it might be because I've already written the report with regular week groupings and I just tried to change the group to your formula. There's probably something else I need to do. Also, the first two days of this week (12/30 & 12/31 still...

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

Solved! Thanks Ken for the final piece to the puzzle. You guys are great! Dan

I tried the if/then as well as a select/case formula, but I am still not able to choose my formula in the Sort Records or TopN Expert areas. The one difference in the above formula is that I do not want to sort by a field, but by a group total. Maybe this isn't possible. Can someone answer that?

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

There is not two separate tables for the two years, but the suggestion from synapsevampire worked. Thanks!

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?