Hi,
I created a main report that passes a variable to the subreport.
Main report:
shared stringvar strShowValue2;
strShowValue2:=strShowValue2+totext({@v_percentage})+"^";
I pass this to my subreport and it shows in subreport as:
{?Pm-@v2_ShowValue}= 0.00^0.00^95.04^0.00^...
Hi, I seem to have problems aggregating data and then storing the data into a temp table for later viewing:
Ex:
select ticketnum, sum(priceextension) total
into "#table1"
from TICKHISD
where ticketnum=457117
group by ticketnum
trying to view the temp table:
select * from "#table1"
result...
After some research, I believe we are using PCC since I sometimes get an erro with PCC.exe.
I've tried to create another stored proc that aggregates and stores to a temp table then aggregate that result and store to a another temp table to see if the result set would be divided by 100 twice...
The version I'm using is 8.60.192.030.
I'm creating the stored proc through the Data Manager and executing the stored proc by calling it.
the salary field is a currency field.
I'm not sure what you mean by (PCC, ODBC Test). I've since reduplicated this many times and have found that if you...
Hi,
I have been working for the last two hours trying to figure out why this was happening in Pervasive 8.
table employee (simplified table)
ID salary
A 100
A 100
A 100
simplified version of stored procedure
my stored proc:
select ID, sum(salary) Total from
employee
group by...
Hi,
I went through every single IV table to try and find the table that contains the data for the DOCTYPE field in IV30300.
I know that DOCTYPE can be 1, 2, 3, 4, 5, 6, 7, and 11.
But does anyone know which table actually links to that field to identify the data in DOCTYPE FIELD?
Thanks in...
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.