Creating reports and dashboards | Stimulsoft community forum

Hi

I'm hoping someone can help me here. We have created a report that we are using in Sitecore Analytics. The first time we run the report, all the data shows up correctly and it works as expected. The second time we run the report, the graphics show up but none of the data. 'Cache all data' is set to false for the report. If I make a change to the report and save (reportname.mrt), the report displays correctly again for the first run.

Any thoughts?

Hello.

cwearne wrote:I'm hoping someone can help me here. We have created a report that we are using in Sitecore Analytics. The first time we run the report, all the data shows up correctly and it works as expected. The second time we run the report, the graphics show up but none of the data. 'Cache all data' is set to false for the report. If I make a change to the report and save (reportname.mrt), the report displays correctly again for the first run.

Please, describe more detailed.
1. Which version do you use.
2. What Data Source do you use?
3. How do you run the report?
4. What changes do you make?

Thank you.

Hi

Thanks for the reply.


1. Which version do you use.

To run the reports, we're using the Report.dll and Report.Web.dll's. Both have a file version of 2009.3.600.0
We're using Reports.Net version 2011.2.1100 to build the mrt files.

2. What Data Source do you use?

We're using a standard sql server connection for the datasource: Data Source=;Initial Catalog=;User Id=;Password=; The query we are running is as follows;

set dateformat ymd
select b.*, cast(cast(b.TotalItemsSold as float) / cast(b.TotalTrans as float) as decimal(18,2)) AS AvgQty,
(select q.description from lookup q where b.pckg_type = q.id and q.type = 'PACKAGE TYPE') as Category
from (
select a.pckg_description, count(*) As TotalTrans, sum(a.pax_count) as TotalItemsSold, sum(a.totprice) as TotalRevenue, avg(a.totprice) as AvgPrice, a.pckg_type
from (
select distinct et.trip_id, ph.package_id, ph.pckg_description, pcv.pax_count, et.totprice, ph.pckg_type
from trip_header et
inner join pax_count_view pcv on et.trip_id = pcv.trip_id
inner join fit_trip_detail_supplier fit on et.trip_id = fit.trip_id
--inner join dbo.package_header (nolock) as ph on fit.package_id = ph.package_id
inner join package_header ph on fit.package_id = ph.package_id
inner join (SELECT

webbookingid, odysseybookingid, packageid

FROM

webbookingauditlogdetail
) ew on et.trip_id = ew.odysseybookingid
inner join (SELECT

webbookingid

FROM

webbookingauditlog
) ea on ew.webbookingid = ea.webbookingid
inner join DatabaseServer.[sitecore.application.uat].dbo.bookingauditlog b on ea.webbookingid COLLATE DATABASE_DEFAULT = b.bookingreferencenumber COLLATE DATABASE_DEFAULT
left join DatabaseServer.[sitecore.application.uat].dbo.regions r on b.visitorregion COLLATE DATABASE_DEFAULT = r.regioncode COLLATE DATABASE_DEFAULT
where b.createddate >= '2011-10-27 00:00:00.000' -- @StartDate
and b.createddate 0
) b
order by b.TotalItemsSold

3. How do you run the report?

The report is loaded (without params or filters) through the asp.net control. Unfortunately it is a sitecore page so I don't have the .net code that directly loads the report.

4. What changes do you make?

Not entirely sure what you mean here. I've changed just about every property at the report level and data level to no effect.

Thanks for any help.

Cheers.

Hello,

We couldn't reproduce this issue.
Can you please send us a sample report with data or a simple test project, which reproduce the issue?

Thank you.