Search found 10 matches

by dwabare92
Wed Oct 19, 2022 9:48 pm
Forum: Stimulsoft Reports.WEB
Topic: Convert Text to Integer
Replies: 2
Views: 567

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? "...
by dwabare92
Wed Oct 19, 2022 9:09 pm
Forum: Stimulsoft Reports.WEB
Topic: Convert Text to Integer
Replies: 2
Views: 567

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))}
by dwabare92
Mon Oct 10, 2022 5:21 pm
Forum: Stimulsoft Reports.JS
Topic: Expression for Footer
Replies: 1
Views: 466

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
by dwabare92
Mon Oct 10, 2022 2:51 pm
Forum: Stimulsoft Reports.WEB
Topic: Converting Crystal to Stimulsoft
Replies: 10
Views: 1534

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...
by dwabare92
Mon Oct 10, 2022 11:44 am
Forum: Stimulsoft Reports.WEB
Topic: Converting Crystal to Stimulsoft
Replies: 10
Views: 1534

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
by dwabare92
Sun Oct 09, 2022 3:57 pm
Forum: Stimulsoft Reports.WEB
Topic: Converting Crystal to Stimulsoft
Replies: 10
Views: 1534

Re: Converting Crystal to Stimulsoft

I will give it a shot. Thank you
by dwabare92
Sat Oct 08, 2022 9:07 pm
Forum: Stimulsoft Reports.WEB
Topic: Converting Crystal to Stimulsoft
Replies: 10
Views: 1534

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...
by dwabare92
Sat Oct 08, 2022 8:57 pm
Forum: Stimulsoft Reports.WEB
Topic: Converting Crystal to Stimulsoft
Replies: 10
Views: 1534

Re: Converting Crystal to Stimulsoft

Lech, this works great! Thank you so much!
by dwabare92
Fri Oct 07, 2022 4:24 pm
Forum: Stimulsoft Reports.WEB
Topic: Stimulsoft Freelance Work
Replies: 0
Views: 3815

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?
by dwabare92
Thu Oct 06, 2022 8:36 pm
Forum: Stimulsoft Reports.WEB
Topic: Converting Crystal to Stimulsoft
Replies: 10
Views: 1534

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...