Comments by Aggeliki Asimakopoulou

Aggeliki Asimakopoulou 13-May-24 2:16am View

Thank you, I refered programmatically with source code in case it is possible of course, not manually!

Aggeliki Asimakopoulou 12-Apr-24 14:07pm View

I have never written source code in Crystal Reports as the link you shared to me and it's not properly source code because I know visual basic .net and I tried it and it has several error the debugger hits. However you didn't explain to me. If I don't understand something, if I don't have any guidance how can I solve it? If your run your source code, you will definetely see, that yes it doesn't work, it give only the first record. Through OrderReport.SetParameterValue(columnName, values.ToArray()); you set all the values but the parameter only gets the first one...
If you had explained to me as I asked it, I could do that.
Anyway, I watched this video https://www.youtube.com/watch?v=rwc6oxOG0OQ, I followed step by step and it works for me, I get all values in a different way and I will include it to my main report as a subreport.
Excuse me, but I can't accept a solution that doesn't work and without a good example in order to try it, by my own. Thank you.

Aggeliki Asimakopoulou 12-Apr-24 7:40am View

Excuse me, but I described it a lot from the start. All source code is written in C# and the question is refered to C#. I have never written code in crystal reports.
I have created a back - end application in C# with embedded microsft sql server.

I have a form represent orders management. So when the user runs the application, he enters an OrderID in the Search Text Box and the corresponding Order appears in the form controls. All these in C#. More detailed, the displayed Order comes with the appropriate Invoice Record, the appropriate Customer that made this order, all these appear in RichTextBoxes, and a DataGridView that displays the products that Customer ordered. Everything runs perfectly.

I also have button for my crystal report of the searched order, the btnPrint in a form.
I would like also to mention that report values are place to details section in C#.

The problem comes when I try to give values to the report from the DataGridView with GiveValuesToRpt function, all the other values appears correctly. I get to the Report only the last record of product details of the DataGridView and not all the records it's need. All the source code is written in C#, the crystal report is also created in C#. And the source code I shared is written in C#, both the print button on the OrdersForm and the GiveValuesToRpt which is called form the print button. Isn't something clear? I have tried with your code, even with parameters and I get only the first record of datagridview, with my source code I get only the last record of datagridview, what if I had dozens of records to the datagridview that they refer to order products? I don't want the first or the last record of the datagrid view data, I want all these records to be displayed one under the other in my crystal Report. My crystal report represent an Order Receipt.

Aggeliki Asimakopoulou 11-Apr-24 13:54pm View

Your code doesn't work even with parameters and the crystal report is created in C# not in other platforms, not in other programming languages

if (dtGridViews.Any())
{
foreach (var dtGridV in dtGridViews)
{

for (int iC = 0; iC < dtGridV.Columns.Count; iC++)
{
string columnName = dtGridV.Columns[iC].Name;
List<string> values = new List<string>(dtGridV.Rows.Count);
for (int iR = 0; iR < dtGridV.Rows.Count; iR++)
{
if (dtGridV.Rows[iR].Cells[columnName].Value is string value)
{
pf = params_.FirstOrDefault(x => x.Name.Contains(columnName));
name = columnName.ToString();
//pf.EnableAllowMultipleValue = true;
values.Add(value);

//OrderReport.SetParameterValue(name, dtGridV.Rows[iR].Cells[columnName].Value);
//pf.CurrentValues.Clear();
//ParameterDiscreteValue paraDescritValue1 = new ParameterDiscreteValue();
//paraDescritValue1.Value = value;
//pf.CurrentValues.Add(paraDescritValue1);
//paraFields.Add(pf);

//OrderReport.SetParameterValue(columnName, value);
//pf.CurrentValues.Clear();
//ParameterDiscreteValue paraDescritValue1 = new ParameterDiscreteValue();
//paraDescritValue1.Value = value;// value;
//pf.CurrentValues.Add(paraDescritValue1);
//paraFields.Add(pf);
}
}

//var test = values.ToArray();
OrderReport.SetParameterValue(columnName, values.ToArray().Last().ToString());
pf.CurrentValues.Clear();
ParameterDiscreteValue paraDescritValue1 = new ParameterDiscreteValue();
paraDescritValue1.Value = values.ToArray().Last();

pf.CurrentValues.Add(paraDescritValue1);
paraFields.Add(pf);
}

Aggeliki Asimakopoulou 11-Apr-24 13:13pm View

I don't understand the source code in the link. It is not writtern in C#. I don't understand at all the source in this unknown programming language... How can I change the code, when I understand nothing?

Aggeliki Asimakopoulou 10-Apr-24 6:30am View

No effect even I refresh the Report.

 private void btnPrint_Click(object sender, EventArgs e)
        {
            Reports.OrderRpt orderRprt = new Reports.OrderRpt(); ;

            //orderRprt.EnableDrillDown = False;

            //OrdersPrintReport printFrm=new OrdersPrintReport(fromForm,ref orderRprt);
            OrdersPrintReport printFrm = new OrdersPrintReport(ref orderRprt);
            
            IEnumerable< CrystalDecisions.Shared.ParameterField> params_ =
                (from CrystalDecisions.Shared.ParameterField p in orderRprt.ParameterFields
                 where string.IsNullOrEmpty(p.ReportName)
                 select p);
            
            foreach (ParameterField pf in params_)
                pf.EnableAllowMultipleValue = true;

            IEnumerable<String> paramNames = 
                (from CrystalDecisions.Shared.ParameterField p in orderRprt.ParameterFields
                 where string.IsNullOrEmpty(p.ReportName)
                 select p.Name);


            orderRprt.Refresh();

            foreach (Control Container in this.Controls)
                if (Container.GetType() == typeof(GroupBox) || Container.GetType() == typeof(Panel))
                {
                    GiveValuesToRpt(Container, paramNames,ref orderRprt);
                }

            printFrm.Text = this.Text;
            fromForm.OpenChildForm(printFrm, this.fromForm.menuBtn);
        }

With orderRprt.Refresh(); the prompt enter parameter values window always displays and we don't want this. So your code doesn't work... If I don't use orderRprt.Refresh(); I get only the first record of datagridview and I want them all... With my code I get only the last record? What's going on?
I don't understand at all the link you shared.

Aggeliki Asimakopoulou 10-Apr-24 6:17am View

No, how can I do that?

Aggeliki Asimakopoulou 10-Apr-24 6:11am View

So, I tried the following:

 
private void btnPrint_Click(object sender, EventArgs e)
{
      Reports.OrderRpt orderRprt = new Reports.OrderRpt(); 

       OrdersPrintReport printFrm = new OrdersPrintReport(ref orderRprt);
            
       IEnumerable< CrystalDecisions.Shared.ParameterField> params_ =
       (from CrystalDecisions.Shared.ParameterField p in orderRprt.ParameterFields
        where string.IsNullOrEmpty(p.ReportName)
        select p);
            
        foreach (ParameterField pf in params_)
           pf.EnableAllowMultipleValue = true;

        IEnumerable<string> paramNames = 
        (from CrystalDecisions.Shared.ParameterField p in orderRprt.ParameterFields
         where string.IsNullOrEmpty(p.ReportName)
         select p.Name);
          
            
        foreach (Control Container in this.Controls)
           if (Container.GetType() == typeof(GroupBox) || Container.GetType() == typeof(Panel))
            {
                 GiveValuesToRpt(Container, paramNames,ref orderRprt);
            }

            printFrm.Text = this.Text;
            fromForm.OpenChildForm(printFrm, this.fromForm.menuBtn);
        }

In order to allow multiple value to params.
But with your code, I get only the first record of the dtGridV now. What goes wrong?

Aggeliki Asimakopoulou 10-Apr-24 1:55am View

No, my queries run through source code application in C#. Sql is embedded to C# project. It's a back - end client application.

Aggeliki Asimakopoulou 9-Apr-24 11:17am View

I have no idea how to use a parameterized query. May you give me an example please?

Aggeliki Asimakopoulou 9-Apr-24 11:16am View

Which would be the better approach instead of using string concatenation to sql statements?

Aggeliki Asimakopoulou 9-Apr-24 11:15am View

You are welcome, thank you so much. I realised that I forgot Rdr.NextResult(); statement under the while (Rdr.Read()) ends. However it runs, both ways. It's very effective using the column name to get the appropriate value. Thank you.

Aggeliki Asimakopoulou 9-Apr-24 8:12am View

Thank you so much. I have some question please!!!
First question : You told me NEVER use SELECT .*, however with your code I realized that it works perfectly and not only with SqlDataReader but with DataSet too. So, is there any reason for not doing this? I would appreciate your explation.

Secondly as a determination : InvoiceID_ = (string)Rdr["InvoiceID"].Value;
FromOrderID_ = (string)Rdr["FromOrderID"].Value;
InvFinalPriceWithTax_ = (decimal)Rdr["FinalPricesWithTax"].Value;
.Value doesn't need because it doesn't exist such a property.
However I didn't know that at all, I was always finding as an explanation with Rdr.GetName(0) or Rdr.GetValue(0) we always get the current name of the field or value respectively. So, I want to thank you so much for that, because I learned something new.

Aggeliki Asimakopoulou 5-Apr-24 10:40am View

Yes it does! I am just not very familiar with this type of code. Thank you so much!!!

Aggeliki Asimakopoulou 1-Apr-24 4:35am View

I don't understand what @ does and I don't understand how does it work? May you explain me please?
Thank you so much.

Aggeliki Asimakopoulou 29-Mar-24 9:27am View

Thank you so much, for all the explation and for the link too. A thought came into my mind, that all this procedure that the interpreter looks firstly to the char type and secondly to the extended class may take a long time procedure, could we use async await to extended class methods in order to gain execution time? Or would we able to avoid looking at the char type and force the interpreter to look immediately at the extended method? That's very interesting.

Aggeliki Asimakopoulou 29-Mar-24 7:44am View

Thank you so much, I have two questions. First question: How does the system recognizes IsVowel is a methond of char? Because letter is a char? Does it come the argument this char c? And why do we use "this" in argument declaration?
And second question: Is there a way to be compilied through an assembly to include it to library in order to use it for any application that we write source code depending on the needs of course?
Thank you so much!!!

Aggeliki Asimakopoulou 12-Mar-24 10:08am View

The default DropDownHeight value is actually 106, but if we set it to 1, we can only retrieve it with a const variable. Thank you!!!

Aggeliki Asimakopoulou 12-Mar-24 10:08am View

The default DropDownHeight value is actually 106, but if we set it to 1, we can only retrieve it with a const variable. Thank you!!!

Comments by Aggeliki Asimakopoulou (Top 19 by date)