Thanks,
The databse is MS SQL SERVER 2005
ERP System: JD Edwards
Table: F4111
I used query analyzer to query the field in question:
Select * from testdta.f4111 where ILDCTO = ''
It returned all of the records with blank values. Changing the '' to ' ' (space betwwen the ') returned the same...
thanks for your input.
i think i need to treat the blank value as a null because the record (inventory transaction) may or may not have a order type, so blank is a valid value. 2 issues arise.
1. the code produced an error message stating the "this array must be subscripted" . I have tried...
Crystal XI
SQL Server
I tryiny to write a report where i ask the user for record selection based on values in the database field. The field can have several different values including nothing.
In my prompt i list the values but i am having a problem of how to represent blank value - I have a...
TurkBear:
Thanks for the info. I have tried that scenario but it will fail when i encounter situation 'C' listed in my initial post. in that situation i get 4 lines (should only be 2):
apdoc123 (line 1) = gldoc123 for line 1
apdoc123 (line 1) = gldoc123 for line 2
apdoc123 (line 2) = gldoc123...
CR XI
JDE User Business Views
I a trying to integrate more Crystal into our reporting environment and have run accross a situation where i need to link 2 tables. I have read that Crystals sub report feature works well when there is a many to many join between tables. here is my situation:
Main...
other info:
each running sum formula has an evaluate criteria that is specific to the run sum formula - as an example:
{F4211.SDLITM} = "VAT00" (for the #RunSum_Vat00 formula)
this criteria seems to work for the Vat tax that actually had data
RJ Piekos
its returning null for the those sums because there were no VAT (taxes) for the report period.
i understand your formula but i was wondering if there was a way to put
if isnull({#RunSum_Vat00}) then 0
somewhere in the running sum dialogue box so that it at least returns a zero.
RJ Piekos
Yes, they appear to be working. Only 1 running sum has an actual sum (#RunSum_Vat16), the other three return nothing as in not even a zero (which i formatted for).
RJ Piekos
Why won't a simple formula such as
{#RunSum_Vat00}+{#RunSum_Vat04}+{#RunSum_Vat07}+{#RunSum_Vat16}
not return the correct values?
The running sum formulas are set to NOT reset.
RJ Piekos
thank you for the suggestion. the 2 dates that are affected by this are not database dates, they are 2 system dates:
CurrentDate and DataDate
i think i'll go with the if...then or maybe the select case
RJ Piekos
I have created a Dunning Letter in CR XI for our Spain office. The letter is in English and looks OK when i run it here in the US but when the Spain user runs it, the month names show up in Spanish. I am using the Crystal date format of DD MONTH, YYYY.
Is there a way of not converting the MONTH...
CR XI
SQL 2005
If my database date values are stored as Julian and I create a parameter to select on the date field, how do i get the dates to show in mmddyyyy format?
i do have a function that i use in the report to convert julian to mmddyyyy but i need to select on dates that are in the...
Thanks for the suggestions.
I am on version 11.5.9.1076
One other thing that i did not mention - the fields that i want to suppress are in the Group Header (#1a) section. I didn't know if that made a difference.
I assume that when you say that i should insert a new section you are referring to...
I am writing a report that includes the full address of a customer in the form:
{name}
{addr1}
{addr2}
{addr3}
{city} {state} {zip}
In most cases the second and third address fields are blank so i want to suppress them and move the rest of the fields up. I have checked the suppress box on the...
Crystal Reports: V10
Data Source: MS Access
First question: does suppressing a field simply not print it but leave the field space on the report?
I have a report with 5 description fields. fields are stacked above each other in the detail section. most of the time, fields 3 thru 5 are blank. I...
I am trying to prototype row security in the stand-alone system (B8.10) but nothing works. roles don't work, user security doesn't work (users can sign on with out a password), the system user profile does not appear to work.
does password security need to be required in order to make row...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.