AspWebSolution Forums » Products » ASP Report Wizard (version 1)

index | search | no replies | posting guidelines | help

» »

:: Row Customization :: (9)

Post a New Message | Post a Reply

Nov 10 2003, 10:42 AM

Row Customization

Post a Reply

sumomedia

since: Nov 7, 2003
from: MIami

I see this has been answered in a few posts. But I'm not sure if this is supposed to work in the free version. I tried adding the style attibutes in the default.asp, but it was ineffective.

Does this mean I need to create a style sheet for the project? Can I get more detailed info on how to do row customizations?

Rene

Nov 11 2003, 7:44 AM

Re: Row Customization

Post a Reply

Ghost

from: Washington, DC

Currently the report wizard supports only basic css classes for grid rows. This was mean to keep the overall HTTP POST size at a minimum. Version 2 should be relatively more flexible.

If you need something specific, let us know maybe we can show you how to implement it using cascading styleshets.

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

Nov 11 2003, 3:57 PM

Re: Row Customization

Post a Reply

sumomedia

since: Nov 7, 2003
from: MIami

Thank you! That would be very helpful. I tried putting a link to a style sheet in the default.asp and it didn't work. If you teach me how to edit these rows, I would appreciate it. I merely want to add colors and specify font attributes to make it easier to read.

Nov 12 2003, 8:47 AM

Re: Row Customization

Post a Reply

Ghost

from: Washington, DC

Paste the code below into the style section of your report page. It should help you understand the basic style classes.

copy the following code into your .asp file
It might help you understand how to cutomize your reports.

<style>
/*background (line) color*/
.report-table{
    background-color:red;
}

/*header row background color*/
.header-row{
    background-color:black;
}

/*header row text style*/
a.col-header{
    color:aqua;
    font-family:arial;
    text-decoration:none;
}
a.col-header:visited{
    color:aqua;
    font-family:arial;
    text-decoration:none;
}
a.col-header:hover{
    color:lime;
    font-family:arial;
    text-decoration:underline;
}

/*odd row background color*/
.odd-row{
    background-color:blue;
    color:yellow;
    font-family:tahoma;
    font-style:italic;
    font-weight:bold;
}

/*even row background color*/
.even-row{
    background-color:yellow;
    font-family:courier sans ms;
    font-wieght:bold;
    color:blue;
}
</style>

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

Nov 13 2003, 8:55 AM

Re: Row Customization

Post a Reply

sumomedia

since: Nov 7, 2003
from: MIami

Tried that before, with no success.

But just to confirm:

When you say report page, you mean the xml page? I ask because there is no "styles" section as you mentioned.

When you say asp page do you mean the default.asp?

Just a note: I have the free dll verion of the program.

Rene

Nov 13 2003, 10:48 AM

Re: Row Customization

Post a Reply

Ghost

from: Washington, DC

Sorry, I actually meant the asp page.

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

Nov 13 2003, 3:12 PM

Re: Row Customization

Post a Reply

sumomedia

since: Nov 7, 2003
from: MIami

No going yet...
OK, this is my asp page now:

<style>
/*background (line) color*/
.report-table{
     background-color:red;
}

/*header row background color*/
.header-row{
     background-color:black;
}

/*header row text style*/
a.col-header{
     color:aqua;
     font-family:arial;
     text-decoration:none;
}
a.col-header:visited{
     color:aqua;
     font-family:arial;
     text-decoration:none;
}
a.col-header:hover{
     color:lime;
     font-family:arial;
     text-decoration:underline;
}

/*odd row background color*/
.odd-row{
     background-color:blue;
     color:yellow;
     font-family:tahoma;
     font-style:italic;
     font-weight:bold;
}

/*even row background color*/
.even-row{
     background-color:yellow;
     font-family:courier sans ms;
     font-wieght:bold;
     color:blue;
}
</style>

<%

Dim objReport, strConnectionString
Set objReport = Server.CreateObject("AspWebSolution.ReportWizard")

'TODO: Change the following connection string to reflect your 'database location
'strConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("../oms.mdb")
strConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=H:/hshome/omsdelad/omsdelivery.com/asp/oms.mdb"

'NOTE:
'You must call the Init procedure before adding any HTML Tags/Text into your page
objReport.Init(strConnectionString)

objReport.DisplayReports
Set objReport = Nothing

%>

Nov 13 2003, 4:13 PM

Re: Row Customization

Post a Reply

Ghost

from: Washington, DC

Try the code below

<%

Dim objReport, strConnectionString
Set objReport = Server.CreateObject("AspWebSolution.ReportWizard")

'TODO: Change the following connection string to reflect your 'database location
'strConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("../oms.mdb")
strConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=H:/hshome/omsdelad/omsdelivery.com/asp/oms.mdb"

'NOTE:
'You must call the Init procedure before adding any HTML Tags/Text into your page
objReport.Init(strConnectionString)

%>

<style>
/*Tables' listing styles*/

A
{
    COLOR: #0000ff;
    TEXT-DECORATION: none;
}
A:visited
{
    COLOR: #0000ff;
    TEXT-DECORATION: none;
}
A:active
{
    COLOR: #0000ff;
    TEXT-DECORATION: none;
}
A:link
{
    COLOR: #0000ff;
    TEXT-DECORATION: none;
}
A:hover
{
    COLOR: #990033;
    TEXT-DECORATION: underline;
    /*background-color:aqua;*/
}

/*Delete button*/
.delete{
            FONT-SIZE: 11px;
            FONT-WEIGHT:BOLD;
            COLOR: red;
            FONT-FAMILY:  Verdana, Arial;
            TEXT-DECORATION: none;
        }

/*report header*/
.header{
            font-weight:bold;
            font-size:13px;
            font-family:arial;
            color:black;
        }


/*background (line) color*/
.report-table{
     background-color:black;
}

/*header row background color*/
.header-row{
     background-color:olive;

}

/*header row text style*/
.col-header{
     color:white;
     text-decoration:none;
     font-size:10pt;
}
a.col-header{
     color:white;
     font-family:arial;
     text-decoration:none;
     font-size:10pt;
}
a.col-header:visited{
     color:white;
     font-family:arial;
     text-decoration:none;
     font-size:10pt;
}
a.col-header:hover{
     color:white;
     font-family:arial;
     text-decoration:underline;
     font-size:10pt;
}

/*generic style*/
TD {
    FONT-SIZE: 8pt; VERTICAL-ALIGN: top; COLOR: #000000; FONT-FAMILY: Verdana, Arial, Helvetica, sans-serif
}

/*odd row background color*/
.odd-row{
     background-color:#cccc99;
     color:black;
     font-family:verdana;
     font-size:8pt;
}

/*even row background color*/
.even-row{
     background-color:white;
     font-family:verdana;
     color:black;
     font-size:8pt;
}

/*input text-box style*/
INPUT.report{
            border:1px solid gray;
            font-size:9px;
            font-family:tahoma;
            padding:0px;
            text-align:center;
        }
</style>

<%

objReport.DisplayReports
Set objReport = Nothing

%>

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

Nov 14 2003, 5:12 AM

Re: Row Customization

Post a Reply

sumomedia

since: Nov 7, 2003
from: MIami

Thanks! Working well now. If I come up with something nice I'll email it over to you...

Rene

Pages: (1) [1]