Hi everyone,
Could someone explain to me how to refresh the links to my sql server?
Each time i modify or create a field in a table, the modifications are
not implented in the front-end. How can i resolve this.
Greetings,
StefanieAre you selecting from views with SELECT *? In this case, check out
sp_refreshview in the Books Online.
--
Hope this helps.
Dan Guzman
SQL Server MVP
--
SQL FAQ links (courtesy Neil Pike):
http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
http://www.sqlserverfaq.com
http://www.mssqlserver.com/faq
--
"Stefanie Pindew" <spindew@.yahoo.com> wrote in message
news:ehJkMpZXDHA.1004@.TK2MSFTNGP12.phx.gbl...
> Hi everyone,
> Could someone explain to me how to refresh the links to my sql server?
> Each time i modify or create a field in a table, the modifications are
> not implented in the front-end. How can i resolve this.
> Greetings,
> Stefanie
>|||Or are you referring to an Access front end? In that case,
you can use the Linked Table Manager or do it
programmatically with the refresh method of the tabledefs
collection.
--Sue
On Fri, 08 Aug 2003 12:46:17 +0200, Stefanie Pindew
<spindew@.yahoo.com> wrote:
>Hi everyone,
>Could someone explain to me how to refresh the links to my sql server?
>Each time i modify or create a field in a table, the modifications are
>not implented in the front-end. How can i resolve this.
>Greetings,
>Stefanie|||>--Original Message--
>Or are you referring to an Access front end? In that case,
>you can use the Linked Table Manager or do it
>programmatically with the refresh method of the tabledefs
>collection.
>--Sue
>On Fri, 08 Aug 2003 12:46:17 +0200, Stefanie Pindew
><spindew@.yahoo.com> wrote:
>>Hi everyone,
>>Could someone explain to me how to refresh the links to
my sql server?
>>Each time i modify or create a field in a table, the
modifications are
>>not implented in the front-end. How can i resolve this.
>>Greetings,
>>Stefanie
>.
>Hi,
I want it do it programmatically in the access front-end
and in the access adp front-end|||Stefanie,
I've just checked the following code and it works:
Dim tdLoop As TableDef
For Each tdLoop In CurrentDb.TableDefs
tdLoop.RefreshLink
Next
However, I can remember having problems when using the
.RefreshLink method... Give it a try though.
Regards,
Danny
"Stefanie Pindew" <spindew@.lollo.com> wrote in message news:02f201c35fee$71d670c0$a001280a@.phx.gbl...
> >--Original Message--
> >Or are you referring to an Access front end? In that case,
> >you can use the Linked Table Manager or do it
> >programmatically with the refresh method of the tabledefs
> >collection.
> >
> >--Sue
> >
> >On Fri, 08 Aug 2003 12:46:17 +0200, Stefanie Pindew
> ><spindew@.yahoo.com> wrote:
> >
> >>Hi everyone,
> >>
> >>Could someone explain to me how to refresh the links to
> my sql server?
> >>Each time i modify or create a field in a table, the
> modifications are
> >>not implented in the front-end. How can i resolve this.
> >>
> >>Greetings,
> >>
> >>Stefanie
> >
> >.
> >Hi,
> I want it do it programmatically in the access front-end
> and in the access adp front-end|||>--Original Message--
>Stefanie,
>I've just checked the following code and it works:
>Dim tdLoop As TableDef
>For Each tdLoop In CurrentDb.TableDefs
> tdLoop.RefreshLink
>Next
>However, I can remember having problems when using the
>..RefreshLink method... Give it a try though.
>Regards,
>Danny
>
>"Stefanie Pindew" <spindew@.lollo.com> wrote in message
news:02f201c35fee$71d670c0$a001280a@.phx.gbl...
>> >--Original Message--
>> >Or are you referring to an Access front end? In that
case,
>> >you can use the Linked Table Manager or do it
>> >programmatically with the refresh method of the
tabledefs
>> >collection.
>> >
>> >--Sue
>> >
>> >On Fri, 08 Aug 2003 12:46:17 +0200, Stefanie Pindew
>> ><spindew@.yahoo.com> wrote:
>> >
>> >>Hi everyone,
>> >>
>> >>Could someone explain to me how to refresh the links
to
>> my sql server?
>> >>Each time i modify or create a field in a table, the
>> modifications are
>> >>not implented in the front-end. How can i resolve
this.
>> >>
>> >>Greetings,
>> >>
>> >>Stefanie
>> >
>> >.
>> >Hi,
>> I want it do it programmatically in the access front-end
>> and in the access adp front-end
>
>.
>He thanks man, it works for me too|||Stefanie,
There are some issues with using .RefreshLink with Access97,
but I can't remember what they are. In case you have any
problems, I ended up implementing a solution that deleted the
linked tables from within Access and then re-linked them.
Both tasks can be accomplished using the DoCmd object:
DoCmd.DeleteObject
DoCmd.TransferDatabase
Email me if you want some sample code.
Regards,
Danny
"Stefanie Pindew" <spindew@.lollo.com> wrote in message news:066501c35ffe$995740b0$a301280a@.phx.gbl...
> >--Original Message--
> >Stefanie,
> >
> >I've just checked the following code and it works:
> >
> >Dim tdLoop As TableDef
> >For Each tdLoop In CurrentDb.TableDefs
> > tdLoop.RefreshLink
> >Next
> >
> >However, I can remember having problems when using the
> >..RefreshLink method... Give it a try though.
> >
> >Regards,
> >Danny
> >
> >
> >"Stefanie Pindew" <spindew@.lollo.com> wrote in message
> news:02f201c35fee$71d670c0$a001280a@.phx.gbl...
> >>
> >> >--Original Message--
> >> >Or are you referring to an Access front end? In that
> case,
> >> >you can use the Linked Table Manager or do it
> >> >programmatically with the refresh method of the
> tabledefs
> >> >collection.
> >> >
> >> >--Sue
> >> >
> >> >On Fri, 08 Aug 2003 12:46:17 +0200, Stefanie Pindew
> >> ><spindew@.yahoo.com> wrote:
> >> >
> >> >>Hi everyone,
> >> >>
> >> >>Could someone explain to me how to refresh the links
> to
> >> my sql server?
> >> >>Each time i modify or create a field in a table, the
> >> modifications are
> >> >>not implented in the front-end. How can i resolve
> this.
> >> >>
> >> >>Greetings,
> >> >>
> >> >>Stefanie
> >> >
> >> >.
> >> >Hi,
> >>
> >> I want it do it programmatically in the access front-end
> >> and in the access adp front-end
> >
> >
> >.
> >He thanks man, it works for me too
Showing posts with label refresh. Show all posts
Showing posts with label refresh. Show all posts
Monday, March 26, 2012
Refreshing a report
I use a javascript to close a window and refresh another window that contains
a report. I'm trying to actually refresh the report and have it get new data
from a table.
For some reason I refresh the browser and the report doesn't refresh until
the 2nd time it's done. Anyone know why or how to fix this?Hi John,
The problem probably is that the report gets data from cache. You can
disable this in URL you are using in the Report Rendering with
"rs:ClearSession=true" option. For example I use
http://localhost/reportserver?/MyReport&rs:Command=Render&rs:ClearSession=true
Hope solve your problem.
"John" wrote:
> I use a javascript to close a window and refresh another window that contains
> a report. I'm trying to actually refresh the report and have it get new data
> from a table.
> For some reason I refresh the browser and the report doesn't refresh until
> the 2nd time it's done. Anyone know why or how to fix this?
>|||This works perfectly. Thank you so much!
"ata" wrote:
> Hi John,
> The problem probably is that the report gets data from cache. You can
> disable this in URL you are using in the Report Rendering with
> "rs:ClearSession=true" option. For example I use
> http://localhost/reportserver?/MyReport&rs:Command=Render&rs:ClearSession=true
> Hope solve your problem.
>
> "John" wrote:
> > I use a javascript to close a window and refresh another window that contains
> > a report. I'm trying to actually refresh the report and have it get new data
> > from a table.
> >
> > For some reason I refresh the browser and the report doesn't refresh until
> > the 2nd time it's done. Anyone know why or how to fix this?
> >|||ClearSession never work for us. Any ideas?
"ata" wrote:
> Hi John,
> The problem probably is that the report gets data from cache. You can
> disable this in URL you are using in the Report Rendering with
> "rs:ClearSession=true" option. For example I use
> http://localhost/reportserver?/MyReport&rs:Command=Render&rs:ClearSession=true
> Hope solve your problem.
>
> "John" wrote:
> > I use a javascript to close a window and refresh another window that contains
> > a report. I'm trying to actually refresh the report and have it get new data
> > from a table.
> >
> > For some reason I refresh the browser and the report doesn't refresh until
> > the 2nd time it's done. Anyone know why or how to fix this?
> >
a report. I'm trying to actually refresh the report and have it get new data
from a table.
For some reason I refresh the browser and the report doesn't refresh until
the 2nd time it's done. Anyone know why or how to fix this?Hi John,
The problem probably is that the report gets data from cache. You can
disable this in URL you are using in the Report Rendering with
"rs:ClearSession=true" option. For example I use
http://localhost/reportserver?/MyReport&rs:Command=Render&rs:ClearSession=true
Hope solve your problem.
"John" wrote:
> I use a javascript to close a window and refresh another window that contains
> a report. I'm trying to actually refresh the report and have it get new data
> from a table.
> For some reason I refresh the browser and the report doesn't refresh until
> the 2nd time it's done. Anyone know why or how to fix this?
>|||This works perfectly. Thank you so much!
"ata" wrote:
> Hi John,
> The problem probably is that the report gets data from cache. You can
> disable this in URL you are using in the Report Rendering with
> "rs:ClearSession=true" option. For example I use
> http://localhost/reportserver?/MyReport&rs:Command=Render&rs:ClearSession=true
> Hope solve your problem.
>
> "John" wrote:
> > I use a javascript to close a window and refresh another window that contains
> > a report. I'm trying to actually refresh the report and have it get new data
> > from a table.
> >
> > For some reason I refresh the browser and the report doesn't refresh until
> > the 2nd time it's done. Anyone know why or how to fix this?
> >|||ClearSession never work for us. Any ideas?
"ata" wrote:
> Hi John,
> The problem probably is that the report gets data from cache. You can
> disable this in URL you are using in the Report Rendering with
> "rs:ClearSession=true" option. For example I use
> http://localhost/reportserver?/MyReport&rs:Command=Render&rs:ClearSession=true
> Hope solve your problem.
>
> "John" wrote:
> > I use a javascript to close a window and refresh another window that contains
> > a report. I'm trying to actually refresh the report and have it get new data
> > from a table.
> >
> > For some reason I refresh the browser and the report doesn't refresh until
> > the 2nd time it's done. Anyone know why or how to fix this?
> >
Refreshing a development database with production data
Hello,
I am trying to refresh a test database with data from a production database. Both database structures are identical, e.g. constraints, stored procs, PK, etc. I am trying to create a package in SSIS that accomplishes this task and I am having extensive problems. The import export wizard is out of the question because the constaints are not carried over, plus when I try to refresh the data using the import export wizard, it fails on 1 specific table because of a column in that table named "Error code". I think "Error code" is a micrsoft keyword, so it fails on this column. Does anyone know a workaround that I can do to accomplish this simple task, that could be completed in minutes using DTS. I understand that SSIS is not as straight forward as DTS, but this task is something that DBA's do on a regular basis and therefore should not be this difficult.
Any help would be appreciated,
David
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1118044&SiteID=1Refresh with jsp doesnt work
Hi!
I've created a simple jsp page with a crystal report viewer on it. I used Crystal Reports Developer to design the report, as db I use access and IBM WSED to create and run the jsp file on a server. That works fine, but when I would refresh the report it shows no recordset (and also no error message appears). Why I can't refresh the data?
The code:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<%@. page import="com.crystaldecisions.report.web.viewer.CrystalReportViewer" %>
<%@. page import="com.crystaldecisions.sdk.occa.report.data.*" %>
<%@. page import="com.crystaldecisions.reports.reportengineinterface.JPEReportSourceFactory,
com.crystaldecisions.sdk.occa.report.reportsource.IReportSourceFactory2,com.crystaldecisions.sdk.occa.report.reportsource.IReportSource"
%>
<HTML>
<HEAD>
</HEAD>
<BODY>
CrystalTest.jsp
<%
try {
IReportSourceFactory2 rptSrcFactory = new JPEReportSourceFactory();
String report = "/CrystalReport/Report1.rpt";
Object reportSource = rptSrcFactory.createReportSource(report, request.getLocale())
CrystalReportViewer viewer = new CrystalReportViewer();
viewer.setReportSource(reportSource);
viewer.setOwnPage(true);
viewer.setTop(80);
viewer.setDisplayGroupTree(false);
viewer.setHasLogo(false);
viewer.setHasRefreshButton(true);
viewer.processHttpRequest(request, response, getServletConfig().getServletContext(), null);
viewer.dispose();
} catch(Exception e)
{
out.println("CrystalTest: "+e);
}
%>
</BODY
</HTML>hi there!
I've now solved the problem with a jdbc/db2 connection.
The solution is, that I must connect the Crystal Report with jdbc/db2 to the database and also connect in java/jsp to the database as the follows (only samplecode from helpfile):
setDbLogonViewReport.jsp
<%@. page import= "com.crystaldecisions.report.web.viewer.*,
com.crystaldecisions.sdk.occa.report.data.*" %>
<%@. page import="com.crystaldecisions.report.web.viewer.*" %>
<%@. page import="com.crystaldecisions.sdk.occa.report.data.*" %>
<%@. page import="com.crystaldecisions.reports.reportengineinterface.JPEReportSourceFactory" %>
<%@. page import="com.crystaldecisions.sdk.occa.report.reportsource.IReportSourceFactory2" %>
<%
Object reportSource = session.getAttribute("reportSource");
if (reportSource == null)
{
String report = "/reports/sample.rpt";
IReportSourceFactory2 rptSrcFactory = new JPEReportSourceFactory();
reportSource = rptSrcFactory.createReportSource(report, request.getLocale());
session.setAttribute("reportSource", reportSource);
}
ConnectionInfos connInfos = new ConnectionInfos();
IConnectionInfo connInfo1 = new ConnectionInfo();
connInfo1.setUserName("reportLogin");
connInfo1.setPassword("");
connInfos.add(connInfo1);
CrystalReportViewer viewer = new CrystalReportViewer();
viewer.setReportSource(reportSource);
&n bsp; viewer.setEnableLogonPrompt(false);
viewer.setDatabaseLogonInfos(connInfos);
if (session.getAttribute("refreshed") == null)
{
viewer.refresh();
session.setAttribute("refreshed", "true");
}
viewer.setOwnPage(true);
viewer.processHttpRequest(request, response, getServletConfig().getServletContext(), null);
%>
Ask if you've more questions to that.
I've created a simple jsp page with a crystal report viewer on it. I used Crystal Reports Developer to design the report, as db I use access and IBM WSED to create and run the jsp file on a server. That works fine, but when I would refresh the report it shows no recordset (and also no error message appears). Why I can't refresh the data?
The code:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<%@. page import="com.crystaldecisions.report.web.viewer.CrystalReportViewer" %>
<%@. page import="com.crystaldecisions.sdk.occa.report.data.*" %>
<%@. page import="com.crystaldecisions.reports.reportengineinterface.JPEReportSourceFactory,
com.crystaldecisions.sdk.occa.report.reportsource.IReportSourceFactory2,com.crystaldecisions.sdk.occa.report.reportsource.IReportSource"
%>
<HTML>
<HEAD>
</HEAD>
<BODY>
CrystalTest.jsp
<%
try {
IReportSourceFactory2 rptSrcFactory = new JPEReportSourceFactory();
String report = "/CrystalReport/Report1.rpt";
Object reportSource = rptSrcFactory.createReportSource(report, request.getLocale())
CrystalReportViewer viewer = new CrystalReportViewer();
viewer.setReportSource(reportSource);
viewer.setOwnPage(true);
viewer.setTop(80);
viewer.setDisplayGroupTree(false);
viewer.setHasLogo(false);
viewer.setHasRefreshButton(true);
viewer.processHttpRequest(request, response, getServletConfig().getServletContext(), null);
viewer.dispose();
} catch(Exception e)
{
out.println("CrystalTest: "+e);
}
%>
</BODY
</HTML>hi there!
I've now solved the problem with a jdbc/db2 connection.
The solution is, that I must connect the Crystal Report with jdbc/db2 to the database and also connect in java/jsp to the database as the follows (only samplecode from helpfile):
setDbLogonViewReport.jsp
<%@. page import= "com.crystaldecisions.report.web.viewer.*,
com.crystaldecisions.sdk.occa.report.data.*" %>
<%@. page import="com.crystaldecisions.report.web.viewer.*" %>
<%@. page import="com.crystaldecisions.sdk.occa.report.data.*" %>
<%@. page import="com.crystaldecisions.reports.reportengineinterface.JPEReportSourceFactory" %>
<%@. page import="com.crystaldecisions.sdk.occa.report.reportsource.IReportSourceFactory2" %>
<%
Object reportSource = session.getAttribute("reportSource");
if (reportSource == null)
{
String report = "/reports/sample.rpt";
IReportSourceFactory2 rptSrcFactory = new JPEReportSourceFactory();
reportSource = rptSrcFactory.createReportSource(report, request.getLocale());
session.setAttribute("reportSource", reportSource);
}
ConnectionInfos connInfos = new ConnectionInfos();
IConnectionInfo connInfo1 = new ConnectionInfo();
connInfo1.setUserName("reportLogin");
connInfo1.setPassword("");
connInfos.add(connInfo1);
CrystalReportViewer viewer = new CrystalReportViewer();
viewer.setReportSource(reportSource);
&n bsp; viewer.setEnableLogonPrompt(false);
viewer.setDatabaseLogonInfos(connInfos);
if (session.getAttribute("refreshed") == null)
{
viewer.refresh();
session.setAttribute("refreshed", "true");
}
viewer.setOwnPage(true);
viewer.processHttpRequest(request, response, getServletConfig().getServletContext(), null);
%>
Ask if you've more questions to that.
refresh view
Hello,
My problem is that I don't know how to refresh the view. Actually, what I
want to programaticaly do is something equivalant to presing the "run" butto
n
in the Enterprise manager.
A stored procedure that will do it, will also be good. But the only stored
procedure that I thought about is to drop the view and to create it again
(not a very elegant solution).
Do you know how I can solve this problem?
thanks!We could tell you, if you tell as the coding your using. "Refreshing" a view
means getting the data new, this differs in the languages.
HTH, Jens Suessmeyer.
"Liat" <Liat@.discussions.microsoft.com> schrieb im Newsbeitrag
news:83A7E9FC-9B15-4529-B49E-7EB2E27E4709@.microsoft.com...
> Hello,
> My problem is that I don't know how to refresh the view. Actually, what I
> want to programaticaly do is something equivalant to presing the "run"
> button
> in the Enterprise manager.
> A stored procedure that will do it, will also be good. But the only stored
> procedure that I thought about is to drop the view and to create it again
> (not a very elegant solution).
> Do you know how I can solve this problem?
> thanks!|||Liat
sp_refreshview stored procedure
"Liat" <Liat@.discussions.microsoft.com> wrote in message
news:83A7E9FC-9B15-4529-B49E-7EB2E27E4709@.microsoft.com...
> Hello,
> My problem is that I don't know how to refresh the view. Actually, what I
> want to programaticaly do is something equivalant to presing the "run"
button
> in the Enterprise manager.
> A stored procedure that will do it, will also be good. But the only stored
> procedure that I thought about is to drop the view and to create it again
> (not a very elegant solution).
> Do you know how I can solve this problem?
> thanks!|||I am using C++
"Jens Sü?meyer" wrote:
> We could tell you, if you tell as the coding your using. "Refreshing" a vi
ew
> means getting the data new, this differs in the languages.
> HTH, Jens Suessmeyer.
> "Liat" <Liat@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:83A7E9FC-9B15-4529-B49E-7EB2E27E4709@.microsoft.com...
>
>|||Hi
View doesnt store any data. Selecting rows from a view is as good as
executing the query that created it.
We go for views because, it improves the performance of a query.
thanks and regards
Chandra
"Liat" wrote:
> Hello,
> My problem is that I don't know how to refresh the view. Actually, what I
> want to programaticaly do is something equivalant to presing the "run" but
ton
> in the Enterprise manager.
> A stored procedure that will do it, will also be good. But the only stored
> procedure that I thought about is to drop the view and to create it again
> (not a very elegant solution).
> Do you know how I can solve this problem?
> thanks!|||> We go for views because, it improves the performance of a query.
Unless you are talking about indexed views, I disagree.sql
My problem is that I don't know how to refresh the view. Actually, what I
want to programaticaly do is something equivalant to presing the "run" butto
n
in the Enterprise manager.
A stored procedure that will do it, will also be good. But the only stored
procedure that I thought about is to drop the view and to create it again
(not a very elegant solution).
Do you know how I can solve this problem?
thanks!We could tell you, if you tell as the coding your using. "Refreshing" a view
means getting the data new, this differs in the languages.
HTH, Jens Suessmeyer.
"Liat" <Liat@.discussions.microsoft.com> schrieb im Newsbeitrag
news:83A7E9FC-9B15-4529-B49E-7EB2E27E4709@.microsoft.com...
> Hello,
> My problem is that I don't know how to refresh the view. Actually, what I
> want to programaticaly do is something equivalant to presing the "run"
> button
> in the Enterprise manager.
> A stored procedure that will do it, will also be good. But the only stored
> procedure that I thought about is to drop the view and to create it again
> (not a very elegant solution).
> Do you know how I can solve this problem?
> thanks!|||Liat
sp_refreshview stored procedure
"Liat" <Liat@.discussions.microsoft.com> wrote in message
news:83A7E9FC-9B15-4529-B49E-7EB2E27E4709@.microsoft.com...
> Hello,
> My problem is that I don't know how to refresh the view. Actually, what I
> want to programaticaly do is something equivalant to presing the "run"
button
> in the Enterprise manager.
> A stored procedure that will do it, will also be good. But the only stored
> procedure that I thought about is to drop the view and to create it again
> (not a very elegant solution).
> Do you know how I can solve this problem?
> thanks!|||I am using C++
"Jens Sü?meyer" wrote:
> We could tell you, if you tell as the coding your using. "Refreshing" a vi
ew
> means getting the data new, this differs in the languages.
> HTH, Jens Suessmeyer.
> "Liat" <Liat@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:83A7E9FC-9B15-4529-B49E-7EB2E27E4709@.microsoft.com...
>
>|||Hi
View doesnt store any data. Selecting rows from a view is as good as
executing the query that created it.
We go for views because, it improves the performance of a query.
thanks and regards
Chandra
"Liat" wrote:
> Hello,
> My problem is that I don't know how to refresh the view. Actually, what I
> want to programaticaly do is something equivalant to presing the "run" but
ton
> in the Enterprise manager.
> A stored procedure that will do it, will also be good. But the only stored
> procedure that I thought about is to drop the view and to create it again
> (not a very elegant solution).
> Do you know how I can solve this problem?
> thanks!|||> We go for views because, it improves the performance of a query.
Unless you are talking about indexed views, I disagree.sql
Refresh the properties of as server
I need to check if a server is running and then start the server if it is not running. I am having trouble with the ServiceState never updating. Ie... after I start the service I cannot check if its actually running using ServiceState.
In the following example I start a server that is stopped wait 30 seconds and then display its ServiceState it is allways comming back as stopped even when I know the service is running. If I make a new service object and set it to the server the server state property will correctly return running.
I am baffled by this any ideas on this?
Dim myComp As New ManagedComputer(System.Environment.MachineName)
Dim myservice As Service
myservice = myComp.Services("MSSQL$KBMSS")
myservice.Start()
Dim StartTime As TimeSpan = Date.Now.TimeOfDay
Do While Date.Now.TimeOfDay.Subtract(StartTime).TotalSeconds < 30
If myservice.ServiceState = ServiceState.Running Then Exit Do
Loop
MessageBox.Show(myservice.ServiceState.ToString)
Add myservice.Refresh() before the service state check and you're golden.
SMO is a cached object model, so it means you need to refresh the object state if needed.
refresh SSIS pkg to get the change
Hi, all,
How do you refresh a SSIS pkg to get the latest table schema change?
I have this data flow task that will load data from a flat file into a table.
I got a Warning: Truncation may occur due to retrieving data from database column "txtSNumber" with a length of 50 to data flow column "txtSNumber" with a length of 20.
Then I went into Management Studio and changed the column size.
Now in my dev BID I got next:
[SQL Server 05[82]] Warning: The external metadata column collection is out of synchronization with the data source columns. The column "txt..." needs to be updated in the external metadata column collection.
I think this means my change on the table did not get into my ssis, and I could not find a way to refresh.
Thanks!It actually means the opposite. The change was detected by SSIS and it needs to update the metadata associated with the table in the data flow task (i.e. change the column width from 20 to 50). It does not automatically do this without some user interaction (hitting "OK") since you may need to know about the change and correct it if it is incorrect.|||
Thanks for the reply.
I am not looking for the automatic way to refresh if there is one.
I want to manually start the process in my design environment and click the OK as you have suggested, but I could not find out how or from where to make it happen.
I have tried right click on my .dtsx and select reload with upgrade, but that is not it. Where can tap into the megadata?
|||Look at the components in your data flow that have the yellow triangle with an exclamation mark in it. Start there by double clicking on that component to refresh the metadata.|||Double click on the yellow mark is the trick! Thanks!Refresh SQL_CURSOR_FORWARD_ONLY
Hi,
I'm trying to refresh (re-read) the current row of an forward only cursor
but SQLFetchScroll and SQLSetPos will fail for this kind of Cursor. Is there
any way to do that?
Regards,
Michael Sterzl[GSD]"Michael Sterzl" <msterzl@.gsd-software.com> wrote in message
news:%23dBdajxtGHA.4752@.TK2MSFTNGP03.phx.gbl...
> Hi,
> I'm trying to refresh (re-read) the current row of an forward
> only cursor but SQLFetchScroll and SQLSetPos will fail for this
> kind of Cursor. Is there any way to do that?
> Regards,
> Michael Sterzl[GSD]
No. You can't scroll a forward only cursor.
- Arnie
I'm trying to refresh (re-read) the current row of an forward only cursor
but SQLFetchScroll and SQLSetPos will fail for this kind of Cursor. Is there
any way to do that?
Regards,
Michael Sterzl[GSD]"Michael Sterzl" <msterzl@.gsd-software.com> wrote in message
news:%23dBdajxtGHA.4752@.TK2MSFTNGP03.phx.gbl...
> Hi,
> I'm trying to refresh (re-read) the current row of an forward
> only cursor but SQLFetchScroll and SQLSetPos will fail for this
> kind of Cursor. Is there any way to do that?
> Regards,
> Michael Sterzl[GSD]
No. You can't scroll a forward only cursor.
- Arnie
Refresh selection in Query Analyzer?
I add a new table and I want to see it in my list, I can go to EM and refresh there but it appears I have to close QA in order to see the new table. Is there a refresh option in QA to see my new object?
thx,
Kat
Never Mind, I found it, use F5.
Kat
Friday, March 23, 2012
Refresh report without accessing database
I have a need to refresh a report after applying a filter on the data that is displayed, without accessing the database.
The following example is a simplified version of the functionality I'm trying to accomplish. The first report displays Sales & Projection data for all products. On clicking a particular product in the header, the second report displays just that product and the total metrics. I have created an rdl file for both the reports and based on the parameters passed, it displays one or several products. My concern is that the report is having to access the AS cube every time a product is clicked. In the real report, it's taking minutes to get the data. Is there way I can get the report to refresh to apply the filter without accessing the database again? Thanks in advance...
Report-1
Product
A
B
C
Total
Sales
100
200
300
600
Projection
200
200
300
700
Total
300
400
600
1300
Report-2
A
Total
Sales
100
600
Projection
200
700
Total
300
1300
exactly what I needed... Thanks John.
Refresh report without accessing database
I have a need to refresh a report after applying a filter on the data that is displayed, without accessing the database.
The following example is a simplified version of the functionality I'm trying to accomplish. The first report displays Sales & Projection data for all products. On clicking a particular product in the header, the second report displays just that product and the total metrics. I have created an rdl file for both the reports and based on the parameters passed, it displays one or several products. My concern is that the report is having to access the AS cube every time a product is clicked. In the real report, it's taking minutes to get the data. Is there way I can get the report to refresh to apply the filter without accessing the database again? Thanks in advance...
Report-1
Product
A
B
C
Total
Sales
100
200
300
600
Projection
200
200
300
700
Total
300
400
600
1300
Report-2
A
Total
Sales
100
600
Projection
200
700
Total
300
1300
exactly what I needed... Thanks John.
Refresh Report from Browser
I post a report on report server. I open the report from IE browser, after I
updated the database and I click REFRESH button on toolbar, report was not
refreshed. The only way is that I have to close browser and launch it again
and open the report to display refreshed data.
Could anyone let me know if we only click refresh button on the tool bar of
browser so that we can get refreshed reports?
Thanks a lot.Click the Refresh Button within the report itself.
Charles Kangai, MCT, MCDBA
"Sally" wrote:
> I post a report on report server. I open the report from IE browser, after I
> updated the database and I click REFRESH button on toolbar, report was not
> refreshed. The only way is that I have to close browser and launch it again
> and open the report to display refreshed data.
> Could anyone let me know if we only click refresh button on the tool bar of
> browser so that we can get refreshed reports?
> Thanks a lot.
>|||Here is my report url, I would like disable toolbar only except Refresh
button, how do I do that?
http://localhost/corpreportserver?/UsageReports/UsageStatusSummary&rc:parameters=false&rc:toolbar=false
Thanks,
"Charles Kangai" wrote:
> Click the Refresh Button within the report itself.
> Charles Kangai, MCT, MCDBA
> "Sally" wrote:
> > I post a report on report server. I open the report from IE browser, after I
> > updated the database and I click REFRESH button on toolbar, report was not
> > refreshed. The only way is that I have to close browser and launch it again
> > and open the report to display refreshed data.
> >
> > Could anyone let me know if we only click refresh button on the tool bar of
> > browser so that we can get refreshed reports?
> >
> > Thanks a lot.
> >
> >|||Hi Sally,
Are you talking about the Browser toolbar or the Report toolbar. They are
very different things, but both have a refresh button!
The refresh button on the report toolbar re-submits the query refreshing the
data.
The refresh button on the browser toolbar just requests the report from the
web server again, if you have 'caching' on the report it won't necessarily
submit the query again.
Look in properties and execution for the report in report manager for
'Cache' settings.
Regards
Chris
"Sally" wrote:
> Here is my report url, I would like disable toolbar only except Refresh
> button, how do I do that?
> http://localhost/corpreportserver?/UsageReports/UsageStatusSummary&rc:parameters=false&rc:toolbar=false
> Thanks,
> "Charles Kangai" wrote:
> > Click the Refresh Button within the report itself.
> >
> > Charles Kangai, MCT, MCDBA
> >
> > "Sally" wrote:
> >
> > > I post a report on report server. I open the report from IE browser, after I
> > > updated the database and I click REFRESH button on toolbar, report was not
> > > refreshed. The only way is that I have to close browser and launch it again
> > > and open the report to display refreshed data.
> > >
> > > Could anyone let me know if we only click refresh button on the tool bar of
> > > browser so that we can get refreshed reports?
> > >
> > > Thanks a lot.
> > >
> > >
updated the database and I click REFRESH button on toolbar, report was not
refreshed. The only way is that I have to close browser and launch it again
and open the report to display refreshed data.
Could anyone let me know if we only click refresh button on the tool bar of
browser so that we can get refreshed reports?
Thanks a lot.Click the Refresh Button within the report itself.
Charles Kangai, MCT, MCDBA
"Sally" wrote:
> I post a report on report server. I open the report from IE browser, after I
> updated the database and I click REFRESH button on toolbar, report was not
> refreshed. The only way is that I have to close browser and launch it again
> and open the report to display refreshed data.
> Could anyone let me know if we only click refresh button on the tool bar of
> browser so that we can get refreshed reports?
> Thanks a lot.
>|||Here is my report url, I would like disable toolbar only except Refresh
button, how do I do that?
http://localhost/corpreportserver?/UsageReports/UsageStatusSummary&rc:parameters=false&rc:toolbar=false
Thanks,
"Charles Kangai" wrote:
> Click the Refresh Button within the report itself.
> Charles Kangai, MCT, MCDBA
> "Sally" wrote:
> > I post a report on report server. I open the report from IE browser, after I
> > updated the database and I click REFRESH button on toolbar, report was not
> > refreshed. The only way is that I have to close browser and launch it again
> > and open the report to display refreshed data.
> >
> > Could anyone let me know if we only click refresh button on the tool bar of
> > browser so that we can get refreshed reports?
> >
> > Thanks a lot.
> >
> >|||Hi Sally,
Are you talking about the Browser toolbar or the Report toolbar. They are
very different things, but both have a refresh button!
The refresh button on the report toolbar re-submits the query refreshing the
data.
The refresh button on the browser toolbar just requests the report from the
web server again, if you have 'caching' on the report it won't necessarily
submit the query again.
Look in properties and execution for the report in report manager for
'Cache' settings.
Regards
Chris
"Sally" wrote:
> Here is my report url, I would like disable toolbar only except Refresh
> button, how do I do that?
> http://localhost/corpreportserver?/UsageReports/UsageStatusSummary&rc:parameters=false&rc:toolbar=false
> Thanks,
> "Charles Kangai" wrote:
> > Click the Refresh Button within the report itself.
> >
> > Charles Kangai, MCT, MCDBA
> >
> > "Sally" wrote:
> >
> > > I post a report on report server. I open the report from IE browser, after I
> > > updated the database and I click REFRESH button on toolbar, report was not
> > > refreshed. The only way is that I have to close browser and launch it again
> > > and open the report to display refreshed data.
> > >
> > > Could anyone let me know if we only click refresh button on the tool bar of
> > > browser so that we can get refreshed reports?
> > >
> > > Thanks a lot.
> > >
> > >
Refresh problem in Crystal Viewer control
Dear Guru's
I am using Crystal viewer control in my VC++ application project. Here i am facing report refresh problem. If i call viewer control Refresh method directly the application is crashing. I am calling that inside OnPaint( ) .
The problem is the report data is not displaying first time the user has to click refresh button.
Please help me how to use "Refresh " method.
Thanks
arunNot sure if this will help, but make sure 'Save Data with Report' is NOT checked. Otherwise, have you tried calling Refresh as soon as the report is displayed (instead of waiting for the user to do it)?|||I am trying to refresh the report through code only using Viewer control 'Refresh' method.
If report displayed with blank then how user came to know that he has to refresh the report by clicking refresh button.
I am using Crystal viewer control in my VC++ application project. Here i am facing report refresh problem. If i call viewer control Refresh method directly the application is crashing. I am calling that inside OnPaint( ) .
The problem is the report data is not displaying first time the user has to click refresh button.
Please help me how to use "Refresh " method.
Thanks
arunNot sure if this will help, but make sure 'Save Data with Report' is NOT checked. Otherwise, have you tried calling Refresh as soon as the report is displayed (instead of waiting for the user to do it)?|||I am trying to refresh the report through code only using Viewer control 'Refresh' method.
If report displayed with blank then how user came to know that he has to refresh the report by clicking refresh button.
Refresh problem after installing MSDE
Hi,
After installing a MSDE instance, in the Servcie Manager I don't see the
server I've just installed. But if I enter the name of the instance in
Service Manager, I can acces it and then start/pause/stop it. If I reboot
the PC, the server will not start even if the checkbox in Service Manager is
check. In Service Manager, I see no server again. Seems the system can't see
the server but it is here and I can access it manually since I know the
name.
I have found nothing avout this problem for the moment.
hi David,
David G. wrote:
> Hi,
> After installing a MSDE instance, in the Servcie Manager I don't see
> the server I've just installed. But if I enter the name of the
> instance in Service Manager, I can acces it and then start/pause/stop
> it. If I reboot the PC, the server will not start even if the
> checkbox in Service Manager is check. In Service Manager, I see no
> server again. Seems the system can't see the server but it is here
> and I can access it manually since I know the name.
> I have found nothing avout this problem for the moment.
please have a look at
http://support.microsoft.com/default...b;EN-US;814132
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.18.0 - DbaMgr ver 0.62.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||After reading this, the Sql Server is "started" and "automatically" in the
services. But in the systray, the Service Manager doesn't have a green
arrow. It's just full white.
If I open the Service Manager, type the Sql Server instance name and hit
the button "refresh services ..." then I can see the instance. I must do
this each time after I boot the computer.
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> a crit dans le message de
news: 47dpi7Ff36s5U1@.individual.net...
> hi David,
> please have a look at
> http://support.microsoft.com/default...b;EN-US;814132
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.18.0 - DbaMgr ver 0.62.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
sql
After installing a MSDE instance, in the Servcie Manager I don't see the
server I've just installed. But if I enter the name of the instance in
Service Manager, I can acces it and then start/pause/stop it. If I reboot
the PC, the server will not start even if the checkbox in Service Manager is
check. In Service Manager, I see no server again. Seems the system can't see
the server but it is here and I can access it manually since I know the
name.
I have found nothing avout this problem for the moment.
hi David,
David G. wrote:
> Hi,
> After installing a MSDE instance, in the Servcie Manager I don't see
> the server I've just installed. But if I enter the name of the
> instance in Service Manager, I can acces it and then start/pause/stop
> it. If I reboot the PC, the server will not start even if the
> checkbox in Service Manager is check. In Service Manager, I see no
> server again. Seems the system can't see the server but it is here
> and I can access it manually since I know the name.
> I have found nothing avout this problem for the moment.
please have a look at
http://support.microsoft.com/default...b;EN-US;814132
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.18.0 - DbaMgr ver 0.62.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||After reading this, the Sql Server is "started" and "automatically" in the
services. But in the systray, the Service Manager doesn't have a green
arrow. It's just full white.
If I open the Service Manager, type the Sql Server instance name and hit
the button "refresh services ..." then I can see the instance. I must do
this each time after I boot the computer.
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> a crit dans le message de
news: 47dpi7Ff36s5U1@.individual.net...
> hi David,
> please have a look at
> http://support.microsoft.com/default...b;EN-US;814132
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.18.0 - DbaMgr ver 0.62.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
sql
Refresh page when database data is update
Hi All,
Is it possible to refresh the web page when certain table data is updated? And I cannot use the auto-refresh feature. Thank you very much.
Not easily. I imagine you could hobble something together with AJAX, but it would likely be fragile and not easy to maintain.
Refresh of Data in Crystal Report
Hello,
I'm developing Crystal Report and data is being fetched using Query. Now each time I "run" report, I get stale data. I tested query several times and that is working fine.
I also checked that,
1. File->Report Options-> Save Data with Report is UNChecked.
2. File->Options->Reporting->Save Data with Report is UNChecked.
3. File->Options->Reporting->Discard Saved Data while Loading Report is Checked.
Whenever I open report, I only see Design tab and no Preview tab. however, on running report, I get stale data. Please let me know if you know solution to this problem.
Thanks a lot in Advance,
Regards,
RupeshI am having a very similar problem. I just gave one of our users a new computer. She was running windows 2000 and she is now running windows xp. I installed crystal reports for her and imported all of her ODBC settings from the old computer to the new computer. There are two crystal reports that when she opens them, it only shows the "design tab", but no "preview tab". When I go back and open those two reports from her old computer, they open fine. I see that nobody responded to your post. Did you ever find a solution to the problem?
Thanks - Jeff|||Rupsan,
What do you mean by stale data?
Also what Ver are you using?
Texasman,
The reason your preview tab does not show up is because the savedata box is not checked in report options.|||ya exactly dear when you uncheck the save data you don't find any preview tab if you want preview click on print preview in report you will find it.
and rupsan i also don't understand what stale data means.
thanks|||I have the same issue. I have unchecked (and checked) the appropriate boxes as did the OP. On open, I do not get a preview tab (This is what I expected). However, on refresh the data on my report is last weeks data. I looked directly at the data table and there have been several additional entries that are not shown on the report. I have disconnected and reconnected to the databse, all to no avail. Can anyone figure this out?? Thanks.
I'm developing Crystal Report and data is being fetched using Query. Now each time I "run" report, I get stale data. I tested query several times and that is working fine.
I also checked that,
1. File->Report Options-> Save Data with Report is UNChecked.
2. File->Options->Reporting->Save Data with Report is UNChecked.
3. File->Options->Reporting->Discard Saved Data while Loading Report is Checked.
Whenever I open report, I only see Design tab and no Preview tab. however, on running report, I get stale data. Please let me know if you know solution to this problem.
Thanks a lot in Advance,
Regards,
RupeshI am having a very similar problem. I just gave one of our users a new computer. She was running windows 2000 and she is now running windows xp. I installed crystal reports for her and imported all of her ODBC settings from the old computer to the new computer. There are two crystal reports that when she opens them, it only shows the "design tab", but no "preview tab". When I go back and open those two reports from her old computer, they open fine. I see that nobody responded to your post. Did you ever find a solution to the problem?
Thanks - Jeff|||Rupsan,
What do you mean by stale data?
Also what Ver are you using?
Texasman,
The reason your preview tab does not show up is because the savedata box is not checked in report options.|||ya exactly dear when you uncheck the save data you don't find any preview tab if you want preview click on print preview in report you will find it.
and rupsan i also don't understand what stale data means.
thanks|||I have the same issue. I have unchecked (and checked) the appropriate boxes as did the OP. On open, I do not get a preview tab (This is what I expected). However, on refresh the data on my report is last weeks data. I looked directly at the data table and there have been several additional entries that are not shown on the report. I have disconnected and reconnected to the databse, all to no avail. Can anyone figure this out?? Thanks.
Refresh Memory Usage History in Taskman
Hi,
After some time, my server Memory Usage History run up to 80%-90% even the
server does not have any connection in it.
This is server running only MS SQL 2000 + IIS in Win2K Server.
I was wondering that, by using the Win / WMI command to refresh / reset
this Memory Usage History.
Does anyone try this before or any ideal from you all?
Thank you.....
--
Regard,
Kzeto ngHave a look at
INF: SQL Server Memory Usage
http://support.microsoft.com/default.aspx?scid=kb;en-us;q321363
http://www.mssqlserver.com/faq/troubleshooting-memoryleak.asp
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Kzeto ng" <kzetong@.yahoo.com> wrote in message news:eVe2I3kuDHA.3196@.TK2MSFTNGP11.phx.gbl...
> Hi,
> After some time, my server Memory Usage History run up to 80%-90% even the
> server does not have any connection in it.
> This is server running only MS SQL 2000 + IIS in Win2K Server.
> I was wondering that, by using the Win / WMI command to refresh / reset
> this Memory Usage History.
> Does anyone try this before or any ideal from you all?
> Thank you.....
> --
> Regard,
> Kzeto ng
>
>|||How much memory do you have, how much is assigned to SQL (see SQL
configuration parameters)?
And how much is the threshold set for IIS (check your machine.config file)?
Willy.
"Kzeto ng" <kzetong@.yahoo.com> wrote in message
news:eVe2I3kuDHA.3196@.TK2MSFTNGP11.phx.gbl...
> Hi,
> After some time, my server Memory Usage History run up to 80%-90% even
the
> server does not have any connection in it.
> This is server running only MS SQL 2000 + IIS in Win2K Server.
> I was wondering that, by using the Win / WMI command to refresh / reset
> this Memory Usage History.
> Does anyone try this before or any ideal from you all?
> Thank you.....
> --
> Regard,
> Kzeto ng
>
>
After some time, my server Memory Usage History run up to 80%-90% even the
server does not have any connection in it.
This is server running only MS SQL 2000 + IIS in Win2K Server.
I was wondering that, by using the Win / WMI command to refresh / reset
this Memory Usage History.
Does anyone try this before or any ideal from you all?
Thank you.....
--
Regard,
Kzeto ngHave a look at
INF: SQL Server Memory Usage
http://support.microsoft.com/default.aspx?scid=kb;en-us;q321363
http://www.mssqlserver.com/faq/troubleshooting-memoryleak.asp
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Kzeto ng" <kzetong@.yahoo.com> wrote in message news:eVe2I3kuDHA.3196@.TK2MSFTNGP11.phx.gbl...
> Hi,
> After some time, my server Memory Usage History run up to 80%-90% even the
> server does not have any connection in it.
> This is server running only MS SQL 2000 + IIS in Win2K Server.
> I was wondering that, by using the Win / WMI command to refresh / reset
> this Memory Usage History.
> Does anyone try this before or any ideal from you all?
> Thank you.....
> --
> Regard,
> Kzeto ng
>
>|||How much memory do you have, how much is assigned to SQL (see SQL
configuration parameters)?
And how much is the threshold set for IIS (check your machine.config file)?
Willy.
"Kzeto ng" <kzetong@.yahoo.com> wrote in message
news:eVe2I3kuDHA.3196@.TK2MSFTNGP11.phx.gbl...
> Hi,
> After some time, my server Memory Usage History run up to 80%-90% even
the
> server does not have any connection in it.
> This is server running only MS SQL 2000 + IIS in Win2K Server.
> I was wondering that, by using the Win / WMI command to refresh / reset
> this Memory Usage History.
> Does anyone try this before or any ideal from you all?
> Thank you.....
> --
> Regard,
> Kzeto ng
>
>
Refresh Linked Server without restart?
Hi All,
Firstly, apologies if this isn't the correct category for this posting but I couldn't see anything more appropriate! 
I have an alias set up on my server which I want to change to point to a different server. However when I do this, the original info seems to be cached within SQL Server so any connections that were open before the change continue to use the original server. The only CONSISTENT way (that I can see) of ensuring the new attributes are picked up is by restarting the server which is a little more extreme than I would have hoped. It's worth mentioning that on a couple of occasions the updates have seemed to have filtered through without a restart which has only caused me more confusion due to this inconsistency... 
If anyone knows of a handy sp or the likes that forces the linked server attributes to be refreshed I'd be mighty grateful.
Thanks in advance,
Rob.
Probably too late, but I thought it worth posting for others who may run into this:- Change your alias
- Open SMSS and connect to the server with the linked server
- Open Server Objects -> Linked Servers -> your linked server
- Select Catalogs, and right-click "Refresh"
On my machine, this instantly corrected the cached alias value.
refresh identity value
hi,
how can I refresh a identity value of a table after a record gets deleted.
for example a table has 100 rows. One of its column name is rowIndex set to identity 1, incremental 1. After I remove the row with rowIndex value 100, if I insert a new record the rowIndex will be 101, but I want its rowIndex value to be 100. Is there a way to update the identity value after a record gets removed?Yes, but that's not the intention of an identity column. An identity column is intended to automaticaly give you unique record ids.
If you want your rowindex to represent something else then add a trigger to get the max(rowindex) and then add 1.sql
how can I refresh a identity value of a table after a record gets deleted.
for example a table has 100 rows. One of its column name is rowIndex set to identity 1, incremental 1. After I remove the row with rowIndex value 100, if I insert a new record the rowIndex will be 101, but I want its rowIndex value to be 100. Is there a way to update the identity value after a record gets removed?Yes, but that's not the intention of an identity column. An identity column is intended to automaticaly give you unique record ids.
If you want your rowindex to represent something else then add a trigger to get the max(rowindex) and then add 1.sql
Refresh Fields list
Ok, what is the secret key combination to refresh the fields list? Please? :-)
I am modifying a drilldown report I created, and have added a field returned from my stored procedure, and would now like to include this field on my report. I am clicking around and I cannot seem to trigger it to refresh the fields list, and I am receiving a build error as follows:
"The value expression for the textbox â'Regionâ' refers to the field â'REGION_ORG_CODEâ'. Report item expressions can only refer to fields within the current data set scope or, if inside an aggregate, the specified data set scope."
This field is within the current data set scope, or at least it should be. How can I include this field on my report? CTRL-ALT-F?DOH! Just noticed there is a button on the toolbar in the Data tab for this. It would be nice if this were a little more obvious.
Also, I would suggest that this feature be added to the Right click context menu in the Fields list itself.
Thanks.
"Joe" wrote:
> Ok, what is the secret key combination to refresh the fields list? Please? :-)
> I am modifying a drilldown report I created, and have added a field returned from my stored procedure, and would now like to include this field on my report. I am clicking around and I cannot seem to trigger it to refresh the fields list, and I am receiving a build error as follows:
> "The value expression for the textbox â'Regionâ' refers to the field â'REGION_ORG_CODEâ'. Report item expressions can only refer to fields within the current data set scope or, if inside an aggregate, the specified data set scope."
> This field is within the current data set scope, or at least it should be. How can I include this field on my report? CTRL-ALT-F?
I am modifying a drilldown report I created, and have added a field returned from my stored procedure, and would now like to include this field on my report. I am clicking around and I cannot seem to trigger it to refresh the fields list, and I am receiving a build error as follows:
"The value expression for the textbox â'Regionâ' refers to the field â'REGION_ORG_CODEâ'. Report item expressions can only refer to fields within the current data set scope or, if inside an aggregate, the specified data set scope."
This field is within the current data set scope, or at least it should be. How can I include this field on my report? CTRL-ALT-F?DOH! Just noticed there is a button on the toolbar in the Data tab for this. It would be nice if this were a little more obvious.
Also, I would suggest that this feature be added to the Right click context menu in the Fields list itself.
Thanks.
"Joe" wrote:
> Ok, what is the secret key combination to refresh the fields list? Please? :-)
> I am modifying a drilldown report I created, and have added a field returned from my stored procedure, and would now like to include this field on my report. I am clicking around and I cannot seem to trigger it to refresh the fields list, and I am receiving a build error as follows:
> "The value expression for the textbox â'Regionâ' refers to the field â'REGION_ORG_CODEâ'. Report item expressions can only refer to fields within the current data set scope or, if inside an aggregate, the specified data set scope."
> This field is within the current data set scope, or at least it should be. How can I include this field on my report? CTRL-ALT-F?
Subscribe to:
Posts (Atom)