Portal Question

[oracleofmist]

I have a report I am trying to make that will list every 'package_name' under the table 'package' with the category being the 'product_id' which is held in the 'package' table. the 'product_id' is the primary key of the 'products' table for your reference. I currently have a portal set up in the report to list all the 'package_name's however if there are not 20 'package_name's the report will show blank lines to be filled and likewise if there are more than 20 it will not expand to show all the others. Is there anyway to have the portal dynamically change its size based on the number of rows/records of data fed to it? or is there another solution? thanks, in advanced

[Techphan]

AFAIK you only have two options:

 

1) Allow "vertical scrolling" in your portal definition so that the first 20 (or whatever you define) will display and then the user can scroll through the rest (if more than 20 portal records).

 

2) Set your portal rows to a large number (I once used 450 to see if I could make a portal this large since I wanted to see all the records without portal scrolling -- to find an error), but you will still have to scroll down your window to view all the items.

[LingoJango]

Your db structure is unclear to me.

 

One option, if applicable at all, is to use a SubSummary report based on the package.

 

Another is to have an unstored calculated text field in the relevant table:

DisplayPackageNames = List ( package_name )

[LingoJango]

That calc would be List ( relatedtable::package_name ), where relatedtable is the name of the table wherere the package_name is to be found.

 

You then put your field in the report, preferably as a merge field, and make the text object and the part slide up.