Thread: Custom report

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!

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'
)

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.

For us, we can change the list of custom reports like this:

Code:

UPDATE CustomReport SET SQLCommand='SELECT CustomReportID,Name,Description,SQLCommand,CreatedOn FROM CustomReport' WHERE CustomReportID=5

Because our custom report that lists our custom reports is CustomReportID=5

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!

Code:

DELETE FROM CustomReport
WHERE CustomReportID='#'

I would love to learn more about the Lightbox/Fancybox without the source I've been working on that for ages!

Andy