I am new to SQL, wrote a report, but now, how do I edit, change or delete it?
Thanks in advance!
I am new to SQL, wrote a report, but now, how do I edit, change or delete it?
Thanks in advance!
If you're talking about the built-in custom report functionality, you'll have to make any changes directly in the DB where you saved that report.
I can help you with deleting, please be very very careful running this command.
DELETE FROM CustomReport
WHERE Name='Name of Report'
It would be helpful to have a custom report that lists your custom reports!
Then, when you select this report from the drop-down the results show all of the custom reports. Crucially, it also gives the CustomReportID which allows you to target a report for update/delete.Code:INSERT INTO CustomReport (Name,Description,SQLCommand) VALUES ('List Custom Reports', 'A list of all custom reports', 'SELECT CustomReportID,Name,Description,SQLCommand,CreatedOn FROM CustomReport' )
For us, we can change the list of custom reports like this:
Because our custom report that lists our custom reports is CustomReportID=5Code:UPDATE CustomReport SET SQLCommand='SELECT CustomReportID,Name,Description,SQLCommand,CreatedOn FROM CustomReport' WHERE CustomReportID=5
http://www.esedirect.co.uk
--------------------------------------------------------------------------
Using MS 9.2.0.0 with the following customisations:
Lightbox/Fancybox enlarged images;
Auto-suggest searchbox;
Extra product information shown only to our IP Address (such as supplier info, costs, etc.);
Failed transactions emailed via trigger;
Custom app to show basket contents when customer online;
Orders pushed through to accounting systems.
All the above without source!
I didn't even think about doing that, I just pulled the name from the drop down box, but if for some reason there is a duplicate name ASPDNSF will just runs the first one so your's work much better if you use the category ID, I used it to clean up my custom reports!
I would love to learn more about the Lightbox/Fancybox without the source I've been working on that for ages!Code:DELETE FROM CustomReport WHERE CustomReportID='#'
Andy