Retrieve several entries from an Excel file

Stimulsoft Reports.NET discussion
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

Re: Retrieve several entries from an Excel file

Post by Alex K. »

Hello,

You should use this code before initializing of component:

Code: Select all

public MainForm()
{
    Stimulsoft.Base.StiLicense.Key = "YourKey";
    ConfigureReporting();
    ....
}
Thank you.
Jennypi
Posts: 361
Joined: Mon Nov 17, 2008 7:13 am
Location: France

Re: Retrieve several entries from an Excel file

Post by Jennypi »

Thank you, it worked ! :)
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

Re: Retrieve several entries from an Excel file

Post by Alex K. »

Hello

We are always glad to help you!
Please let us know if you need any additional help.

Thank you.
Jennypi
Posts: 361
Joined: Mon Nov 17, 2008 7:13 am
Location: France

Re: Retrieve several entries from an Excel file

Post by Jennypi »

Hello,

I'm back on this specific topic as the concerned report now generates an error.
I'm joining an sample data and report.
The message says something like "Invalid data type in the expression criteria".

I don't know why it is not working anymore. Users used to be able to type one or several IDs in the form:
ID= 5266
or
ID= 5266, 5566
Now it works only when typing the numbers surrounded with single quote: ID = '5266' for example.

What's wrong? How to go back to the previous behavior?

Thank you for your help.
Attachments
report.mrt
(44.19 KiB) Downloaded 125 times
Lech Kulikowski
Posts: 6254
Joined: Tue Mar 20, 2018 5:34 am

Re: Retrieve several entries from an Excel file

Post by Lech Kulikowski »

Hello,

Your ID column is the string, in this case, the value in the IN should be in single quotes " '5266', '5566' "
You can add necessary modifications in your code in Ok button click event.

Thank you.
Post Reply