reporting services - How to know if a report is already printed in SSRS? -

-

the user of report know if report has been printed? if report has been printed user see message report has been printed on report next time report generated. best way achieve this? in advance.

there no official documentation on how achieve this, there way of doing this.

the executionlogstorage table contains information reports executed or exported.
when print report clicking on print button in toolbar, report "re-generated" , logged in executionlogstorage table, format = 'image'.

if export report tiff file, line generated format = 'image'.

fortunately, there bytecount column, contains "size of rendered reports in bytes." according msdn.

this bytecount column contains 0 in case report printed, , image size if image export.

so ended following query, can execute in ssrs db:

select els.[logentryid],        c.[name],        c.[path],        els.[parameters],        els.[username],        els.[timestart],        els.[timeend] [dbo].[executionlogstorage] els left join [dbo].[catalog] c on els.[reportid] = c.[itemid] els.[format] = 'image' , els.[bytecount] = 0 order els.[logentryid] desc

i kept key columns here , of course can can adapt fit need, , maybe group by have print counts per report.

important notes:

  • this worked in case not officially supported, not surprised if doesn't work you.
  • it can obvious people not work if user prints report in other way clicking on print report button, like:
    • exporting report in format (pdf, excel, doc)
    • ctrl + p page
  • take server properties account:
    • enableexecutionlogging must set true
    • the default executionlogdayskept 60 adjust number accordingly

in case above query, add datasource report targetting reportserver db, , if query has result matching report, display message.

alternatively, schedule job filling db used keep track of reports printed, , query db in report.


Comments

Post a Comment

Popular posts from this blog

PHP DOM loadHTML() method unusual warning -

-
i had following code works fine on localhost: $document = new domdocument(); $document->loadhtml($p_result); $form = $document->getelementsbytagname('form')->item(0); // code continues using $form variable after same code updated on outside server, loadhtml() failed , issued warning. warning: domdocument::loadhtml() expects parameter 1 valid path, string given in path/name/to/script.php returned null instead of object code pretty gets fatal error. note contents of $p_result absolutely same on outside server , on localhost. but why displays kind of warning , why not work? doesn't loadhtml() expects argument 1 string in first place? why method expects parameter 1 valid path ? just make clear i'm not calling loadhtmlfile() , i'm calling loadhtml() . thanks. you're affected one of php bugs . issue present in php 5.6.8 , 5.6.9. have affected php version on server, , bug-free version on localhost. the bug forbids null
Read more

python - How to create jsonb index using GIN on SQLAlchemy? -

-
here's current code creating index jsonb. index("mytable_data_idx_id_key", mytable.data['id'].astext, postgresql_using='gin') but got error. sqlalchemy.exc.programmingerror: (psycopg2.programmingerror) data type text has no default operator class access method "gin" hint: must specify operator class index or define default operator class data type. [sql: "create index event_data_idx_id_key on event using gin ((data ->> 'id'))"] is there way create index on sqlalchemy? the postgresql specific sqlalchemy docs @ http://docs.sqlalchemy.org/en/latest/dialects/postgresql.html#operator-classes mention postgresql_ops dictionary provide "operator class" used postgresql, , provide example illustrating use: index('my_index', my_table.c.id, my_table.c.data, postgresql_ops={ 'data': 'text_pattern_ops',
Read more

c# - TransactionScope not rolling back although no complete() is called -

-
i'm using transactionscope rollback transaction fail bool errorreported = false; action<importerrorlog> newerrorcallback = e => { errorreported = true; errorcallback(e); }; using (var transaction = new transactionscope()) { foreach (importtaskdefinition task in taskdefinition) { loader.load(streamfile, newerrorcallback, task.destinationtable, processingtaskid); } if (!errorreported) transaction.complete(); } i'm sure there no transactionscope started ahead or after code. i'm using entity framework insert in db. regardless state of errorreported transaction never rolled in case of error. what missing ? transactionscope sets transaction.current . that's does. wants transacted must @ property. i believe ef each time connection opened reason. probably, connection open when scope installed. open connection inside of scope or enlist manually. ef has nasty "design decision": default opens
Read more