Data is not there in Regular table in SSRS report

(0) Share

Report

Posted on by @rp@n

Dear All,

Can you please let me know i have developed one SSRS report which is calling form multiple forms. The report output is same for all.

I took Table type = Regular for SSRS report. So, i set table property

Table type : regular

Created by = Yes

Create Transaction Id = Yes

And in DP class in processReport method : i add

Table.setConnection(this.parmUserConnection());

Report is working fine.

But i surprised after executing report when i saw the table it's BLANK. why ???

Could you please let me know why data is not there after executing report ?

Please give me more shed on this.

Thanks!

*This post is locked for comments

I have the same question (0)

All responses (17)

Answers (8)

Sukrut Parab 71,710 Moderator on at

Like (0)

Report
Copy link

Link copied!

Any reason for going with regular table and not with temp table ?

Was this reply helpful? Yes No
Verified answer

Jie G Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello @rp@n

It is recommended to use a temporary table rather than a regular table for RDP reports. The reason is that with a temporary table, each report instance gets a different table instance, and therefore will only see whatever data the report instance adds to the temp table. No data cleanup is needed if the report uses a temporary table.

If an RDP report were using a regular table, then all report instances are getting data from the same table instance, which can lead to problems such as data added by one report instance remaining behind and affecting subsequent report instances, or multiple instances of the report RDP class trying to update the single table instance at the same time.

Was this reply helpful? Yes No
Verified answer

Jie G Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello @rp@n,

I see you mean Pre processing reports using Regular table and RDP class which is extends with SrsReportDataProviderPreProcess.

Once the report is being generated, it'll automatically deletes the records in regular table using the field CreatedTransactionId.

You can see the business logic in the "SrsReportRunRdpPreProcessStrategyRegular" class.

1 people found this reply helpful.

Was this reply helpful? Yes No
@rp@n 30 on at

Like (0)

Report
Copy link

Link copied!

Thanks Ada ding,

So, that is the reasons i am not getting data in to Regular table after executing report. Right?

Please give me more shed on this

Thanks!

Was this reply helpful? Yes No
@rp@n 30 on at

Like (0)

Report
Copy link

Link copied!

Dear Ada,

The reason to using Regular table is when i set Table type = "In Memory" and execute the report. It's not throwing any error and executing well but report is not displaying any data but in Regular table i got data...

DP Class i extended by "extends SRSReportDataProviderbase"

I cleared caches from Tool > Cache... and Refresh dataset in VS and Rebuid and deploy...

But it's not showing data in report.

Could you please let me know how to resolve this issue.

Was this reply helpful? Yes No
@rp@n 30 on at

Like (0)

Report
Copy link

Link copied!

Hi All,

If i set Table type = "Temp DB" then i am getting below error

Form > Clicked method > Line 22

@ I restart Report services too.

Please give me more shed on this.

Was this reply helpful? Yes No
Verified answer

Jie G Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello @rp@n,

Once the report is being generated, it'll automatically deletes the records in regular table using the field CreatedTransactionId. Yes, That's the reason you are not getting data in Regular table after executing report.

Was this reply helpful? Yes No
@rp@n 30 on at

Like (0)

Report
Copy link

Link copied!

Thanks Ada,

Shall i go for Regular table ?

Thanks!

Was this reply helpful? Yes No
Verified answer

Sukrut Parab 71,710 Moderator on at

Like (0)

Report
Copy link

Link copied!

I think you should go ahead with temp table and figure out a way to overcome the stack trace error you posted earlier. There is definitely something wrong with your code which is causing stack trace error.

Was this reply helpful? Yes No
@rp@n 30 on at

Like (0)

Report
Copy link

Link copied!

Thanx Sukrut,

Will try to find out the solution.

But could you please let me know the exact reason for NOT to use REGULAR table. Why???

If we used regular table then what will happened?

What is the benefit of using Temp DB or In Memory table?

Kindly elaborate me.

Was this reply helpful? Yes No