Search results for query: *

Using MySQL version 5.0.45, I have the following problem: SELECT * FROM student_completed_section stud inner JOIN curriculum_unit cur ON (stud.curriculum_id = cur.curriculum_id AND stud.unit_id = cur.unit_id); Shows an explain plan which indicates a simple select on...

Big-picture problem: for a single training session, select a single trainer (though there can be more than one trainer). If there is no trainer (possible) select an alternate trainer or training coordinator in that order. Specifics: I've been able to accomplish this by placing a subquery in the...

Is there a maximum number of values that a parameter is able to have? Specifically, I'm interested in creating either a static parameter or dynamic parameter that has a very long list of possible values from a database. However, in both cases the list of values gets cut off around "S" and...

So the Windows/Temp folder is fast filling the disk in my deployment. Each time a report is opened, a number of files are created here. The problem is, of course, probably that I'm not releasing my report objects in my code, as these files can't even be manually deleted without shutting down...

On my local machine, when I preview the report, I am shown the report as it is in Crystal in terms of the dimensions of the page. For instance, I have an 11x17 report and it shows up that way in the browser window of my ASP distribution local site, etc. When I click the print button, it also...

I've got an ASP script using a report document that allows me to launch the web page at a scheduled time and export my report to disk as a PDF. I can then grab the PDF and attach it to an email and send it out. This is great for sending daily updates to our staff. I've received a request...

So here's the problem I'm having-- I have a fairly complicated report with some 50 or so formula fields that are creating a variety of subtotals/totals of my data using the following technique: whileprintingrecords; NumberVar LicensesYearTotalCorporate; LicensesYearTotalCorporate :=...