Working on adding in OrderHed.ResDelivery to the Order Acknowledgement query. But it is so tight int here that when I try to add it doesn’t allow it. Then I copied it all and put it into Notepad++ and then every line just expanded. Is there an easier way than just line by line removing spaces and making it as tight as possible?
I recall a thread about the Query expression of some RDLs being “too long” Seems that even though the original expression is too long, it works. But as soon as you add to it, it doesn’t.
Look here:
Interesting, I’ve been able to copy it out, adjust and put it back in with little issue, so far. Today, had an issue. Big thing on this was the fastest way to reduce the spaces between the commas. When i put it notepad++ it added in the spaces making it impossible to put back without compressing line by line.
I assume notepad++ has a find & replace function.