If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

LABELS :-Can user enter Number of Labels

Started by sys2674, 15 Oct 2007 02:02:48 PM

Previous topic - Next topic

sys2674

HI All

I have created lables using Repeter.

My requiremnt says I need to give user the input for number of labels to be printed out.

For that i have created a Prompt text prompt were user can input the value.

But after that i don't undersatnd how to go fwd.

Number of Labels: The user can enter the number of labels needed to be printed out.

Can anybody pls tell me.How to go with it.

Thanks
SYS2674


sys2674

its urgent can anyone please help Urgent

almeids

You need a table to return a variable number of records to drive your repeater.  The table should have some sort of sequence number column so you can add a filter like sequence<=number-of-labels-parameter.  You will need to allow cross joins for your query.

sys2674

#3
Hi Almeids

Thanks for your reply.
But i am not using sql.Only a tabular model.
I donot have a column with sequence noumber.

Also how can i created a dataitem with all sequence numbers
Let me know if you know anyother way.



//

almeids

It doesn't matter what your query is built on top of; what matters is that you must be able to return N rows with your query if you want to print N labels.  The second table doesn't have to contain a sequence number, but it does have to contain something you can (reliably) filter on to control the number of rows returned.
If the maximum number of duplicate labels to be printed is small, you could instead use nested tabular sets containing tabular models which each include a hardcoded sequence number data item and a tabular reference to your current query to duplicate your record(s), then filter the sequence number at the query level...but that maximum duplicate count would have to be pretty small to be worth that sort of jumping through hoops.

sys2674

Hi almeids,

Thanks a lot. I think we donot have tabular sets in Cognos8.Also I am not sure how can i return N rows.
i tried to create two prompt valuses
1.Label count  which user will input
2.Count which has static values invisible to user.
here i am unbable to compare parameter values.

is there a way to create a dataitem which can create a sequence number.

thanks again

almeids

Sorry - forgot I was looking in C8 forum - you will have to provide the translation to C8 concepts since I am not there yet.  I don't understand what you are trying to do with a second prompt.  The one thing I am sure of is you will need the rows in your query to support what you are trying to do regardless of the environment, so you must find a way to either bring them all back from the database (some sort of cross product multiplier table approach) or to duplicate what you get from the database locally (some sort of union approach).  You can't make something from nothing.
Good luck.

sys2674

Hi Almeids

Thanks for your help.I will speak to modeler who can provide me some squence number
On other hand i trying to write some html tag were i can take the input from parameter and give it to print.

thanks a lot
Sys2674