how to show picture from database in RTC

julkifli33 · **Posted:** Tue Apr 05, 2011 11:28 am

hi all
i'm using NAV 2009 R2
i want to show company logo,which is uploaded through company information
how to show it in RTC reports at the header?
thanks

mohana_cse06 · **Posted:** Tue Apr 05, 2011 11:37 am

Just follow this link :thumbsup:

http://blogs.msdn.com/b/nav-reporting/archive/2009/02/05/how-to-add-a-company-picture-to-a-report.aspx

julkifli33 · **Posted:** Tue Apr 05, 2011 11:59 am

mohana_cse06 wrote:

Just follow this link :thumbsup:

http://blogs.msdn.com/b/nav-reporting/archive/2009/02/05/how-to-add-a-company-picture-to-a-report.aspx

thanks a lot ! $\:D/$

julkifli33 · **Posted:** Wed Jun 15, 2011 5:06 am

mohana_cse06 wrote:

Just follow this link :thumbsup:

http://blogs.msdn.com/b/nav-reporting/archive/2009/02/05/how-to-add-a-company-picture-to-a-report.aspx

i already use all the steps
but why still not working

julkifli33 · **Posted:** Wed Jun 15, 2011 5:13 am

i try to change this code become visible

Code: Select all

=Convert.ToBase64String(Fields!CompanyInfo_Picture.Value)

but the result is #Error

Troubles In Paradise · **Posted:** Wed Jun 15, 2011 10:15 am

julkifli33 wrote:

i try to change this code become visible

Code: Select all

=Convert.ToBase64String(Fields!CompanyInfo_Picture.Value)

but the result is #Error

if it shows "#Error", it means that there's something wrong.
1. Are you sure you've passed the right value to the function Convet.ToBase64String?
2. Did you call CalcFields for Picture field?

julkifli33 · **Posted:** Wed Jun 15, 2011 10:38 am

Troubles In Paradise wrote:

julkifli33 wrote:

i try to change this code become visible

Code: Select all

=Convert.ToBase64String(Fields!CompanyInfo_Picture.Value)

but the result is #Error

if it shows "#Error", it means that there's something wrong.
1. Are you sure you've passed the right value to the function Convet.ToBase64String?
2. Did you call CalcFields for Picture field?

1. in body... i add textbox. and then the expression i add

Code: Select all

=Convert.ToBase64String(Fields!CompanyInfo_Picture.Value)

2. yes... i add in onPreReport

Code: Select all

CompanyInfo.Calcfields(Picture);

for your information Convert.ToBase64String(Fields!CompanyInfo_Picture.Value)
--> the bold one in expression is still red underlined

Troubles In Paradise · **Posted:** Wed Jun 15, 2011 10:45 am

julkifli33 wrote:

[for your information Convert.ToBase64String(Fields!CompanyInfo_Picture.Value)
--> the bold one in expression is still red underlined

This is "normal", also if it will show the picture it will remain red underlined.
Did you try to rewrite code in the textbox that containts convertion? if haven't done yet, try using the assist edit...

julkifli33 · **Posted:** Wed Jun 15, 2011 11:15 am

Troubles In Paradise wrote:

julkifli33 wrote:

[for your information Convert.ToBase64String(Fields!CompanyInfo_Picture.Value)
--> the bold one in expression is still red underlined

This is "normal", also if it will show the picture it will remain red underlined.
Did you try to rewrite code in the textbox that containts convertion? if haven't done yet, try using the assist edit...

yes i did it several times

i attach my steps and result
please take a look
what did i miss?

Troubles In Paradise · **Posted:** Wed Jun 15, 2011 11:24 am

All seems correct.
Could you attach a screenshot of the "About this Report" please?
The idea I have is that DataSet hasn't the value of the Picture field in the moment you do the convertion.

julkifli33 · **Posted:** Wed Jun 15, 2011 11:48 am

Troubles In Paradise wrote:

All seems correct.
Could you attach a screenshot of the "About this Report" please?
The idea I have is that DataSet hasn't the value of the Picture field in the moment you do the convertion.

what do you mean "About This Report" ?
in classic mode it showed the picture
but i added calcfields in section

Troubles In Paradise · **Posted:** Wed Jun 15, 2011 12:01 pm

After have launched the report press CTRL+ALT+F1.
Or use the question mark:

Attachment:

about.png

after this the system will ask you to redo it and then you will see the DataSet.

Quote:

but i added calcfields in section

You said before that you placed calcfields in section... hope not in a section trigger...

julkifli33 · **Posted:** Wed Jun 15, 2011 12:08 pm

Troubles In Paradise wrote:

After have launched the report press CTRL+ALT+F1.
Or use the question mark:

Attachment:

The attachment about.png is no longer available

after this the system will ask you to redo it and then you will see the DataSet.

Quote:

but i added calcfields in section

You said before that you placed calcfields in section... hope not in a section trigger...

yes i know... in section trigger it doesn't affect the RTC
i add calcfields twice
1 in section... (just for testing classic), and another one is in onPreReport

here the attachment for About This Report

Troubles In Paradise · **Posted:** Wed Jun 15, 2011 12:17 pm

This is the problem... As you can see from your screenshot the Companyinfo_Picture hasn't value (otherwise you would see '*' in its column, since it's a BLOB), so when you pass it to convertion function it has nothing to convert.

In which section you placed the Image in classic report?

mihail_kolev · **Posted:** Wed Jun 15, 2011 1:32 pm

and don't forget to call CompanyInfo.GET somewhere before the CALCFIELDS :wink:

mibuso.com

how to show picture from database in RTC

Who is online