Currently, I have two different parameters. One uses Fields.ID the other needs to use Field.ID2 However, using the code below. I am unable to rename ID to ID2. If I use ID It modifies Parameter1's ID field instead of Parameter2's ID field. I need to use dual union to be able to select all employees but when I run it with the "AS" command for renaming ID to ID2 it errors out(see below code). If I run it without the dual union. It works and renames ID to ID2. But, then I do not have the ability to select all employees which I need. How can I fix this in the report designer? is there a better way or am I using my code wrong, what would be a good solution to this?
How can I get this to work and rename ID to ID2 for the second source using the code below so that I can still use the dual union?
[Doesn't work]
SELECT TO_NCHAR('All Employees') AS FirstName, TO_NCHAR('*') AS LastName, 0 AS ID FROM DUAL
UNION
select FirstName, LastName, ID AS ID2
FROM Personnel
ORDER BY LastName NULLS FIRST
[Works]
select FirstName, LastName, ID AS ID2
FROM Personnel
ORDER BY LastName NULLS FIRST
Thank you!
2 Answers, 1 is accepted
Hello Austin,
The Reporting engine and the Report Designer wizards utilize the specified data provider to send the connections string and the query/stored procedure name to the database server. The SQL code is executed on the database server. We cannot control this and only use the data returned by the data provider.
From the Reporting side, you may use different SqlDataSources for the values of the two Report Parameters. The downside is that the database will be queried twice for the same data.
Regards,
Todor
Progress Telerik
Rank 2
Iron
Iron
Iron
Good Afternoon Todor,
So, I made a mistake in my original code and didn't realize I had already called an AS statement on ID in my first sentence.
I modified it to the following and it worked perfectly. Sorry for the confusion and my stupid question :P
SELECT TO_NCHAR('All Employees') AS FirstName, TO_NCHAR('*') AS LastName, 0 AS ID2 FROM DUAL
UNION
select FirstName, LastName, ID
FROM Personnel
ORDER BY LastName NULLS FIRST