Search options (Page 32 of 42)

Hi EHW,

These are the steps causing the error message at my end:

Cool stuff EHW..........
Thank you very much for your patience and time...............................................

I see that for image object on Fast Reports, images must be stored in DB not linked.

I think your images provides very valuable information for beginners like me amongst MVD lovers. Therefore, I put together and hot linked your images so that others can see bigger image within allocated forum post width here:

Thank you soooooooooooooooo much EHW.............................
Great stuff...

There are two things I noticed.
1. Couldn't get coLogo image displayed
2. On group footer band you have calculated net, tax and total from master data band.
On my actual project inv totals are calculated on inv form as there are discount and delivery cost calcs for the whole invoice.  What I like to do is to copy already calculated values of
sub total
tax total
gross total
less discount
plus delivery
inv total
fields to group footer or suitable band.

Hi EHW,

Thanks a lot for the info...

I was thinking in practical terms. I agree that multiple companies cannot share same invoice/s but shouldn't they be able to share same customer/s?

SELECT
    Company.coLogo,
    Company.coName,
 Company.coAddress,
 Company.coPhone,
    SaleInv.invDate,
    SaleInv.invCode,
    SaleInv.subTotal,
    SaleInv.taxTotal,
    SaleInv.grossTotal,
    SaleInv.discount,
    SaleInv.delivery,
    SaleInv.InvTotal,
    Customer.name,
    Customer.surname,
    Customer.street,
    Customer.city,
    SaleProduct.name,
    SaleInvItem.Qty,
    SaleInvItem.unitPrice,
    SaleInvItem.netPrice,
    SaleInvItem.taxAmt,
    SaleInvItem.totalAmt
FROM
    SaleInv
INNER JOIN Customer ON Customer.id = SaleInv.id_Customer,
 SaleProduct
INNER JOIN SaleInvItem ON SaleInvItem.id_SaleInv = SaleInv.id
    AND SaleProduct.id = SaleInvItem.id_SaleProduct
INNER JOIN Company ON Customer.id_Company = Company.id
WHERE SaleInv.invCode = '{edSaleInvCode}'
INNER JOIN Company ON SaleInv.id_Company =Company.id
WHERE SaleInv.invCode = '{edSaleInvCode}'

The above produces syntax error.
If I add semicolon after customer lines like below it doesn't produce error but it doesn't display correct company on report preview. I'm thinking script lines I added are wrong.

FROM
    SaleInv
INNER JOIN Customer ON Customer.id = SaleInv.id_Customer,
 SaleProduct
INNER JOIN SaleInvItem ON SaleInvItem.id_SaleInv = SaleInv.id
    AND SaleProduct.id = SaleInvItem.id_SaleProduct
INNER JOIN Company ON Customer.id_Company = Company.id
WHERE SaleInv.invCode = '{edSaleInvCode}';  
INNER JOIN Company ON SaleInv.id_Company =Company.id
WHERE SaleInv.invCode = '{edSaleInvCode}'

Sample project attached:

The following refers to Report designer.

I delve into report designer... I must say it's one of those awkward app to learn... It seems to me that they took approach of showing left ear with right hand.

I needed to use two data levels - master/details.
In FR help, it states "In the report designer, enable the data sources in the “Report>Data...” dialogue." However, I cannot find it. If MVD report designer is a different version and doesn't have this feature, is there a work around?

I like to insert inv item details into master band and inv totals into details band that details band doesn't repeat after every master band data lines.

Edit:
-----------------------
One solution I found is that just using header for names labels, master data band for inv items data and inserting inv totals below master data band on the page. Visually (preview) it seems ok. However, I'm not sure if it's right way to do tho.

No, I get file path instead of image itself

Images are using "LinkFile" type.
What's causing the issue of not working on my example?
Perhaps there is a workaround...

Hi Math,

Thanks a lot for the generous amount of info....

I have deleted the link from Company and tried the following on ReportSQL but I still couldn't get it working tho

SELECT
Company.coLogo,
Company.coName,
Company.coAddress,
Company.coPhone,
SaleInv.invDate,
SaleInv.invCode,
SaleInv.subTotal,
SaleInv.taxTotal,
SaleInv.grossTotal,
SaleInv.discount,
SaleInv.delivery,
SaleInv.InvTotal,
Customer.name,
Customer.surname,
SaleProduct.name,
SaleInvItem.Qty,
SaleInvItem.unitPrice,
SaleInvItem.netPrice,
SaleInvItem.taxAmt,
SaleInvItem.totalAmt

FROM
Company
INNER JOIN Company ON Company.id = SaleInv.id_Company,

SaleInv
INNER JOIN Customer ON Customer.id = SaleInv.id_Customer,

SaleProduct
INNER JOIN SaleInvItem ON SaleInvItem.id_SaleInv = SaleInv.id
AND SaleProduct.id = SaleInvItem.id_SaleProduct

Not clear on this one.

It's user business-company, where they keep some company info such as tax and company registrations numbers etc beside co logo name address etc to use in reports and prints. i.e. if an invoice printed it'd have user's company logo, address, etc beside what's on inv form. It's not for recording any financial activity. It's mainly getting user company details on reports.

Project is a sample project, you can edit, change as you see fit to make it work.

Hi EHW,

Once again, thank you soooooooooooooooooo much.... Appreciated very much........

Hi Dmitry,

True, it saves...
I was naming the file for instance abcd and when I click on backup database menu item to get save as dialog window, saved abcd file wasn't on the list. However, when I change Save as type combo and choose Any file they are shown on the list with Type as File while files saved with default name type were DB File.
Shouldn't files saved with custom name such as abcd automatically be assigned to DB File type?

Hi EHW,

I see and understand your points. Please see the updated project file attached.

My above explanation from previous post doesn't seems to be clear enough. What I meant is;
If user clicks on "Backup the database file" button on form1 without changing backup location on frmBDFSettings application uses default backup settings as on frmBDFSettings and creates backup folder within application folder and backs up into backup folder created.

It'd also be nice to include backup location on "Backup completed" dialog win such as:
"Backup completed.
The File saved to:
D:\Application folder\backup "

-------------------