Data Window Error

Most likely the data type for the parameter is different from the report parameter window (Report Setup) to the Retrieval Arguments in the datawindow (Infomaker).  You’ll see this error if you try to pass, for instance, a string parameter value to a number datatype.

______________________________________

Ryan Creps

Network Developer |Tessitura Network, Inc

Hi ,

I have created a new report which seems to be fine,

but I am unable to run it in Tessitura.

Throws me an error::

Retrieve argument 2 does not match expected type

Kindly suggest me what is the mistake...

Thank you.

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.5.325 / Virus Database: 270.12.18/2096 - Release Date: 05/07/09 05:57:00

In the column specifications, make sure also that you are adjusting the datatypes of the parameters in the Arguments window to match the parameters in the Report Setup.  These need to match the datatypes and also be in the same order.  Some older standard reports utilize application code in between the parameter window and the report datawindow and the parameters aren’t always in the order (because they don’t have to be in the application necessarily).

Sorry if this is too basic, but this is just a quick mention in case the foundation of your report is off track:

Keep in mind that if you are making customizations of standard reports, you need to create local versions to modify in your system.  Otherwise you may be running into issues where application code and objects are overriding your customizations.  Have you created a new stored procedure from the standard stored procedure, so instead of RP_ON_ACCOUNT_TRACKING_REPORT create a copy LRP_ON_ACCOUNT_TRACKING_REPORT.  Instead of d_on_acct_tracing_rpt, create ld_on_acct_tracking_rpt.

Hope that helps.

______________________________________

Ryan Creps

Network Developer |Tessitura Network, Inc

Thank you for all the help .

Hi ,

I am new to design the reports in the Info Maker,

how can I  manually refresh the link between the Infomaker report and the proc??

Now,I am just doing this

view->Column specification->right click select stored procedure ->change the name and the parameters of the stored procedure.

I basically chaged the ON ACCOUNT TRACKING REPORT...

I have added source channel ,and posting date to the report.

I have changed the parameters to @start date and @end date instead of @cut of data..........

Kindly let me know if I doing anything wrong....

I have tested the Stored Procedure in SQL Server Management Studio...

It worked fine.

Any help with this would be really appreciated ...