I found the issue. This was a composite report and you can't have a string array at the top level. I had changed the retrieval argument in akll the sub reports but did not think to check the main report. This is not something that was supported until after PB version 9.x if i read correctly.
Hey all,
I have been trying to pass a string array to a datawindow for a couple of days now with no luck. In the data window report I have defined the retrieval argument as a string array. The datawindow has syntax as follows:
select ....
from...
where value in (:ls_array)
I have a program in...
I guess I figured out my own solution. I just changed the query to be an append query that selected all the data into a temp table. I based the report from the temp table rather than the query and it works fine now.
As most of the replies elsewheer on the net have to do with just aliasing the calculated field...does anyone know how to create an alias for a summary field on a report.
The following will fail:
=(Sum([BlkDen]*[SumOf#Loads])/Sum([SumOf#Loads])) as some_name
so will this:
some_name...
I have been down that road already, and like I mentioned the query that the report is based on runs without issue. There is a section on the report where it is doing a calculation based on the values from the query, and thta is what is casing the error to occur. I have tried typecasting...
I have an Access database front-end that connects to an SQL server through linked tables. Within this database there is a report that is based on a query. When I try to run the report, I get the error mentioned in the subject line. If I run the query by itself I do not havw the issue. There is...
I found a way to do it through VB scripting and a program called Redemption. This program allows you to write code to get around M$ security "fixes" for Outlook. We had already installed the click yes program, but we were very unhappy with it. When it is trying to click yes to the message, all...
Is there any way to disable the warning message that Outlook gives when a program tries to send an email? We automatically send out a message every hour, on the hour, and if we do not click yes to allow outlook to send the message, it will not get sent.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.