Hi all,

I have been doing my best to create some CR templates for use in a helpdesk program my company uses.  As this is my first experience with CR and I have no practical experience with databases or writing code, I've been struggling.  I'm not even sure what to search for in these forums, although I have tried with no success to find my own answers.

Hopefully this is an easy one for somebody.

Everything is based on an issue number {IS_ISSUE_NO}.  For the most part I've been able to create a report by merely dragging and dropping a desired field into the report, and I get the data in that field for the corresponding issue number.  Simple enough.

The problem I am having is that one of the fields I want in the report, {ITX_ISSUE_TEXT}, is used for an issue description AND an issue resolution.  There is another field, {ITX_ISSUE_TEXT_TYPE}, that is used as a second primary key (which seems counter-intuitive to me).  {ITX_ISSUE_TEXT_TYPE} is set to 1 for a description, and 2 for a resolution.

I only want resolution data in my report.  However, if I merely drag {ITX_ISSUE_TEXT} in, it only yields description data.  Can someone assist me with a formula that I can drag into the report that will give me the {ITX_ISSUE_TEXT} data where the {ITX_ISSUE_TEXT_TYPE} primary key is 2?  It seems simple, but yet it eludes me.

Any assistance would be GREATLY appreciated...  Time to buy the book!

Thanks,

Craig

Hi Brian,

Thanks for the reply.  The formula you posted is basically what I have been trying to no avail.  Here's what I know so far:

-- For every record, the table {ISSUE_TEXT} will have two entries.

-- The table {ISSUE_TEXT} uses {ISSUE_TEXT.ITX_ISSUE_NO} as a primary key, and it also uses {ISSUE_TEXT.ITX_ISSUE_TEXT_TYPE} as a primary key.  {ITX_ISSUE_NO} is linked to {ISSUES.IS_ISSUE_NO}.

-- The result of this is that the two entries for each record both have the same value for {ITX_ISSUE_NO} but different values for {ISSUE_TEXT.ITX_ISSUE_TEXT_TYPE}.

-- If I delete the entry with {ISSUE_TEXT.ITX_ISSUE_TEXT_TYPE}=1, the formula gives me what I want.  However, the next time I open the record, the database recreates the entry with {ISSUE_TEXT.ITX_ISSUE_TEXT_TYPE}=1.

It seems like the formula is never even looking at the second entry, as if it is assuming it's done after finding one entry with a matching primary key value.  If this is the case, is there a way to make it keep looking?

I hope my question makes sense.

Thanks again for your help,

Craig

P.S. This is Crystal Reports 10 if it matters.


Edited by malibu327 - 07 Jan 2009 at 6:31am

DBlank,

You are right on with what I have and what I want.  And overcomplicating seems to be my speciality!

So, rather than referencing the formula I've created, I simply dragged {ISSUE_TEXT.ITX_ISSUE_TEXT} into the report, right clicked it, chose "Select Expert" and told it {ISSUE_TEXT.ITX_ISSUE_TEXT_TYPE}=2.

I still am experiencing the same problem.

FWIW, if I delete the row where {ISSUE_TEXT.ITX_ISSUE_TEXT_TYPE}=1, I get the result I want.  The application sticks it right back in though when it saves the record.  So, I feel confident that the presence of the first row is the cause of the symptom I am reporting.  However, I don't know what to fix!

Something I just noticed is that CR identifies the indexes of this table in a way that seems odd to me.  According to the index legend, I have 1 1st index, 1 2nd index, and 3 3rd indexes.  The 1st index is also a 3rd?????

I can't upload a screen cap image but can provide one to anyone interested in seeing a screen cap from where I link the tables.

I have a message in to the support guy for the application as well.  I'm stumped.

Thanks again,

Craig

I thought I understood the question, but reading through what CR is doing doesn't make sense (a third index???). So what about taking a different approach... Let's assume that you can't get rid of the record equaling 1 and it is always there. Just suppress the records you don't want printed. On the Details section, use a conditional formula for the Suppress property and set it to

Edited by BrianBischof - 07 Jan 2009 at 1:14pm

This is bad luck. I'm guessing that there might be a versioning issue between the two. Are all the other fields okay? Are you showing the actual field on the report or a formula? If its a formula,what if you change it around some, will that make something appear? Are you using VS 2005? Do you have the latest service packs so its up to date with the latest version of CR XI?