How to add Report Description to the Report?

Kinetic ERP
,
1

I would like to add the description field, found here:

Capture232jhg23624
Capture232jhg23624697Ɨ639 65.2 KB

to the top of my report here:
Capture.232c344d123dJPG

However, I do not see the description field in the available fields in the RDL expression editor. Can I access this description from my report and get it to stick in there?
Thanks!
Nate

2

Should be there already I think

=First(Fields!RptLiteralsRptTitle.Value, "RptLabels")

image

BAQ Report not sure been a while.

1 Like
3

Interesting! That field is not listed in my RptLabels dataset.

Capture23d3 f 42d423
Capture23d3 f 42d423357Ɨ534 46.1 KB

2 Likes
4

Try adding it to the DataSet Query see if it picks it up.

1 Like
5

Was the description left blank initially?

6

No I donā€™t think so. You can see in the first screenshot the description is there. I did created this BAQ Report by copying an older report.

I added it ok, and didnā€™t get any syntax errors, but it wouldnā€™t run. sent a server side error:

Query execution failed for dataset ā€˜RptLabelsā€™. ā€”> System.Data.SqlClient.SqlException: Invalid column name ā€˜RptLiteralsRptTitleā€™.

7

Is this a legacy BAQ Report or using the Report Data Definition (New way)?

8

Legacy I believe.

9

Do you have a dataset called BAQReportParameter I wonder if any of these fields have the desc

image
image275Ɨ528 5.04 KB

10

Can you manually add the label to the RDD?

image

11

Yes, I checked there. It is not in my report parameters. I tried the BAQID, BAQRptID, ReportTitle, and RptVersion fields. None of them are the description that I am looking for. :thinking:

12

I can try that! What should I use for the value here?
EDIT: Oh I can just manually assign the label instead of pulling the description field from the BAQ Report. Is that what you suggest?

1 Like
13

:man_shrugging: Iā€™m assuming you can enter a static valueā€¦ whatever you want show in the description. Give it a name, and that value will show up when you add that field to the report.

Dunnoā€¦ havenā€™t done it before, haha.

:crossed_fingers:

1 Like
14

I think this approach might work, but it so much trouble to resync my RDD now. If there is any other way I would like to try that first. haha!

15

I was getting ahead of myself. There is a field right below description in the BAQ Report Designer called Form Title. I just updated the form title to match my description. Then I added this field to my report:

=First(Fields!ReportTitle.Value, ā€œBAQReportParameterā€)

This is perfect! I didnā€™t need the description field after all. Thanks guys!

5 Likes
16

Wait, so youā€™re going to leave it to ME to test if you can manually add a label successfully???

In that caseā€¦

giphy.gif ?cid=6c09b952w9ib6d268hd99cm8wgw1jcplb8upccqiv3qm65du&ep=v1_internal_gif_by_id&rid=giphy. gif&ct=g

2 Likes
17

Bahaha! I know, right?!

18

I always had @ckrusen test. He needs to come back we need to give him our demo env :slight_smile:

7 Likes
19

Itā€™s been so long since Iā€™ve been on an Epicor system, Iā€™d only be able to provide help with E10. E10 - using the Classic shell.

1 Like