First Records Operator Id Will Not Display

[williadn48]

I have a CR that reads results from a SQL Stored Procedure. When I look at the sp in query analyzer I see the first records as null and then the next set of operator records for Andrewsk99, but when I look at the CR I cannot see AndrewsK99 on the report, all I see is the results of AndrewsK99. How do I force CR reports to print that op id for the very first record?

 

[synapsevampire]

What does:

"but when I look at the CR I cannot see AndrewsK99 on the
report, all I see is the results of AndrewsK99"

mean in English?

You can see something but you can't see it...

Perhaps you're trying to say that you don't see rows that have a null value?

I doubt that this is true, perhap it's the grouping or ordering being used in CR.

And I'd guess that "I see the first records as null" probably means that some field within is null, not that every row is null in the "first records".

It would really help were you able to state what it is you have and what you need, rather thhan using generic, vague terms such as "first records" and "results of AndrewsK99".

If a field is null, Crystal will return the row anyway.

Try going into the Report->selection Formula->Record and placing:

isnull({table.field})

Now Crystal will filter out the other rows and only show those with a null in that field.

Also don't confuse null with blank, they aren't the same.

-k