Recent content by beatlejus

Hi, works fine except from the fact, that I do not know how to give the field a name and sort it. Field name is shown as Casewheniassalhead.countryin(' I can rename it through the layout tab, but how to sort then with that field.

Hi, I am just trying to define a separate field in my report called "EWU" with the CASE command, but get the above mentioned error. What's going wrong? My query: select IASSALHEAD.COUNTRY, 'EWU' = CASE iassalhead.country when iassalhead.country in...

Hi, I am just trying this query: where the use of iasmatx.ltext causes the error message. Is there any solution to use this field without having the error?

Hi, We have the following script: ... and dcviewumsatzpos.createdat >= '&Datum_von' and dcviewumsatzpos.createdat <= '&Datum_bis' ... Is it possible, to give the input window a description for the user like "Please input the dates in the following form: DD.MM.YY"?

Hi, I would like to see statistic information at the end of my report, especially the number of records found, eventually total records in database? Is that possible?

If I do that, e.g. where iassalhead.docnum = iassalitem.docnum and iassalitem.material like '%10121777%' and iassalhead.country in (&list) Input is: S, N, DK, SF or S,N,DK,SF but I receive the error message "invalid column name" Can you help? ------------------ -- Rgds, Norbert

Hi, Is it possible to include a list of arguments after the "where" function, e. g. Select * from sampledatabase where desc "in the list of" (desc1,desc2,desc3)? Ideally it should work as input variable (&). Or does this only work in the form "where desc = desc1 or desc = desc2"...

Hi, many thanks first of all for your prompt replies here. In a report I have to fields: invoice_value, statistic_value and I would like to have the following calculations: invoice_value < 1000 EUR, statistic_value * 1,05 invoice_value > 1000 EUR, statistic_value / 1,05 Is that possible...

Hi, If I choose '0' as output format, figures will be shown in the report e.g. as 23148 instead of 23148,05. So far, so correct, but when I export this to CSV, I will have 23148,05 as value in my output file. How can this be changed? ------------------ -- Rgds, Norbert

It's a bit difficult, as I have done this in my last job with R&R Report Writer and I do not have access to that here in my new job, but I'll try: I think, it's a bit equivalent to the Sum/Break function of Query Reporteer. But in Query Reporter there is no way to get _only_ the summary lines...

Hi, will there be a feature to suppress record line, e. g. for a sum function? I know that feature from R&R Report Writer. ------------------ -- Rgds, Norbert

Hi, How can I query for empty fields in a table?

Hi, I would like to group my records and show the content of the data in the grouped line, but as far as I know, I only have to choice to summarize the records, e. g. the following table: Statmatnum Country Total 27150000 A 10 20...

Thanks a lot, that's exactly what I'm looking for. ------------------ -- Rgds, Norbert

Hi, is it possible to export data to Excel with changing all upper case in lower case or better using an Excel function to convert all upper case in first letter upper and the rest of the statement lower case? Rgds, Norbert ------------------ -- Rgds, Norbert