Lay-out design

Eddy Kalliski

Can anybody tell me how to move or remove the folding stripe in de Marketingdin lay-out?

Best Regards,

Eddy Kalliski

Philipp Knecht

Hi Eddy

Zoom out of the layout and then you'll see it on the top of the layout.

hth

Eddy Kalliski

Danke sehr!
Es wirkt.

Martin Cerasuolo

Dear Sir, Madame,

I'm trying to use the following query to generate a Coresuite report with a parameter. With the parameter i want to select only one state and the result are business partner of which the delivery address is situated in that particular state. By the way i tested the query in SAP Business One and it works correct.

SELECT T0.Name as 'Provincie', T1.CardName as 'Klantnaam', T1.MailAddres as 'Afleveradres', T1.MailZipCod as 'Postcode Afleveradres', T1.MailCity as 'Plaats Afleveradres', T1.Phone1 as 'Telefoonnr'
FROM OCST T0 INNER JOIN
OCRY T2 ON T0.Country = T2.Code RIGHT OUTER JOIN
OCRD T1 ON T0.Code = T1.State2
WHERE (T1.CardType = 'C') and T0.Name=[%Name]

Anybody, please help me to get this right in Coresuite Lay-out designer. I tried 20 ways with the formtypes and parameters. But the lay-out still gives a message that the fieldname doesn't exists. Although it works in SAP Business One.

Martin Cerasuolo

Massimo Sommaruga

Hi Martin,
try to use:

..... and T0.Name='[%Name]'

As written in the Layout Designer manual (paragraph 5.2.1) , alphanumerical and date parameters always need to be closed by apostrophes.

Hope it works!

Regards.

Philipp Knecht

Hi Martin

Also check if you've defined the parameter correctly (You don't need to link it to formtype if you intend to make an userquery starting from menu)
A good way to check that is to go to then parameters tab in the Layoutdefinitionfom, delete all the params listed there and press "Get from Datasource".

hth

Martin Cerasuolo

Dear Philip,

Did that done that, but still the errormessage occurs in the Lay-out Designer.
I think it has to do with the way the query is build. I'll check it out.

Best Regards,

Martin Cerasuolo

Martin Cerasuolo

Problem solved...and T0.Name=[%Name]
and change and T0.Name='[%Name]'

Giovanni Carletti

Hello,


sorry but I zoom out but don't see the stripe: in the marketing document, can you tell me the name of the control? is it shape1?

thanks
giovanni

Philipp Knecht

Hi Giovanni

It's shape2 and within the PageOverlay Control

hth

Martin Cerasuolo

Dear Sir, Madame,

Is it possible and how to use the lay-out designer to export to a text file?

Please let me know?

Best Regards

Martin Cerasuolo

Martin Cerasuolo

Dear Phillip,

I created a report for production orders. After selecting with Shift + F2 the sales order. The report shows all productionorders linked to this sales order. The problem is that if there are more than 6 or 7 productionorderheaders and lines the lines of the sixth or seventh productionorder are divided over two pages. Instead my customer wants a keep it together function to have the groupheader and lines on one page.
Is it possible to define my lay-out in this particular way?

Philipp Knecht

Hi Martin

You can export in different ways:

- Via Preview -> Export Toolbarbutton
- Via Printdefinition (You even can check the Fax for that purpose)

Keeping together a Band is not possible. But you can set NewPageAfter Property in GroupFooter to true.

hth