nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

problem in designing report in birt

Jyoti Anand

i want to use this data in the table to design a chart: and i want to design a chart using birt like this: how to do that . plese helpp>.....

Find more posts tagged with

Comments

GLO_FR

Jyoti Anand

GLO_FR

Hi Jyoti, Try this query, it should give you the expected output<pre class="_prettyXprint _lang-sql">SELECT 'SCANNED_APPLICATION' AS APP_TYPE, A.TECHNOLOGY AS APP_TECH, COUNT(A.PROJECTID) AS APP_COUNT FROM AIS.dbo.PROJECT_MASTER AWHERE MONTH(DATE) = 1AND SCAN LIKE '%Y%'GROUP BY TECHNOLOGYUNIONSELECT 'CLEARED_APPLICATION' AS APP_TYPE, A.TECHNOLOGY AS APP_TECH, COUNT(A.PROJECTID) AS APP_COUNT FROM AIS.dbo.PROJECT_MASTER AINNER JOIN AIS.dbo.PROJECT_SCAN_MASTER BON A.PROJECTID = B.PROJECTIDAND B.MONTH(SUBMITDATE) = 1AND B.CLEARED = 'YES'GROUP BY A.TECHNOLOGY</pre>You should get this result<pre class="_prettyXprint _lang-">APP_TYPE | APP_TECH | APP_COUNT

Jyoti Anand

IT WORKED....THANK YOUU SO SO VERY MUCHH..............THNKYOU

GLO_FR

You're welcome

Jyoti Anand

sir, i have another problem ,i have these two tables:and wht the problem is that i am getting a null value corresponding to the technology now if i change the SP.TECHNOLOGY to CP.TECHNOLOGY in the third line then i am getting the right output but only for a single case so how should i manipulate my query to get the right output. hoping for a quick and positive response . thank you.

GLO_FR

Hi, this error is there because you're using a full outer join and the number of rows retuned by the differents queries is not the same.Query nÂ°1 (on SP.TECHNOLOGY) returns 3 technologies : Php, .Net, JavaQuery nÂ°2 (on CP.TECHNOLOGY) returns 4 technologies : Php, .net, Java, Asp With the full outer join, you're triing to create a link between those results BUT in the first case you're using the smaller list of technologies. What happens is that the database matches and returns the technology names when this one is present, otherwise it returns null. If you really want an output like this one it's saffer to do this <pre class="_prettyXprint _lang-sql">SELECT APP_TECH, SUM(SCANNED_APPLICATION) AS SCANNED_APPLICATION, SUM(CLEARED_APPLICATION) AS CLEARED_APPLICATIONFROM (SELECT A.TECHNOLOGY AS APP_TECH, 1 AS SCANNED_APPLICATION, 0 AS CLEARED_APPLICATION FROM AIS.dbo.PROJECT_MASTER A WHERE MONTH(DATE) = 1 AND SCAN LIKE '%Y%' UNION SELECT A.TECHNOLOGY AS APP_TECH, 0 AS SCANNED_APPLICATION, 1 AS CLEARED_APPLICATION FROM AIS.dbo.PROJECT_MASTER A INNER JOIN AIS.dbo.PROJECT_SCAN_MASTER B ON A.PROJECTID = B.PROJECTID AND B.MONTH(SUBMITDATE) = 1 AND B.CLEARED = 'YES') AGROUP BY APP_TECH </pre>

Jyoti Anand

sir it is not returning the output as previous one....... the first table shows what u have posted the latest query n the second table shows the previous query.... i have taken the month as '2' please helpp.....

GLO_FR

Hi, sorry for the late answer, I was quite busy this week. In fact, I don't understand exactly your needs.What kind of output do you want ?This one <pre class="_prettyXprint">APP_TYPE | APP_TECH | APP_COUNT

10 | 4 | .Net 6 | 7 | Java/J2EE...</pre>

Jyoti Anand

sir i need the table in the second format where "scanned_application","cleared_application"and "technology " are the column names...now i need the data in that format.

GLO_FR

Hi, this query should works<pre class="_prettyXprint _lang-sql">SELECT APP_TECH, SUM(SCANNED_APPLICATION) AS SCANNED_APPLICATION, SUM(CLEARED_APPLICATION) AS CLEARED_APPLICATIONFROM (SELECT A.TECHNOLOGY AS APP_TECH, 1 AS SCANNED_APPLICATION, 0 AS CLEARED_APPLICATION FROM AIS.dbo.PROJECT_MASTER A WHERE MONTH(DATE) = 1 AND SCAN LIKE '%Y%' UNION SELECT A.TECHNOLOGY AS APP_TECH, 0 AS SCANNED_APPLICATION, 1 AS CLEARED_APPLICATION FROM AIS.dbo.PROJECT_MASTER A INNER JOIN AIS.dbo.PROJECT_SCAN_MASTER B ON A.PROJECTID = B.PROJECTID AND B.MONTH(SUBMITDATE) = 1 AND B.CLEARED = 'YES') AGROUP BY APP_TECH </pre>what is the output you have ?