Search results for query: *

Yes, the feedback report is a separate report which gets email and ClassName as parameter from the main report. I did change the dataset source as Changed it from Query to stored procedure and the stored procedure returns correct rows when I pass email and name of all the classes but in the...

I am creating a report in SSRS 2008 R2. In the report, email and ClassName are the parameters and when a teacher enters his email, then based on this it will display all the Classes associated with that teacher. Now In the report based on the ClassSelected, it should all the information for the...

There are 45 companies and several employees works in each company. Each company has its unique code EX: AA11, AA12..so on Each emp has a unique id in 16 digit numeric format Now at a particular location, I have 45 folders for each company (starts with unique code) and each folder contains 2...

I have data in the following format in an excelspreadsheet in a workbook. Workbook1: Data Origin Type Sub-Type Score1 Score2 Score3 Total South Africa Apple Red Delicious 5 10 3 18 South Africa Apple Grany Smith 1.3 2.2 3.0 6.5 South Africa Apple Sweet Apple 2 1 4 7 South...

Thanks kdt82 for the links.Those are really helpful I was wondering can I use DDE to create Excel workbook with 50 tabs for each state? Thanks, Blyssz

Actually I need to create a pivot table in excel with the final dataset , so I need to create Month as a field variable that displays 1-6Mon,7-12Mon as data variables so that I can just drag the Month variable in the column field. The final dataset after transposing data look like State...

Thanks a lot kdt82. Is it possible to create Month variable for months batches as I want to create a pivot table in excel with the output dataset and it will be easier to arrange the months if there is a variable for that. Thanks, Blyssz

I have a dataset in the format : A1,A2,….A18,B1,B2…..B18, Mon1, Mon2.....Mon18 Mon 1 15.....13 25 27...34 2009-12 2009-11 2008-08 17 I need to sum up data in batches of 6 month in the format: 1-6Mon 7-12Mon 13-18Mon Total...

I have a dataset which contains State, Section and School Name and rest of the data. For 50 states, there are 45 schools and one school may have branches in one or more than one state with different sections. There are 4 sections: Primary, Secondary, Middle and Senior. Ex: School A can have...

My question is : For each type of color,I want to replace string var1, var2 as its color descriptors. like for type "Red" , I want to replace Var1 as Redcolor1, Var2 as RedColor2 and so on. It is possible to achieve this? Thanks Blyssz

Thanks Kdt82 for your response. I apologize for not explaining the problem clearly. Actually I have 39000 recurring rows for subjects, as shown below. Subject mon name1 name2 name3 Score1 Score2 Score3 Math 01-06 Mon Avi6 John6 Becky6 0 107.67 221.67 Math 07-12 Mon Avi12 John12 Becky 12 97...

Thanks a lot KDT82 for your response. I am new to SAS so please bear with me. The problem is that My Dataset consists of 3600 rows, and I already have dataset in the work directory in the given format. How Is it possible to create array of names and scores from the existing dataset? Thanks, Blyssz

Thank you FatCaptain for your response. After using proc transpose, I got the following format Subject Math mon 01-06mon 7-12mon 13-18mon Total Math score1 0 97 55 152 Math score2 107.67 102...

I have a table with a column name Type which contain several colors like Red, Green, Blue, White, Black etc. Another column has variable var1,….var10 and for each color group I want to label the variable accordingly. Type Variable RED Var1 RED Var2 RED Var3 RED Var4 RED...

Hello All, I want to change the format of the dataset: MY input dataset: Subject mon name1 name2 name3 Score1 Score2 Score3 Math 01-06Mon Avi6 John6 Becky6 0 107.67 221.67 Math 07-12Mon Avi12 John12 Becky12 97 102 200.46 Math 13-18Mon Avi18 John18 Becky18 55 114 211 Math Tot...

Thanks dblan for your response. I am trying to import pivot table data in PC SAS as I do not have access to actual source data for the pivot table report. I need to change format of the report, so want to create SAS dataset from pivot table. Thanks, Blyssz

Hi, I have a pivot table report and the output data for that report in MS excel. I was wondering if I can import that data into SAS to create a SAS Dataset so that I can change the format of that report. Thanks, Blyssz

I tried that but it did not work. Also I tried putting domain\username and pwd but that did not work either.

I created a report and want to deploy it to a folder in Report Manager but when I click deploy, It asks me for Reporting services login user name and Pwd and does not accepts anything. I have no idea what to put in. Please help. Thanks, Blyssz

Thanks to all. This issue is resolved now as I Turned on .Net framework but Now I am having another problem. I created a report In SSRS and want to deploy it to a folder in Report Manager but when I click deploy, It asks me for Reporting services login user name and Pwd and does not accepts...