| :: Miscellanious questions :: (3) | Post a New Message | Post a Reply |
 Miscellanious questions | Post a Reply |
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?
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?
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?
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?
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.
Thanks much,
Joe
 Re: Miscellanious questions | Post a Reply |
from: Washington, DC
I will have to report this bug. I should have a fix by next week
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
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
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.
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
Let me know if this information helps.
-------------------------
Ghost
| Re: Miscellanious questions | 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 ********