Creating reports and dashboards | Stimulsoft community forum

Hello,
I am using graphql query to export report, but the issue is when the requested data is too large report.render(false); throw a timeout 100 sec error. I tried increasing the timeout but there is no such option provided by stimulsoft in the latest version too, so i would really like to know the way to solve this issue. This is my code ---

history.DataLoadedAt = DateTime.UtcNow;
await dbContext.SaveChangesAsync();
report.ReportCacheMode = StiReportCacheMode.On;
LogTime(sw, $"[{_report.Name}] Report Render started");
report.Render(false);
LogTime(sw, $"[{_report.Name}] Report Rendered");
history.ReportRenderedAt = DateTime.UtcNow;
await dbContext.SaveChangesAsync();

this is my graphql query --

query zz($search: String!) {
meenadev_suggestedPatientLists(
skip: 0
take: 900000
where: {
and: [
{ treatment: { providerCategories: { any: true } } }
{ name: { contains: $search } }
]
}
) {
items {
id
name
userId

providerCategories {
PayerProgram: name
}

patient {
NationalId: govCode
nationalityNavigation {
countryCode
name
}
partner {
PatientName: name
birthday
}
}
treatment {
id
TreatmentName: name
TreatmentState: state
policy {
code
name
}

meenaRisk {
RiskName: name
}
payerTag {
PayerRisk: name
}

providerCategories {
MeenaProgram: name
}
}
}
}
}
I have also attached the designer --

Hello,

There are no timeout settings for GraphQL in the designer. Try to check the IIS timeout settings.

Also, you can retrieve data in your code in the DataSet and then provide it to the report with the RegData() method.

Thank you.

We did it but it does not works as we expected and the relations aren't forming well. Please check attached zip for solution that we are using.

Attached Zip:
- Solution file for the project that has one API endpoint to generate report
- Please use "reportString.txt" file to grab packedString of report which has everything in it. (graphql datasource and all relations)

It does shows data properly in DESIGNER PREVIEW (with limited data as you know) but when I did fetch the same data using custom method (you can check the code) and covert it to datatable but it didn't work. If I do create hardcoded relations then it works but we need it dynamically to be set.

Thanks.

Hello,

> If I do create hardcoded relations then it works but we need it dynamically to be set.

Please explain this in more detail.

Thank you.

I have answered it in viewtopic.php?p=175813#p175813 post. Please refer that.

Hello,

Ok.