Hi,

I created an SSRS report but while preview some variables values are showing as blank while the same report printed in display device shows values.
These fields are calculated in report script in before and after section of some layout.I declared them as extern and included them in input fields still the same problem... any1 with solution ???

Thanks.

Hi all,
I have same problem with some reports.
First step I generate XML file with SSRS design device. In this file some variables are blank. if i print same report with display device and then again with SSRS design, then all of data are correct. Does anyone have any suggestion ?
Thanks.
Giuseppe

Hi,

Check if all the fields are included in the report input fields. Include it if not exists, compile the report. Delete the existing xml and recreate it. Import it again in SSRS and check if you get them.

Also check if there are any conditions which are not allowing those fields during generating the xml file.

Hi Bhushan,
Thanks for the reply.
Report is standard purchase orders. first time i print a PO on SSRS device : some info are blank. Second time i print same PO with display device and ALL info are correct. Third time i print same PO on SSRS device and in this case ALL info are present in xml file.
All info are correct with SSRS if i print BEFORE with display device.

Regards

Giuseppe

Ahh,

May be SSRS device is not able to generate the tmp file in the $BSE\tmp folder. Though I am not sure, I ll need to check.

What you can do is, print a new PO with SSRS device and check if any tmp file is created in $BSE\tmp. If not, then its a file permission issue. You can give full rights to everyone for $BSE\tmp folder then and try again.

I have full permission into LN server.
File is present on BSE\tmp.
Only few data (Always strings : adress,... ) are blank if i don't print before with display device.
Other test : when i change po number same info are blank at first time. after reprint with D, and reprinting with SSRS all is correct.

Giuseppe

Hi,

Try deleting the field from SSRS report and adding it again. Try refreshing it. Have you done any additional formatting for those fields?

There are sometimes uncertain problems with SSRS, you just need to play around and you will find out the exact problem.

I tried the same in my 10.2 and 10.2.1 environments, but see no differences after choosing display device.
If you post the files here, I can have a look. Ensure that there is no confidential data in it!
So, perform the following steps:
1. Start tdpur4401m000
2. Select the order to be printed and the options
3. Print to designer device
4. Rename $BSE/tmp/ier_<user>_tdpur440102000.xml to ier_before
5. Print to display
6. Print to designer device
7. Rename $BSE/tmp/ier_<user>_tdpur440102000.xml to ier_after

Post ier_before and ier_after, or just the differences, here. A screenshot of tdpur4401m000 (with the selected options) may help as well.

Hi Giuseppe,

It can be a good case for support If it is working fine in SSRS after printing on Display device.

Hi All,
Thanks for reply, but I don't have access to my system now. I'll try next week.
Giuseppe

last(variable) or sum(variable) or first(variable) .... etc

Try any of these on SSRS reporting and you will get the values. It worked for me hope it works for u too :)

Hi rocks23,
I don't understand. Could you explain what you mean with last(variable),.... ?
Giuseppe

In ssrs report design , when you add a field .. you get aggregate option such as sum , add ,last , first ...etc . In that you will get LAST , FIRST ....