Powered by Jitbit .Net Forum free trial version. dismiss

HomeProblems and issues

Post bug reports here. The forum is pre-moderated, your message will appear after being checked by us.

How To Setup Report Parameters Messages in this topic - RSS

smccarthy945
smccarthy945
Posts: 2


8/25/2018
smccarthy945
smccarthy945
Posts: 2
I cannot figure out how to setup report parameters. I even had one of my employees look at it who is a SQL expert and he was lost as well. We read the FAQ on it. I am trying to setup a drop down that reads from the table called "MATTERS" from the field called "NUMBERS". I want the drop down to display all the NUMBERS from the table MATTERS.

I love this product and am definitely going to purchase it but I need to get the parameters working before I do so. Can you help show me how to setup the parameters to make the drop down work? I greatly appreciate it.

Awesome product by the way! I love it!
0 link
Gleb
Gleb
Administrator
Posts: 48


8/25/2018
Gleb
Gleb
Administrator
Posts: 48
Hi, for the dynamic dropdowns, the query should return Text and Value columns, i.e.

select NUMBERS as Text, NUMBERS as Value from MATTERS order by NUMBERS.

Hope it helps.
edited by Gleb on 8/25/2018
0 link
smccarthy945
smccarthy945
Posts: 2


8/25/2018
smccarthy945
smccarthy945
Posts: 2
Hey Gleb, sorry but I am not a smart as you so bear with me on this. I appreciate your time in helping me as I really love this product and want to understand it and get it working. I just need some clarification.

I guess what I am asking so I understand this is the following:

1. What do I put in the two parameter fields for values? numbers?
2. What should the actual SQL statement be? Should it be:
select NUMBERS as Text, NUMBERS as Value from MATTERS order by NUMBERS


If you can tell me what should be in the parameter fields and give me the actual SQL statement, I will understand how this works.

This is my SQL Query if it helps at all:


SELECT
m.Number AS matter,
mot.Timekeeper AS tkprnumber,
t.DisplayName AS tkprname,
mot.Percentage,
m.MattStatus,
m.DisplayName,
m.Client,
Client.DisplayName AS DisplayName1
FROM
Matter m
JOIN MattDate md ON md.MatterLkUp = m.MattIndex
JOIN MattOrgTkpr mot ON mot.MattDate = md.MattDateID
JOIN Timekeeper t ON mot.Timekeeper = t.TkprIndex
INNER JOIN Client ON m.Client = Client.ClientIndex
WHERE
md.NxEndDate >= GetDate()
ORDER BY
matter
0 link
Gleb
Gleb
Administrator
Posts: 48


8/26/2018
Gleb
Gleb
Administrator
Posts: 48
Sorry, I am confused. Are you asking about how to create a drop-down parameter, filled with data from field NUMBER from table MATTER?
0 link






Powered by Jitbit Forum 8.3.8.0 © 2006-2013 Jitbit Software