Search found 10 matches
- Wed Oct 19, 2022 9:48 pm
- Forum: Stimulsoft Reports.WEB
- Topic: Convert Text to Integer
- Replies: 2
- Views: 599
Re: Convert Text to Integer
Update: I've got what I believe to be the formula {((DateDiff(Today, PLDet._Data.Relation.User_Date1) .Days)*(-1))/((Int32.Parse(PLDet._Data.Relation.Relation6.User_Text2))*30)} However; it is giving me a value of 0 which leads me to believe that I've got to convert this to a date afterwards? "...
- Wed Oct 19, 2022 9:09 pm
- Forum: Stimulsoft Reports.WEB
- Topic: Convert Text to Integer
- Replies: 2
- Views: 599
Convert Text to Integer
Hi guys,
Running into an issue with this...I do believe that I am failing to understand how to convert to an integer which is why my formula is failing...can you take a look?
{DateDiff(PLDet._Data.Relation4.Relation3.User_Date2, Today)/ (Int32.PLDet._Data.Relation.Relation6.User_Text2))}
Running into an issue with this...I do believe that I am failing to understand how to convert to an integer which is why my formula is failing...can you take a look?
{DateDiff(PLDet._Data.Relation4.Relation3.User_Date2, Today)/ (Int32.PLDet._Data.Relation.Relation6.User_Text2))}
- Mon Oct 10, 2022 5:21 pm
- Forum: Stimulsoft Reports.JS
- Topic: Expression for Footer
- Replies: 1
- Views: 501
Expression for Footer
Is there a way to write an expression to show a footer? In Crystal I've done this
To suppress I would use: if UCASE({PLMain.CustCode}) = "HYPER" then false else true
To suppress I would use: if UCASE({PLMain.CustCode}) = "HYPER" then false else true
- Mon Oct 10, 2022 2:51 pm
- Forum: Stimulsoft Reports.WEB
- Topic: Converting Crystal to Stimulsoft
- Replies: 10
- Views: 1623
Re: Converting Crystal to Stimulsoft
Lech, made some progress with this: { (DateDiff(Today, PLMain.Relation.User_Date1.AddMonths((int)PLDet.Relation2.User_Text2)).Days )} / {(DateDiff(PLMain.Relation.User_Date1, PLMain.Relation.User_Date1.AddMonths((int)PLDet.Relation2.User_Text2)).Days * 100).ToString() } If I make them into 1 formula...
- Mon Oct 10, 2022 11:44 am
- Forum: Stimulsoft Reports.WEB
- Topic: Converting Crystal to Stimulsoft
- Replies: 10
- Views: 1623
Re: Converting Crystal to Stimulsoft
Lech, this is the error I am getting. "There is no matching overloaded method for 'AddMonths(String)'"
Any ideas?
Currently writing in CSharp
Any ideas?
Currently writing in CSharp
- Sun Oct 09, 2022 3:57 pm
- Forum: Stimulsoft Reports.WEB
- Topic: Converting Crystal to Stimulsoft
- Replies: 10
- Views: 1623
Re: Converting Crystal to Stimulsoft
I will give it a shot. Thank you
- Sat Oct 08, 2022 9:07 pm
- Forum: Stimulsoft Reports.WEB
- Topic: Converting Crystal to Stimulsoft
- Replies: 10
- Views: 1623
Re: Converting Crystal to Stimulsoft
Lech, any chance you could take a whack at this? Aleksey wasn't sure with the DateDiff and DateAdd functions ToText(DateDiff('d',currentdate+0,{DateAdd('m',{ToNumber({Estim.User_Text2})},{OrderDet.User_Date1})}) / (DateDiff('d',{OrderDet.User_Date1},{DateAdd('m',{ToNumber({Estim.User_Text2})},{Order...
- Sat Oct 08, 2022 8:57 pm
- Forum: Stimulsoft Reports.WEB
- Topic: Converting Crystal to Stimulsoft
- Replies: 10
- Views: 1623
Re: Converting Crystal to Stimulsoft
Lech, this works great! Thank you so much!
- Fri Oct 07, 2022 4:24 pm
- Forum: Stimulsoft Reports.WEB
- Topic: Stimulsoft Freelance Work
- Replies: 0
- Views: 4850
Stimulsoft Freelance Work
Does anyone know anyone or is anyone interested in doing some freelance work for some Stimulsoft reports embedded within our Jobboss ERP system?
- Thu Oct 06, 2022 8:36 pm
- Forum: Stimulsoft Reports.WEB
- Topic: Converting Crystal to Stimulsoft
- Replies: 10
- Views: 1623
Converting Crystal to Stimulsoft
We are migrating over to Stimulsoft and I am working on learning the syntax. Could I get some help converting this Crystal Syntax? if {CustCode.CustCode} startswith "L-3" and (today-{OrderDet.User_Date2}) < 180 then "Short Life Material" else if {CustCode.CustCode} startswith &qu...