Search results for query: *

hello I want to use (learn to understand) the evaluation functions. In an invoice we’ve on line level the reference number to the sales order . The Invoice is created from multiple sales orders. In need those reference numbers singular printed in the header of the invoice. In the line reference...

Hello I’ve created a stored procedure as input for my Crystal Report for open orders. In the SP aren’t any selection variables. In Crystal Report I’ve a selection on customers. When I select for example customer 1 to 5, the stored procedure gives customer 1, 3 and 5 as result with them open...

hello I have a tabele with 3 colums. I need to increment the value of the row with 1 eachtime the partner changes (see column row2) number partner row row2 1 A100 5 5 2 A100 5 6 3 A100 5 7 4 A200 28 28 5...

hello I've written a query (base of a more complex one) that I used to test all the records of a document in a stored procedure. In this simple example it's checks the quantity on row level in a document is = 1, the an error message will follow. My problem is that the check only works on the...

Hello I have created a stored procedure that I use for import for my Crystal Report and gives some information about Items. Because the Item records holds many fields, in the report I put some records among each other in one detail line (i didn't create extra lines in the section manager). So...

hello, in the discount table is a column with volume discount: qty discount 10 15% 20 18% 30 19% I've a quantity of 25, how can I find the right discount, in this case 18% Dan

Hello I try to import a xml file in MSSQL database with the bcp command: EXEC master..xp_cmdshell 'bcp Database.table in C:\Users\Desktop\test.xml -x -U sa -P password' I receive the message in sql query results window: Enter the file storage type of field _PRODUCT_CODE [nvarchar(max)]...

Hello I've a simple query, like: select 'PurchaseOrder' , t0.DocNum , t0.CardCode , t1.VisOrder +1 as LineNr , t1.ItemCode from OPOR t0 inner join POR1 t1 on t0.DocEntry = t1.DocEntry with the results: DocNum CardCode LineNr ItemCode -------------...

Hello I’m looking at the following issue We want to run at night a query in the mssql server (for example as a job), and let the results written to a csv file on the server. What is the best way to do this? Dan

hello I’ve a sales table with items and the date when they are sold. Most items are sold multiple times on different days. How do I write the query with as result the items with the latest day when they were sold? Dan

Hello If you have a formula between a few fields where one or some off the fields has the value ‘null’ or 0, you’ll receive an error and the report is not printed. What is the best practice to handle with this issue. I thought an if-then analyze for first checking every field if the value <>...

Hello, I need to find the right exchange rate from the rate table by a purchase document on the purchase date. In the purchase table a have the docnr, date, and value in euro. In the rate table I have for each date a currency and the rate, for example: 5 march, USA, 0.75 12 april, USA...

hello, to print the selected parameter to the report, I use the formula: "Status: " & Minimum ({?ProjectStatus} ) & " to Status: " & Maximum ( {?ProjectStatus} ) The value can be 1 or 2. I want to print when the value is 1 'open' and if 2 'closed'. I don't have succed with an...

I’ve an invoice whereby I use a page footer and a report footer. In both there is some standard text. With a few orderliness (1 page) there is no problem, the report text will print to the bottom. But by more orderliness (1,5 pages) the report footer text will be print halfway the page, under...

Hello I have a page footer section which I suppress with the formula ‘PageNumber <> 1’. In the report footer are the ‘general terms’ in a ‘grow’ box what takes 5 pages. On the next pages after page 1, the suppressed page footer area will be blank and unused by other text of the ‘general...

Hello I want to learn a program language to expand my professional skills. I doubt between Visual Basic 2010 or C#. Microsoft offers for both the learning book 'Step by Step'. I don't have any program experience at all. I do have professionals skills on standard finance and logistic software...

Hello I want to learn a program language for extending my professional skills. I doubt between Visual Basic or C#. I don’t have any program experience at all. I do have professionals skills on standard finance and logistic software which are created for ‘dot net’. I read that C# is special...

hello In an invoice lay-out/report, I want to use the function 'running total'. In the footer on each page as a totall of that page(carried forwards) and on the next page the same amount in the header (brought forward) and also the same function on the next pages. (for testing I also print the...

hi I've a vertical line that i want to suppress with a condition. Unfortunately I don't see the condition option by a line. When I use an empty textbox, all the other text is moved down. Is there conditional another suppress option for a line? Dan

Hello I’ve 3 sections of footer text. A and B are conditional and will only be printed on the last page, C will be print on every page. When I print the report, only the last page shows how I mean to. On the earlier pages B and C are suppressed like I want it, but C is printed on the place of...