Custom Reports- Modeling

[TPAVP]

We have a plan that we are setting up on Quantech. It will be tracked daily and involves modeling. The problem is that all the reports print all the underlying investments relating to each particular model. Our client just wants to see the Model Investments and does not want to confuse the participants with all the underlying investments. I have spoken with Corbel and they do not have any reports that suppresses the underlying investments, but says that Crystal says it can be done. Before we attempted to tackle it, I thought maybe someone may already have something like that.

I'd appreciate any help in this area.

[Tom Poje]

We don't do daily, so we dont use modeling. But it sounds like you are trying to print by source? I would assume an individual has one 'model' as to how his investment gets split and no other investments? If so, then yes, thats the way we print our SOA, and certs.

[TPAVP]

I'm not sure if it is by source that we want to print. This particular client only has deferrals, but the participants have the option of Growth Model, Income Model or Balanced Model. They may choose any variation of the 3 as to how to split their money. Within that, each model invests in 10-15 different underlying investments. We want a report that just prints their balances in Growth Model, Income Model and Balanced Model and NOT their tiny pieces of each of the 15 underlying investments within those models.

Kind of complicated, but Corbel says a report can be written, so I am trying to hunt one down before we try and tackle it!

[Tom Poje]

sounds ugly.

I'm not sure if there is a field name 'modelnameid' or anything you could sort by.

if not using trade agents, then maybe assigning trade agents = to particular model name would work.

[pmacduff]

agriffith- is there is already a report that is giving you MORE information than you want but including the modeling totals??...couldn't you just then modify the existing report by using "suppress" or hiding the underlying investment data thereby only reflecting the modeling totals? I may be wrong but wanted to give you a possible idea (I'm no Crystal expert!)

[TPAVP]

No, there is no report that gives us the modeling totals. If there were, I don't believe it would be too hard to suppress the underlying investments. All the reports give ONLY the underlying investments, not even mentioning what model they are associated with, which I find odd to begin with because most employers would not want to have all the underlying investments printed for each model. I understand that it has to be tracked by the underlying investments to allow the models to work correctly, but it would make sense to me that the models themselves should be the only thing that is printed- But what do I know!!

[Tom Poje]

so it sounds like you are going to have to 'trick' the system by using some field you are not currently using, and assign each account to a specific investment?

[FAPInJax]

The field that she wants is already in the RPTEEACCT table (I think). The field is INVPRODID (Investment product ID) which indicates the model. It can be linked backward to determine the English name of the model. The report just has to group data using this field I think.

Does this help?

[TPAVP]

thank you! I will let the person preparing the report know and hopefully that will help out. We've been on Quantech for only two years, so a lot of the Crystal Report Writing is still new to us.

Thank you for all the help.