Search results for query: *

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...

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...

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...

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 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

I am trying to install SSRS 2005 on a report server and the database is on another server. I selected the components and installed them but did not do sharepoint integration. Now the problem is whenever I try to check the installation for report server and manager using...

I am an intermediate level access programmer, I have been using MS Access from the past few year and very new to SQL Server and now we are moving on to SQL Server 2005. I am trying to produce some reports in SQL Server 2005 but I have a very fundamental question. As we design forms and create...

I have a table in MS access that I want to link to SQL Server 2005 for reporting purposes. How do I do that??? Thanks, Blyssz

I have an excel spreadsheet named Employee with fields Name, DOJ, Salary and State. I want to dump the data into a MS access Temp-EmployeeData table from execl spreadsheet everyday so that I can create a report anytime needed for any date. I created Temp-EmployeeData table with EmpName as Text...

I am very new to the SQL Server so please bear with me. I have project server 2007 and I am building OLAP cube in SSAS through Project Server 2007 but when I actually check in SQL server, based on the cube dimension selected in project server it creates 14 cubes in the database: Assignment...

While trying to install Analysis, Reporting and Integration services for SQL Server 2005 and everything works okay except Reporting services. I tried to install default as well as named instance but getting the following error in both the cases: The Reporing Service Configuration manager Error...

I have data in the Excel 2007 spreadsheet which has been exported from MS Project Server 2003. I want to create a chart in Visio using excel data i.e. I want to read data from the excel spreadsheet and create Graphs and chart in Visio 2003. Is it possible to do that??? I am new to MS Visio...

Hello all, I created some reports in the MS access for # of books Borrowed / Returned each month for each type . Now I want to get the data along with the report. I can select show data table option to display the data but my problem is that I want to get the data and also want to calculate...

Hello all, I have 2 tables in excel: Table 1: Column A and Column B Table 2 Column A and Column C I want to join Table 1 and Table 2 to get Table 3 with columns A, B and C Now, It is possible that some of the values in column A might be same in Table 1 and Table 2 . How can I merge 2 tables In...

Hello all, I have a form and want to generate report. I am using various SELECT queries to compute values. When I call these queries using docmd.openquery, then the intermediate results of SELECT query appears. I want them to be hidden from the user, since they are temp queries and should...

Hello All, I have library books database in MS Access and people borrow books and submit them. In the table I have Status field, BorrowedDate, SubmitDate and several other fields like BookName, BookType etc I want to checkthe count i.e # of New books borrowed at the end of each week for the...