Hi, I am working on an aspx file which uses css. It displays fine in IE but not in Safari, Chrome, Firefox etc. I am trying to get my head around it but all in vain.. When it get displayed in other browsers all the li jumps to the right only displaying only half of each li. What i think is the width(eg : width :67px for li.studylink a:active) given in the css is not being identified by other browsers. It would be very helpful if someone could help me sort it out. I am posting my html contents and css which doesn't gets displayed right. Thanks in advance. Payal CSS ----

.HeaderMenu ul {float:right;height:20px;font-size:6pt;padding-top:2px;}
.HeaderMenu li {display:inline;font-family:arial,arial,sans-serif;font-size:6pt;height:20px;padding:0 0 0 15px; }
li.studylink a:link, li.studylink a:visited, li.studylink a:active {background-image:URL(/Test/Images/studylinkoff.jpg);background-repeat:no-repeat;background-position:left center;width:67px;vertical-align:middle;padding:6px 5px 7px 23px;color:#000;text-decoration:none;height:100%; }
li.studylink a:hover {background-image:URL(/Test/Images/studylinkon.jpg);background-repeat:no-repeat;background-position:left center;color:#000;text-decoration:none;height:100%; }
li.home a:link, li.home a:visited, li.home a:active {background-image:URL(/Test/Images/home_off.gif);background-repeat:no-repeat;background-position:left center;width:67px;vertical-align:middle;padding:6px 5px 7px 23px;color:#000;text-decoration:none;height:100%; }
li.home a:hover {background-image:URL(/Test/Images/home_on.gif);background-repeat:no-repeat;background-position:left center;color:#000;text-decoration:none;height:100%; }
li.print a:link, li.print a:active, li.print a:visited {background-image:URL(/Test/Images/print_off.gif);background-repeat:no-repeat;background-position:left center;width:80px;vertical-align:middle;padding:6px 5px 7px 23px;color:#000;text-decoration:none;height:100%; }
li.print a:hover {background-image:URL(/Test/Images/print_on.gif);background-repeat:no-repeat;background-position:left center; color:#000;text-decoration:none;height:100%; }

HTML ------

<table border="0" cellspacing="0" cellpadding="0" width="770" height="70">
<tr>
<td>
<A id="a1" href="/Test/Info/Information/HomePage.aspx" runat=&q

Thank you Holmes.

Hi, I am working with an SSIS package(2005), which dumps records from a csv file into TABLE1. After making some alterations to thses records, it is gain inserted into another TABLE2 in the DB. One of the columns is a date column. TABLE2 has all the datatypes fixed and it has a col with datatype "smalldatetime". TABLE1 is created each time the package is run. So at first i made the TABLE1.Rdate col datatype datetime but when i try converting this col to smalldatetime for inserting into TABLE2 it gives an error "The conversion of a datetime data type to a smalldatetime data type resulted in an out-of-range datetime value." I tried changing the date col datatype to VARCHAR but again at the time of converting this col to smalldatetime for inserting into TABLE2 it gives an error "The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.". The date in the TABLE1.Rdate col is in the format '2009-10-13'. Can anyone help me with this Please? Thanks & regards, Payal

Hi, I am using SQl 2005 for setting up a job which has 2 steps:- Step 1: Executes a SP which sends out result to a file Type : T-SQL Command : DECLARE @cmd varchar(2000), SET @cmd = 'osql -E -S CONDOR -s";" -w2000 -d Arion -Q"EXEC dbo.ENRSP_Applicants" -o D:\Applicants.txt' EXEC master..xp_cmdshell @cmd Step 2: Mailing the txt file to the user Type : Operating System(CmdExec) Command : "D:\MSSQL\JOBS\EmailFile.cmd" D:\Applicants.txt aa@yahoo.com ss@yahoo.com "Applicants Report" This works fine but the user want some modification to the current Job * the email subject to include the date also * Wants the result set to be dumped into a CSV file and to attach the file to the mail * Can you also tell me how to include a message to the mail plz? I know its easy to get this all done using a SSIS but Can these be done using an SQL Job , if so can you plz help me with it? Thanks in advance. Warm regards, Payal

modified on Thursday, September 24, 2009 11:10 PM

Can you tell me how to proceed(Using SQL job) with a CSV file please? Thanks & regards Payal

Hi, I am using SQl 2005 for setting up a job which has 2 steps:- Step 1: Executes a SP which sends out result to a file Type : T-SQL Command : DECLARE @cmd varchar(2000), SET @cmd = 'osql -E -S CONDOR -s";" -w2000 -d Arion -Q"EXEC dbo.ENRSP_Applicants" -o D:\Applicants.txt' EXEC master..xp_cmdshell @cmd Step 2: Mailing the txt file to the user Type : Operating System(CmdExec) Command : "D:\MSSQL\JOBS\EmailFile.cmd" D:\Applicants.txt aa@yahoo.com ss@yahoo.com "Applicants Report" This works fine but the user want some modification to the current Job * the email subject to include the date also * Wants the result set to be dumped into an Excel file and to attach the file to the mail, if there is no results returned no file should be atached * If the Sp doesn't return a result set she wants a message and if it does she wants the message to be another which includes date also. Can all these be done , if so can you plz help me with it? Thanks in advance. Warm regards, Payal

Hi All, I have 2 reports, one a main report and the other a subreport. My question is, Will i be able to change or refer to a control(item) in the main report depending on the value of an item in the subreport, when the subreport is being run? If yes how? Any comments are appreciated. Thanks in advance. Payal

Thanks Paul :) . Can this property be checked from the main report? I don't know how to refer the subreport from the main report...Like ReportItems!txtbox1 is there options for referring to a subreport also? It will be really helpful if u could help me out with some examples as i am coming across this for the first time. Cheers Payal

Hi All, I have a table report which has 10 fields as cols.The last 2 fields come from 2 diffrent subreport, having a single field each. There are also 2 groups in this table. I have to limit the rows by checking each cell in a group is 0. If all the cells have got a 0 then hide the row. I can check for all the cells except the last 2(Subreport). Since the last 2 cells has only got 2 subreports instead of a textbox, as it is the case for the remaining 8 cells, i don't know how to check for data returning from a subreport. For all the other textboxes i have checked it as ReportItems!textbox1.value=0 Can anyone help me with this Please? Thanks & Regards, Payal

Thanks I found out out how to go about it. Payal

The Class field has 3 static values Class1 Class2 Class3. If Class was a single dataset then only Year and class could be set as Column grouping. Can u plz explain how to go about in the case where i have 3 different static values for the class? Thanks Payal

Hi, I need to have a Matix report which looks like : ...............|YEARS -------------------------------- ...............|Class1|Class2|Class3 Programme|StudNo|StudNo|StudNo ie; The Matix will look like this Programme|.......2001.................|........2002............|. ------------------------------------------------------------------------ ..............|Class1|Class2|Class3|Class1|Class2|Class3|..... IT...........|..23...|...24..|..45....|..12...|..23...|..12..|..... MBA........|..34...|...12..|..12....|..31...|..13...|..14..|..... I don't know how to split the YEARS' column into 3 different subcolumns which has got class1,class2,class3.Each year has got the 3 different staic classnames. Under that the no of students in each class comes. The students in each class in each year should be calculated based on some condition. Its not available directly from a dataset. Hope u can understand the matix. PLEASE HELP!!! :sigh: Thanks & regards, Payal

modified on Thursday, March 6, 2008 8:38 PM

Hi, I am working with SSRS matrix Control. I have the column header--Year,Row Header--Programme & data--No of students YEAR --------------------- PROGRAMME | No OF STUDENTS The Matrix control displays all the years as columns which i have in the dataset. I have tried hiding the columns which has year values <2005 by giving a condition in the Hidden ppty of that cell. It does work leaving blank spaces between the columns. Can anyone tell me how to getrid of the blank spaces between the columns or how to delete the columns of a Matrix based on a condition ? Thanks & Regards, Payal

Hi, I am woking with SSRS Matrix Control. I have the column header -- year, Row--Programme and Data -- No of Students. YEAR ---------------- PROGRAMME | NO OF STUDENTS The Matrix will display all the years as columns which i have in the dataset. I have tried hiding the colums by giving a condition in the Hidden property. It does work leaving blank spaces between the columns. Can anyone tell me How to getrid of the blank spaces between the colums or how to delete the colums of a Matix based on a condition Please? Thanks & regards, Payal

Hi, I am trying to generate a report which has 10 parameters. All the parameters are set using the Report parameter option in The Report menu. When the report starts processing i want a msgbox which asks "Do U want to change any Parameter values" If yes then i need the report to stop rendering Else continue with the processing. I 've got the Msgbox done but i don't know how to stop rendering the report. Plz Help? Thanks & regards, Payal

Hi All, I have got some web pages which can be seen properly (with the style sheets applied to the page's contents) from the domain i am working on. But when others from a different domain or when accessed from anywhere else, the page seems to be missing its style sheet.:confused: Can anyone please suggest some possible solutions so that i can try it out to tackle this? :sigh: Thanks & Regards, Payal

Thanks for the reply. I will try it out.

Hi Colin, I was being given this table(Built by somebodyelse) to get the specified result. Thanks. Payal

Hi All, I have a Student table which has 3 fileds:- ID Name PartNo ---------------------- 1 Smith 3 1 Adam 1 1 Samuel 3 2 Gary 1 2 Johnson 2 3 Immanuel 4 3 Ryan 2 3 Irene 1 3 Pete 5 My problem is i need to group students based on IDs and the Name need to be a concatenation of names based on the PartNo in ascending order. The O/p need to be like:- ID Name --------------------------- 1 Adam Smith 2 Gary Johnson 3 Irene Ryan Immanuel Pete I am working with SQL 2000. Hope somebody can help me sort this out. Thanks In Advance. Payal:) -- modified at 22:57 Wednesday 17th October, 2007