Recent content by gdwood

one thing you may want to consider if there is no data being returned is a page stating that, which you can show the client instead of them getting an error

Did you solve this? is your parameter Global in scope? You should get a value back for it no matter what the query does. The header does not rely on any onRow or BuildFromRow processing does it, as if you get nothing back in the query you will have no rows!

Sounds like you might be over the top on this. Can you write efficient SQL to pull the data of the server? Our reports hit data for many more years than that and the SQL works fine. you can go the stored porcedure route, but that just adds more overhead a lot of times.

have you used navigator within Actuate to locate them?

they should be stored as rox files on the unix box in the directory that you upload them.

Why would you need to load the data to the actuate server. If you create reports to access the SQL server and pull data in then you should be fine. And you probably don't want users to create their own reports, but it can be done. You need to figure out your stategy for delivering the...

Are you certain this Trunc(wostatus.changedate) gives you a date and not a char? And the previous post shoudl have you in the right direction, sql doesn't like - between dates it will probably not give you a date as a result

Are you going to put the hyperlink in the control's OnRow or are you going to use the linkexp ?

It does? Are these frames at the end of the page and then there is a page break after perhaps so you get all the blank space after?

hope about using a lookahead aggregate like SUM (qty) where (blah) group by (blah)? OR add that sum in your SQL and make it a cloulm on your sql so that you can test it in the content frame as well?

If you don't have the sum of that column as a column on that row, you can use the adjust size of the after frame to check and see in that sum is 0. If it is then you can set the height of the frame to 0

Did you solve this one yet? You can tyr a few things and nothing looks out of place here, but I'm wondering if the rules of the case mean you have to end the inner and then the outer and they can't share an else? Can you try the select case statement?

If you remove the red lines it works? Even though there are two 'END's there? Is there another case statment? Or do you remove the other end?

depends on what you want to do with that variable as well. Another option is to create a publice variable in the root of you report. Make the variable static and it ca be used by all objects as long s your value is not changing

Would be the base objects or components in Actaute. A frame, report section, group section and so forth...