AspWebSolution Forums » Products » ASP Report Wizard v2 » Recap of previous post for response

index | search | no replies | posting guidelines | help

login | register

» »

:: Recap of previous post for response :: (2)

Post a New Message | Post a Reply

Apr 19 2005, 5:00 PM

Recap of previous post for response

Goldestates

since: Mar 27, 2005
from: Maryland 1. When I get the first screens listing all the tables in the DBC, the views are not listed. How do I get the views in the display?

I will have to report this bug. I should have a fix by next week
[joe] Any news on this change?

2. When I run a report it comes up 100% left to right as needed. When I press the Print link it comes up 1/4 page wide. Is it possible to widen output in the print screen?

- Make sure that there is no HTML text before you initialize your connection string
[joe] See setup at end of message for details.

3. When sending a report to DOC, Text, Excel, etc I get a doc not found error. There must be a path setting somewhere. Where might it be please?
- Make sure that there is no HTML text before you initialize your connection string
- Make sure that your temp folder is not full.
[joe] It's empty and see setup at end of message for details.

******* REPORT SETUP ********
<%
Dim objWiz
DIM today
Set objWiz = Server.CreateObject("AspWebSolution.ReportWizard2")

With objWiz
.LincenseKey = "ERASED FOR PRIVACY"
.DatabaseType = 3 'FOXPRO
.DefaultDateFormat = "DD/MM/YY"
.StyleSheet = "styles.css"
.ImagesUrl = "images"
.Title = "PBS Web Cases"
.PrintHeader = "<div align='CENTER'>My Header</div>"
.PrintFooter = "<p align='center'>© My Footer</p>"
.Width = "100%"
End With

Set objGrid = Server.CreateObject("AspWebSolution.SimpleGraph")
strConn = "Provider=VFPOLEDB.1; Data Source=C:\inetpub\wwwroot\refer\pglaw\pbscases.dbc; Collating Sequence=MACHINE;"
objWiz.Init(strConn)
%>
<HTML>
<HEAD>
<TITLE></TITLE>
<LINK rel='stylesheet' href='../stylesheets/pbsstyles.css' TYPE="text/css">
</HEAD>

<BODY TOPMARGIN="0" LEFTMARGIN="0" BGCOLOR="#FFFFFF">
<TABLE width='100%' CELLPADDING="0" CELLSPACING="0">
<TR>
<TD CLASS=PBSfields1 WIDTH="100%">
<B><CENTER><FONT>
Report Writer
</FONT></CENTER></B>
</TD>
</TR>
<TR>
<TD WIDTH="100%">
<%
objWiz.DisplayReports
Set objWiz = Nothing
%>
</TD>
</TR>
</TABLE>
</BODY>

</HTML>
******* REPORT SETUP END ********

Apr 22 2005, 12:25 PM

Re: Recap of previous post for response

ghost

Send this author a private message

Visit author's homepage

from: Washington, DC

Hello Golden States. - sorry for the late reply
1. When I get the first screens listing all the tables in the DBC, the views are not listed. How do I get the views in the display?

This bug has been fixed in the current version v2.5.17

2. When I run a report it comes up 100% left to right as needed. When I press the Print link it comes up 1/4 page wide. Is it possible to widen output in the print screen?

- Make sure that there is no HTML text before you initialize your connection string
This bug was fixed later today after I had already published the latest version. The fix will be available in the next minor release due before the end of next week.

3. When sending a report to DOC, Text, Excel, etc I get a doc not found error. There must be a path setting somewhere. Where might it be please?
- Make sure that there is no HTML text before you initialize your connection string
- Make sure that your temp folder is not full.
try using a different browser such as FireFox just to make sure it is not being caused by Internet Explorer.

These results were tested using the code below:

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

  With objWiz
     .LincenseKey = "ERASED FOR PRIVACY"
     .DatabaseType = 3 'FOXPRO
     .DefaultDateFormat = "DD/MM/YY"
     .StyleSheet = "styles.css"
     .ImagesUrl = "images"
     .Title = "PBS Web Cases"
     .PrintHeader = "<div align= 'CENTER'>My Header</div>"
     .PrintFooter = "<p align= 'center'>© My Footer</p>"
     .Width = "100%"
  End  With

'strConn = "Provider=VFPOLEDB.1; Data Source=C:\inetpub\wwwroot\refer\pglaw\pbscases.dbc; Collating Sequence=MACHINE;"

strConn = "DRIVER={Microsoft Visual FoxPro Driver};"& _
     "SourceDB=C:\Program Files\Microsoft Visual Studio\Vfp98\demos\databases\nwind\nwind.dbc;"& _
     "SourceType=DBC;Exclusive=No;"

objWiz.Init(strConn)
%>
<HTML>
<HEAD>
<TITLE></TITLE>
<LINK rel= 'stylesheet' href= '../stylesheets/pbsstyles.css' TYPE= "text/css">
</HEAD>

<BODY TOPMARGIN= "0"LEFTMARGIN= "0"BGCOLOR= "#FFFFFF">
<TABLE width= '100%' CELLPADDING= "0" CELLSPACING= "0">
     <TR>
         <TD CLASS=PBSfields1 WIDTH= "100%">
             <B><CENTER><FONT>
             Report Writer
             </FONT></CENTER></B>
         </TD>
     </TR>
     <TR>
         <TD WIDTH= "100%">
             <%
             objWiz.DisplayReports
              Set objWiz =  Nothing
             %>
         </TD>
     </TR>
</TABLE>
</BODY>

</HTML>

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

Pages: (1) [1]