SQL SEVER

[agnipra]

Mata data table 3 yana vidiha..natnam relation diagram ekak denna puluvan nam kmanata vade goda dala dennam..mata one data distribute vela tiyana vidiha danagannai...natnam joint karanakota data duplicate venna balavi

 

[Mal Baba]

bump

 

[agnipra]

machan..meka mehema koranna amarui..ubata meka user tak pennanna one kramet kiyapan..

 

[agnipra]

asp.net valanam..grid eka atule grid bind karala pennana puluvan....windows nam venama pennana venne..natnam duplication ekak venava eka grid eke pennuvot...et eka sql eken karanna puluvan LINQ valin

 

[wsvperera]

Mata data table 3 yana vidiha..natnam relation diagram ekak denna puluvan nam kmanata vade goda dala dennam..mata one data distribute vela tiyana vidiha danagannai...natnam joint karanakota data duplicate venna balavi

Ow ban uba dila thiyana details madi ... meka theum ganna

 

[agnipra]

Machan...uba issella mee table 3 aniva bill no tiyana table eka hoya ganin...eke bilno ekata anit table 2 tiyana bil no deka left outer joint ekak dala lin karala query eka ganin..etakota aniva billno tiyana table eke tiyana billno eka anit 2ke natnam evata null evi..left outer joint nisa....habai uba meka datatable ekakata hari object list ekekata hari aran LINQ gahala eka eka table eke data ena vidiha vena venama group karala distinc karala ganin..echcharai danata uba deela tiyana data anuva kiyanna puluvan venne

 

[ad.hasareli]

machan..meka mehema koranna amarui..ubata meka user tak pennanna one kramet kiyapan..

Ow ban uba dila thiyana details madi ... meka theum ganna

machanla mata meka tawa wistara karanna terenne nehe ban..

menna me widihata tamai machan userta penna oni widiha

user select karana billno aken return table ake and rotation table ake value netnam menna me wiidhata display wenna oni

me widihatat wenna puluwan machan

 

[agnipra]

machanla mata meka tawa wistara karanna terenne nehe ban..

menna me widihata tamai machan userta penna oni widiha

user select karana billno aken return table ake and rotation table ake value netnam menna me wiidhata display wenna oni

me widihatat wenna puluwan machan

Yakoo... Tota report ekakda one...okata sub report 3k gahapiya...ivarane...ayoo salliiiiiiiiiiiii

 

[ad.hasareli]

Yakoo... Tota report ekakda one...okata sub report 3k gahapiya...ivarane...ayoo salliiiiiiiiiiiii

sub reprt 3k gahala hari yanne nehe ban....aka report akakin dsply karanna oni ban.... ...

 

[agnipra]

sub report 2k gahapan...sniva bil no tiyana eka main report eke tiyala..sub report 2ka hadanakota...billno eken link karapan...ivaraii..chapter close

 

[agnipra]

machan...ube aniva billno tiyana table eka report ekata adapan...eta passe eke details pennapan...ee report eke idala menu vala tiyanava subreport kiyala option ekak eka click karahama podi window ekak evi..ekata nama dala load from file kiyala option eka natuva anit option eke gihin (new report) kiyala...ekedi ayet DB eka link karala 2veni table eka dapan...eke details pennala ee report eke close karala..mulin vada karapu ekata avit ara dapu sub report eka select karala eke ati link karanna ona vidiha pennanna tanak etanata gihin bill no deka equal karapan

 

[ad.hasareli]

machan...ube aniva billno tiyana table eka report ekata adapan...eta passe eke details pennapan...ee report eke idala menu vala tiyanava subreport kiyala option ekak eka click karahama podi window ekak evi..ekata nama dala load from file kiyala option eka natuva anit option eke gihin (new report) kiyala...ekedi ayet DB eka link karala 2veni table eka dapan...eke details pennala ee report eke close karala..mulin vada karapu ekata avit ara dapu sub report eka select karala eke ati link karanna ona vidiha pennanna tanak etanata gihin bill no deka equal karapan

ane ban aka karanna lesi unata user feasibility aka adui ban.... plz check ur pm

 

[ltty head]

since its with crystal report and stuff i have no idea of the coding way.. but i guess we may need more than a single query to achieve this.

 

[ad.hasareli]

bmp

 

[ltty head]

macho...... qyery 3k liyuwama hari neda bung.. oka podi scene eke neda,.. mata c# echchara danne naha.. php nam mama umbata karala denawa scene eka..

 

[ad.hasareli]

macho...... qyery 3k liyuwama hari neda bung.. oka podi scene eke neda,.. mata c# echchara danne naha.. php nam mama umbata karala denawa scene eka..

ane manda ban....

 

[agnipra]

ane manda ban....

hari uba avada thred ekata??

 

[agnipra]

ubata FB enna puluvanda mama kiyana vade?

 

[smother]

පොඩ්ඩක් හිටපන් මම බලන්නම් තව ටිකකින්..
දැන් පොඩි වැඩක්

 

[ad.hasareli]

පොඩ්ඩක් හිටපන් මම බලන්නම් තව ටිකකින්..
දැන් පොඩි වැඩක්

ane ban balala kiyapan machan loku help akak... moko vb walinma meka karanna puluwan patta slow ban akai seen aka... I3 desktop aketh 8sec witara yanawa ban report aka load wenna....