Small width layout Medium width layout Maximum width layout Small text Medium text Large text
     Search
Downloads Downloads Directory Directory Forums Forums Forge Forge Blogs Blogs        Marketplace Marketplace Careers Program Careers
Community › Forums Register  |  

Maximum ASP
  Need Help?  
Professional technical support for DotNetNuke is available from DotNetNuke Corporation.
 


  Ads  
Webhost4Life - $4.95 Windows Hosting
 


  Sponsors  

Meet Our Sponsors

Jango Studios - Skins, Modules and Hosting for DotNetNuke
eUKhost.com is commited to offer exceptional UK Windows Web Hosting solutions with quality 24x7 technical support.Our plans support ASP.Net, ASP, ASP.NET Ajax extensions, XML, MSSQL, MySQL, PHP,DNN, multiple domains and Shared SSL as standard.
SmarterTools
The Official Microsoft ASP.NET Website
Portal Webhosting - Hosting For Developers
Red-Gate Software
 


DotNetNuke Forums
 
  Forum  DotNetNuke® Pro...  Reports Module ...  Reports 05.00:'Object reference not set to an instance of an object' when using visualizer
Previous Previous
 
Next Next
New Post 2/20/2008 11:39 PM
Unresolved
User is offline felixhelix
51 posts
10th Ranked


Reports 05.00:'Object reference not set to an instance of an object' when using visualizer 

Reports 05.00:'Object reference not set to an instance of an object' when using visualizer

DNN 04.08.00
Reports 05.00.00
ZedGraph 5.1.1.428
DotNetNuke Reports Module - Chart Visualizer 01.02.00

Hi, when I try to use the ChartVizualiser (ZedGraph) I get the following error (error msg is in german):

AssemblyVersion: 04.08.00
PortalID: 0
PortalName: xxx
UserID: 1
UserName: host
ActiveTabID: 107
ActiveTabName: Statistiken
RawURL: /ShopAdmin/Statistiken/tabid/107/Default.aspx
AbsoluteURL: /Default.aspx
AbsoluteURLReferrer: 
UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 2.0.50727)
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: 3c02eb58-b908-4fc0-9bfb-1161fa7c2506
InnerException: Der Objektverweis wurde nicht auf eine Objektinstanz festgelegt.
FileName: 
FileLineNumber: 0
FileColumnNumber: 0
Method: DotNetNuke.Modules.Reports.Visualizers.Chart.ChartImageManager.RenderImage
StackTrace: 
Message: DotNetNuke.Services.Exceptions.PageLoadException: Der Objektverweis wurde nicht auf eine Objektinstanz festgelegt. ---> System.NullReferenceException: Der Objektverweis wurde nicht auf eine Objektinstanz festgelegt. bei DotNetNuke.Modules.Reports.Visualizers.Chart.ChartImageManager.RenderImage(ReportInfo Report, DataTable ReportResults, String ImagePath, ExtensionContext ExtensionContext) bei DotNetNuke.Modules.Reports.Visualizers.Chart.Visualizer.Page_Load(Object sender, EventArgs e) bei System.Web.UI.Control.OnLoad(EventArgs e) bei System.Web.UI.Control.LoadRecursive() bei System.Web.UI.Control.LoadRecursive() bei System.Web.UI.Control.LoadRecursive() bei System.Web.UI.Control.LoadRecursive() bei System.Web.UI.Control.LoadRecursive() bei System.Web.UI.Control.LoadRecursive() bei System.Web.UI.Control.LoadRecursive() bei System.Web.UI.Control.LoadRecursive() bei System.Web.UI.Control.LoadRecursive() bei System.Web.UI.Control.LoadRecursive() bei System.Web.UI.Control.LoadRecursive() bei System.Web.UI.Control.LoadRecursive() bei System.Web.UI.Control.LoadRecursive() bei System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) --- Ende der internen Ausnahmestapelüberwachung ---

I use the follwing SQL Query, which works fine with table layout and returned 42 records the day I tested it:

select 'Datum' = convert(varchar,DateTime,102),
'Seitenaufrufe' = count(*),
'Besucher' = count(distinct dbo.SiteLog.UserHostAddress),
'angemeldete Besucher' = count(distinct dbo.SiteLog.UserId)
from SiteLog
where PortalId = @PortalId
and dbo.SiteLog.DateTime between '01.01.2007' and '01.01.2008'
group by convert(varchar,DateTime,102)
order by Datum desc

your's
felix
 
New Post 2/21/2008 11:15 PM
User is offline felixhelix
51 posts
10th Ranked


Re: Reports 05.00:'Object reference not set to an instance of an object' when using visualizer 

Aahh: I forgot to set
Bar Name Column
Bar Value Column
to the matching columns in my query.
RTFM, right ;-)
 
New Post 2/23/2008 7:59 AM
User is offline Andrew Nurse
353 posts
8th Ranked






Re: Reports 05.00:'Object reference not set to an instance of an object' when using visualizer 

Glad you fixed the problem! Still, the module should be displaying a clearer error, so I'll log a bug for it.

Andrew Nurse
DotNetNuke Core Team Member and Reports Module Project Lead
Microsoft Certified Professional Developer
 
New Post 10/9/2008 11:29 PM
User is offline Mike
4 posts
10th Ranked


Re: Reports 05.00:'Object reference not set to an instance of an object' when using visualizer 

I have the same problem and my columns are set right.

my query

SELECT fact_periodica.no_ciclo, hist_aux_val.consumo_fact_ap FROM hist_aux_val INNER JOIN fact_periodica ON hist_aux_val.id_proceso = fact_periodica.id_proceso INNER JOIN instalacion ON hist_aux_val.id_servicio = instalacion.id_servicio INNER JOIN clave_lectura ON hist_aux_val.id_clave_lectura = clave_lectura.id_clave_lectura INNER JOIN servicio ON hist_aux_val.id_servicio = servicio.id_servicio INNER JOIN cliente ON servicio.id_cliente = cliente.id_cliente WHERE (hist_aux_val.id_servicio IN (10444)) AND (fact_periodica.no_ciclo >= 65) AND (fact_periodica.no_ciclo <= 78) ORDER BY fact_periodica.no_ciclo


 		 fact_periodica.no_ciclo

 		 hist_aux_val.consumo_fact_ap

 The result in grid mode is:

no_ciclo consumo_fact_ap
65 9.00
65 26.00
66 10.00
66 36.00
67 10.00
67 32.00
68 10.00
68 26.00
69 14.00
69 16.00
70 15.00
70 20.00
71 12.00
71 19.00
72 16.00
72 21.00
73 14.00
73 27.00
74 16.00
74 28.00
75 16.00
75 23.00
76 14.00
76 16.00
77 9.00
77 9.00
78 15.00
78 10.00

 
 Page 1 of 1
Previous Previous
 
Next Next
  Forum  DotNetNuke® Pro...  Reports Module ...  Reports 05.00:'Object reference not set to an instance of an object' when using visualizer
 


Forum Policy

These Discussion Forums are dedicated to the discussion of the DotNetNuke Web Application Framework.

For the benefit of the community and to protect the integrity of the project, please observe the following posting guidelines:

1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DotNetNuke.
2. Discussion or promotion of DotNetNuke product releases under a different brand name are strictly prohibited.
3. No Flaming or Trolling.
4. No Profanity, Racism, or Prejudice.
5. Site Moderators have the final word on approving/removing a thread or post or comment.
6. English language posting only, please.
 


DNN Photo Gallery
DNN Photo Gallery is a truly unique photo management module released January 1st 2006. With DNN Photo Gallery you can REALLY integrate images into your existing portal and make them look like they were designed for your site.
DNN Photo Gallery 		Swirlhost Inc.
Affordable DotNetNuke Hosting, Skin Development, Custom Module Development, and DotNetNuke Consulting. We will install your preference of DNN and now host with us and get a free license for the Swirl AJAX Chatroom Module.
www.swirlhost.com 		Active Modules, Inc.
Creators of Active Forums, the best forum module for DotNetNuke
www.activemodules.com

DotNetNuke Corporation   Terms Of Use  Privacy Statement
DotNetNuke®, DNN®, and the DotNetNuke logo are trademarks of DotNetNuke Corporation
Hosted by MaximumASP