Search results for query: *

No - double clicking on the .dqy file to run it and then the parameter box(es) pop up for the client to enter dates into. :-) Man plans. God laughs.

Hi Everyone, I am using MS Query/Excel to build a query, and due to the data structure there is some "Or" logic involved. And for all three sets of criteria, I use a parameter for the start date. The problem is that if I use three [Enter Start Date] parameters (one for each set of criteria)...

I am sorry...I tried to post in the wrong section and it won't let me delete it! Rayna Man plans. God laughs.

This is an incredibly basic question - but I just got a new machine and have been "upgraded" from Word 2003 to Word 2007. In my job, I use current Word Documents, and add mergefields to them to pull data from our database and print completed documents. The original docs are/were normal Word...

When one of my clients runs a Crystal Report, it is taking forever to load! His email reads: "I found that the variable that the report is using is the %HOMEDRIVE% variable. [Cut for boring and probably useless stuff here] I would really like to change the report to write data to the %TEMP%...

...But I mistakenly thought my questions was simply a formatting issue - ie how the data was coming into the document was irrelevant. I thought that the data could simply be *displayed* as a cross tab and didn't think it had to be brought in this way. My apologies. Rayna Man plans. God laughs.

OK...here was my developer's response to the question "How is this done without VBA?": "Build the query directly in C++ and use the Visual Studio wrappers to call open Word, call the query, and pass the result set" Does that help at all? Man plans. God laughs.

I work on MS Word Merge docs (usually XP). They are designed based on a query of a SQL database and the query brings back rows containing the following three pieces of data - Date/Category/Number. I am able to do a table like thus: Date Sale Type Number of Sales Aug 7 Chocolate 7 Aug...

I am building various word merge documents and have fields like "final_amount". Some of my clients want there to be a statement such as "If you cancel within 30 days of the event, you are charged a cancellation fee of 50% of the final amount [insert the actual calculation here]". I can't seem...

*LOL* Funny you should mention that! It did fail, and I was too embarassed to ask as I figured I had made an error. So I merely took the 255 you gave me and made it 254, but since you have offered me up a better solution, I shall take it! :-D Man plans. God laughs.

Rosemary, Thank you SO much....that worked like a charm!!! Rayna Man plans. God laughs.

I cannot for the life of me locate a way to make, say, "beverly hills" into "Beverly Hills", in 8.5. I tried titlecase() and even leadingcaps() (after finding references to it on the Crystal website) but all I can manage to make work for me is uppercase() and lowercase(). Am I missing...

This is probably a terribly basic question, but I am very new to Word merge. If I need a field in a Word Document called "Guaranteed_People" and my query contains <<guaranteed_adults>> and <<guaranteed_children>>, is there some sort of Sum() function I can use to get the result I need, or can...

Am using 8.5, and am looking to put three columns, side by side - Budget, Actual, and Last Year Actual. The last year actual is in the same table as the current actual, and therefore the only way I can figure out how to do it is by subreport and shared variable. The thing is, I can't figure...

Oh my gosh....that worked perfectly. And I had 199 lines of code. :-) You are da bomb! Thank you so much. Rayna Man plans. God laughs.

IdoMillet.... Sad, but true!!! It does not apply to 8.5. Looks like I'll be typing a whole slew of forward slashes until we upgrade!! Rayna Man plans. God laughs.

Thank you for your help. I thought it HAD to be there someplace and I was just missing it. Rayna Man plans. God laughs.

...anyone knows how to comment out entire sections of code in a formula. Each line can be commented out by // and in some languages you can do: /*Here is the text I want to not be evaluated*/ Does Crystal have such a thing, because commenting out a hundred lines of code one by one is...

LB, YOU RULE! Thanks so much for the help. It worked perfectly. Rayna Man plans. God laughs.

LB, Thanks so much for your response. I am very sorry - Should I have mentioned I am using 8.5? I don't see the check box you have recommended. Rayna Man plans. God laughs.