We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Blank report\no Header if no data from SQL

NKMM
6 - Meteoroid

Hello experts , 

Wei need to generate PDF report with Header with Report name and   given input parameter like from date, to date  and  data  in details section 

if no data found then we need only header with input param values and details section as blank / "No cahnges "

If data populated then report generated as expected 

but if there is no data from SQL then we are getting blank report seeking your help on this 

My Workflow is as below 

 

user interface ( date parameters ) --> input date ( connect Postgres DB) -->  Join & preparation tools -> Convert tool -> basic table  -> report text --> render  ( PDF)

 

 

Thanks in advance,

NKMM

 

1 REPLY 1
geraldo
13 - Pulsar

@NKMM 

 


Here is an example workflow on how to test and generate a blank report.
the header with the interface data remains hanging

 

the filter tool is configured to not generate data, change it to 1=1 to generate data for testing

Labels
Top Solution Authors