Search results for query: *

The File...Send menu item/feature isn't working for me. When you try to mail the current open file using Send off of the File menu you get first an error message from Outlook (2003): Microsoft Office Outlook "The Operation Failed" click OK then this error: Paint Shop Pro 9 "Cannot send...

YES you can query INFORMATION_SCHEMA.views from any user database. Only under master are they listed in enterprise manager. This is the curious part. You can query them but WHERE are they?!?! Thanks! X

Not sure if I understand. I created a new report and was trying to set the Database Location to point to the views. If you look under the master database you can see them listed but under any other user database they are not listed. They aren't listed in Enterprise Manager either but you can...

I'm trying to query SQL INFORMATION_SCHEMA views with Crystal but when I use Set Location the INFORMATION_SCHEMA views are not listed. Am I missing something here? Thanks! X

Yes that's how I had it before but then you lose the super-neato-fancy calendar date selector and have to rely on users getting the date format right. I think the answer is no - at least not in 8.5 or 9.0 - maybe 10! ; ) Thanks! T

When you use a SQL stored procedure as a data source for a report, the Parameter Field for any datetime values in the parameter list of the stored procedure defaults to prompting the user for both the date AND the time. Is there any way to just get the parameter field to prompt for the DATE...

No I haven't found a fix to this yet. I've tried pretty much everything including reinstalling the entire runtime distribution. It's baffling. X

I was never having problems SEEING BLOBs in a report. The problem I'm having is the selection box/canvas size wireframe around the BLOBs is easily 5 times the actual size of the graphic. If you try to resize this so you can put other objects around it in the report the image is automatically...

If while running the designer you change the ODBC data source (a stored procedure) of a report from one SQL server to another. How do you get Crystal to actually recognize the change? Right-click/Refresh doesn't do it. Verify Database doesn't do it. Set Location doesn't do it. Seems the only way...

Also note that the reports use stored procedures in SQL as the ultimate data source (navigated to via ODBC connections). Not sure if this is pertinent. The stored procedure name is the same from ODBC source to ODBC source. Thanks!

Using Crystal 8.5/9.0. I have reports that are the same but need to have different ODBC data sources at runtime depending on where they are deployed. Without saving the data source in each copy of the report how can I have just ONE report that works with any number of ODBC data sources?! I'm...

Nope purely stock viewer configuration. X

That DLL list is the product of my researching the runtime.hlp files (Crystal 8.5), runtime.chm files (Crystal 9) and email tech support from Crystal itself. I was hoping someone here might have a 'working' list at this point ; ). X

I've found that one of the more frustrating aspects of Crystal 8, 8.5, 9 is a clear cut understanding of what DLLs need to be distributed for runtime. I currently have an installation that now will not print from the viewer. You can hit the print button, select a page range, and hit OK but...

I was poking around in Report Options and found my "Convert NULL field to Default" was unchecked. I checked it and that formula started working for me like it did for you. Still need to find out what that really does but for not it seems to be a solution to my dilema which is GREAT...

Create a Group on DETAIL_TYPE and then create a Running Total field that counts some other field (like ROW ID if you have one or employee name etc). Have the group reset on every change of DETAIL_TYPE. If I understand your issue correctly that would do it I think. X

When setting up Parameter fields you can specify a table as a source of the prompt value possibilities. This is great - at the time you create the parameter. But shouldn't this read the table each time to get an updated list of values that are current with the data set? (i.e. DATA DRIVEN). Is...

Doesn't this get you started towards that goal? (Basic syntax): Formula = CurrentDate - {TABLENAME.DATEFIELD} You can group on this / sort on it etc. Smallest values are the dates closest to the target. Negative values will be future dates, etc. X

This comes straight out of the CR 8.5 help. Of course FINDING it is a different issue - we all know how helpless CR's help is. "Suppose you want to calculate the last day of the month for the DateTime field {Orders.Order Date}. Notice that in the calculation, DateSerial(Year(d), Month(d) +...

Is it possible to NOT print objects in a report when it's actually sent to a print device versus appearing in the viewer? Thanks! X