Search results for query: *

Hello, We are using BOE XI 3 and we have a report scheduled to a email destination and the report goes out as a attachment as well as link in word format. The issue is when the user clicks on the link it is coming up with a open/save pop up box . Is tehre a way to avoid this and make the...

Hello As far as I know there is no way around this if you want the whole subreport to be displayed on the main. You can pass the values from Sub to main if there are only values that need to be displayed from the sub then export which will work fine.

Give us some sample data.It will make it clear for us

Create the formula on the report field not the summary

May be you can try creaing a formula like this if left(invoice ammount,1)="-" then "Credit" else "debit" then use that for your second group

Hello Di, First group on Dept , then second group on Credit,debit field then third group on Customer number. Then you can use summary fields at the thord group level. Hope this helps.

Hello Norm, I'm not sure if I understood your comments. But here is what I would suggest If you follow what Pete suggested the uer doesn't have to enter the values twice. The main report parameter values will be passed to the sub report.

You do the same like I mentioned earlier Use the time periods in the formula For 7am - 3pm shift You use formula in the running total like outtime >7am and outtime <3pm same for others

Hello, I'm guessing that you are trying to get the no. of rooms for times between 7am-3pm then 3pm-7pm and 7pm - 7am if you are looking for no.of rooms after 3pm then you can use the formula in the running total When you go to create running total wizard under Evaluate -> Use a...

Hello JRR, As far as I'm aware you can't filter main report data based on a shared variable. What you can do is supress/hide the main report data based on the shared variable.Hope this helps.

Thank you very much for all your responses. I tried that but it is showing the local path of the file(C :\Documents\ \Locals\temp-------------). I guess it is giving the original temp folder path. Not the location on the Business Objects server .

Hello Everyone, We have Crystal reports 2008 and Business Objects XI R2 I want to display the report path (the folder path of the report on BOE where we published) on the report footer, So that when a user sends me a instance of a report ,If i have it displayed in the footer It would...

Hello LB! Thank you very much. That is exactly what was happening. I had the repeat group herdes on each page option checked in the Change group options . I have a question for you LB Where can we find all these options that we have in crystal reports.

Hello Everyone! I'm using Crystal 2008 and SQL Server 2005 I have 2 groups in the main report My subreport is in the footer of the group # 2 I calculate the total documents in the subreport and pass it to the main report by using a shared variable. shared numbervar...

In that case you can try Fisheromacse formula with a little change ; use this formula to convert the text field to a date: //{@TextToDate} stringvar ttd; IF isnull({YourTable.ProgramYear}) or TRIM({YourTable.ProgramYear})="" then ttd := "0000" else := {YourTable.ProgramYear}...

Can we see an example of the Program year Is it always in the same format

I meant your start and stop dates . Probably from your above post DateDiff("d", {@LOA On}, {@LOA Off}) Can you explain in more details,what exactly happened when you used the formula.

Hello! You can use a formula to get the sum numbervar SumOfDays; SumOfDays:=SumOfDays+datediff("d",start,stop); SumOfdays; Have this in the details sectoion and suppress it and then also place it in the Group footer for the sum to be displayed. You also have to create another formula...

Hello ! I had the same request and here is what i did. Please see if this helps you. thread767-1531876

You should be able to supress the header based on the results form the test. Please post the test and the values youget with the test.