AspWebSolution Forums » Products » ASP SimpleGraph » simple Graph

index | search | no replies | posting guidelines | help

login | register

» »

:: simple Graph :: (18)

Post a New Message | Post a Reply

Aug 31 2004, 4:32 PM

simple Graph

johnny

from: tx I install the report wizard and it works great. But when create a graph the graph does not show. ?? Is there any code I need to add to my report.asp?

I am using Ver 2.0.0.436

<%

If Session("UserName")="" Then
Response.Redirect "login.asp"
End If

Dim objWiz
Set objWiz = Server.CreateObject("AspWebSolution.ReportWizard2")

With objWiz
.LincenseKey = "ABCD-EFGH-IJKL-MNOP"
If CBool(Session("IsAdmin")) Then
.IsAdmin = True
Else
.CanAdd = CBool(Session("CanAdd"))
.CanEdit = CBool(Session("CanEdit"))
.CanDelete = CBool(Session("CanDelete"))
End If

If Session("Departments")<>"" Then
.UseReports = Session("Departments")
End If

If CBool(Session("UseImages")) Then
.LocaleFile = "locale/locale_img.xml"
Else
.LocaleFolder = "locale"
.AutoDetectLocale = True
End If

.ImagesUrl = "images"
.Title = "ACME Reporting Solution"
.HideProcedures = True
.ReportsFile = Server.MapPath("../data/team6.xml")
'.Width = "90%"
End With

'Make sure you initialize before adding any HTML text
objWiz.Init("Provider=MSDASQL;Driver={SQL Server};" & _
"Server=Server1;Database=database;" & _
"User ID=test;Password=test;")

%>

<html>
<head>
<title>Advanced Reporting</title>
</head>
<body scroll="auto">
<div align=left style="font-size:16pt;">
<%=Session("team")%><font color=BLUE face=tahoma>TEAM 6</font></a>
</div>
<div align=right style="font-size:8pt;">
<a href="default.asp"> <font color=gray face=tahoma>Logout (<%=Session("UserName")%>)</font></a>
</div>
<%
'put this where you want your reports
objWiz.DisplayReports

%>

</body>
</html>

<%
Set objWiz = Nothing
%>

Aug 31 2004, 7:15 PM

Re: simple Graph

whichman

from: Laurel, MD See me your source code so I can make sure everything is OK

-------------------------
Master of the Game

Sep 14 2004, 1:15 PM

Re: simple Graph

Darin

from: Conway, AR I'm having trouble getting a graph to display as well. Was there a resolution to this problem?

Sep 14 2004, 1:41 PM

Re: simple Graph

ghost

from: Washington, DC I'm not sure by what you mean - is the it the HTML that is out of sync ... can you send me a screen shot!

-------------------------
Ghost

Sep 14 2004, 1:47 PM

Re: simple Graph

Darin

from: Conway, AR There is no graph displaying at all, and no error message either.

Sep 14 2004, 2:02 PM

Re: simple Graph

ghost

Send this author a private message

Visit author's homepage

from: Washington, DC

Try this let me know if you see anything:

<%

'declare variables
  Dim objGraph

' Create an instance of SimpleGraph
  Set objGraph = Server.CreateObject("AspWebSolution.SimpleGraph")

  With objGraph
     'Add some data
     Call .AddRowData("Kevin Garnett","35, 40")
     Call .AddRowData("Tracy McGrady","51, 52")
     Call .AddRowData("Allen Iverson","50, 58")
     Call .AddRowData("Jason Kidd","35, 43")

    'Add some variables
    .XScaleValues = "2003-04 Highs, Career Highs"
    .xALign = "center"
    .yLabel = "PPG"
    .Title = "NBA Season Highs / Career Highs"

    'Space the groups
    .Spacing = 10

    'You can chage the colors if you want
    '.Colors = "green,  red,  yellow,  blue,  orange,  fuchsia"
  End  With

'Draw your graph
objGraph.Draw

  Set objGraph =  Nothing

%>

-------------------------
Ghost

Sep 14 2004, 2:09 PM

Re: simple Graph

Darin

from: Conway, AR I may be confusing you, I am trying to create graphs from within the asp report wizard. Here's the weird part. I have 2 sql server databases which are identical as far as the structure goes (tables, views being used by report wizard are identical save for the actual data). Using the same reports.xml file, the graph shows up for 1 database, but not for the other.

Sep 15 2004, 5:37 AM

Re: simple Graph

ghost

from: Washington, DC Make sure that the graph's datasource fields are of numeric type.

Also, try creating an aggregate (GROUP BY) report from this database that does not display graphs and let me know what happens.

-------------------------
Ghost

Sep 15 2004, 8:49 AM

Re: simple Graph

Darin

from: Conway, AR I tried using the group by, no luck there either.

I have packaged up a sql server backup file of the database. Is there a place I could upload it for you to look at?

Sep 15 2004, 11:36 AM

Re: simple Graph

ghost

from: Washington, DC Make sure you post it to this url before the end today

http://www.cityjams.com/uploads/

-------------------------
Ghost

Sep 15 2004, 12:15 PM

Re: simple Graph

Darin

from: Conway, AR Ok, it's there. Thanks.

Sep 15 2004, 12:23 PM

Re: simple Graph

ghost

from: Washington, DC I can't seem to find any new file - what is the file name?

-------------------------
Ghost

Sep 15 2004, 12:25 PM

Re: simple Graph

Darin

from: Conway, AR seaswebdemo.9.14.2004.zip

Sep 15 2004, 1:01 PM

Re: simple Graph

ghost

from: Washington, DC can you try uploading it again. It isn't there.

-------------------------
Ghost

Sep 15 2004, 1:11 PM

Re: simple Graph

Darin

from: Conway, AR Ok, I uploaded it again. I thought the filename may have been giving it trouble so I called it seasweb.zip this time.

Sep 15 2004, 1:36 PM

Re: simple Graph

ghost

from: Washington, DC still nothing.

note: after you upload your file, make sure it has been uploaded by trying to download it as shoown on the link below:

http://www.cityjams.com/uploads/uploads/temp.xml

http://www.cityjams.com/uploads/uploads/seasweb.zip

-------------------------
Ghost

Sep 15 2004, 1:42 PM

Re: simple Graph

Darin

from: Conway, AR Are there filesize restrictions? My file is about 5mb.

Sep 15 2004, 1:46 PM

Re: simple Graph

ghost

from: Washington, DC Note sure!
Anyway, export the tables concerned to a blank database, backit up and try uploading a copy

-------------------------
Ghost

Pages: (1) [1]