tracker issue : CF-4119834

select a category, or use search below
(searches all categories and all time range)
Title:

Report Builder lost SQL advanced Query after closing file

| View in Tracker

Status/Resolution/Reason: Closed/Withdrawn/CannotReproduce

Reporter/Name(from Bugbase): Carsten Pohl / Carsten Pohl (Carsten Pohl)

Created: 02/19/2016

Components: Reporting, Report Designer

Versions: 2016

Failure Type: Unspecified

Found In Build/Fixed In Build: CFB2016_Final /

Priority/Frequency: Minor / Very few users will encounter

Locale/System: English / Win 2008 Server x64

Vote Count: 0

Problem Description:
Report lost after save and closing the SQL query in the view. The report works fine but you can't change the query. 

Steps to Reproduce:
1.<click Report Query (Query Builder)>
2.<add an advanced query>
3.<save query>
4.<save file>
5.<close file>
6.<open file>
7.<click Report Query (Query Builder)>

Actual Result:
Can't edit SQL Query

Expected Result:
See the query of the report.

Any Workarounds.

----------------------------- Additional Watson Details -----------------------------

Watson Bug ID:	4119834

External Customer Info:
External Company:  
External Customer Name: Carsten Pohl
External Customer Email:  
External Test Config: My Hardware and Environment details:

Server:

Coldfusion 11

Windows 2008



Client:

Coldfusion Report Builder (Build 282452)

Windows 7

Attachments:

  1. February 19, 2016 00:00:00: 1_Coldfusion2.zip
  2. February 24, 2016 00:00:00: 2_STSG_MERCK_REPORTING_Gesamtueberblick.zip

Comments:

Was able to save and retrieve the query, could edit it too, this was on opening and closing the file through report builder. Please provide more details to repro, which data source type, platform etc. Thanks, Akhila.
Comment by Akhila K.
4595 | February 23, 2016 09:32:56 AM GMT
The attached report is full accessable but you can't see the query. RDS -> Coldfusion MySQL embedded ODBC driver. Server: Windows Server 2008 Client: Windows 7
Comment by External U.
4596 | February 24, 2016 03:43:57 AM GMT
Crasen, Could you please provide more information to let us understand the scenario: 1) Which mysql version you are using? 2) The screenshot attached says RDS type as JDBC while in note you are mentioning the type as ODBC. 3)How you configured the data source ? and driver you selected in ColdFusion during data source configuration? Thanks
Comment by Poonam J.
4597 | June 09, 2016 04:40:56 AM GMT
Carsten, Also Could you please do below steps to see if this works for you: 1)open Coldfusion Report Builder Report Creation wizard 2)Select import and select the cfr file.Click save 3)Open Query Builder You query will be visible.
Comment by Poonam J.
4598 | June 09, 2016 05:42:50 AM GMT
Carsten , any update here. Did the solution work?
Comment by Poonam J.
4599 | June 15, 2016 09:43:15 PM GMT