Search found 12 matches

by anshulmehta
Mon Jun 15, 2020 7:14 am
Forum: Stimulsoft Reports.NET
Topic: Can not open this file as file name or extension is incorrect with Stimulsoft 2013.1
Replies: 1
Views: 762

Can not open this file as file name or extension is incorrect with Stimulsoft 2013.1

Hi Team

We are trying to export the mrt file to excel using Stimulsoft 2013.1 version.
The excel file when sent across as email attachment is open fine but when we try to open it is giving us the error and not loading data in correct format.

kindly help on this.
by anshulmehta
Mon Jun 15, 2020 3:18 am
Forum: Stimulsoft Reports.NET
Topic: Want to display display columns horizontally in Stimulsoft report
Replies: 17
Views: 4458

Re: Want to display display columns horizontally in Stimulsoft report

Hi Lech

Sorry for the late reply , I was able to resolve this issue.
Thanks for the guidance.
by anshulmehta
Thu May 21, 2020 11:30 am
Forum: Stimulsoft Reports.NET
Topic: Want to display display columns horizontally in Stimulsoft report
Replies: 17
Views: 4458

Re: Want to display display columns horizontally in Stimulsoft report

Hi Lech I am very new to the stimulsoft ,little confused.What do you mean by show all 16 records in a row ? do you mean pivot the answers ? Will there be 3 different data sources ? One which will have all the questions and answers and used to display Questions and Answers SELECT Question, ISNULL(Mod...
by anshulmehta
Wed May 20, 2020 9:08 pm
Forum: Stimulsoft Reports.NET
Topic: Want to display display columns horizontally in Stimulsoft report
Replies: 17
Views: 4458

Re: Want to display display columns horizontally in Stimulsoft report

Hi lech

Is this possible using the stimulsoft report ?
by anshulmehta
Wed May 20, 2020 10:59 am
Forum: Stimulsoft Reports.NET
Topic: Want to display display columns horizontally in Stimulsoft report
Replies: 17
Views: 4458

Re: Want to display display columns horizontally in Stimulsoft report

Hi Lech

There is also one more issue.

If suppose user marks the Room column whose value is Basement as invisible then data shifts one cell left even though header remains static.
So what happens is basically header remains static but values in the rows shift .

Please see attaches screenshot.
by anshulmehta
Wed May 20, 2020 1:16 am
Forum: Stimulsoft Reports.NET
Topic: Want to display display columns horizontally in Stimulsoft report
Replies: 17
Views: 4458

Re: Want to display display columns horizontally in Stimulsoft report

Hi Lech Thanks for the reply ,I was able to achieve the desired result . But the only concern I have now is if in one subformTable I mark one question as "Invisible" and in other I do not ,data is not displayed correctly. I am attaching the sample data for reference and the sample image as...
by anshulmehta
Tue May 19, 2020 7:38 am
Forum: Stimulsoft Reports.NET
Topic: Want to display display columns horizontally in Stimulsoft report
Replies: 17
Views: 4458

Re: Want to display display columns horizontally in Stimulsoft report

Hello Also this is the query I am using to fetch Header SELECT distinct Question,DisplayOrder FROM table1 WHERE HeaderId = 66332 AND Ignore = 0 AND Visible = 1 AND RenderAsTable = 1 order by DisplayOrder This is query I am fetching to get the answers SELECT Question, ISNULL(ModifiedAnswer, Answer) A...
by anshulmehta
Tue May 19, 2020 7:18 am
Forum: Stimulsoft Reports.NET
Topic: Reading data from Excel
Replies: 10
Views: 3823

Re: Reading data from Excel

Hi With 64 bit machine even if we change the connection string to Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\Anshul\Desktop\ResultData.xlsx;Extended Properties="Excel 12.0 Xml;HDR=YES"; It still does not fetch anything. SELECT * FROM [Sheet1$] It is giving "keyword not sup...
by anshulmehta
Tue May 19, 2020 4:14 am
Forum: Stimulsoft Reports.NET
Topic: Want to display display columns horizontally in Stimulsoft report
Replies: 17
Views: 4458

Re: Want to display display columns horizontally in Stimulsoft report

Hi Lech Thanks for the reply. I am confused here. I am not able to understand what is DataSource1 in the mrt file you have provided. I have attached screenshot. We have QuestionnaireHeader which contains columns Header and DisplayOrder and this is used to display the colums header. and we have Quest...
by anshulmehta
Sun May 17, 2020 11:26 pm
Forum: Stimulsoft Reports.NET
Topic: Want to display display columns horizontally in Stimulsoft report
Replies: 17
Views: 4458

Re: Want to display display columns horizontally in Stimulsoft report

Is there no solution available in stimulsoft 2013.1 version for the issue I have raised