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

computed columns based on expression builder.

thelcd

Hi, I've got a report where I'm asking users to enter a month of year, and a search variable. However, I would like to create N columns where N is the number of days in the month and populate it with a count of number of occurances on the day (1-30 for example) of that month. I can calculate the number of days in the month in a birt variable and have the month and month+1 variables also. So how can I create a report to query the Result of my data set and perform a count on a date field?I don't think it would require N selects!!? Thanks for any suggestions on how to go here...

Find more posts tagged with

Comments

kclark

If the customer selects a month, November, and then selects something to search by, "AAA" you would like to count how many times "AAA" is in November, correct? I think the SQL would look something like<pre class="_prettyXprint">select count(customernumber) as customer_countfrom paymentswhere YEAR(paymentdate) = ? and MONTH(paymentdate) = ?</pre>

Hans_vd

I think what you want is to have a report that has the days of the month, next to one another. A column for each day, is that it? You can create a crosstab for this. It's really easy:First you create a data cubewhen you drag a date field to the dimensions area, you can immediately select "day of month"Then drag the datacube to the report layout and a crosstab will be created showing all the days of the month next to one another. From another post of yours, I see that you tried solving this problem in the query, but in my opinion this is a better solution. Hope it helps