cancel
Showing results for 
Search instead for 
Did you mean: 

Add external data to a report

Former Member
0 Kudos

Good afternoon,

My question is the following:

I have created a report(invoice to customers) with CR XI, now the users want to type the number of copies which they need..., there is no problem with this as adding an external database or an excel sheet and later creating a report header with this field i get as much copies as needed..

The case is that i need to create this external data base or excel sheet where the report is published...

Have we any way of avoiding this external data?

Thks

Pepe

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Thks for the idea....

Former Member
0 Kudos

i dont know of any other way, this is what i have done in the past

i have done that in reports with parameters

i have a table that contains the following

COPYNUM

1

2

3

in the sp i use the following syntax

CASE WHEN ISNUMERIC(so_load_tbl.so_load_key) = 1

THEN CONVERT(varchar, CONVERT(INT,

so_load_tbl.so_load_key) * 10 + T10.COPYNUM)

ELSE so_load_tbl.so_load_key + CONVERT(varchar, T10.COPYNUM) END AS CPY, T10.copynum,

in the report i create a parameter and i would set the copy type against the number

record selection i use this {pr_inv_cust_purp.copynum}<={?COPIES}

when the end user runs the report they can select the number of copies Customer Copy

i would substitute the values in the report to create labels

if copynum =1 then'Customer Copy' ' else

if copynum =2 then 'Accounting Copy'

Former Member
0 Kudos

Hi Sharon

what i am trying to avoid is the table that contains the number of copies as you mentioned in your reply...

I have the same idea in my report..

Table/excel sheet with:

Copia

1

2

3

4

5

Table included in the report without any link

Create a header report based on this field (copia), then the user type the number of copies needed and then i have created a formula field like yours, if fieldx =1 Then "Original" else "Copy"

But how to eliminate this extra table

Copia

1

2

3

4

5

Thks

Pepe

Former Member
0 Kudos

couldnt you create a temp table that gets dropped after its been utilized?

is the data set from a stored procedure?