| |
Data Dynamics Reports Support
Started by strategia at 06-18-2009 6:53 AM. Topic has 3 replies.
  
|
|
Sort Posts:
|
|
|
|
 06-18-2009, 6:53 AM
|
strategia
Joined on 06-18-2009
Posts 2
|
Cannot create a drillthrougth report in TABLE view. I always have a "Must declare the scalar variable"
|
|
|
|
|
Here is my query in the second report
I have created the parameter before updating the query, but I always have this error mentioned in the subject.
What am I doing wrong?
I have the latest downloadable version and I am working directly in the designer, not inside Visual Studio
Select * From V_DD_Users_SAS where RenewalDatePN is not null
and RenewalDatePN >= GetUtcDate()
and RenewalDatePN <= DateAdd(MONTH, 10, GetUtcDate())
and SupervisorPersonNo =(@SupervisorPersonNo)
|
|
|
|
|
Report
|
|
|
|
|
06-18-2009, 10:31 AM
|
Amit Pal
Joined on 12-11-2008
Posts 517
|
Re: Cannot create a drillthrougth report in TABLE view. I always have a "Must declare the scalar variable"
|
|
|
|
|
|
Hello,
This error generally occurs when the name of the parameter in the dataset is missing the leading @ symbol.
However, before providing the complete solution, would like to see the report which is throwing this error. Can you please attach the RDLX file?
Regards,
Amit
Amit Pal
GrapeCity- DataDynamics
|
|
|
|
|
Report
|
|
|
|
|
06-18-2009, 1:06 PM
|
strategia
Joined on 06-18-2009
Posts 2
|
Re: Cannot create a drillthrougth report in TABLE view. I always have a "Must declare the scalar variable"
Attachment: Compliance.rdlx
|
|
|
|
|
|
Here is my Report and please
provide more detail on how to write the query it and where do I add the info properly for the parameters as I have try over 10 different way to do it.
I am going nuts
Thanks
|
|
|
|
|
Report
|
|
|
|
|
06-19-2009, 7:37 AM
|
Amit Pal
Joined on 12-11-2008
Posts 517
|
Re: Cannot create a drillthrougth report in TABLE view. I always have a "Must declare the scalar variable"
|
|
|
|
|
|
Hello,
In the attached report, there are no parameters defined in the dataset and that’s the reason the report is throwing error ‘Must declare the scalar variable’.
I would suggest you to please add a parameter in the dataset (SkillAcquisitionByOUandSUP) by following underline steps:
(1) Right click the dataset in ‘Report Data Explorer’ and click Edit.
(2) Click on the Parameters and then add a parameter.
Also, you have provided a query which contains the parameter (@SupervisorPersonNo). To know the value of SupervisorPersonNo, you need to add another unparameterized dataset (dataset without parameters).
This dataset will get the list of available SupervisorPersonNo and set dataset property of report parameter to this dataset.
You may go through following walkthrough which list out both of the above steps:
http://www.datadynamics.com/Help/ddReports/ddrwlkDrillThrough.html
Regards,
Amit
Amit Pal
GrapeCity- DataDynamics
|
|
|
|
|
Report
|
|
|
|
|
GrapeCity » Product Support » Data Dynamics R... » Cannot create a drillthrougth report in TABLE view. I always have a "Must declare the scalar variable"
|
|
|
|
|