| :: Miscallaneous Revisited :: (5) | Post a New Message | Post a Reply |
 Miscallaneous Revisited | Post a Reply |
since: Mar 27, 2005
from: Maryland
I will have to report this bug. I should have a fix by next week
[joe] Many thanks
2. Is there a way for me to format the table display page to make it look a bit more like my site. Right now I get a list of tables ad reports and want to format it differently. Also, is it possible to change links, such as the print link, to a button?
The report's fonts and color settings can be formatted by editing the ReportsFile. For more information check the following online manuals
1. Colors & Font Settings
2. Localization and Multilingual Data Support
[joe] I was hoping for more formatting options than colors.
3. 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
4. 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
5. At report runtime there is a filter textbox at the top of the report but is there a way to set two parameter such as between dates to recapture between dates? Idealy, it would be nice to to filter on one item and then between dates. This would save having to write many reports with different between dates and or having to edit a report to change the between dates.
The current version of the report wizard only supports simple filters when in user mode. However, this same task can be archived by settings two filters or using pop-up filters
For more information see Filtering Your Report
[joe] I have two filters set up but have not tried popup filters. I'll play with that.
******* 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)
%>
******* REPORT SETUP END ********
 Re: Miscallaneous Revisited | Post a Reply |
from: Washington, DC
2. Localization and Multilingual Data Support
[joe] I was hoping for more formatting options than colors.
Can you be more specific?
******* 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)
%>
******* REPORT SETUP END ******** Can you show me the complete source code of your ASP page! the code above is not complete. Where do you display your reports?
-------------------------
Ghost
| Re: Miscallaneous Revisited | Post a Reply |
since: Mar 27, 2005
from: Maryland
2. Localization and Multilingual Data Support
[joe] I was hoping for more formatting options than colors.
Can you be more specific?
[Joe] This is certainly not a show stopper be any means. But, the current screen is a tad sterile.Perhaps more control over table layout, placement of groups and controls might let each installation add their own specific look and feel. Again, not a show stopper and only an observation.
*********** DEFAULT.ASP ***********************
Can you show me the complete source code of your ASP page! the code above is not complete. Where do you display your reports?
************ HERE IT IS ************
<%
Dim objWiz
DIM today
Set objWiz = Server.CreateObject("AspWebSolution.ReportWizard2")
With objWiz
.LincenseKey = "MYLICENSE"
.DatabaseType = 3 'FOXPRO
.DefaultDateFormat = "DD/MM/YY"
.StyleSheet = "styles.css"
.ImagesUrl = "images"
.Title = "REPORT WRITER"
.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;"
objWiz.UsePopupFilters = True
objWiz.Init(strConn)
%>
<HTML>
<HEAD>
<TITLE>Report Writer</TITLE>
<LINK rel='stylesheet' href='../stylesheets/pbsstyles.css' TYPE="text/css">
</HEAD>
<BODY TOPMARGIN="0" LEFTMARGIN="0" BGCOLOR="#D1E5F3">
<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%">
<%
'put the next two lines where you want your reports to show up.
objWiz.DisplayReports
Set objWiz = Nothing
%>
</TD>
</TR>
</TABLE>
</BODY>
</HTML>
 Re: Miscallaneous Revisited | Post a Reply |
from: Washington, DC
try using a different browser such as firefox just to make sure that it is not being caused by your cache.
<%
Dim objWiz
DIM today
Set objWiz = Server.CreateObject("AspWebSolution.ReportWizard2")
With objWiz
.LincenseKey = "MYLICENSE"
'.DatabaseType = 3 'FOXPRO
.DefaultDateFormat = "DD/MM/YY"
.StyleSheet = "styles.css"
.ImagesUrl = "images"
.Title = "REPORT WRITER"
.PrintHeader = "<div align='CENTER'>My Header</div>"
.PrintFooter = "<p align='center'>MY FOOTER</p>"
.Width = "100%"
End With
dim strConn
strConn = "DRIVER={Microsoft Visual FoxPro Driver};" & _
"SourceDB=C:\Program Files\Microsoft Visual Studio\Vfp98\demos\databases\nwind\nwind.dbc;" & _
"SourceType=DBC;Exclusive=No;" ' "Provider=VFPOLEDB.1;Password=; Data Source=C:\Program Files\Microsoft Visual Studio\Vfp98\demos\databases\nwind\nwind.dbc; Collating Sequence=MACHINE;"
objWiz.UsePopupFilters = True
objWiz.Init(strConn)
%> -------------------------
Ghost
| Re: Miscallaneous Revisited | Post a Reply |
since: Mar 27, 2005
from: Maryland