Jump to content
TNG Community
spuddled

Problem Creating Reports

Recommended Posts

spuddled

I'm having trouble creating reports (I'm running version v.13.0.2 at https://montgomeryhoffmann.com/wp/genealogy), and I'm not sure if the issue is user error or something else. I've attached screenshots of the parameters I used (just testing something very basic; ). When I click Save and Stay, all the parameters are removed, and the report basically pulls everyone from my database. What am I doing wrong?

It does seem that the SQL functionality works, so I can usually paste in SQL code others have posted here and have that save, but I don't know enough to create reports on my own using SQL.Image 4.jpgImage 5.jpg

Thanks!

Megan

Share this post


Link to post
Share on other sites
bhemph

Megan,

I think there may have been a bug in a previous version with the Save + Stay.  If you click Save + Exit, I believe it saves correctly and the parameters stick.  Another option is to upgrade to the latest version of TNG 13.1.2 which works for your example report case.

Brent

Share this post


Link to post
Share on other sites
spuddled

Hmm, I've upgraded to 13.1.2, then created a new report with the same "Megan" parameters, and did Save + Exit. When I open the report, none of my parameters are saved, and the SQL area is blank on that screen, but when I actually run the report, it seems to be pulling in a random SQL statement that I didn't enter. I did just do an upgrade to 13.1.2, not a full upload, so I don't know if that would make a difference. 

Share this post


Link to post
Share on other sites
Leif Sweden

Hi Megan,

I think if you in Option replace "=" with "Contains" you will get what you want.

Regards
Leif

 

Share this post


Link to post
Share on other sites
spuddled

I tried that change, and it still doesn't save my parameters, unfortunately.

Share this post


Link to post
Share on other sites
Leif Sweden

Strange, I used exacly your parameters and it works for me.

Share this post


Link to post
Share on other sites
spuddled

Yeah, it looks like it may be isolated just to my site. Darrin is taking a look at it for me to see if he can figure out what's going on.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×