I am trying to produce a report in a particular folder and a particular title:
'vdatex = CMONTH(var->gdte1)+"-"+ var->gseason
vdatex = "CompetitionResult-"+CMONTH(var->gdte1)+"-"+ var->gseason
query.filter = ""
query.order = ""
' Report.SaveAs("CompetitionResultForNLTB", "pdf", query.filter, query.order, a5.get_path()+"\reports\CompetitionResult.pdf", .F.) this ok is OK
' produces this: CompetitionResult.pdf ok
' I want this CompetitionResult-January-2016-2017.pdf
':Report.SaveAs("CompetitionResultForNLTB", "pdf", query.filter, query.order, a5.get_path()+"\reports\'CompetitionResult'+vdatex.pdf", .F.)
':Report.SaveAs("CompetitionResultForNLTB", "pdf", query.filter, query.order, a5.get_path()+"\reports\'CompetitionResult-'+CMONTH(var->gdte1)+'-'+ var->gseason.pdf", .F.)
':Report.SaveAs("CompetitionResultForNLTB", "pdf", query.filter, query.order, a5.get_path()+"\reports\var->vdatex.pdf", .F.)
':Report.SaveAs("CompetitionResultForNLTB", "pdf", query.filter, query.order, a5.get_path()+"\reports\"var->vdatex".pdf", .F.)
':Report.SaveAs("CompetitionResultForNLTB", "pdf", query.filter, query.order, a5.get_path()+"\reports\\'vdatex\'", .F.)
':Report.SaveAs("CompetitionResultForNLTB", "pdf", query.filter, query.order, a5.get_path()+"\reports\"vdatex"", .F.)
I can do this for data files, but I can not produce a report with formatted file name.
I think I have used all possibilities in working with quotes combinations.
I can not come up with the right code. There must the 101th
'vdatex = CMONTH(var->gdte1)+"-"+ var->gseason
vdatex = "CompetitionResult-"+CMONTH(var->gdte1)+"-"+ var->gseason
query.filter = ""
query.order = ""
' Report.SaveAs("CompetitionResultForNLTB", "pdf", query.filter, query.order, a5.get_path()+"\reports\CompetitionResult.pdf", .F.) this ok is OK
' produces this: CompetitionResult.pdf ok
' I want this CompetitionResult-January-2016-2017.pdf
':Report.SaveAs("CompetitionResultForNLTB", "pdf", query.filter, query.order, a5.get_path()+"\reports\'CompetitionResult'+vdatex.pdf", .F.)
':Report.SaveAs("CompetitionResultForNLTB", "pdf", query.filter, query.order, a5.get_path()+"\reports\'CompetitionResult-'+CMONTH(var->gdte1)+'-'+ var->gseason.pdf", .F.)
':Report.SaveAs("CompetitionResultForNLTB", "pdf", query.filter, query.order, a5.get_path()+"\reports\var->vdatex.pdf", .F.)
':Report.SaveAs("CompetitionResultForNLTB", "pdf", query.filter, query.order, a5.get_path()+"\reports\"var->vdatex".pdf", .F.)
':Report.SaveAs("CompetitionResultForNLTB", "pdf", query.filter, query.order, a5.get_path()+"\reports\\'vdatex\'", .F.)
':Report.SaveAs("CompetitionResultForNLTB", "pdf", query.filter, query.order, a5.get_path()+"\reports\"vdatex"", .F.)
I can do this for data files, but I can not produce a report with formatted file name.
I think I have used all possibilities in working with quotes combinations.
I can not come up with the right code. There must the 101th
Comment