Recent content by pontupo

There aren't any indexes on the columns. This would certainly increase the efficiency of the queries, I just think it's a little odd that the left join approach doesn't work at all. The query you provide does run, but is really another form of the first one, right? An inner join expressed...

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...

Here's a user defined function that I created. Assuming you have permission to create a user defined function, you should be able to add this to your database and then use it like so: select * from dbo.create_table_from_array('your list here','your delimiter here') CREATE FUNCTION...

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...

Very interesting. I'll definitely be exploring the use of these Commands.... I think I noticed that menu option before, but have never tried them out. In my particular case, I was pulling a field that is from a database view that was setup specifically to limit the list of values already... so...

Would this command be on the database end then? Like a stored procedure or a function?

OK, I guess I spoke too soon. Restarting -seems- to have eliminated the error. Oddly, the report wasn't working properly even when I moved it to the webserver and my ASP reports portal, so something was definitely wrong with it, though it could have just been caused by my computer being confused...

Here's the error, found through debugging with VisualStudio: Unhandled exception at 0x012ac991 in crw32.exe: 0xC0000005: Access violation reading location 0x00000000.

Interesting. I now receive what I think is basically a null pointer exception and CR crashes when I actually apply these parameters. I can get the full list into the list of values... but I'm not sure that I can actually utilize the resulting parameter. Still investigating... Pont

I'm all set, though if you're willing, I'm still curious about what that approach would be...

Just another update with a simpler link to the support article: http://support.businessobjects.com/library/kbase/articles/c2017238.asp

Thanks for the help, lbass. Here is a link to the article I located on the BO Support website for modifying the registry in CR XI release 1 and 2...

lbass: What kind of a command can you use to populate the list? I'll take a stab at finding that registry setting. I don't see any particular reason to limit that list of values (obviously I wouldn't want to put a million values in there... but my list isn't -that- long!). Madawc: My values...

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...

Here's the code that I use: Option Strict On Imports CrystalDecisions.CrystalReports.Engine Imports CrystalDecisions.Shared 'Imports System.Diagnostics Imports System.Net.Mail Partial Class _Default Inherits System.Web.UI.Page Private report As String Private reportDoc As...