Search results for query: *

Group Footer text field can be populated with from 0-6 lines. I want to count the number of non-blank lines in Group Footer, so the total of Group Footer + Detail lines can be calculated before TotalPageCount is calculated. The problem is that when the Group Footer lands near the bottom of the...

Mysql has 'load data infile' to load a list of file names into a table. I want to load all the blob files from a directory into a table, not just names.

I have a report header with a subreport in it. I want to hide the report header but run the subreport to get shared variable values that I print in the page header. If I Hide(drill-down OK) the report header, I don't get the subreport values. Can I get the subreport values and hide the report...

Posted solutions (lbass) to cross tab percentage problems can involve creating a formula, then summing that formula in a cross tab and creating running totals inside that summed formula: Select (Sum of @formula}->right click->format field->suppress->x+2 and enter: whileprintingrecords...

I created 3 formulas: A sum; B sum; A+B sum. In the cross tab, I summarize these formulas. I get correct amounts but I want A sum/A+B sum (B sum/A+B sum) percentages per row. A running total that resets might work but I don't want a group by.

The Cross tab column is date and row is category. The summarized fields are A sum, B sum, and A+B sum. I want the summarized A sum and B sum to show a percentage of A+B sum, not show a percentage of all A sum or B sum. CR 11 Date 1 Date 2 Category 1 A sum% A...

The Cross tab column is date and row is category. The summarized fields are A sum, B sum, and A+B sum. I want the summarized A sum and B sum to show a percentage of A+B sum, not show a percentage of all A sum or B sum. CR 11 Date 1 Date 2 Category 1 A sum% A...

Sorry, I don't have an @Name. I was just asking if it was possible to create a formula called @Name that uses the parsed value from P.ID (@ID) as an index to get to C.Name. I will stop asking about @Name now.

Just one name field. The first entry in P.ID is always the ID to link to. C.Name - Shoe, Jim C.ID - 0000001234 P.ID - 1234 45678 @ID - stringvar array cust := split ({P.ID}," "); totext(val(cust[1]),"0000000000"); Can formula @Name use @ID as an index to get C.Name? @Name -...

If I group by formula @Name, how do I write it to reference @ID, point to C.ID, and get C.Name? @ID formula: stringvar array cust := split ({P.ID}," "); totext(val(cust[1]),"0000000000");

The linking is the issue. I parse/reformat P.ID_etc to get @ID ('01234 etc' becomes '0000001234'). Now I can group by @ID. Now that I have a vaild ID, I link to a subreport that displays C.Name. That is followed by SKU footer totals. Something like this: 0000001234 (Header Group 1) Shoe, Jim...

I can group by C.ID, then by P.SKU after parsing and reformatting P.ID_etc. I want to group by C.Name, then by P.SKU. The problem is that I can't just add a group by for C.Name (can't create an initial link between C.ID and P.IDs to allow grouping by C.Name). How do I build a list of IDs so I...

I actually figured it out and then checked back here. What I ended up doing is exactly what you suggested.

Additonal Info - There is a zize field so (when printing) I can check for the existence of a quantity ordered for each size. I don't just group by size because it would be in a funky order (L M S X). CR 11.

I want to group by code# (t-shirt) and then group by sku (size), printing the quantity ordered for all skus within a code# all on the same line. Grouping by sku puts sizes in the proper order since the lowest sku number always corresponds to the smallest size. Is there something I can do without...

The select works fine. Adding the insert into causes it to hang. How do I get the results into a new table? INSERT INTO table3 ( id,lastn,firstn,addr3,state) SELECT t1.id,t1.lastn,t1.firstn,addr3,t1.state FROM cust t1 INNER JOIN( SELECT lastn+firstn+state+addr3 AS dupmatch FROM cust...

Not sure you mean by "stuff which is in the WHERE clause needs to go in the AND ..." Can you explain?

I want to change this so orders.total is a sum by order.id Something with "sum(orders.total) as total". How do I change this? select c.name from cust c inner join orders on c.id=orders.id left join flags on c.id=flags.id where orders.order_date > '1/1/2007' and orders.total>20 and...

Maybe I can do something like this. Where do I add the left join? select c.name from cust c inner join (select order_tot,order_date from orders where sum(item_tot)>'30' and order_date between '1/1/2006' and '12/31/'2006') o on c.id=o.id where c.country='us'

I'm not sure how to write a single stmt that joins all 3 tables. Any help would be appreciated.