Angular 6 reporting කරන්නේ කොහොමද?-ලොකු උදව්වක්

[saja]

Angular 6 reporting කරන්නේ කොහොමද?-ලොකු උදව්වක්

බරපතල reports හදන්න වෙලා Angular 6 වලින් , Angular ලොකු knowledge එකක් නැ , Crystal reports කොහොමද view කරන්නේ Angular 6 වලින් (sample code තියෙනවා නම් දෙන්න please ) , එහෙම බැරි නම් sample code එකෙක් දෙන්න please ලොකු උදව්වක් ,web url උනත් කමක් නැ sample code තියෙන

අපි Visual Studio code එක editor එක විදිහට පාවිචි කරන්නේ

rep දෙන්නම් support එකට

ලොකු උදව්වක්

 

[හෙනයා]

crystal reports export කරන්න පුලුවන් නේද pdf, xls වගෙ format වලට.. API එකකින් ඒවා expose කරලා angular වලින් view කරන්න

https://dzone.com/articles/learn-mvc-using-angularjs-and-crystal-report

 

[saja]

අපි Visual Studio code එක editor එක විදිහට පාවිචි කරන්නේ
type script code karanne , meka hari yanne na ne

crystal reports export කරන්න පුලුවන් නේද pdf, xls වගෙ format වලට.. API එකකින් ඒවා expose කරලා angular වලින් view කරන්න

https://dzone.com/articles/learn-mvc-using-angularjs-and-crystal-report

 

[saja]

rep දුන්න ඔක්කොමටම

 

[saja]

support ඕනේ please help

 

[හෙනයා]

අපි Visual Studio code එක editor එක විදිහට පාවිචි කරන්නේ
type script code karanne , meka hari yanne na ne

oya JS වලින් තියෙන්නෙ.. අලුත් එකේ responseType එක blob වලින් දාල ගන්න

 

[dilduda]

Kendo aran denna kiyapan lokkata

 

[terminator.101]

developer bump

 

[saja]

free trial na da ban sample ekak dekak hadala penna na

link ekak tiyenawa nam denna sample wala

rep +

Kendo aran denna kiyapan lokkata

 

[හෙළයෙක්]

Monawage reportsda thiyene. mehema wedak karana puluwan html walin hadala eka pdf render karanath pujluwan pdf2js walin. ehema nathan serverside report gen karala eka pdf viwer ekaka penanath puluwan. hodama widiya thama 2nd option eka.

 

[saja]

html tikkak time yanawa , 2 nd option tutorial ekak denna plz
rep +

Monawage reportsda thiyene. mehema wedak karana puluwan html walin hadala eka pdf render karanath pujluwan pdf2js walin. ehema nathan serverside report gen karala eka pdf viwer ekaka penanath puluwan. hodama widiya thama 2nd option eka.

 

[HAneo]

Reporting Angular

බරපතල reports හදන්න වෙලා Angular 6 වලින් , Angular ලොකු knowledge එකක් නැ , Crystal reports කොහොමද view කරන්නේ Angular 6 වලින් (sample code තියෙනවා නම් දෙන්න please ) , එහෙම බැරි නම් sample code එකෙක් දෙන්න please ලොකු උදව්වක් ,web url උනත් කමක් නැ sample code තියෙන

අපි Visual Studio code එක editor එක විදිහට පාවිචි කරන්නේ

rep දෙන්නම් support එකට

ලොකු උදව්වක්

Ok okata thiyana wisadum tika meka....

1. Forget about crystal reports. you cannot use crystal reports any way inside a angular application. Uba Stackoverflow eke hoyanna athi ne. wadak na wast of time.

2. ubata one karana report eka Pdf walata harawala download karaganna denna. (we are talking about we here. not a desktop application. any thing not compatible to web we cannot render it inside any kind of web app)

3. Crystal report web ekata denne nathi case eka thama .. IIS sever eke Pool eka block wenawa. Crystal report Web version ekath fail. ayi ISS reset karala ganna one . IIS Reset. ehema reset kalama log wela inna users la seragema Cache clear wenawa auto. so they must have to start from beginning.

4. Okata solution eka SSRS reporting tool. eka SQL server ekata separate ship wenne. so oyata wenamama setup karaganna wenawa. eka independent server ekak widihata wada karanne. Report hama ekama URL widihata denne
EX: Server URL: http://localhost:49858/lbFinanceSSRSStack/Reports
Report Name: MothlyCumilativebalance.rdl

ithin wade harima lesiyi. oyage Angular project ekata me Component eka daganna

ngx-ssrs-reportviewer

Link eke example eka thiyanawa. patta lesi balan karanna

PS:SSRS setup karana eka poddak amaruyi. Help ekak one nam PM ekak dapan

 

[Thilantdm]

Monawage reportsda thiyene. mehema wedak karana puluwan html walin hadala eka pdf render karanath pujluwan pdf2js walin. ehema nathan serverside report gen karala eka pdf viwer ekaka penanath puluwan. hodama widiya thama 2nd option eka.

ow me deka thiyenne.
server side seen eke nm wenama service ekakin report eka generate krnna thiynne.

html seen eka time ynne na.

example - ticket booking ekak kiyamu.eka e widiya html page eka haduwa nm ganata.eken krnna pluwan.

blpn thawa angular plugin ehema nadda kiyla.

 

[Thilantdm]

Ok okata thiyana wisadum tika meka....



3. Crystal report web ekata denne nathi case eka thama .. IIS sever eke Pool eka block wenawa. Crystal report Web version ekath fail. ayi ISS reset karala ganna one . IIS Reset. ehema reset kalama log wela inna users la seragema Cache clear wenawa auto. so they must have to start from beginning.

crystal report web eke ohoma wenwada bn

ape kln company eke kara ginnak nathuwa wadane web eke.

 

[HAneo]

crystal report web eke ohoma wenwada bn

ape kln company eke kara ginnak nathuwa wadane web eke.

Yes We are tested on Production deploy on LB Finance and Soft logic Finance. Count eka kiyann aba . kohomath 11 withara wenakota report 2000 k withara wadinawa . atleast 10 concurrent reports . eka parama URL not found Error eka enawa. later investigation shows it's because of IIS being unable to handle that load and must be restarted

 

[Master malli]

Bmp

 

[saja]

back end eka SAP HANA db
SSRS puluwanda HANA connect karanna ? ODBC ?

Ok okata thiyana wisadum tika meka....

1. Forget about crystal reports. you cannot use crystal reports any way inside a angular application. Uba Stackoverflow eke hoyanna athi ne. wadak na wast of time.

2. ubata one karana report eka Pdf walata harawala download karaganna denna. (we are talking about we here. not a desktop application. any thing not compatible to web we cannot render it inside any kind of web app)

3. Crystal report web ekata denne nathi case eka thama .. IIS sever eke Pool eka block wenawa. Crystal report Web version ekath fail. ayi ISS reset karala ganna one . IIS Reset. ehema reset kalama log wela inna users la seragema Cache clear wenawa auto. so they must have to start from beginning.

4. Okata solution eka SSRS reporting tool. eka SQL server ekata separate ship wenne. so oyata wenamama setup karaganna wenawa. eka independent server ekak widihata wada karanne. Report hama ekama URL widihata denne
EX: Server URL: http://localhost:49858/lbFinanceSSRSStack/Reports
Report Name: MothlyCumilativebalance.rdl

ithin wade harima lesiyi. oyage Angular project ekata me Component eka daganna

ngx-ssrs-reportviewer

Link eke example eka thiyanawa. patta lesi balan karanna

PS:SSRS setup karana eka poddak amaruyi. Help ekak one nam PM ekak dapan

 

[saja]

searching

 

[HAneo]

back end eka SAP HANA db
SSRS puluwanda HANA connect karanna ? ODBC ?

I didn't know that you were using hana dude.
SSRS - SQL Server Reporting Services just for SQL server.
one of my client were using hana and he refuse to move to another DB.
So what i did was , when i need to generate report i get data from hana and put it in SQL server. all the schema's are redefined and match one to one. then i run SSRS from SQl server side using that data and show it in angular side using Ngr report viewer .

Cons:
this will take out the load to main SAP database. cus we copied all the data from SAP to SQL at night time using a job.

also we had a method to compere row count of each mapped table and we sync only if row counts are not same.Also every table we have a column call IsNotSyncedOrChanged (int) it will indicate the sync records of a given table. using that flag we can copy only changed records.

i don't know this will help in your organization cus it's entirely up to Architect to decide this move. but trust me it remove main Sap DB some 60% pressure.

Any thing tell me will help