Generate yerarly report

Help Studio
, ,
1

image
getting exception while extracting the data can anybody help me with this

2

Hi @Sandhya_Gajare

As per the error message your data table variable is not initialized.
I assume you performed data scrapping to retrieve the Work Items and performed filter record for WI4 activity.

Then passed the filtered rows to For each row in Data table WI4 activity.
somewhere in between you have missed the assignment of data table.

Mostly that’s the reason you are getting object reference not set to an instance of object error message

  1. Please check all you input / output for each activities used
  2. Check valid data tables are used in the assignments, you may wrongly referenced unused data table

Thanks
John

3

Hello @Sandhya_Gajare

Usually, we will be getting this error if a variable or argument is not properly initialized.
Please check whether the Datatable is having some value in it.

Thanks

4

@Sandhya_Gajare run in debug mode and give exact point where are you facing issue?

1 Like
5

Generate_Yearly_Report_Dispatcher.zip (964.5 KB)
Please can you help me where i fail
its littely urgent

6

HI @Sandhya_Gajare

Check out the Argument that are passed in the workflow

Regards
Gokul

1 Like
7

@Sandhya_Gajare
GenerateYearlyReportPerformer.zip (2.0 MB)
GenerateYearlyReportForVendor.zip (2.3 MB)

1 Like
8

thanks for help

9

TaxID: IT145632
Name: Softing Company
Address: Via Longa 201
City: Rimini, Italy

How to get only taxid from above string

10

hey
give a try

yourStringVar.Substring(yourStringVar.IndexOf("TaxID: ") + "TaxID: ".Length).Split(Environment.NewLine.ToCharArray)(0)

Regards

11

HI @Sandhya_Gajare

You can Try with Regex Expression

System.Text.RegularExpressions.Regex.Match(YourString,"(?<=TaxID:\s).*").Tostring

image

Output

image

Regards
Gokul

12

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.