Search results for query: *

Hi All - I'm wondering if anyone could tell me how I can get the data on my main (GF1) to repeat when I have multiple items on the linked Sub-report (GF1). I am writing a report for our transportation team that on the main report has a shipment number and other shipment detail (carrier, leg...

Just wanted to pass a note that your input worked perfectly LB, I appreciate the help! [bigsmile]

Great! I will try this! I did find a work around by converting the date to a string but it is clunky. I will give your example a try in the morning as I'm off to a baseball game now. Thanks much LB, I will report back!! *Ü*

Hello all - I am a bit stumped. I am trying to concatenate a series of dates that are already in the 05/23/18 format. For example, I have the following: Order # RDD 20012512 05/23/18 20012512 06/01/18 20012512 07/03/19 At the GF I'd like to see: 20012512 05/23/18; 06/01/18; 07/03/19...

I believe I have found a solution. I ended up using a formula in the Details Section Expert to suppress any "exceptions" (If {@Short To Order} < 0 Then {@Short To Order}Else 0)that were = to "0.0". Works like a charm. Thanks for the ideas and assistance!!

I am still not able to suppress the positive results. I need to be able to show only the negative results of the formula, which are the exceptions. Typically I would use the Select Expert/Formula Workshop to say where {formula} < 0. I have to think that there is a way to create this exception...

Hi all! I have created a report where I have 2 sub-reports passing a total of 8 variables back to the main. On the main I have a formula where I am using the shared variables from the 2 subs to create positive or negative number (basically, open orders minus deliveries minus any avail open...

Yes, tried it all. Funny thing is that I get the correct result of my calc on the main in GF2b but as soon as I move it to GF2a, it will not add the var number from the sub. So, I found a work around that gives the intended results. Basically, I moved all of my data less the original subreport...

The sub is in GF1 (grouped by material)....the main is in GF2a (grouped by material)

Hmmmm....Ok,I think I am doing what you stated above. So on my sub I am taking a vaule that is on GF1 and using in a calculation that is in GF2b on my main, this works perfectly, however if I pull the calc up to GF2a where it needs to be, it does not add the subreport value. I've uploaded a...

Quick question, hopefully..... *Ü* I have a shared var from my sub that I am using in a simple addition problem on my main. I can get the result of my addition to come up but it will only show the correct result on my GF2b, not my GF2a where I need it. When I pull the formula up to GF2a, it...

We're on BO 11 R2, SP is 2010 version, would this int kit work for that combo or is there a different one that supports the BO 11 R2/SP2010 combo?

Is this possible?? I have a ton of scheduled jobs that run daily, I have them set up to email me and then I have to turn around and save them to my hard drive then upload them to SharePoint....ugg! Is there a way to just automatically send them to SP??

Going to give this a shot, running this adhoc for the remainder of the week to verify Thurs will pull in Sat-Mon. Hopefully it works, so far it seems to. I'll post back tomorrow with yay or nay. Thanks! Formula: RDD Begin IF DayOfWeek (currentdate)= 2 THEN currentdate + 2 ELSE //If Monday...

Thanks pmsawyer - I am trying to use the formula you suggested but I am not too familiar with variables. I've used them a few times in subreports, passing info from sub to main but not for a dating formula such as this. I have left my afternoon open to work on this. Thanks again!

Checkout this thread....I've used it before and it works perfectly http://www.forumtopics.com/busobj/viewtopic.php?p=615604

I should clarify that I only get Monday when I run it on Thursday. All other days (M,T, W,F) pull in the orders correctly.....I just can't get the Sat, Sun, Mon all in one report. Thanks! Ü TB

Hi there Ü hoping to get some help- [hairpull] I have a report I am developing where I need it to run M-F (actually will run BOE and dist via email) and I need my open orders to pull in 2 days ahead of the cusotmer requested delivery date i.e, Ran on Mon pulls in Wed's orders due...

Worked perfectly! Thanks so much! Ü

I'm not sure if using DAYOFWEEK is what I need but I am trying to exclude Sat and Sun from a calculation. I want to be able to look at a date and return a value of 2 days prior less the Sat and Sun. It would look something like this Monday 6/27/2011 would read Thursday 6/23/2011. Any help...