need steps to modify the CSS for viewer/ toolbar

I want to use the CSS stylesheet to modify the viewer/ toolbar.
This may be a dumb question, but can anyone please tell me:
What are the steps to modify the CSS?
Also - please tell me what kind of things I can do with it?
I have been trying to open the CSS in a text editor and playing with
it, with limited success and limited vision of what can be done.
ThanksHere is a little more specific question:
All the properties regarding parameters I see in the CSS are as below.
I want to change the font size of the parameter prompt, and I would
like to put 3 in a row instead of 2. Is that possible?
Actually - I would like to some more... but even if the above is
possible, it would be helpful. Thx
.ParametersFrame
{
border-bottom: 1px darkgray solid
}
.ParamLabelCell
{
padding: 10px;
padding-right: 5px;
vertical-align: baseline
}
.ParamEntryCell
{
padding: 1px;
vertical-align: baseline
}
.ParamsGrid
{
margin: 0px;
padding: 1px
}
.InterParamPadding
{
padding-left: 1px
}|||hey,
ok, sorry to hijack your question, but I am wondering about the same
thing. Something else I'd like to do is add to the toolbar if
possible. For a parameter textfield for a date say, I'd like to place
a calandar control if possible...
Anyone know if it's possible to get at the code for the control
somewhere and hack at it there to make personalised changes?
Also, something else that might sound silly but - even as the report
is being generated there is an animated gif. Anyone know how to
change that?
Thanks...
creative@.mailcity.com (Harsh) wrote in message news:<fa671a26.0408282005.4829c524@.posting.google.com>...
> Here is a little more specific question:
> All the properties regarding parameters I see in the CSS are as below.
> I want to change the font size of the parameter prompt, and I would
> like to put 3 in a row instead of 2. Is that possible?
> Actually - I would like to some more... but even if the above is
> possible, it would be helpful. Thx
>
> .ParametersFrame
> {
> border-bottom: 1px darkgray solid
> }
> .ParamLabelCell
> {
> padding: 10px;
> padding-right: 5px;
> vertical-align: baseline
> }
> .ParamEntryCell
> {
> padding: 1px;
> vertical-align: baseline
> }
> .ParamsGrid
> {
> margin: 0px;
> padding: 1px
> }
> .InterParamPadding
> {
> padding-left: 1px
> }|||Still no answers... neither to my question nor to yours.
Maybe there is no way of hacking into the "parameter viewer" but can
anyone please explain what are the things I CAN achieve... with the
current functionality?
I have tried reading the SP1 readme but that does not seem to say
anything.
I want to know this before I decide on building my own viewer.
Thanks

need information for "Before Select" Trigger

hi guys!
Currently i'm facing a bit odd situation. i cant modify my code so i
have to make changes in SQL Server.

the problem is, i've modified one table by adding new column and now i
want only those row which has not null value in that column whenever
the select statement gets fire. i mean in every select statement only
those rows should be returned which has NOT NULL value in the newly
added column.

for this i've created one view and tried to run the application but the
i'm facing some problem as my application is developed in .net 2.0,
i've used lots of .net functionalities and now i cant make any changes
in Code.

another solution i think is triggers. if i can fire a trigger before
any select statements, my problem can be solved instantly but i'm
afraid i can not write andy "before select" trigger.

if anyone has any idea or any other solution to my problem, please let
me know.

all suggestions are welcomed.

thanks,
LuckyLucky (tushar.n.patel@.gmail.com) writes:
> Currently i'm facing a bit odd situation. i cant modify my code so i
> have to make changes in SQL Server.
> the problem is, i've modified one table by adding new column and now i
> want only those row which has not null value in that column whenever
> the select statement gets fire. i mean in every select statement only
> those rows should be returned which has NOT NULL value in the newly
> added column.
> for this i've created one view and tried to run the application but the
> i'm facing some problem as my application is developed in .net 2.0,
> i've used lots of .net functionalities and now i cant make any changes
> in Code.
> another solution i think is triggers. if i can fire a trigger before
> any select statements, my problem can be solved instantly but i'm
> afraid i can not write andy "before select" trigger.

There are no BEFORE SELECT triggers. (In fact, there are no BEFORE triggers
at all in SQL Server.)

The way to handle this would be define a view, which includs a filter on
this column.

However, personally, I would not add a view for such a simple condition,
but rather add it as needed.

If you real problem is that this table is referred to in lots of places
(lots => more than 20), and you want this column to take effect every
where, you could renamed the table, and then create a view with that
carries on the original name of the table.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||Hi Pal,
i did the same way but as i said i'm using .net 2.0's dataset which
seems doesnt understands the view. As i've added "Enforced Constraints"
in the Dataset, may be that could not allowed the View to be considered
with foriegn key, unique value, not null constraint.

to avoid this situation i need to some other way. and yes it is true.
i'm reffering it in more then 20 webpages so i cant modifiy it.

anyways thanks for help.

Lucky

Erland Sommarskog wrote:
> Lucky (tushar.n.patel@.gmail.com) writes:
> > Currently i'm facing a bit odd situation. i cant modify my code so i
> > have to make changes in SQL Server.
> > the problem is, i've modified one table by adding new column and now i
> > want only those row which has not null value in that column whenever
> > the select statement gets fire. i mean in every select statement only
> > those rows should be returned which has NOT NULL value in the newly
> > added column.
> > for this i've created one view and tried to run the application but the
> > i'm facing some problem as my application is developed in .net 2.0,
> > i've used lots of .net functionalities and now i cant make any changes
> > in Code.
> > another solution i think is triggers. if i can fire a trigger before
> > any select statements, my problem can be solved instantly but i'm
> > afraid i can not write andy "before select" trigger.
> There are no BEFORE SELECT triggers. (In fact, there are no BEFORE triggers
> at all in SQL Server.)
> The way to handle this would be define a view, which includs a filter on
> this column.
> However, personally, I would not add a view for such a simple condition,
> but rather add it as needed.
> If you real problem is that this table is referred to in lots of places
> (lots => more than 20), and you want this column to take effect every
> where, you could renamed the table, and then create a view with that
> carries on the original name of the table.
>
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/pr...oads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodin...ions/books.mspx|||Lucky wrote:
> Hi Pal,
> i did the same way but as i said i'm using .net 2.0's dataset which
> seems doesnt understands the view. As i've added "Enforced Constraints"
> in the Dataset, may be that could not allowed the View to be considered
> with foriegn key, unique value, not null constraint.
> to avoid this situation i need to some other way. and yes it is true.
> i'm reffering it in more then 20 webpages so i cant modifiy it.
> anyways thanks for help.
> Lucky

I don't think I understand what your problem is but you can obtain the
same effect as a "before" trigger by referring to the virtual table
called Deleted within the trigger. The Deleted table contains the state
of the changed rows before the statement was executed.

--
David Portas, SQL Server MVP

Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.

SQL Server Books Online:
http://msdn2.microsoft.com/library/...US,SQL.90).aspx
--|||Lucky (tushar.n.patel@.gmail.com) writes:
> i did the same way but as i said i'm using .net 2.0's dataset which
> seems doesnt understands the view. As i've added "Enforced Constraints"
> in the Dataset, may be that could not allowed the View to be considered
> with foriegn key, unique value, not null constraint.
> to avoid this situation i need to some other way. and yes it is true.
> i'm reffering it in more then 20 webpages so i cant modifiy it.

Looks like you have to modify 20+ web pages one way or another.

I don't really know how your .Net looks like, but permit me to point
out that had you retrieved the data with stored procedures, the change
would have been snap.

Then again, not even that should be necessary. Had you defined the
SelectCommand for the adapter in one place, it would also have been
a simple thing.

So when you modify your 20+ web pages, you strive to find a strategy
so that it does not happen again.

You may also want to visit microsoft.public.dotnet.framework.adonet for
better advice for the ADO .Net side of things.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

Need help with tsql script

I have a t sql script that works but i need to modify it to show the prvious years info can someone show me how to do this below is the code I have and it show this between defined dates I need it to show the yearbefore also

SELECT 'Quarter All' as 'qtr',
COUNT(JOB.JOBID) as 'transcount',
COUNT(DISTINCT JOB.PATIENTID) as 'patient count',
SUM(JOB.LANGUAGE_TCOST) as 'lcost',
SUM(JOB.LANGUAGE_DISC_COST) as 'dlcost',
AVG(JOB.LANGUAGE_DISC) as 'avgLDisc',
SUM(JOB.LANGUAGE_TCOST) + SUM(JOB.LANGUAGE_DISC_COST) as 'LGrossAmtBilled',
SUM(JOB.LANGUAGE_TCOST) / COUNT(DISTINCT JOB.PATIENTID) as 'PatAvgL',
SUM(JOB.LANGUAGE_TCOST) / COUNT(JOB.JOBID) as 'RefAvgL',
SUM(JOB.LANGUAGE_DISC) as 'avgPercentDiscL',
JOB.JURISDICTION,
PAYER.PAY_COMPANY,
PAYER.PAY_CITY,
PAYER.PAY_STATE,
PAYER.PAY_SALES_STAFF_ID,
JOB.INVOICE_DATE,
JOB.JOBOUTCOMEID,
JOB.SERVICEOUTCOME,
JOB.LANGUAGE_ID,
INVOICE_AR.INVOICE_NO,
INVOICE_AR.INVOICE_DATE AS EXPR1,
INVOICE_AR.AMOUNT_DUE,
INVOICE_AR.CLAIMNUMBER,
LANGUAGES.DESCRIPTION

FROM JOB
INNER JOIN INVOICE_AR
ON JOB.JOBID = INVOICE_AR.JOBID
LEFT OUTER JOIN PAYER
ON PAYER.PAYERID = JOB.PAYERID
LEFT OUTER JOIN STATES
ON JOB.JURISDICTION = STATES.INITIALS
LEFT OUTER JOIN LANGUAGES
ON JOB.LANGUAGE_ID = LANGUAGES.DESCRIPTION

WHERE
(INVOICE_AR.AMOUNT_DUE > 0)
AND
(INVOICE_AR.INVOICE_DATE BETWEEN @.startdate and @.enddate)
AND
(MONTH(INVOICE_AR.INVOICE_DATE) IN (1,2,3,4,5,6,7,8,9,10,11,12))
AND
(PAYER.PAY_COMPANY like '%' + @.Company + '%')


Group By
JOB.JURISDICTION,
PAYER.PAY_COMPANY,
PAYER.PAY_CITY,
PAYER.PAY_STATE,
PAYER.PAY_SALES_STAFF_ID,
JOB.INVOICE_DATE,
JOB.JOBOUTCOMEID,
JOB.SERVICEOUTCOME,
JOB.LANGUAGE_ID,
INVOICE_AR.INVOICE_NO,
INVOICE_AR.INVOICE_DATE,
INVOICE_AR.AMOUNT_DUE,
INVOICE_AR.CLAIMNUMBER,
LANGUAGES.DESCRIPTION
Order By 'QTR' asc

How do want to diplay the "Year before also"?You just run it for the previous year by changing the input dates,You could alias the table so you could select twice and join the second selection change (INVOICE_AR.INVOICE_DATE BETWEEN @.startdate and @.enddate)to (INVOICE_AR.INVOICE_DATE BETWEEN DATEADD(year, -1, @.startdate) and DATEADD(year, -1, @.enddate)and you can select two periods at once!|||How do want to diplay the "Year before also"?You just run it for the previous year by changing the input dates,You could alias the table so you could select twice and join the second selection change (INVOICE_AR.INVOICE_DATE BETWEEN @.startdate and @.enddate)to (INVOICE_AR.INVOICE_DATE BETWEEN DATEADD(year, -1, @.startdate) and DATEADD(year, -1, @.enddate)and you can select two periods at once!|||How do want to diplay the "Year before also"?You just run it for the previous year by changing the input dates,You could alias the table so you could select twice and join the second selection change (INVOICE_AR.INVOICE_DATE BETWEEN @.startdate and @.enddate)to (INVOICE_AR.INVOICE_DATE BETWEEN DATEADD(year, -1, @.startdate) and DATEADD(year, -1, @.enddate)and you can select two periods at once!|||

Try

SELECT 'Quarter All' as 'qtr',
COUNT(JOB.JOBID) as 'transcount',
COUNT(DISTINCT JOB.PATIENTID) as 'patient count',
SUM(JOB.LANGUAGE_TCOST) as 'lcost',
SUM(JOB.LANGUAGE_DISC_COST) as 'dlcost',
AVG(JOB.LANGUAGE_DISC) as 'avgLDisc',
SUM(JOB.LANGUAGE_TCOST) + SUM(JOB.LANGUAGE_DISC_COST) as 'LGrossAmtBilled',
SUM(JOB.LANGUAGE_TCOST) / COUNT(DISTINCT JOB.PATIENTID) as 'PatAvgL',
SUM(JOB.LANGUAGE_TCOST) / COUNT(JOB.JOBID) as 'RefAvgL',
SUM(JOB.LANGUAGE_DISC) as 'avgPercentDiscL',
JOB.JURISDICTION,
PAYER.PAY_COMPANY,
PAYER.PAY_CITY,
PAYER.PAY_STATE,
PAYER.PAY_SALES_STAFF_ID,
JOB.INVOICE_DATE,
JOB.JOBOUTCOMEID,
JOB.SERVICEOUTCOME,
JOB.LANGUAGE_ID,
I1.INVOICE_NO,
I1.INVOICE_DATE AS EXPR1,
I1.AMOUNT_DUE,
I1.CLAIMNUMBER,
I2.INVOICE_NO,
I2.INVOICE_DATE AS EXPR1,
I2.AMOUNT_DUE,
I2.CLAIMNUMBER,
LANGUAGES.DESCRIPTION
FROM JOB
INNER JOIN INVOICE_AR I1 ON JOB.JOBID = INVOICE_AR.JOBID
INNER JOIN INVOICE_AR I2 ON JOB.JOBID = INVOICE_AR.JOBID
LEFT OUTER JOIN PAYER ON PAYER.PAYERID = JOB.PAYERID
LEFT OUTER JOIN STATES ON JOB.JURISDICTION = STATES.INITIALS
LEFT OUTER JOIN LANGUAGES ON JOB.LANGUAGE_ID = LANGUAGES.DESCRIPTION
WHERE I1.AMOUNT_DUE > 0
AND (I1.INVOICE_DATE BETWEEN @.startdate and @.enddate)
AND (DATEADD(year, 1, I2.INVOICE_DATE) BETWEEN @.startdate and @.enddate)
AND (MONTH(I1.INVOICE_DATE) IN (1,2,3,4,5,6,7,8,9,10,11,12))
AND (PAYER.PAY_COMPANY like '%' + @.Company + '%')
Group By JOB.JURISDICTION, PAYER.PAY_COMPANY, PAYER.PAY_CITY, PAYER.PAY_STATE, PAYER.PAY_SALES_STAFF_ID, JOB.INVOICE_DATE, JOB.JOBOUTCOMEID, JOB.SERVICEOUTCOME,
JOB.LANGUAGE_ID, I1.INVOICE_NO, I1.INVOICE_DATE, I1.AMOUNT_DUE,I1.CLAIMNUMBER, LANGUAGES.DESCRIPTION
Order By 'QTR' asc