Search results for query: *

3. get your quoting style right, from the start. Personally I use heredoc for anything more than a couple of lines" I researched heredoc here: http://www.hudzilla.org/phpwiki/index.php?title=Heredoc_syntax Is heredoc something that needs to be installed or defined? Or, can I just start using...

jpadie, thanks for the tips. Don, thanks for that code as well. I was sure there was a better way then what I was doing. I just wanted to try and do it within the confines of my existing knowledge. And even then I couldn't do it. I came here because I knew my method was on the right track...

Thanks, jpadie. I figured there was a better way to do this straight from sql. But I figured I could write a script to do it easily. I was wrong. I am just now getting to learn how to use mysql with php. I've been reading books and tutorials slowly over the past couple of months. I can...

Doesn't my code do the following: 1) set a variable ($num) equal to 1. 2) state that while the variable is less than 40, execute the following: 3) run the query based on $num being equal to 1. 4) set $num equal to 2. 5) return to step #2.

I am in the process of teaching myself PHP/SQL. I have a seemingly simple thing I'm trying to do. I have a field called "memberid" in my database that is populated with a unique number for each row. I have another field called "member_id" that I want to populate with the same number that is...

Where is the subreport linking screen? I am using CR 8.5. I only know about the Add Subreport screen. I already have a subreport, I just want to change the linking.

I'm using Crystal 8.5. When I try using the formula you mentioned, I get a "The summary/running total field could not be created.

ohhhhh....I see. Never thought of that. I will try both of your ideas. Thanks a bunch!

Thanks, I will try the linking advice. The problem with your formula is that if I choose the date range of May 1 through May 31, and it turns out there is no data on May 1, my formula label would say "May 2 through May 31". And, although technically accurate, I think this may confuse my customers.

I have a report and a subreport. I have one parameter, it is a date range. Instead of a date range I want to have a begin date and an end date for the report parameter. How do I add a linked parameter to a subreport? The reason I want to change the type is because I want to print the...

Yes! That worked. Thanks.

I've developed a report that generally will fit 3 different groups on the same page. (Generally, each group is about 1/3 of a page in height.) However, if there are more than 2 details for any one of the groups, the third group will be split over to a second page. Is there a way to make sure...

lbass, thanks. I copied your version and pasted it and it worked. I know very little about SQL queries. It looks like your version has two changes from mine (which came straight from my book). You added: Customer. in front of each field, and you used " instead of '. What does each of...

I used this SQL query in the Add Command dialogue: SELECT "Customer Name", "Region", "Country", "Last Year's Sales" FROM Customer I did this on the Xtreme Database example that came with Crystal XI.

I have a crystaluser.com training guide. In the lesson about using the Add Command prompt, it tells me to access the sample database with a simple SQL statement in the Add Command function. In my guide, after I add the Command, it shows 4 fields with their original names as the titles...

Is there a way to do multiple summaries at once? For example, if I put 10 different objects in the DETAILS section and want to create a GRAND TOTAL for each object, is there a way to total them all at once, or do I have to go one by one and do a GRAND TOTAL SUMMARY?

What do other people do to remember how they built their report? I don't have a good system. I will write a report, often times a complicated report. Something will change in the way my company records sales or SKU's, etc. and I often forget to thoroughly update my reports to reflect the new...

Plus the date format in a date parameter totally blows. I'm feeling pretty disappointed by version XI.

I just recently got XI as well (upgrading from 8.5). Is it just me or is the Refresh Parameter input box worse on XI than it was on 8.5?

Is there a way to change the default Text File Export so that it sets the Number Of Lines Per Page to "0" (Do not paginate)?