Search results for query: *

JACKPOT!!! Perfect! Thank you for your help.

For clarification purposes, the following keywords I would need: q=space+program&start=0 (I would want to pull out space+program) q=dog+food+stores&start=0 (I would want to pull out dog+food+stores) q=puppies&start=0 (I would want to pull out puppies) Does that help to clarify things?

I only want the keyword, yes. The keyword is ALWAYS identified in the Google string by a "q="...for each word that was used in the search, it is always separated by a "+". So there could be multiple instances of "+" after the "q=" I want everything that is equal to the "q="...if I say...

For this suggestion, I get this error: split(split({table.field},"q=")[2],"+")[1] "A subscript must be between 1 and the size of the array.

Thanks. However, I get an error in the formula on the last line: "The remaining text does not appear to be part of the formula." substr({table.field}, i + 2, j - 1); I'm not following the logic behind this formula...what is it attempting to do?

I'm trying to parse a string within a field. Specifically, the field captures the referring URL from which the traffic was sent to our site (i.e. Google) and I need to parse out the value of the keyword so I can sort on that. I've not found an easy way to do that. A typical entry is like...

When creating a Crystal Template that needs to interface through a SQL ODBC, if you go to Database->SQL Query (running Crystal Reports 10), it will pop up with the SQL script that Crystal created in order to interact with the database. However, depending on the complexity of the query, the SQL...

I'm using cross-tabs for the first time in Crystal Reports 10. I've placed States along the top with Dates along the side. The summarization will look at the values for each particular state for that particular date and drop the value into the summarization field. When you scroll over to the...

I did manage to get it to work using the method you described above. However, it returns all the results. Let me try to explain without confusing myself. The main report is grouped by date. The subreport is placed in the group footer. Ideally, I only want the subreport to run and return...

It does do that initally. But once I hit "OK", the settings are apparently lost. No matter how many times I try it, I can't get it to be set to the main report parameters. Might be a bug in Ver 10.

That makes a lot of sense, thanks. However, even after linking the subreport to the ?from_date and ?to_data parameters from the main report, I get an error "This field name is not known" when I set the sort criteria to {invoices.purchased_date} in {?PM-from_date} to {?PM-to_date} When I go...

I've been using Crystal reports for some time. However, I've only recently run into a situation that requires me to analyze data from different databases that aren't necessarily linked together. Ideally, I'm trying to link a subreport to the main report using the date. On the main report, I...