Common questions about 1C:Query language, Query builder tool and Data composition schema

#1
People who like this: 0 Yes / 0 No
Active user
Rating: 2
Joined: Sep 18, 2012
Company:

Hello everyone,
I've got DocumentForm where I created command. Now I want to open report fr om this form with report's parameter filled using Object.Ref of document.
Command button triggers something like this:

Code
&AtClient
Procedure OpenReport(Command)
   Filter = New Structure("Ref",Object.Ref);
   FormParameters = New Structure("GenerateOnOpen, Filter, VariantKey",True,Filter,"Default");
   OpenForm("Report.ZlecenieNaprawyPodsumowanie.ObjectForm",FormParameters,ThisForm,ThisForm);
EndProcedure


The object form of report opens after clicking button but Ref parameter of report has no value, it is not filled. How should I open it so the report knew the value of document Reference? So that user could click button at document and see report data linked with this document?

MainDataCompositionSchema of report has query where is written:
Code
"... WHERE Document.Ref = &Ref"

I just want to see only &Ref data in report after calling command at documents form.
Thank you for any help.
Kris

 
#2
People who like this: 0 Yes / 0 No
Active user
Rating: 2
Joined: Oct 4, 2018
Company:

Hello, Kris!
I think you should use "Report.ZlecenieNaprawyPodsumowanie.Form" instead of "Report.ZlecenieNaprawyPodsumowanie.ObjectForm".

 
Subscribe
Users browsing this topic (guests: 1, registered: 0, hidden: 0)
Be the first to know tips & tricks on business application development!

A confirmation e-mail has been sent to the e-mail address you provided .

Click the link in the e-mail to confirm and activate the subscription.

/* Улучшаем читаемость списков в документации */ .workarea ul, .content ul { margin: 15px 0 20px 25px !important; padding: 0 !important; list-style-type: disc !important; } .workarea li, .content li { margin-bottom: 8px !important; padding-left: 5px !important; line-height: 1.6 !important; } /* Ультимативный фикс для всех уровней заголовков в контенте */ .workarea h1, .workarea h2, .workarea h3, .workarea h4, .workarea h5, .workarea h6, .content h1, .content h2, .content h3, .content h4, .content h5, .content h6, div[id*="content"] h5, div[class*="content"] h5 { display: block !important; font-weight: 700 !important; color: #005aa0 !important; /* Наш фирменный синий */ text-transform: none !important; margin-top: 30px !important; margin-bottom: 15px !important; line-height: 1.2 !important; font-family: Arial, sans-serif !important; } /* Принудительные размеры в пикселях (чтобы не зависеть от % или em) */ .workarea h1, .content h1 { font-size: 28px !important; } .workarea h2, .content h2 { font-size: 24px !important; } .workarea h3, .content h3 { font-size: 21px !important; } .workarea h4, .content h4 { font-size: 19px !important; } .workarea h5, .content h5 { font-size: 18px !important; } /* Для 5 решеток ##### */ .workarea h6, .content h6 { font-size: 16px !important; } /* Фикс, если Битрикс добавил лишние отступы перед списками после заголовка */ .workarea h5 + ul, .content h5 + ul { margin-top: 5px !important; }