Search results for query: *

No, I haven't. Anyone?

Crystal Reports 11. No matter what I do, the report is printing as if the paper size is 3" wide (or 3" tall in landscape). The paper size = Letter. Left margin = 0.2" Right Margin = 0.2" Top margin = 0.166" Bottom margin = 0.18" There is no button to choose a printer. The report, for...

Crystal Reports 11.0.0.1282 Report has a dynamic date prompt. The report has been working fine until now. Now, every time the report is refreshed, the following error appears: --------------------------- "Prompting failed with the following error message: 'List of Values failure: fail to get...

I wrote a report on my machine. All fields were Arial 8. I ftp'd the report to a client's machine that has Crystsal 11 installed. Once it's on their system, all fields are showing up as "Device Font." If you try to change the font, there are no options other than "Device Font." If you go...

I support about 4000 clients and the database is the same on all clients - same tables, views, indexes, columns, etc. The hardware/setup of the servers for each client are controlled by the client, so, that's out of my control. But, I've taken the query and run it on about a dozen...

We have some clients that are on SQL Server 2000 and others that are on SQL Server 2005. I have a report with the following query: SELECT "vwGenSvcInfo"."Department_Abbr", "vwGenSvcInfo"."Actual_Dr_Name", "vwGenSvcInfo"."Patient_Number", "vwGenSvcInfo"."Service_Date_From"...

Never mind. It was a problem with the placement of the parenthesis. Mods, feel free to delete.

I have the following formula. It's 3 completely self contained conditions - let's call them A, B, and C. Only one of the 3 conditions must be met in order for the row to apply. Assuming the 3 conditions are in the order A,B,C, A & B are working correctly. Rows that meet condition C do not...

You rock.

I'm writing a report for a medical office and the patients can see any of the doctors within the office. They want a report that will appear similar to: Dr 1 Patient A 10 total visits 3 visits for Dr1 30% Patient B 15 total visits 3 visits for Dr1 20% Dr 2...

I'm working on a report for a doctor's office and they'd like a printout of the schedule to view at a glance. Desired Output is: Dr 1 Dr 2 Dr 3 Dr 4 8:00 D Smith M Jordan J Worthy K Smith 8:15 A Jamison V...

I'll check the AutosmartLinking. But I'm never getting to the point of selecting a table. As soon as I click the new icon (or File --> New), Crystal goes to lunch, and dinner, drinks, etc.

I've verified the #s and the filter is respecting the left outer. Is there a way to get the command statement to respect the indexes on a table/view? Every time I use a command statement, performance goes to crap.

You do understand correctly. Unfortunately for me, my company keeps the media in our New Hampshire office so it looks like I won't be working from home any time soon.

Wouldn't the fact that all of the filters are connected with "OR" instead of "AND" keep the left join in tact? Also, I'd love to be able to establish constraints as part of the ON clause. How do I do that in Crystal?

That's correct.

I thought about that, except I'm not even getting a chance to choose my connection. For all Crystal knows, I could be connecting to a database located on lap top.

No, I'm able to copy and paste the sql statement into MS Query Analyzer and it runs fine. I think I have it figured out. The problem is with the 2nd line of the section. ID.....chgDt.....chgVdDt.....pmtDt.....PmtVdDt 48781..12/29/06..............1/17/07.......... Filter: ChgDt = {?dtRng}...

{vwGenVouchInfo.Posting_Date} = {?Dt Range} or {vwGenVouchInfo.Date_Voided} = {?Dt Range} or {vwGenSvcPmtInfo.Posting_Date} = {?Dt Range} or {vwGenSvcPmtInfo.Date_Voided} = {?Dt Range} ------------------------------------- SELECT * FROM (vwGenVouchInfo INNER JOIN...

That is the full record selection formula