Crystal Reports - How To Display Text Block Stored In Blob Field.

URGENT: Crystal Reports And BLOB Field.
Hi guys,

its little urgent!

i wish to embedd a blob field which stores a picture in my crystal report in detail-tab. somehow its not been displayed... kindly help me for this problem.

well, all i have done is ... set up the connection for the report, and put the picture field on the report in detail tab.

plz helpppppppppppppppppppppppp

butterfly.

Daring ideas are like chessmen moved forward. They may be beaten, but they may start a winning game.

---

Print A Formatted RTF Stored In A BLOB Field
Hi:
I have a formatted RTF text stored in a BLOB field in an Access 2000database and i need to print the entire record in a report like Crystalreports o Data report in VB6 but this kind of report generator do notallow to print this especific data type, RTF stored in a BLOB, (oryes?), , someone knows is exists a report generator that print thistype of fields or a proceedure or function that does it.



Thanks

Schiaroli Diego
Medife SA

---

Text Field Does Not Display For Crystal Report After Saving It To A File
In my VB 6 code I do the following to a text field on my report.


VB Code:
CigUnitRpt.Text2.SetText "From " & Trim(Main.DTPicker1.Value) & "  to  " & Trim(Main.DTPicker2.Value)


After the report is created in vb, I save the report to a file like this.


VB Code:
Report.SaveAs "C:CigUnits.rpt", cr80FileFormat


When I open the file I created, this text field shows nothing in it even though I know there is data placed in the field.

Anyone know why this is happening and how to get around this problem?

Thanks

---

ASP To Output Text In Access Blob Field Containing RTF Tagged Text
Can you tell me what I am doing wrong?

I have a simple asp page that is outputting text from a blob field in an access database. The output on the site looks like this:

{
tf1ansiansicpg1252deff0{fonttbl{f0fnilfcharset0 Arial;}} {*generator Riched20 5.50.99.2010;}viewkind4uc1pardfs20lang1033 ADE participated in the formulation of the Village Support Program (VSP) which seeks to improve the living conditions of Guinea s rural population by increasing access to basic infrastructure and services in a more efficient and sustainable way. A major instrument to achieve this objective will be the decentralisation of decision-making, resources and responsibilities at the community level. The program will strengthen fiscal, administrative, and political decentralisation, and, thereby, reinforce the capacity of the Communaut e9s Rurales de Developpement (CRDs) and other local institutions to design, implement, finance, operate and maintain priority rural infrastructure. It will also develop the capacity of villages to play an active role in the operation, maintenance and management of the newly established infrastructure. The program will be demand-driven and use matching grants to fund priority investments identified by local communities. The Project, as the first phase of the longer term program, would be limited in scope and support a limited range of infrastructure investments to help simplify planning, execution and technical backstopping. By adopting a flexible implementation strategy it would, in turn, allow new approaches to be tested, new systems/procedures to be developed and the necessary people to be trained. The M&E expert provided by ADE was to design an M&E system taking into account these features and define indicators and triggers accordingly. A logical framework was drawn up. The institutional set-up, staffing and costs of the system were determined for the first phase of the project. par }

Obviously I want it to output the formatted text not the rtf tags as well? Do I need to configure my IIS to support rtf text? Do I need an ocx? Or do I need to handle the output in asp differently than as now with a normal response.write?

//The functions to open a new window with the info of a project is:

var childEYPWindow

function openEYPtWindow (url)
{
    if (childEYPWindow)
                childEYPWindow.close()
    childEYPWindow = window.open (url,"EYP","dependent,width=450,height=550,toolbar=no,resizable=no,titlebar=no,status=no,scrollbars,left=0,top=0");
}

function closeEYPtWindow()
{
    if (childEYPWindow)
                childEYPWindow.close()
}

function openr(code)
{
    url = "Company_eypExt.asp?Field=" + document.forms[0].elements['Field'].value + "&Service=" + document.forms[0].elements['Service'].value + "&Region=" + document.forms[0].elements['Region'].value + "&Number_A=" + code
    openEYPtWindow (url)
}

//The SQL selection:

sql = "select Number_A, Title, [Long Description], Country, [Begin Date], [End Date], [Field of Expertise], Client from AdeMaster " & _
            "where (IsDate([End Date])) and (InStr([services],  '" & Service & "') > 0 and  " & _
                "InStr([Field of Expertise],  '" & Field & "' ) > 0)"

//The blob field that contains rtf tags is
[Long Description]

So how to I show the formatted text correctly, now is a mess  each window that opens show as you could see above the rtf tags in it.

Highly appretiate if someone can explain what went wrong here...

THanks in advance guys

---

Saving And Retrieving Text From A Blob Field In MYSQL.
I'm trying to learn how to save and retrieve text to and from a blob field in mysql. I've seen tutorials on how to save an image file into a blob field, but I haven't seen one for saving and retrieving text.

The reason I'm trying to do this is because I'm switching my database from Access to mysql and I need to move text from a memo field into a field of a similar type, but mysql doesn't have a memo type. I'm assuming that the blob fields are mysql's equivalent to Access' memo field.

Does anyone know how to accomplish this task?

---

In Crystal Reports, How To Display Financial Reports (P & L, Balance Sheet Etc.) In Columnar Format
Dear All,

I am developing a Financial application using VB6, MS-Access & Crystal Reports 8.5. I am facing problems in certain reports. Some of the reports like Profit & Loss and Balance Sheet require the output to be printed in columnar format.

I have tried giving subreports for each section, i.e.; Assets & Liabilities, but then, the output is not coming in order as per the groups. The problem is even more where there are sub-sections in the right side column & left side column for example in Profit & Loss, where there are sub-sections for Gross Profit/Loss and Net Profit/Loss. In such cases, how to bring the total amount fields at the same horizontal level.
I hope someone can help me how to do the above.

Thanks in advance.

Best Regards
Mahesh

---

Crystal Reports: Highlight Field Based On Value Of Other Field
Is this possible in Crystal Reports? I'd like to colour the values in {ado.NetWt} red where the value in {ado.LBound} > 0....a forecolor property or something?

---

Stored Procedure With Crystal Reports
I have found it very hard to find any information using sql server stored procedure and using them for crystal reports.

When I connect to my sql server via the crystal reports interface it logs me in fine and I can view the fields.

When I go to run the report it forgets my connection string and say unable to open report server not opened or login failed for user.

Anyone help me on this its driving me MAD! Cant find any help out there!

---

Stored Procedures & Crystal Reports
I've created a report in Crystal Reports that runs off of a stored procedure with a parameter on the SQL server. From my Vb app, how can I pass the parameter to stored procedure and bring up the report? Any help would be greatly appreciated.

---

Crystal Reports And Stored Procedures
I'm using VB 6.0, Crystal Reports 8.5, and SQL Server 7.

I use Active Data Source to pass an RDO recordset to an existing Crystal Report that was created using a ttx file. When the recordset is created from a SQL statement hardcoded into my VB program, the Report will load like it should. When I place the exact same query into a stored procedure, I get Error 20527: SQL Server Error. The thing that baffled me about this error is that I designed my program and the Crystal Reports so that Crystal will never connect to the database. The database query is done through my VB program and the recordset is passed to Crystal.

Upon further investigation, I discovered that the error only occurs if the Stored Procedure contains an IF statment or a CASE statement. If I use ADO, I don't have this problem. The problem is that I have get working with RDO since it's not possible at this time to migrate to ADO.

I have searched Google, CodeGuru, and Crystal's knowledge base using every combination of words I could think of. I can't find any information in regards to this. I have also posted numerous times on this board and on other boards hoping someone could shed some light on this. I finally called Crystal directly, but have heard nothing back from them yet. If anyone has any sort of suggestion, or website I could visit, I would be forever grateful to you!

---

Crystal Reports Using SQL Stored Procedure Trouble
I am having so much trouble sending a value to my crystal report.

my crystal report is set up to use
pdssql.dll driver

so in my script I send

Code:
CrystalReport1.LogOnServer "pdssql.dll", "APTSQL", "AMS", "USER", "XXX"
that works fine, I think as least.

but report runs off over a stored procedure
my stored proocedure ask for one parameter
nvarchar(12)

But I tried everything I know to get my report to update my report with my parameter, but nothing.

In vb I am using ActiveX control.

This is what I tried:

Code:

Dim myddu as string

myddu = cstr("000047")

CrystalReport1.StoredProcParam(0) = "@DDU;" & myDDU & ";TRUE"
CrystalReport1.StoredProcParam(0) = "@DDU;000047;TRUE"

CrystalReport1.SQLQuery = "spClientsByDDU '000047'"

CrystalReport1.ParameterFields(0) = "@DDU;" & myDDU & ";TRUE"
CrystalReport1.ParameterFields(0) = "@DDU;"000047";TRUE"
I also tried it with 1's instead of 0's

please help me

Thanks

he9ap00

---

Passing Stored Procedures To Crystal Reports
I need some help passing an ADO recordset to a Crystal Report.
I would eventually just like to send a stored procedure. If someone could show me an example of this, it would be greatly appreciated

---

Crystal Reports With Sqlserver Stored Procedures Using Paramater
Crystal reports with Sqlserver stored procedures using Paramater ...?

---

How To Call Sql Server Stored Procedure In Crystal Reports
Please given the Method for calling stored procedure in Crystal Reports.

I'm simply using sql server stored procedure,
through Crystal reports we pass the parameter of that st. procedure.

Thankx if you r trying.





Edited by - unique_jai on 8/20/2004 6:50:42 AM

---

VB6 And Crystal Reports 9 Caches Results From Stored Procedure
I have a VB6 application which has several Crystal Reports in it which call Stored Procedures in one of our SQL Server 2000 databases. Functionally it all looks fine except for the fact that after the first time any report is requested the resulting report is exactly the same as the first, regardless of what changes may have occured to the database in the meantime. This "caching" of the report results will even occur across multiple executions of the VB program which calls the report.

How do I get Crystal Reports to update the report to contain current information?


The report for is loaded by the following code:
[vb]
Private Sub Form_Load()
    Dim CRXParamDefs As CRAXDRT.ParameterFieldDefinitions
    Dim CRXParamDef As CRAXDRT.ParameterFieldDefinition
    Report.DiscardSavedData
    Set CRXParamDefs = Report.ParameterFields
    For Each CRXParamDef In CRXParamDefs
        With CRXParamDef
            Select Case .ParameterFieldName
                Case "@ptrProject"
                    .SetCurrentValue ptrProject
            End Select
        End With
    Next
    Report.EnableParameterPrompting = False
    Me.Icon = Data_Access.Icon
    Height = 0.75 * Screen.Height
    Width = 0.8 * Screen.Width
    Move (Screen.Width - Width) / 2, (Screen.Height - Height) / 2
    Screen.MousePointer = vbHourglass
    CRViewer91.ReportSource = Report
    CRViewer91.Refresh
    CRViewer91.ViewReport
    Screen.MousePointer = vbDefault
End Sub
[/vb]

Why doesn't the line Report.DiscardSavedData or the line CRViewer91.Refresh take care of this problem? And since they don't fix this problem, what are they supposed to do?

---

Need To Export SQL Data To XML File. 1 Field Is A BLOB (binary Field)
I'm a VB/SQL newb looking for some help on exporting records from the DB to an XML file. one of the challenges is that i have one field that is a Binary datatype (BOLB). i need to export that data out and convert it from its Binary state to readable text and save it to an XML file. Can some help me with this?


i will need to be able to specify how the XML file is laid so i can designate the tag names to be compatible with my web software.

Sample code, small projects...anything would be great.

Thanks
GK

---

Error-handling For Stored Procedure Executed By Crystal Reports
Note: I am posting this in both the General and Database forums.


When I ran my Crystal Report (the source of the data is a SQL Server stored proc) out of VB, I get no results.

OK, to see what's going on, I ran the query in SQL Server analyzer, and lo and behold, there is a bug in the s.p. that causes the s.p. from completing (turns out a division by zero error was occurring in some cases). But this is not a problem, I can fix it.

The problem/question is that in the VB Sub that is executing my Crystal Report, there is an error-handler, so I would expect an error to be thrown if Crystal had a problem running the report. But no error is thrown; the report runs and produces 0 records (no output).

How do I get the error to be thrown by VB?

---

My Problem Is Stored Procedures In Crystal Reports Which Has Input Parameters
My problem is stored procedures in crystal reports which has input parameters ...?

---

The Field Is Not Known With Crystal Reports 10
I have integrated a crystal report (v10) vs visual basic.
My report has one subreport... I have linked this one with the report main. The first time I execute the report is ok. All information attached is displayed sucessfully. However, if I execute it again with the same or different data (filter with combo boxes) crystal reports shows me the next error: 'The field is not known' associated with CRViewer1.ViewReport method
Do you have any idea about this error?
Any suggestion will be appreciated.
Thanks

---

Crystal Reports - Error 20533 - Invalid Stored Procedure Parameter
I'm using Crystal Reports (ver 4) and VB6

Using the crystal custom control(CCC) I pass parameters to a stored procedure and then print the report. This works fine until ...

I send 5 parameters to stored procedure A
then I send say 3 parameters to stored procedure B.

As soon as I send less parameters as with my previous call (to a different stored procedure) I get the error message:

Runtime error 20533
-Invalid Stored Procedure Parameter-

So it seems to me that VB is trying to send 5 parameters to a 3 parameter stored procedure.

Is there a reset command for the CCC?

So here's 2 of the procedures I use.....
Private Sub Print_Letter_Occupancy(Par1, Par2, Par3, Par4, Par5)


With Crystal 'This is the crystalReport control
.ReportFileName = ""
.ReportFileName = App.Path & "Letter_Occupancy.rpt"
.StoredProcParam(0) = Par1
.StoredProcParam(1) = Par2
.StoredProcParam(2) = Par3
.StoredProcParam(3) = Par4
.StoredProcParam(4) = Par5

.Connect = "DSN = database1;UID = 12;PWD = 1234"
.Destination = crptToWindow
.Action = 1
End With
Crystal.ReportFileName = ""
End Sub


Private Sub Print_Letter_TowerCrane(Par1, Par2, Par3)


With Crystal
.ReportFileName = ""
.ReportFileName = App.Path & "Letter_towerCrane.rpt"
.StoredProcParam(0) = Par1
.StoredProcParam(1) = Par2
.StoredProcParam(2) = Par3
.StoredProcParam(3) = Par4
.StoredProcParam(4) = Par5


.Connect = "DSN = database1;UID = 12;PWD = 1234"
.Destination = crptToWindow
.Action = 1
End With
Crystal.ReportFileName = ""
End Sub

---

Crystal Reports Formula Field
Hi
I got a database column which has number values like
480, 495 , 615, 630
which is equivalent to
480 = 8am (which is like 480/60=8)
495 = 8.15am
615 = 10.00am
630 = 10.15 am
i get this values from ctDEdit control, which gives numbers for time.
Now i have to show this number values as time in crystal reports. so i thought of having a formula field.
its easy to get hours and minutes from this number:
its goes like this
(615/60)=10.25
so 10 is hours
(25*60)=1500, here 15 is minutes.
can any one please help me to do this in a formula field, ie to show the time as 10.15am for number 615.
i hope im clear.
thanks
kumaarrv

---

Crystal Reports Field Suppression
How do you check whether a field is suppressed or not in the formula editor?

---

Hide Field With Crystal Reports
How do I do if I want to hide a specific field in a report.
I'm going to use my own parameterized queries so I will be able to send boolean values to the report from the application during run-time.

The problem is how to design the report.
Do I have to group that specific field to able to hide it in the report?

---

Crystal Reports, Hide A Field
Hi, How can I hide a field in crystal reports 8.0 to print it only in the last page of the report, is there a way to do it without using sections?

Thanks

---

Long Field In Crystal Reports
I have a string selected from a database table, and it can get really long.
Is there any way to automatically wrap the string once it exceeds certain length?

Can anybody help?

---

Crystal Reports - Null Field
Im using the crystal reports wizard to connect to an access database. Currently the report is returing everything in my access table.

I only want it to return items with a NULL value in my field called "DATE".

Therefore IF my field called "date" has a NULL value then i want to see these records.

Does anyone know how to do this within the crystal report wizard??

---

Using The Parameter Field In Crystal Reports
I know how to use the parameter function in Crystal but how do I place the parameters entered on the report. I've tried pulling the parameter expression on the report but when the report is run and parameters are entered the field on the report is blank.

---

Crystal Reports Date/Field
I am currently using a Crystal Report (8.0) which has ADO connection to MS Access 97 database.

I have a Date/Time field (Short format) in my database which contains the date/time 1/23/03 10:43:45 AM. For some reason the Crystal report shows this as being PM not AM.

Is it because I am using a short date? Anyone...

---

Max Field Size In Crystal Reports
does Crystal Reports impose a maximum field size? I have a Comments field that holds 500 chars but the report only shows 256 characters.

help.

thanks in advance.

---

Date Field - Crystal Reports
I have a report in Crystal Reports which works fine, except in a PC. In that machine the report prints well, except the date fields that appeared in an empty way. I've worked with Regional Settings, fonts, pass the date to string, but the report doesn't work.

Have you experienced something similar? Have you any suggestion I could follow in order to solve the problem?

Thanks in advance!

---

Setting Field Value In Crystal Reports
Hi,
I am using a crystal repirt designer (crystal 8) in VB6 - the ICRDesigner. I have placed fields in the Details section of the report designer (a part of the VB application) but I want to assign values to these fields at runtime. Does anyone know the syntax for this. I have used

CrystalReport1.Field1.Value = rsScotiaParameter!LetterDate

but I get an error ...

please help.

---

Field Formatting In Crystal Reports
I have a field in a table (used in my report) that is "010422". It is a date.. but saved as a string. How do I convert this to look like: "01/04/22" on my report.
Same with time .. I have 140232.. and i want it to look like 14:02:32.

sa

---

Crystal Reports 4.6 - Field Justification
Hi friends,

How can I justify a text or memo field on a Crystal report ?

Thanks for any help,
Fernando.

---

OLE Object Field To Crystal Reports
Hello,

I have the Image(OLE Object field ) sitting in access 97 table, and I am using crystal reports to print out the Image.

I am linking the crystal reports to the table by the normal way(normal text field way) and it doesn't seem to work. Beacuse of OLE Object field, I wonder if there is special way to deal with it.


Thank you very much.

---

Crystal Reports Field Suppression
Hi all - in my report, the details section can show up to 8 fields. The fields are aligned atop each other, like so:

field1
field2
field3
field4
field5
field6
field7
field8

I suppress the fields if they are null. The problem is that the report appears very disorganized and has too much white space. I need to be able to modify the positions of the fields so that they appear consecutively. Example: if fields 2 and 5 are suppressed, I want the report's details section to show like this:

field1
field3
field4
field6
field7
field8

but instead it comes out like this:

field1

field3
field4

field6
field7
field8

and the spaces make it look horrible! How to fix this?

---

Autoincrement Field In Crystal Reports
i want a auto increment filed in crystal report
for ex in innoice
the format
no product
1 dwe
2 dww

the values for no filed are auto generated and for each invoice it should start from 1

---

Crystal Reports-field Object-
i hope to modify a file (*.rpt)-crystal reports V8.5-,I can change the textObject and the fieldobject , but if this textobject contain a fieldobject i can't read this field???
ex:
la date [?du] a [?au]->text object contain fields
then program return:la date[] a []
and i can't read {?du} {?au}!!!

---

Date Display In Crystal Reports
I havbe a report that needs to display fields from a database. While other fields display the date fields just show blank. Has any one a solution to this starnge beviour. I have check the date field actually has dates in the database for display

---

Display Crystal Reports *.rpt File
is it possible to display a crystal reports *.rpt file using the crystal reports activex control? i'd like to have the reports external to my app, cos there's quite a lot of them. failing that, would it be a good idea to have them all in a DLL?

---

Crystal Reports-Multiple Values For One Field
I have a VB6 program that contains a form that allows the user to select 3 different criteria. These criteria in turn are used by the program to pass an sql statement to the crystal report 7 object within the vb program.
The problem I am having is that I need to pull data from two different tables within the same Access database. The first table is the main table with information on machines (i.e. IPAddress, name, location, repairtime etc). The second table is linked via a generic ID number field, and contains the names of the maintenance personnel who repaired the machine. In some cases, there are several people working on one machine. I am currently using the sql statements to pull information from an Access query that combines the two tables. The problem is that if there is more than one maintenance person who repaired the machine, the query will list that record several times.
Any suggestions on how to get around this? I want all of the names to show on the report for any given ID number.

---

Not Able To Sum The Field In Crystal Reports 9 Formula Editor
Friends,

The below formula is not working. Please point me where iam making mistake.

=========================================
whileprintingrecords;
global numbervar tottrd;
numbervar cnttottrd;
if
(
{Admin.OTC}="001"
or
{Admin.COEN} in
["Chargeable Labour + Chargable Spares",
"Chargeable Labour + Free Spares",
"Chargeable Spares + Free Labour"]
)
then
cnttottrd := {PAYMENTS.PAIDAMT}
else
cnttottrd := 0;
tottrd := tottrd + cnttottrd

=========================================

if i change
cnttottrd := {PAYMENTS.PAIDAMT}
to
cnttottrd := 1
then its working.......

Please treat this as urgent.

Thanks & Regards
Sathyguy

---

Crystal Reports - Sorting A Formula Field
Hi,

I've got a formula field on my report: -


Code:
//@SumQty
Sum({SALES_VIEW.SUM_QTY}, {SALES_VIEW.AR_DESCRIPTION})
I want to sort the report using this field, but can't seem to find a way.

Is it possible to do this?

Regards

---

Word Wrap On Field In Vb Crystal Reports 8.5
Hi,
I'm very new to vb crystal reports 8.5 and have to generate a mailing label report where in I need to word wrap on the fields as it is creating spaces if either the database field is null and does not word wrap.

Also give some links to learn and explore vb crstal reports 8.5

Thanks a million....in advance

---

Using A Memo Field In An Expression In Crystal Reports
I need to use a memo field in an expression in a crystal report, but can't. I know there is some problem with memo fields, but how can I get around this?

---

Using A Parameter Field In Crystal Reports - Very Easy One
I am new to Crystal Reports. I need to filter a query
with a where clause. I guess I need to insert a
parameter field here. I've tried but failed a couple
of times to get that thing to use. Can someone here
walk me through the process of successfully creating
and using a parameter field in Crystal Reports. To
make it easier, let me imagine a situation where I
have a table called [My Friends] and I need to
retrieve all the friends of mine who stay in Delhi. So
I need a query something like:

select * from [My Friends] where [City] = 'Delhi'

Now I create a simple report using the Report Expert
where I select one table [My Friends] and all the
fields and I have the report in front of me, showing
all my friends and their addresses, wherever they
live. Now, I need to place this filter. Please take it
from here.

Sathyaish Chakravarthy

---

Find Field Parameters In Crystal Reports Using VB
I have a query that returns 800 reports and I want to find the fields associated with each of those reports. How should I go about coding this into vb?

Set return = store.query("SELECT SI_NAME, SI_ID, SI_FILEs, SI_PROGID FROM CI_InfoObjects WHERE (SI_PROGID = 'crystalenterprise.report')")

if return.count > 0 then
For each item in return
        objexcel.cells(i, 1).value = item.id
        objexcel.cells(i, 2).value = item.title

I have returned the ID and Title, so now how do i get every field? Please Help!

---

Extension Of Details Field In Crystal Reports
hai hai hai every one

hope u all r fine

im back here to eat ur heads

ok im asking a solution from u all as

how to extend the details section of crystal reports? the problem does not ends here as i want to place a footer message in the footer section of reports. so now my problem is that footer runs for all the pages. but i wanted it ti be displayed for only the last page if the report is more then a single page.

hope u can help me

thanks

nithi

with regards Nithi

There are no such things as applied sciences, only applications of science.
  - Louis Pasteur

---

Not Able To Sum The Field In Crystal Reports 9 Formula Editor
Friends,

The below formula is not working. Please point me where iam making mistake.

=========================================
whileprintingrecords;
global numbervar tottrd;
numbervar cnttottrd;
if
(
{Admin.OTC}="001"
or
{Admin.COEN} in
["Chargeable Labour + Chargable Spares",
"Chargeable Labour + Free Spares",
"Chargeable Spares + Free Labour"]
)
then
cnttottrd := {PAYMENTS.PAIDAMT}
else
cnttottrd := 0;
tottrd := tottrd + cnttottrd

=========================================

if i change
cnttottrd := {PAYMENTS.PAIDAMT}
to
cnttottrd := 1
then its working.......

Please treat this as urgent.

Thanks & Regards
Sathyguy

---

How To Creating Hyperlink In Crystal Reports On A Field
Hi everybody,

I have a problem regarding crystal report i have to tables tblMailInfo and tblAttachments.
I have designed a main report selecting fields from tblMailInfo, the problem is that i want to create a hyperlink
on the MailID field so that when i click this field a new report opens displaying the attachements for that MailID from tblAttachments
Please help me in this problem with code if any one have.

---