Can I do a Order By?

[Sahubba]

Hello,I need to display data in these orders

Group (Customer Name)
ERQ – ER – IP – OPO

Group (Customer Name)
ERQ – ER – OPO – IP

And if it is not in this order then i do not want the customers name to display.

Currently this is what i am getting

Group (Customer Name)
ER – OPO

Group (Customer Name)
ERQ – IP - ER

And this is not correct.
I hope this makes sense and someone can help me with this.
Thanks

 

[Sahubba]

I get the same data,
currently GH1b and GH2 are supress, so the only thing I am getting in return is GH1a which is the customers name

 

[lbass]

I asked you to create the formula in the field explorer and then place it in the GH1b section directly and then report back with the result. By the way, the customer name should be in GH1b, and the sub should be in GH1a.

-LB

 

[Sahubba]

That is what I have done,
In the subreport GH1 is the Customer name.
So when I run the report the only thing that display is the subreport with the customers name.

And Currently in GH1a and GH2 I have the supress formula in the section expert. is that how it is suppose to be?

 

[lbass]

Why are you showing anything in the subreport? All sections WITHIN the sub should be suppressed.

-LB

 

[Sahubba]

Ok, I supress everyhting in the subreport and now the onlything that I am getting is false

 

[lbass]

I don't really understand what you have done. You cannot suppress the subreport itself, just all sections within it. And you can't suppress the GH1a section that contains it. Where are you seeing "false"? What formula is generating this? Is it the reset formula which always will say false?

-LB

 

[Sahubba]

I did supress each section with in the sub. I did not supress the subreport itself. I also did not supress GH1a in the main report.

I am seeing the false in Gf1a
this is the formula:
whileprintingrecords;
shared booleanvar y;y := false;

 

[lbass]

That is the reset formula and it will ALWAYS say false. Just suppress it. Based on the example of two customers you showed, both should have been entirely suppressed, so I can't tell what the problem is from your description.

You should test the value of the shared boolean variable as I showed in an earlier post and you might also then test the value of the shared stringvar x in the main report, to see what exactly is being passed to the main report.

-LB

 

[Sahubba]

The probelm is I am not getting any data back. When I run the report its blank.

I did test the shared boolean variable and it comes back False,
I also test the shared stringvar x thats locatted in the the subreport. I tested it in the subreport and this is what I get
115,115,115,103,103,103,101,101,101,104,104,104,115,115,115,103,
103,101,101,101,101

 

[lbass]

First of all, why am I seeing numbers when all along you indicated the fields read like EDQ, OPO, etc.? This is the field my formula was meant to test, not the numeric one. It also appears that you did not move the formula to the Group section for status.

-LB

 

[Sahubba]

I change it to EDQ, ER, IP, OPO and it still giving me the same thing. EDQ,EDQ,EDQ,ER,ER,ER,IP,IP,IP,OPO,OPO,OPO,EDG,EDG,EDG,ER,
ER,IP,IP,IP,IP

Also those numbers are not a NUMERIC Value, it’s a VARCHAR, so it should work.

Which formula are you referring to that i did not move to the Group section for status?
If it’s this one,
whileprintingrecords;
shared booleanvar y;

I did and its giving me a false

 

[lbass]

No, the formula checks for the specific letters, so of course it wouldn't work if used the numeric field. The reason you are getting the repeating values is that you have not placed the formula in the group that corresponds to the field that returns EDQ or ER, etc. I thought that was the status field, but maybe it is something else.

-LB