"short circuit"/stop auto generating report after clicking report

In Report Manager, using a parameterless report or a report with parameters
that have default values, if one clicks on the report link in a folder, the
report automatically begins generating and then the data is viewable.
Is there any way to prevent the report from being (automatically) generated
so as to require the user to have to click the standard "View Report" button?
A solution might be in the "code"/RDL or perhaps the
"web.config"/RSWebApplication.config. Either is OK. Or anything else.On Jun 27, 1:28 pm, John <J...@.discussions.microsoft.com> wrote:
> In Report Manager, using a parameterless report or a report with parameters
> that have default values, if one clicks on the report link in a folder, the
> report automatically begins generating and then the data is viewable.
> Is there any way to prevent the report from being (automatically) generated
> so as to require the user to have to click the standard "View Report" button?
> A solution might be in the "code"/RDL or perhaps the
> "web.config"/RSWebApplication.config. Either is OK. Or anything else.
The easiest way to accomplish this is, in cases where report
parameters are used, to not have a default set for at least one of the
parameters. Sorry that I could not be of greater assistance.
Regards,
Enrique Martinez
Sr. Software Consultant

"Session" values

Is it possible to have the equivalent of a session value? What I'm wanting
to do is get the user to choose a value (item center) on the home page and
use that value to filter all the reports. Then if he wants to see the
reports for a different item center, he must go back to the home page and
choose a different one.
Even better, display the same list of item centers as a filter option at the
top of each report and default it to the currently chosen item center.
Any ideas on how to do this? I saw a post where someone asked if it was
possible to create a global variable to use throughout all reports and noone
answered him. So I'm assuming that it can't be done. But I'm asking anyhow.
Thanks
ToddTodd,
If you create your own web application, you can certainly keep track of some
value and pass it to your reports as one of the parameters. AFAIK, there is
no built-in functionality in the ReportServer or Report Manager web apps.
Ted
"Todd Bright" wrote:
> Is it possible to have the equivalent of a session value? What I'm wanting
> to do is get the user to choose a value (item center) on the home page and
> use that value to filter all the reports. Then if he wants to see the
> reports for a different item center, he must go back to the home page and
> choose a different one.
> Even better, display the same list of item centers as a filter option at the
> top of each report and default it to the currently chosen item center.
> Any ideas on how to do this? I saw a post where someone asked if it was
> possible to create a global variable to use throughout all reports and noone
> answered him. So I'm assuming that it can't be done. But I'm asking anyhow.
> Thanks
> Todd|||So basically each report is just a standalone report, right?
"Ted K" wrote:
> Todd,
> If you create your own web application, you can certainly keep track of some
> value and pass it to your reports as one of the parameters. AFAIK, there is
> no built-in functionality in the ReportServer or Report Manager web apps.
> Ted
> "Todd Bright" wrote:
> > Is it possible to have the equivalent of a session value? What I'm wanting
> > to do is get the user to choose a value (item center) on the home page and
> > use that value to filter all the reports. Then if he wants to see the
> > reports for a different item center, he must go back to the home page and
> > choose a different one.
> >
> > Even better, display the same list of item centers as a filter option at the
> > top of each report and default it to the currently chosen item center.
> >
> > Any ideas on how to do this? I saw a post where someone asked if it was
> > possible to create a global variable to use throughout all reports and noone
> > answered him. So I'm assuming that it can't be done. But I'm asking anyhow.
> >
> > Thanks
> > Todd

"Missing Parameter Values" Error shown when subReport includes in Main Report

Dear all,

There is an error,"Missing Parameter Values" shown when sub-report includes in the Main report.
(And there is no parameter setup in sub-report)
What i do is to setup the datasource into sub-report by coding..

I find that they runs fine when the main report, sub-report are separated.

CAn anyone give me some ideas about the solution?

P.S. The platform i am using is VS 2005.. Thanks much

michaelDid you link your subreport to your main?
GJ|||there is no link between the subreport and the main report. Maybe say, main report and subreport are totally 2 different kinds of report.

P.S. the subreport is located in report footer

Thx

"List of Values Failure" error in CR

I have designed a Crystal report from an ODBC connection. But recently I was asked to change the connection to JDBC. The data is from an SQL database. I have set the database location to JDBC from crystal report program. Everytime I preview the resuls I get the following error message.

"Prompting failed with the following error message: 'List of Values failure: fail to get values. [Cause of error: Failed to open connection. Failed to open the connection. UNKNOWN.rpt']. Error source: prompt.dll Error code: 0x8004380D."

Please help.Goto Database and Set Location and set the path
Do verify Database also

"IN" clause limitation

Does anybody know what is the limit for the number of values one can
have in a list of expressions (to test for a match) for the IN clause?

For example,
SELECT au_lname, state
FROM authors
WHERE state IN ('CA', 'IN', 'MD')

Is there a limit in the number of expressions that can be included in
the list to check for a match to STATE? I know this is a bad example as
there are only 50 states, but my actual query is similar to this, the
only difference being I may have about 1000 values in the 'IN' clause
to test for a match.

TIA!I don't think there is a documented limit and with 1000 values you'll
probably be ok. At some point you'll hit a memory allocation or batch
size limit if you keep adding values to the list.

Is that really the best way you can pass 1000 values? Why don't you put
the data in a table instead?

--
David Portas
SQL Server MVP
--|||Thanks David! You were right on target - I've already hit the memory
allocation limit!

Table sounds good, but I was just tweaking somebody else's code. Thanks
for the idea though! :)

David Portas wrote:
> I don't think there is a documented limit and with 1000 values you'll
> probably be ok. At some point you'll hit a memory allocation or batch
> size limit if you keep adding values to the list.
> Is that really the best way you can pass 1000 values? Why don't you
put
> the data in a table instead?
> --
> David Portas
> SQL Server MVP
> --|||karthik (karthiksmiles@.gmail.com) writes:
> Does anybody know what is the limit for the number of values one can
> have in a list of expressions (to test for a match) for the IN clause?
> For example,
> SELECT au_lname, state
> FROM authors
> WHERE state IN ('CA', 'IN', 'MD')
> Is there a limit in the number of expressions that can be included in
> the list to check for a match to STATE? I know this is a bad example as
> there are only 50 states, but my actual query is similar to this, the
> only difference being I may have about 1000 values in the 'IN' clause
> to test for a match.

1000 values should work. However, the performance for large IN list
is absymal. The problem is not with query execution time, but query
compile time. So putting the values into a table is certainly a good idea.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

"Column name or number of supplied values does not match table definition" when trying to

Hello,
I am receiving the following error:

Column name or number of supplied values does not match table definition

I am trying to insert values into a temp table, using values from the table I copied the structure from, like this:

SELECT TOP 1 * INTO #tbl_User_Temp FROM tbl_User
TRUNCATE TABLE #tbl_User_Temp
INSERT INTO #tbl_User_Temp EXECUTE UserPersist_GetUserByCriteria @.Gender = 'Male', @.Culture = 'en-GB'

The SP UserPersist_GetByCriteria does a"SELECT * FROM tbl_User WHERE gender = @.Gender AND culture = @.Culture",so why am I receiving this error when both tables have the samestructure?
The error is being reported as coming from UserPersist_GetByCriteria on the "SELECT * FROM tbl_User" line.
Thanks,
Greg.
hello...
this might be simplified version..
SELECT * INTO #tbl_User FROM tbl_User WHERE Gender='Male' AND Culture='en-GB'
and there might be idenity column on your original tbl_User..?
i tested a table with identity column, same error msg (just guess)|||In addition to busyweb's reply, if you do need to create an empty temptable using SELECT INTO in the future, try the following instead of TOP1 + TRUNCATE:
SELECT *
INTO #Tbl
FROM SomeTable
WHERE 1=0

"Colescing" values in a field?

Hello all, i am wondering if i can do the following with simple TSQL
statements without needing to resort to using cursors... i am having a hard
time trying to think of a way, but TSQL isnt my 'native' sql programming
language (i 'grew up' on PL/SQL), so im hoping someone else can think of
something of how to do this.
I have a field which has essentially sequential values, say,
1,2,3,4,5,6..... but for certain reasons they are not sequence assigned
(they are actually alphanumeric, 1A, 1B, 1C, 1D, etc...). After time,
records get added and deleted, and the sequnce winds up with holes in it...
1A, 1B, 1D, 1G, ...
Is there a slick or elegent T/SQL statement i can run to coalesce these
values back down to fill in the gaps?
So the above holed sequence of 1A, 1B, 1D, 1G would wind up being 1A, 1B,
1C, 1D.
Thanks in advance.
- Arthur Dent.one obvious way, but perhaps not very elegant would be to insert the
values into a temporary table with an extra identity field, then use
that to remap your values with an update statement|||Arthur Dent wrote:
> Hello all, i am wondering if i can do the following with simple TSQL
> statements without needing to resort to using cursors... i am having a ha
rd
> time trying to think of a way, but TSQL isnt my 'native' sql programming
> language (i 'grew up' on PL/SQL), so im hoping someone else can think of
> something of how to do this.
> I have a field which has essentially sequential values, say,
> 1,2,3,4,5,6..... but for certain reasons they are not sequence assigned
> (they are actually alphanumeric, 1A, 1B, 1C, 1D, etc...). After time,
> records get added and deleted, and the sequnce winds up with holes in it..
.
> 1A, 1B, 1D, 1G, ...
> Is there a slick or elegent T/SQL statement i can run to coalesce these
> values back down to fill in the gaps?
> So the above holed sequence of 1A, 1B, 1D, 1G would wind up being 1A, 1B,
> 1C, 1D.
> Thanks in advance.
> - Arthur Dent.
Is SQL Server a word processor or a DBMS? How about putting the values
in a table rather than delimiting them in a column?
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--|||One question comes to mind... WHY?
Another one would be... is this column being referenced by another table?
I would lean towards doing this in a client application.
"Arthur Dent" <hitchhikersguideto-news@.yahoo.com> wrote in message
news:eJvDfhYWGHA.1200@.TK2MSFTNGP03.phx.gbl...
> Hello all, i am wondering if i can do the following with simple TSQL
> statements without needing to resort to using cursors... i am having a
> hard time trying to think of a way, but TSQL isnt my 'native' sql
> programming language (i 'grew up' on PL/SQL), so im hoping someone else
> can think of something of how to do this.
> I have a field which has essentially sequential values, say,
> 1,2,3,4,5,6..... but for certain reasons they are not sequence assigned
> (they are actually alphanumeric, 1A, 1B, 1C, 1D, etc...). After time,
> records get added and deleted, and the sequnce winds up with holes in
> it...
> 1A, 1B, 1D, 1G, ...
> Is there a slick or elegent T/SQL statement i can run to coalesce these
> values back down to fill in the gaps?
> So the above holed sequence of 1A, 1B, 1D, 1G would wind up being 1A, 1B,
> 1C, 1D.
> Thanks in advance.
> - Arthur Dent.
>|||I think you guys misread it, I interpreted 1,2,3,4,5,6..... as being
1
2
3
4
5
6|||Will wrote:
> I think you guys misread it, I interpreted 1,2,3,4,5,6..... as being
> 1
> 2
> 3
> 4
> 5
> 6
Perhaps you are right. If Arthur had included DDL and some proper
sample data then we wouldn't have to resort to guessing.
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--|||I understood it the same way you did Will.
So you should change your post to:
>I think you guy misread it, ... :-)
"Will" <william_pegg@.yahoo.co.uk> wrote in message
news:1144336766.712050.287240@.j33g2000cwa.googlegroups.com...
>I think you guys misread it, I interpreted 1,2,3,4,5,6..... as being
> 1
> 2
> 3
> 4
> 5
> 6
>|||> One question comes to mind... WHY?
Obviously to make the result set pretty as must have been the intention of
whoever invented this lovely key generator. :)
ML
http://milambda.blogspot.com/

"Blank" Data Values in SQL Profiler

I'm built a trace in SQL Profiler and I have selected columns "DatabaseName" and "Filename" (among others) to be displayed. When I run the trace, the columns are displayed but the values are blank. The SQLServer 2K version is 8.0.760. Is this a bug or am I missing something?Not all profiler data columns are populated for all events that can be captured.

AFAICT "database name" will be populated for some events in the "security audit" catgory of events.

In the "trace properties" box , on the "data columns" tab, press the help button.

This should open up the BOL entry for "properties (data columns tab)"

click on the "monitoring with SQL Profiler Event categories" link at the bottom of that help page, and you get to see which columns may be relevant to each trace event.

Bill|||Thanks; the BOL tip is very helpful.