Search results for query: *

Ensure that whereever/whoever you are running the crystal report under has permissions. You may want to use fully qulified path instead of a drive letter as well. Hope this helps,

Let's say I have 4 reports. In one the selection criteria is: tbl.date IN MonthToDate Crystal would translate this into the SQL Query of: tbl.date between '7/1/12' AND '7/7/12' Another one with tbl.date IN WeekToDate SQL = tbl.date Between '7/1/12' AND '7/7/12' Another tbl.date between...

A" is just an alias name for "table" If you see FROM table A or you may see FROM table AS A Now you can use A to reference table instead of table.... This is extremely handy for long table names and if you join the table on itself. You can also do this with column names. table.date AS...

Thanks.. Any idea on automating though and getting what the dates are from the selection criteria or SQL statement itself. Any help would be greatly appreciated. Thank you,

Your best bet would be to use your Visual Studios and just create an SSIS package on the SQL Server itself. Either that or just get the DBA's to write a quick procedure and put it into a SQL job.

Instead of using the Command, you may want a SQL Expression. That may be able to give you the Count you are looking for.

I need to know if there is a way to retrieve dates from the Selection Filter and/or the SQL Query that is built from the Selection Filter. IE: Selection Filter: tbl.date IN MonthToDate SQL Query: Where tbl.date between '7/1/12' and '7/5/12' I would like to see if there is a way to make it...