By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,985 Members | 2,884 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,985 IT Pros & Developers. It's quick & easy.

Progress indicator for Queries/Reports

P: 15
Hi,

I have a report which is taking a rather long time to generate because i have had to use nested ranking queries (i'm not sure if nested is the right term - basically rank within rank queries). Unfortunately, this has meant it the report takes 2 minutes+ to generate.

Is there a way of making a progress indicator for the report so that users don't think their computer has crashed?

Thanks again.
Oct 23 '06 #1
Share this Question
Share on Google+
6 Replies


100+
P: 143
Check this out.

http://search.support.microsoft.com/search/default.aspx?catalog=LCID%3D1033&1033comm=1&spid=1 265&query=progress+bar&pwt=false&title=false&kt=AL L&mdt=0&res=20&ast=1&ast=2&ast=3&ast=4&ast=7&mode= a&adv=1
Oct 23 '06 #2

MMcCarthy
Expert Mod 10K+
P: 14,534
If you want to post the nested queries I'll have a look at it for you.

Hi,


I have a report which is taking a rather long time to generate because i have had to use nested ranking queries (i'm not sure if nested is the right term - basically rank within rank queries). Unfortunately, this has meant it the report takes 2 minutes+ to generate.

Is there a way of making a progress indicator for the report so that users don't think their computer has crashed?

Thanks again.
Oct 24 '06 #3

P: 15
If you want to post the nested queries I'll have a look at it for you.
Hi mmcarthy, thanks for offering to help. Pls see below the query i'm using to assign a ranking:

IntlRP_Rank_b: (SELECT COUNT(*) FROM [q_Trans_1c_sum_by_country] AS IntlRPTotal_a WHERE
[q_Trans_1c_sum_by_country].[Ind_Rank] = IntlRPTotal_a.Ind_Rank AND
[q_Trans_1c_sum_by_country].[Trans_2a_Aust_Ent_Name] = IntlRPTotal_a.Trans_2a_Aust_Ent_Name AND
[q_Trans_1c_sum_by_country].[SumOfSumOfTrans_2a_AUD1] = IntlRPTotal_a.SumOfSumOfTrans_2a_AUD1 AND
[q_Trans_1c_sum_by_country].[Intl_RP_Country_Code] > IntlRPTotal_a.Intl_RP_Country_Code)+1

Your suggestions are most welcome.
Oct 24 '06 #4

MMcCarthy
Expert Mod 10K+
P: 14,534
I'm surprised this is working for you at all.

Try this and see if it gives you the result you want:


SELECT COUNT(*) FROM [q_Trans_1c_sum_by_country] IntlRPTotal_a INNER JOIN
[q_Trans_1c_sum_by_country_1] IntlRPTotal_b
ON ((IntlRPTotal_a.[Ind_Rank] =IntlRPTotal_b.[Ind_Rank])
AND (IntlRPTotal_b.[Trans_2a_Aust_Ent_Name] = IntlRPTotal_a.Trans_2a_Aust_Ent_Name)
AND (IntlRPTotal_b.[SumOfSumOfTrans_2a_AUD1] = IntlRPTotal_a.SumOfSumOfTrans_2a_AUD1))
WHERE (IntlRPTotal_b.[Intl_RP_Country_Code] > IntlRPTotal_a.Intl_RP_Country_Code)+1)
Oct 24 '06 #5

P: 15
Thanks for offering that mmcarthy.

I tried it but it said that there is an error with syntax in the expression??
Oct 25 '06 #6

MMcCarthy
Expert Mod 10K+
P: 14,534
SELECT COUNT([IntlRPTotal_a].*)
FROM [q_Trans_1c_sum_by_country] IntlRPTotal_a INNER JOIN [q_Trans_1c_sum_by_country] As [q_Trans_1c_sum_by_country_1]
ON ((IntlRPTotal_a.[Ind_Rank] =[q_Trans_1c_sum_by_country_1].[Ind_Rank])
AND ([q_Trans_1c_sum_by_country_1].[Trans_2a_Aust_Ent_Name] = IntlRPTotal_a.Trans_2a_Aust_Ent_Name)
AND ([q_Trans_1c_sum_by_country_1].[SumOfSumOfTrans_2a_AUD1] = IntlRPTotal_a.SumOfSumOfTrans_2a_AUD1))
WHERE ([q_Trans_1c_sum_by_country_1].[Intl_RP_Country_Code] > (IntlRPTotal_a.Intl_RP_Country_Code)+1)SELECT COUNT([IntlRPTotal_a].*)
FROM [q_Trans_1c_sum_by_country] IntlRPTotal_a INNER JOIN
[q_Trans_1c_sum_by_country_1] IntlRPTotal_b
ON ((IntlRPTotal_a.[Ind_Rank] =IntlRPTotal_b.[Ind_Rank])
AND (IntlRPTotal_b.[Trans_2a_Aust_Ent_Name] = IntlRPTotal_a.Trans_2a_Aust_Ent_Name)
AND (IntlRPTotal_b.[SumOfSumOfTrans_2a_AUD1] = IntlRPTotal_a.SumOfSumOfTrans_2a_AUD1))
WHERE (IntlRPTotal_b.[Intl_RP_Country_Code] > IntlRPTotal_a.Intl_RP_Country_Code)+1)
Oct 25 '06 #7

Post your reply

Sign in to post your reply or Sign up for a free account.