on 01-26-2009 4:29 PM
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
Thks for the idea....
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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'
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.