SSRS Report : the value expression for the query parameter refers to a non-existing report parameter

This is one nasty error which I've experienced many times. Finally got one solution for that.. Do view code of the rdl..Find the killer bug..and correct it... ex:

Only referring to the code will help..


            =Parameters!FromDate.Value
         

         
            =Parameters!ToDate.Value
         
       

Correct it to


            =Parameters!FromDate.Value
         
         
            =Parameters!Todate.Value
         
       

Whatever we do outside wont help...even if we remove all the parameters from query and redo again... :)

Thanks to this part of the report...

Hope this serves good for someone out there...

Happy programming guys!!
Regards,

Export import AX model - Dynamics AX 2012

Hey Folks,

I had to do this ax model export today and found the command quite interesting. Thought of sharing it..

Open cmd prompt and run as administrator and then

locate the folder c:\program files\microsoft dynamics ax\60\managementutilities

axutil export /model:[modelname] /file:[backupmodelname].axmodel /db:[dbname]_model /s:[servername]

Dynamics AX field lookup method.

The below lookup method is overridden in the form datasource.

 public void lookup(FormControl _formControl, str _filterStr)
{
    SysTableLookup sysTableLookup;
    Query query;
    QueryBuildDataSource qbd;

    ;
    sysTableLookup = SysTableLookup::newParameters(tablenum([tableName]),_formcontrol);

    query = new Query();
    qbd = query.addDataSource(tablenum([tablename]));
    qbd.addRange(fieldnum([tablename],[fieldname])).value(SysQuery::value([value]));

    sysTableLookup.addLookupfield(fieldnum([fieldname]));
    sysTableLookup.addLookupfield(fieldnum([fieldname1]));
    sysTableLookup.parmQuery(query);
    sysTableLookup.performFormLookup();

}

Happy Programming!!