Crosstab activereport työt

build a data frame and do plots and tests # 1] Create Objects # 2] Build a data frame, read, write # 3] Summary Statistics [summary, describe, freq, table, crosstab, CrossTable, Normality] # 4] Plot [barplot, histogram, boxplot, scatterplot, qplot, ggplot] # 5] Inferential Statistics [, aov, cor, , , OR, RR, Linear Regression, Logistic Regression] ############ # 1] Create Objects: ############ # Numeric: Grades # Numeric: Weight # Numeric: Height # Numeric: BMI [weight in KG/squared height in meter] # Numeric: Salary: # Binary: Sex # Binary: Diabetes [NOT SAMPLING] # Binary: HTN [SAMPLING] # Binary: CHD [SAMPLING] # Integer : Age [SAMPLING] # Integer : Rank[Non-SAMPLING]: # Categorical : Smoking Status [more than the number]

I am in need of a skilled developer who is experienced in creating Jasper reports using the specified version of Tibco Jaspersoft St...creating Jasper reports using the specified version of Tibco Jaspersoft Studio . The ideal candidate will have knowledge of Jasper Reports 6.19.0 and be able to efficiently work with this version. Skills and experience required for this project include: - Proficiency in Jasper Reports 6.19.0 - Strong understanding of database integration for data sources - Experience in creating tabular and crosstab reports using Jasper Reports - Ability to design and implement graphical elements such as charts and graphs and table If you have the necessary skills and expertise in Jasper Reports and data visualization, please submit your proposal for cons...

I want to have a jasper/crystal report file and i am using crosstab to display state wise cities name and it's respective Ids. Look at the and as you can observe first it will display all rows at once and then again it will print same rows with remaining columns. But what i want is as per destination file. Look at the result set file to have an idea about how the result set will be look like. P.S. : You can take your own data of Country,State and City and demonstrate the same. All i want to have the results as per specified format. You will be responsible to make me understand how you have achieved the result. Simple and easy project for an expert developer.

Looking for the production of a bespoke spreadsheet to use to track staff sales and takings. I have all the information Is need for the spreadsheet, I just need it to be easy to use with dropdown menus, crosstab calculations and graphs showing progress and averages

Files attached. If you need further information please let me know

Need a freelance to help dig into an omnibus FSI survey (n=2300) to pull insights by race, age, HHI, etc., to see if there’s a difference in how banks serve Americans. Basically, a lift on crosstab analysis. There is a presentation of the first cuts of the survey that can be shared. However, this report does not contain all of the insights we think are available in the data. We collected a very large amount of data and there are many other cuts and perspectives that can be derived from this single study.

We will provide the SQLs and reports' layout and the developer needs to design the report using Jasper Report accordingly. We will use extensively crosstab in Jasper with grouping in rows and columns and Total with percentages in rows and columns

I have a toy company dataset and need to calculate the Gross Margin of products, create product hierarchy, crosstab product sales and gross margin etc.. Will provide all the details once shortlisted.

details in file attached check the attach file before talking to me, submission in 48 hours Create a Tableau Story contains two points at least. Each Story point is based on one Dashboard that contains not less than three different Worksheet where a variety of data can be viewed and compared. The point of the Story can visualize and convey information from one of the fo...to complete and report the following steps during the implementation of your project: • Explain the idea of your project. • Define the source of the data • Explain the data • Data preparation steps Consider the following requirements while creating the visualization: • Creating interactive Dashboards. • Applying different fillers. • Using multiple types of Charts (Pie, Bar, line, ...

Project Hiring for 3-4months Profile : Jasper Developer Experience : 4-8years Salary : As per market Location : PAN INDIA (WFH) Requisite Skill Set : *Should have experience in development of various kinds of reports using Jaspersoft *Hands on-experience in development of user dashboards, dynamic reports, ad-hoc reports, and graphical reports. *Must have experience in complex crosstab, drill-down/drill-though reports *Experience in development of pixel perfect reports for the purpose of printing. *Hands-on experience in PL/SQL, queries with PostgreSQL and MySQL. *Hands-on Experience in developing high performance and large data reports. *Experience in developing dynamic reports using Jaspersoft and Java is preferred *Should have understanding of Spring Boot, Hibernate and Spring ...

*Should have experience in development of various kinds of reports using Jaspersoft *Hands on-experience in development of user dashboards, dynamic reports, ad-hoc reports, and graphical reports. *Must have experience in complex crosstab, drill-down/drill-though reports *Experience in development of pixel perfect reports for the purpose of printing. *Hands-on experience in PL/SQL, queries with PostgreSQL and MySQL. *Hands-on Experience in developing high performance and large data reports. *Experience in developing dynamic reports using Jaspersoft and Java is preferred *Should have understanding of Spring Boot, Hibernate and Spring MVC framework. *Should have good communication skills. *Willingness to adapt and learn different reporting tools and technology components *Experience i...

Project Hiring for 3-4months Profile : Jasper Developer Experience : 4-8years Salary : As per market Location : PAN INDIA (WFH) Requisite Skill Set : *Should have experience in development of various kinds of reports using Jaspersoft *Hands on-experience in development of user dashboards, dynamic reports, ad-hoc reports, and graphical reports. *Must have experience in complex crosstab, drill-down/drill-though reports *Experience in development of pixel perfect reports for the purpose of printing. *Hands-on experience in PL/SQL, queries with PostgreSQL and MySQL. *Hands-on Experience in developing high performance and large data reports. *Experience in developing dynamic reports using Jaspersoft and Java is preferred *Should have understanding of Spring Boot, Hibernate and Spring ...

Project Hiring for 6 months Profile : Jasper Developer Experience : 4-8years Salary : As per market Location : PAN INDIA (WFH) Requisite Skill Set : *Should have experience in development of various kinds of reports using Jaspersoft *Hands on-experience in development of user dashboards, dynamic reports, ad-hoc reports, and graphical reports. *Must have experience in complex crosstab, drill-down/drill-though reports *Experience in development of pixel perfect reports for the purpose of printing. *Hands-on experience in PL/SQL, queries with PostgreSQL and MySQL. *Hands-on Experience in developing high performance and large data reports. *Experience in developing dynamic reports using Jaspersoft and Java is preferred *Should have understanding of Spring Boot, Hibernate and Spring M...

This crosstab report with custType, Year and Month in rows, product Number in column and usage and Count of accounts as measures. There is a page break on Customer Type so we get separate tab for each Customer Type data. In this report, I am having two issues. 1) I am expecting to see all the months data under 2012 starting from month 9 in the same group. But somehow the data in 2012, month 9 is coming in separate row and then all other months data for 10,11,and 12 are grouped under 2012. 2) When I choose “Auto group and summarize” property for the query, I am getting invalid object error.

I want you to to design a spreadsheet-like report in Crystal Report 10. The report is like a Payslip and might have sections on the report where Crosstab will be used. I have attached a section of the report to this post and i need someone very good with Crystal report who can help design this report ASAP. The data will be fetched from MSSQL Server 2008 database tables.

I have to design a spreadsheet-like report in Crystal Report 10. The report is like a Payslip and might have sections on the report where Crosstab will be used. I have attached a section of the report to this post and i need someone very good with Crystal report who can help design this report ASAP. The data will be fetched from MSSQL Server 2008 database tables.

design ssis package with a dynamic solution to handle crosstab excel source data with multiple sheets to sql server table using ssis

Create queries for access database and create a crosstab

Right now, I have a table in SQL server called TI_Course_table, where every Task Instruction (TI) has multiple applicable courses mapped to it, so for example, if a TI has four courses associated with it, there will be 4 total rows in the database. On the .aspx page, I would like to have this data displayed in a Gridview, but in more of a crosstab/matrix format, where each course represents an additional column and each entry in the Task Instruction row has either checkmarks (preferably) or dropdowns with 1’s or 0’s to represent if a course is mapped to that Task Instruction. When a checkmark is either checked/unchecked or a 1 changes to a 0 or vice versa, the respective row is either added or deleted from the underlying table in SQL Server (perhaps with the event of cli...

Right now, I have a table in SQL server called TI_Course_table, where every Task Instruction (TI) has multiple applicable courses mapped to it, so for example, if a TI has four courses associated with it, there will be 4 total rows in the database. On the .aspx page, I would like to have this data displayed in a Gridview, but in more of a crosstab/matrix format, where each course represents an additional column and each entry in the Task Instruction row has either checkmarks (preferably) or dropdowns with 1’s or 0’s to represent if a course is mapped to that Task Instruction. When a checkmark is either checked/unchecked or a 1 changes to a 0 or vice versa, the respective row is either added or deleted from the underlying table in SQL Server (perhaps with the event of cli...

I have rmd file with data file in csv with a sample data of 10000 rows out of 9 million in the orginal csv file , I want to add some plots and corrplot and crosstab to the rmd file. if possible add geo map

We are looking for someone to build an online survey app to use by our mobile sales team. Must be similar to survey monkey app 1. should be able to capture voice recording as well 2. should have analysis tools such as crosstab reports, filters, and sentiment analysis for deeper insights for presenting survey results 3. should be able capture information both online and offline please put reference app in bid or do not bid

We are looking for someone to build an online survey app to use by our mobile sales team (we would like to be able to capture information both online and offline 1. should be able to capture voice recording as well 2. should have analysis tools such as crosstab reports, filters, and sentiment analysis for deeper insights for presenting survey results

...membership count, article post count and number of member. The data has maximum two years. In order to visualize these data from various points of view, please do exploratory data analysis on each website by using jupyter notebook with python. 1. Look at distribution of data - Histogram - Boxplate diagram - Bar graph - Band graph - Stacked bar chart 2. View the relationship of data - Scatter plot - Crosstab - Heat Map 3. See the transition of data - Line graph - Candlestick Chart And please tell me what kind of impression you saw the data. Actually there are more and more data and variables, and this time we would like to consider what we can find from these data. I will send data only to people who entered "HOGE" in the message. I will ask the same engineers to do t...

...extensive product database in SQL Server. I need to take 3 tables and combine them so that I have at the end a table with columns named after items of one table, with productid as rows with the field data concatenated data from 2 other tables. No mathematical functions are performed at all. Data is just collated. 1) Table 1 pdt_WebWidgets has 132 items I call "Widgets." Column names for the pivot crosstab will come from field labeltext. New widgets are occasionally added, so pivot must be able to include these new widgets as they are created. 2) Table 2 pdt_WebWidgetValue has over 7 million records, with fields ProductID, WidgetID, Value. pdt_WebWidgetValue.WidgetID=pdt_WebWidgetID 3) For IN (2,6), we can join pdt_WebWidgetListBox (57,000 records) to pdt_WebwidgetVa...

I have a database that tracks donations solicited for a charity organization. I would like to make some changes to it. 1) I need a better way to create and save thank you letters...letters. I want the letters to be generated and stored within the database. Right now they are sent off to MS Word and mail merged there. 2) I have a table in the database that tracks correspondences with a donor. I would like that table to be embedded in the main window that I work in. 3) I would like a query of sorts to be able to quickly see who is 'due' to be solicited from. Right now I have a crosstab query that I kind of mine through, but I would like this data to be better accessible. 4) I insert a scan of the cheque that was donated. This is now a 4-5 click procedure. I would like th...

SPSS Statistical analysis: cluster analysis, interpretation, corrrelation, crosstab etc

Rekisteröidy tai kirjaudu sisään nähdäksesi tiedot.

Use MS-Access 2010+ VBA to export data for use in an Excel file. The data is used by a chart, plus some additional summary data needs to populate. The Excel file '' shows how the chart and addional data should be presented. In the sample Access database, there is a sample table (Table1) and a crosstab query (Table1_Crosstab). The number or rows will change over time, and it needs to populate into the Excel sheet named data. The chart must read the full dataset Additionally, there are these queries: 1. qryPerson - the person name should be populated into the named range 'person' 2. qrySummary- this should populate into the screen shot sample beneath the chart. The values have conditonal formatting: a) Outcome rating change: <=0 red background; 1-6...

I'm on a short timeline to complete a project that needs a live chart based on an Excel spreadsheet filtered by day,week,month or custom. Know some VBA.

I have an Excel crosstab that was imported from Discoverer. I would like to somehow convert it back to a 'flat file'

We are a survey research company and are completing a survey that requires SPSS reports that are above our skill set. Client needs crosstabs/banners that include for every question that include: Column Proportion/Means testing Means calculated at specific mid-point Top two boxes Bottom two boxes Sample banner/crosstab has been uploaded for your review prior to bidding. We will provie you a fully labeled SPSS file. Should be a pretty easy project if you know SPSS. A preliminary SPSS file can be provided right now and the final version will be ready Saturday. Would need banners/crosstabs for all questions completed on Sunday 3/26 (-7 GMT time) .

Write some code using MSSQL to produce a crosstab query with columns, and row totals. The shows the fields

I've built a basic Access database with queries and tables. I would like to do some automated reports with an SQL server as well as some crosstab queries that require sql. In the future our company will probably need a website as well as database maintainence.

The BI Report should contain visualizations that address the following, at a minimum: 1. Crash frequency comparison (with injuries and fatalities) over the three-year period. 2. Crash driver age comparison... Crash driver age comparison (via a tree map). 3. Crash number of fatalities and crash number of injuries. 4. Frequency of Driver Contributing causes (via a bar chart) . 5. Weather conditions at the time of the crash or locations of the crash. 6. Frequency of crashes by days of week. 7. Crash times of day (via a line chart). 8. Analysis of the most frequent vehicle harmful events (via a crosstab and a word cloud). 9. Analysis of the Driver Safety Equipment to determine how many crashes an air bag was deployed. 10. Any other visualizations on the report that you deem h...

I have data with multiple variables I need to create a form which allows me to select variables and when I hit submit it need create a crosstab or graph with a dependent variables. I has to allow me to select mutliple variables at a time

I need a report in Access with a graph where the rowsource is a crosstab-query. This means columns are changing each time it is run. It should be a stocked bar graph where each bar show the sum of a row with each color in the bar being a different column. It should also be filtered by from-to date and one more parameter (article).

EXCEL: write a crosstab query to reverse ROWS with COLUMNS -$10 (15 minute task)

EXCEL: crosstab query of existing Excel sheet

I have an application and need some modifications as follows. 1. I already created privileges but now just need to create the roles (Privilege Template) 2. I need to log 4 tables while any entry is being entered(Either by mysql triggers or php) 3. Need to send two forms via email upon submission 4. Need to create one mothly attendence grid (php mysql crosstab query) Thats all. Please provide good price and approx time needed so i can award you right away.

I need person who can convert crosstab data to panel data in excel. Screenshot 1 illustrates the basic point. My data right now looks like Blue table (with blanks between rows) and I need it to look as Green table. Second screenshot shows how the actual workfile looks like. My datafiles are large and I need to convert around 40 sheets of data (with data structured a bit differently on each sheet) overall. The person needs to either convert all of it or provide me with elegant decision to quickly do it myself. Vitali

I need person who can convert crosstab data to panel data in excel. Screenshot attached illustrates the point. My data right now looks as Blue table (with blanks between rows) and I need it to look as Green table. Overall I need to convert around large 45 sheets of data.

I need person who can convert crosstab data to panel data in excel. Screenshot attached illustrates the point. My data right now looks as Blue table (with blanks between rows) and I need it to look as Green table.

...A) You need to identify five key variables that contribute most to determining the survival rate of passengers on the ill-fated Titanic on its maiden voyage. Note you should also refer to the data dictionary provided with the file which describes each of the variables and their range of values. (Hint: an exploratory analysis should be based on summary statistics, histograms, crosstab tables and scatterplots of individual variables and the relationship between individual variables and the target variable survived. Which variables are correlated with target variable survived and other variables?) You might also need to consider reformatting some of variables to facilitate the next stage of analysis of the and data sets using a Decision

...integrity constraints. Populate the tables with 10 test data records. 2) 5 forms that have been customized using HCI design principles. Forms need to include headers and have the correct data input masks set. The following minimum items must be included in the system: 2 total boxes, 2 combo boxes (that move to the selected record), and one embedded sub form. 3) 4 queries; one each of multi-table, crosstab, total, and less-than (one query must ask the user for input) 4) 3 custom reports that have been customized to meet specific business requirements. Reports should include headers, footers, groupings, totals, and special formatting. (Note: Be creative, use color and graphics to build an application people will want to use. Inclusion of a switchboard or other menu system a...

I have an iis web site that queries a foxpro database via a mssql linked server and displays an activereport result. The report worked fine on our old 32bit server using iis 6. On the new 64bit server running iis 7 we are having problems. We have the linked server setup and working fine and we can successfully pull quries from sql of the foxpro tables. The web site can even successfully pull a list of products from foxpro o generate the drop down list above the calendar that you can see below. The problem is when you select a product and you select a date range and run the activereport does not display. I believe this is purely an activereports problem and has nothing to do with foxpro or mssql. See the attached file for more detail. Please bid on this project and...

I have data that represents volume of 6 categories per day. On the attached excel book, on the crosstab tab, there is an example of the stacked bar chart I need to display dynamically in Classic ASP. The "crosstab" data was generated through MS Access for display purposes only. We have a stored procedure that generates the data you see on the rawdata tab - we need to convert that into the barchart dynamically. Summary - convert a recordset of 186 rows of data into a stacked barchart showing 6 categories per day using Classic ASP. Due to our application security setup, we cannot use ASP.NET. I am open to using JavaScript libraries if needed.

I need two web forms. Each form will contain a crosstab grid, to be used for data entry; on top of the grid, I need columns to be grouped in two more levels and display column totals. This must be a Netbeans project, using: Webserver: Tomcat; Server side: JSP/JDBC; Client side: DHTMLX Database: MS SQL Server. I provide the SQL Server database file with the tables needed. See attached file for details.

...astrological variables to explain any aspects of people’s attitudes or behaviour. The absence of an arrow in the diagram below reflects the hypothesis that the two variables are not statistically associated. To test that hypothesis, I use a crosstabulation and chi-square test. This is the appropriate significance test when dealing with two categorical variables. The table below shows the crosstab and the chi-square test result. ...

I have a report that I need developed using data derived from several crosstab queries. A sample of the report layout is attached in a file. I have the first line of data in the report working. Upon acceptance of a bid - I will send a .accdb file along with the sample data and the report that is partially working. This report uses multiple crosstab queries. I have the main queries created and will send those as well.